Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply

Web Auto refresh for data connected to Web link with parameters

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:

eshanpacheriwal_0-1654181807787.png



I tried this, but no sucess. Does anyone has an idea how to tranform the link to allow it to refresh on itis own. 

1 REPLY 1
lbendlin
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.