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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Aleksandra_MLT
Advocate I
Advocate I

Get data from URL retrieved from API

Hey all. I have this table extracting data from API and it was all working fine. Now some changes were made to an API and now instead of getting records I get URL to a json which holds the data. I get new URL each time I call the initial endpoint. My question is how to get the data 🙂 

 

This is how my API call output looks like now, this link hold the data, just not sure how to get there ? GetURL.JPG

2 REPLIES 2
Imrans123
Advocate V
Advocate V

If you take a look at advanced editor, the last step should be something like 

in

#"GetURL"

or something like that 

 

Just call another let function on the editor and parse the GetURL into Web.Contents()

 

If you're okay with it, show me the advanced editor steps but put dummy password or authentication codes to maintain security.

lbendlin
Super User
Super User

call the fileURL again with Web.Contents() and parse the received JSON again.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors
Users online (6,976)