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 solut...
  • campelliann's avatar
    3 years ago

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