Forum Discussion

twilkdaddy's avatar
twilkdaddy
Frequent Visitor
9 years ago

How to return ALL results in API call

I'm new to running queries with API calls in Power BI so please forgive any naivity or obvious errors included in this code.  I've pasted my code below to try and paginate through results, but I'm st...
Need Help
twilkdaddy's avatar
twilkdaddy
Frequent Visitor
9 years ago

As far as I can see, there aren't any lastkey fields.  I thought that was some sort of built in variable as a last record identifier.  

 

Here's a snapshot of the last piece of results yielded out of ARC (-499 is the last array of results containing the desired variable values):

 

-499:  [Array[4]

  0:  768
   1:  "1986"
  2:  "Krystin"
  3:  "Hand"
 
 
"metaData":
-0:  {
"morePagesAvailable": true
"resultsAvailable": 16650
"resultsReturned": 500
"firstResult": 1
"lastResult": 500
"columns":
 
1:  {
"name": "contactId"
"sortable": true
"filterable": true
"reportDataType": "IDSET"
"required": false
}
 
 
2:  {
"name": "companyName"
"sortable": true
"filterable": true
"reportDataType": "SEARCH_STRING"
"required": false
}
 
 
3:  {
"name": "firstName"
"sortable": true
"filterable": true
"reportDataType": "SEARCH_STRING"
"required": false
}
 
 
4:  {
"name": "lastName"
"sortable": true
"filterable": true
"reportDataType": "SEARCH_STRING"
"required": false
}
 
"sorting":
 
{
"filterable":
{
"name": "contactId"
"sortable": true
"filterable": true
"reportDataType": "IDSET"
"required": false
}
 
"direction": "ASC"
}
 
 
 
twilkdaddy's avatar
twilkdaddy
Frequent Visitor
9 years ago

Any suggestions on how to create or identify that variable to identify the "number for the next page" you mentioned?

 

Was I provided in the last post helpful at all for troubleshooting where my code problem is?

  • ImkeF's avatar
    ImkeF
    Community Champion
    9 years ago

    Yes, thank you.

    I thought it would be ContactID, but this wouldn' work, as that would skip the range fom 500 until 768 in the example you've given.

     

    Is there another field (like "Result") in the dataset that is 500 for that last record where Contact ID is 768? Then you would have to take this.