Parameter in base url Relative path DynamicDataSource

[TK12345]

Hi all,

I have a problem with a parameter and connecting a GET connector. When I use a parameter in de base url it does not refresh in the service, when I change it to hard coded, it does work. I get the error that it uses a dynamic datasource so I can't do schedule refresh. Last time I fixed it with RelativePath. Cause the relative path is after the parameter, I think that that is the problem, but I don't know for sure. How to fix it? So the first parameter does not work, the second does work. How do I need to change the formula so it will also refresh in the service?

= (offset) =>
let
Source =
Json.Document(
Web.Contents(
"https://" & Number.ToText ( Parameter1 ) & ".xx.xx.online",
[
RelativePath = "/xxxxxx/xxxx/xxxx?take=1000&skip=" & Number.ToText( offset ),
Headers = [
Authorization = "Token " & (Parameter2)
]
]
)
)

How can I change this, so that I don't get the dynamic datasource error, and I can schedule refresh. Good to know, when I change parameter one to hardcoded number, it does work. So parameter 2 has no problem.

[TK12345 · Accepted solution]

For someone with the same problem, I found a solution myself. 

Make a parameter for the whole base URL:
Parameter 1: https://1234.xx.xx.online and add this to the query.

= (offset) =>
let
Source =
Json.Document(
Web.Contents(
Parameter1,
[
RelativePath = "/xxxxxx/xxxx/xxxx?take=1000&skip=" & Number.ToText( offset ),
Headers = [
Authorization = "Token " & (Parameter2)
]
]
)
)

[amitchandak]

@TK12345 , refer if this can help

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...

[TK12345]

Hi,

Thanks for reaching out. Did check that as well. Problem is, the parameter is in my base url. So the article did not help me.