HTTP snap pagination Not Working

[mohit_jain]

Hi Everyone,

I hope you're doing well. I need some assistance with implementing pagination in SnapLogic for the Google Search Console API. Currently, there's a row limit of 25,000, making it challenging to load the data on a daily basis. If the data exceeds this limit, we risk losing valuable information.

To avoid this, I’m looking for a way to implement a loop within the API calls to handle pagination efficiently. Given the urgency of this task, any guidance or suggestions on how to achieve this would be greatly appreciated.

Here is the snap config

now we need to update the startRow to +25000 in every execution and it should be end once it is completed

api result :

Can anyone help me in this
 

[mohit_jain]

@SpiroTaleski 

[koryknick]

@mohit_jain - Please refer to the SnapLogic documentation for the HTTP Client under HTTP Client Examples

Examples 1 and 2 should give you an idea how the functionality works to paginate the results.  From the screenshots you provided, I believe you would be able to use the Has Next to tell SnapLogic that there is more to get, which you can probably just check to see if the number of results returned is the full 25000:

$entity.rows.length == 25000

Then enable the "Override parameters" to update the "startRow" value.  This value would probably be something like:

(snap.out.totalCount + 1) * 25000

 Hope this helps!

[mohit_jain]

Hi @koryknick 

Really thanks for the reply
But I have tried with the same approach which you have mentioned in the last comment 

But it is giving me error 

I have tried with the second way also 

But still it is giving me same error 
Can you please help 

[koryknick]

Change Has Next to the following:

$.hasPath('entity.rows') ? $entity.rows.length == 25000 : false

Then you may need to look at the second response and see why $entity.rows doesn't exist - it seems odd that you're getting a different response unless there are exactly 25000 documents available.