API request where each record is counted as a request

[ChristyQV]

I have been using an API to pull data into Power Query and then PowerBI from a task management tool.  The API documentation states that they limit requests to 100 request per minute per token.  I have the following M that requests a list of the tasks; it only returns 100 records. Is there something in the way I wrote this that is making multiple requests?  It only looks like one request to me, not one request per record.  Is there a better way for me to do this?

let
    token = "XX_YV5JX1DMD5D3CDEVTGO58UT44YXXXXXX",
    endpoint = "2232929/task?include_closed=True",
    baseUrl = "https://api.clickup.com/api/v2/team/",
    url = Text.Combine({baseUrl,endpoint}),
    
    request = Web.Contents(
        url,
        [
            Headers = [
                Authorization = token
            ],
            Query = [
                    ]
        ]
    ),
    requestData = Json.Document(request),
    
    #"Converted to Table" = Record.ToTable(requestData),
    #"Expanded Value" = Table.ExpandListColumn(#"Converted to Table", "Value")
    
in
    #"Expanded Value"

Judging from discussions on the vendors site, it does not seem that the API limit is really 100 records so I assume it's something I'm doing wrong. Thanks for any insight.

[v-juanli-msft · Accepted solution]

Hi @ChristyQV 

It loads 100 rows by default.

Please read this thread to find some workarounds.

https://community.airtable.com/t/json-string-only-contains-100-rows-when-connected-to-power-bi-deskt...

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.