01

Get items¶

By default, Get items only returns the first 100 items. (don't believe the message it shows that default = all)

Set Top Count to 5000.

Odata Filter¶

numeric_column eq number
string_column eq 'string'

lookup_column/Id eq number
lookup_column/subfield eq 'string'

To get more than 5000 items¶

1. Create a variable lower_limit_id=0
2. Get items with ID > lower_limit && ID < lower_limit + 5000
3. lower_limit=lower_limit + 5000
4. Perform step 2 until the lower_limit_id > max(id of items you just got)
5. Finally, do union

ID = Auto-Generated column

Concurrency Control¶

Better to limit database related operations to 1

Copy file¶

Union¶

union(
  collection_1: object|array,
  collection_2: object|array
)

Comments