Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I know there are lot of solutions regarding this but I have been banging my head against the wall but unable to convert this json into a format that can be used for auto refresh.
Can someone please help me out?
Source = Json.Document(Web.Contents("https://api.xxx.com/v1/objects/object_21/records?page="&Page&"&rows_per_page="&AmountOfRecords&"", [Headers=[#"X-xxxx-Application-ID"="61c2c3c4cd8888xxxx", #"X-xxxx-REST-API-Key"="xxxxx-xxxxx-xxxx-xxb-xxxx9"]]))
I saw a video where the link was segregated into different paths like:
I tried this, but no sucess. Does anyone has an idea how to tranform the link to allow it to refresh on itis own.
"convert this json into a format that can be used for auto refresh"
Do you mean this Power Query code? You are missing the RelativePath component.