Page Comparison

...

1. If we create the query leaving the resultOffset and the resultRecordCount parameters empty:

   

   we can see at the end of the page that the parameter exceededTransferLimit is equal to true:

   

   this indicates that there are more query results and we can continue to page through them. When exceededTransferLimit is false, it indicates that you have reached the end of the query results.

...

1. To fetch the first 1000 records we need to set the resultOffset=0 ,the resultRecordCount=1000 , and the orderByFields=OBJECTID+ASC :

   

   this query will produce the first 1000 records (1-1000)

2. To fetch the remaining records we need to set the parameters as follows:

   1. resultOffset=1000 , because the maxRecordCount for this layer is configured to be 1000.

   2. resultRecordCount=1000 , to fetch the rest of the records.
      Important, if you know the number of the records remaining you can add that to the resultRecordCount parameter instead of 1000. We use the number 1000 because we don’t know the exact number of the records remaining.

   3. orderByFields=OBJECTID+ASC is used for ordering the results.

      

      in this case, there were 72 records remaining.

...

1. Create a Job → ESRI REST Service

   

2. Right click on the Job and select Create Task > Spatial Data Transformation to fetch the first 1000 records. Rules to remember:

   1. Name → School Gates

   2. Source Data → GeoJSON

   3. Filename → the Query URL (ESRI REST service) using the resultOffset=0 , resultRecordCount=1000 , and the orderByFields=OBJECTID+ASC as we used in Example 2 point 1.

   4. Action → Overwrite layer

      

3. Create the second Spatial Data Transformation Task to fetch the remaining records. Rules to remember:

   1. Name → School Gates Append extra records

   2. Source Data → GeoJSON

   3. Filename → the Query URL (ESRI REST service) using the resultOffset=1000 , resultRecordCount=1000 , and the orderByFields=OBJECTID+ASC as we saw in the Example 2 point 2.

   4. Action → Append to layer

      

4. In the Job you should see your two Tasks and you need to set the second Task to Make dependent on previous task completing successfully.

5. Save the Job.

...