Forum Discussion

jesus_heredero1's avatar
jesus_heredero1
Frequent Visitor
6 years ago
Solved

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),

2 Replies

    • jesus_heredero1's avatar
      jesus_heredero1
      Frequent 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"]]),