How to make pagination using cursor api facebok

[FelipMark]

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.

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