REST GET snap Pagination issue

Designing Pipelines
1

I am using REST Get snap and pagination is not working.

pic1
pic1815×637 38.8 KB

pic2
Sample output
“entity” : {
“@odata.context” : “https://test-odata.com/at.odata/v2.0/$metadata_65687877”,
“value” : ,
“@odata.nextLink”“https://test-odata.com/at.odata/latest/&%24top=20000&$skip=10000&$skiptoken=2”
},

2

You need to enable the expressions to evaluate

image
image851×649 68.6 KB

3

It gives error
image

4

Hello @deepthi.chidi,

Try with the following expression:

Has next:

$entity['@odata'].nextLink != null

Next URL:

$entity['@odata'].nextLink

Let me know if this helps you.

BR,
Aleksandar.

1 Like
5

Hello @AleksandarAngelevski ,

It didn’t work , here is the error

image
image1192×262 30.7 KB

6

Try enclosing the keyname in [‘’]

$entity[‘@odata.nextLink’] != null

or you can also use the get method

e.g

$entity.get('@odata.nextLink')  != null

or 

$entity.get('@odata.nextLink','').length > 0
7

Hi @deepthi.chidi,

Evaluating expressions in the pagination fields (‘Has Next’ and ‘Next URL’) is not the same as evaluating expressions in a Mapper with an incoming object. The behavior is different since the very same output of the snap is used to calculate whether there is a next step or not.

That’s why I think @AleksandarAngelevski 's solution is correct, and I suggest you to try and validate or run the pipeline to see the actual results.

Regards,
Bojan

1 Like
8

Hi,

The syntax suggested by @alchemiz is working with me:

image
$entity.get(‘@odata.nextLink’) != null
$entity[‘@odata.nextLink’]

Thank you