Forum Discussion

ChristyQV's avatar
ChristyQV
Frequent Visitor
6 years ago
Solved

API request where each record is counted as a request

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.