Forum Discussion
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
- campelliann
Post Patron
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"]))