Forum Discussion

campelliann's avatar
campelliann
Icon for Post Patron rankPost Patron
3 years ago
Solved

How to transform this dynamic URL to "static" to avoid service refresh error

Hi,

So I need to iterate over an api. If I set fixed values at start and max, there is no problem with the online refresh, the thing is when I use column references instead.

I believe the solution comes from using Webcontents + relativepath +query (as in https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/). But when I was not able to make it work with these final conditions "startAt" &max results.

 

The URL to transform:
Json.Document(Web.Contents("https://company-pt-dev.atlassian.net/rest/api/3/search?jql=project in ('projectname') AND issuetype = 'Test Case' or summary ~ 'Comarch' and issuetype = 'Test Case' &startAt=0"&"&maxResults=100"))

  • Consider the base URL till.net, and everything after that including the Query is relativepath...

    Json.Document(Web.Contents("https://company-dev.atlassian.net/",[RelativePath="rest/api/3/search?jql=project in ('projectname') AND issuetype = 'Test Case' or summary ~ 'Comarch' and issuetype = 'Test Case' &startAt=0"&"&maxResults=1000"]))

1 Reply

  • Consider the base URL till.net, and everything after that including the Query is relativepath...

    Json.Document(Web.Contents("https://company-dev.atlassian.net/",[RelativePath="rest/api/3/search?jql=project in ('projectname') AND issuetype = 'Test Case' or summary ~ 'Comarch' and issuetype = 'Test Case' &startAt=0"&"&maxResults=1000"]))