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
ImkeF's avatar
ImkeF
Community Champion
9 years ago

 

The query would paginate if the result of your WebCall contained a field named "lastKey". Do you really have that field or does the number for the next page sit in a different field/column?

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.