Forum Discussion

data_team_afri's avatar
data_team_afri
Frequent Visitor
7 years ago

Error: Split json web contents with api token

Hello, This is to request help to split a json weblink I have an json file retreived from an api web link: Before Change:  = Json.Document(Web.Contents(" https://api.funnel.io/api/account/v1/-...
Need Help
data_team_afri's avatar
data_team_afri
Frequent Visitor
7 years ago

Here are the corrected web contents which work on the power BI desktop. (there was a comma missing after the relative path.
Refresh successful in desktop but fails to authenticate on the power BI service.


Failed to update data source credentials: Web.Contents failed to get contents from 'https://api.funnel.io/api/' (404): Not Found

 

= Json.Document(Web.Contents("https://api.funnel.io/api/",
[
RelativePath="account/v1/-account_id-/project/project_id",
Query=
[
group_by="campaign_day",
start_day=Date.FromText("2017-01-01"),
end_day=Date.FromText("2050-12-31"),
fields="common-cost",
apikey="12345_example",
]
]
))

 

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi data_team_afri,

     

    The site url may not the domain or the root path of the server which can be visited. You may change the domain url and try again.

     

    Regards,

    Jimmy Tao