Forum Discussion
Re: Query contains unsupported function. Function name: Web.Contents for web API
Hello,
I have tried your solution
contents = Web.Contents(#"URL_jenkins_1", [RelativePath="/bat/view/Deploy-XLD/job/Deploy-XLD-OSB12-EPI/api/json", Query = [pretty="true"]]),
//RawData = Web.Contents("https://yourcompany.atlassian.net", [RelativePath="rest/api/3/search", Query=[jql=JQL,startAt=Text.From(StartAt) ], Headers=[Accept="application/json"]]),
json = Json.Document(contents),
#"URL_jenkins_1 => url server Jenkins
But It,s the same, work perfectly in Power Bi Desktop but when I publish it in the service PowerBi doesn´t work.
Curiosly in the same report, I connet with Jira with webcontens and in this case It is working. In teory is the same or similar call
contents = Web.Contents(#"URL"&"/rest/agile/1.0/board/1779/issue?fields=components,parent,resolution,assignee,customfield_11023,created,status,fixVersions,timetracking,customfield_11100,resolutiondate,issuetype,labels,customfield_10758,summary,worklog&jql=project in (EEDS, PS2PD) and updated >= -120d",[Query = [maxResults= Text.From(pageSize), startAt = Text.From(skipRows)]]),
json = Json.Document(contents),
- Anonymous6 years ago
Check out the “Faking Out” Web.Contents discussion regarding to using Relative path and Query options.
http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/
You could also create a support ticket here.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- AnonymousNot applicable
Check out the “Faking Out” Web.Contents discussion regarding to using Relative path and Query options.
http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/
You could also create a support ticket here.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- jesus_heredero1Frequent Visitor
Thank you , It works
I add a complete URL with the path complete and then work
URL_jenkins_2 = URL_jenkins_1 & "/bat/view/Deploy-XLD/job/Deploy-XLD-OSB12-EPI/api/json?pretty=true",
contents = Web.Contents(URL_jenkins_2, [ Headers=[Accept="application/json;odata=nometadata"] , Query = [pretty="true"]]),