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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
FelipMark
Helper I
Helper I

How to make pagination using cursor api facebok

Hello, I'm querying a facebook API to get data from ad campaigns, but the API has a limit and can't load all the data in a single query, so I decided to limit it to 500 lines and I want to loop to make a request to every 500 pages until you run out of data.

I tried to make a loop using the offset parameter but it doesn't work with the request I'm making... I realized that when I open the .Json the link to the next page is returned.

FelipMark_0-1693971116726.png


How do I create a query that will join all the pages in a single table?

Here's the query I'm using:

 

let
    UrlBase = "https://graph.facebook.com/v17.0/act_636965624958777/insights",
    Cabecalho = [Authorization = "Bearer [TOKEN]"],
    Parametros = [
        fields = "ad_id,campaign_name,ad_name,adset_name,spend",
        time_increment = "1",
        level = "ad",
        limit = "500"
    ],
    Consulta = Web.Contents(
        UrlBase,
        [
            Headers = Cabecalho,
            Query = Parametros
        ]
    ),
    Data = Json.Document(Consulta)
in
    Data

 

 

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.