Forum Discussion
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/-...
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",
]
]
))
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