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

[campelliann]

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-i...). 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"))

[campelliann · Accepted solution]

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"]))