How To Retrieve All Records From Ultipro Connector

Document created by sheng_liao462475 Employee on Oct 26, 2016
Version 1Show Document
  • View in full screen mode

Use Case

Ultipro Connector requests are limited to 1000. However, you may have more than 1000 records and need to retrieve all of them.

 

Approach

You will need to use multiple Ultipro operations to achieve this.

For example, if you have 1800 records to retrieve, the process design will be something like this.

 

 

1. On branch 1 - [get first 1000 records] operation, import the Object and configure the following.

$skip: -1

$top: 1000

This will return the first 1000 records of the set.

 

2. On branch 2 - [get the rest of records] operation, import the same Object and configure the following.

$skip: 1000

$top: -1

Entries 1001 and higher are returned. 

 

$skip: Used to identify a subset by seeking N entries into a collection, then selecting only the remaining entries. For example, when entry N=500, entries 501 and higher are returned.

$top: Used to identify a subset by selecting only the first N items of the set.

 

3. Connect the two branches to a Return Documents shape to return all the records to main process(if you have a main process).

Attachments

    Outcomes