Parameter in base url Relative path DynamicDataSource

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 ...

Need Help

Show and Tell

TK12345
3 years ago
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)
]
]
)
)