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.
Solved! Go to Solution.
Hi @ChristyQV
It loads 100 rows by default.
Please read this thread to find some workarounds.
Hi @ChristyQV
It loads 100 rows by default.
Please read this thread to find some workarounds.
User | Count |
---|---|
22 | |
19 | |
18 | |
17 | |
14 |