Forum Discussion
This dataset includes a dynamic data source. Shipstation API
Hey I am having issues. This is the error I am getting. Below is my current query. I need help!
9 Replies
- jbrown184Helper I
Hey I am having issues. This is the error I am getting. Below is my current query. I need help!
- danextianSuper User
Hi jbrown184
That is expected as you are using a url string from concatenating using different text strings. Use relative property of web.contents. Examples:
let BaseUrl = "https://www.baseurl.com", PageSize = 500, Page = [page column], RelativePath = Text.Combine({"/orders?pageSize=", Text.From(PageSize), "&page=", Text.From(Page)}), AuthorizationKey = "Basic " & "actual key", --key could be parameterized Response = Web.Contents(BaseUrl, [ RelativePath = RelativePath, Headers = [Authorization = AuthorizationKey] ] ), Data = Json.Document(Response) in Datalet PageSize = 500, Page = [page column], BaseUrl = "https://www.baseurl.com", AuthorizationKey = "Basic yourkey=", // --or use a parameter Response = Web.Contents( BaseUrl, [ RelativePath = "orders", Query = [pageSize = Text.From(PageSize), page = Text.From(Page)], Headers = [Authorization = AuthorizationKey] ] ), Data = Json.Document(Response) in DataText.From on PageSize and Page is not needed if both are texts.
- jbrown184Helper I
HI! I did what you said. I made a paramater. When I go back to powerbi.com it still says "
This dataset includes a dynamic data source". Here is what I did....
- jbrown184Helper I
HI! I did what you said. I made a paramater. When I go back to powerbi.com it still says "
This dataset includes a dynamic data source". Here is what I did....
- jbrown184Helper I
Hey I am having issues. This is the error I am getting. Below is my current query. I need help!
- lbendlinSuper User
screenshots are too small read. Please repost.
Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1
- AnonymousNot applicable
Hi jbrown184 ,
Could you please tell us that if your issue has been solved? I reviewed this post and I think the workaround from danextian is great.
If you still have doubts, feel free to ask here.
Best Regards,
Stephen Tao