json - Import data to excel from rails URL -

i want import data excel rails url. have written action serve json data http request url.

but when try import in excel using power query -> other sources -> odata feed not getting data instead got error [dataformat.error] odata: given url neither points odata service or feed: 'http://<server ip>:3000/test1/test2/test.json'.

from odata documentation here, responded json data { "d" : { "key": "value"} }. doesn't seem help. got same issue.

def test   respond_to |format|     format.json        render :json => { "d" => { "key" => "value"} }     end   end end 

what missing?

if using power query -> other sources -> odata feed, should provide url http://services.odata.org/v2/northwind/northwind.svc/categories not .json suffix. if trying import direct json result file of odata service, should use power query -> file -> text