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
Tanim
Helper I
Helper I

Iterate Over Web API Pages With Power Query

Hi everyone,

 

I need a little help, please. I have access to API data: 

 

I'm using the following code to retrieve API data:

 

let iterations = 10,
url = "https://graph.facebook.com/v2.10/[ACCOUNT ID]/insights?access_token=[ACCESS TOKEN]",

FnGetOnePage =
  (url) as record =>
   let
    Source = Json.Document(Web.Contents(url)),
    data = try Source[data] otherwise null,
    next = try Source[paging][next] otherwise null,
    res = [Data=data, Next=next]
   in
    res,

 GeneratedList =
  List.Generate(
   ()=>[i=0, res = FnGetOnePage(url)],
   each [i]<iterations and [res][Data]<>null,
   each [i=[i]+1, res = FnGetOnePage([res][Next])],
   each [res][Data])
 in
  GeneratedList

Now I'm trying to retrieve this API data: 

 

 

 

 

What changes do I need to make to the original code for this? Any help, suggestion or guidance is much appreciated!

 

Many thanks,

Tanim

1 ACCEPTED SOLUTION
Tanim
Helper I
Helper I

Fixed it by copy and pasting the last line from the new API data, it basically got rid of the extra "client_pages" bit and working like a charm. Looks like self help is the best help!

 

Fixed.png

View solution in original post

1 REPLY 1
Tanim
Helper I
Helper I

Fixed it by copy and pasting the last line from the new API data, it basically got rid of the extra "client_pages" bit and working like a charm. Looks like self help is the best help!

 

Fixed.png

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.