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

I don't know why the WebCall was showing as a link and cutting off the entire text.  Please see revised post without the hyperlink.  Thanks!

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity 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?