Exact OnlineGet
Fetches records out of Exact Online, page by page or all at once.
Settings
| Setting | What it is |
|---|---|
| ConnectionRequired | The Exact Online connection the step signs in with. |
| Division | Leave empty to use the administration the connection signed in to. |
| ResourceRequired | The Exact Online resource path after the division — its documentation calls this the endpoint. |
| Fields | The fields to return, comma-separated. Fewer fields is faster and counts the same against your limit. |
| Filter | An OData filter, spelled as Exact Online spells it. |
| Order by | text |
| Records per call | Records per call. Most Exact Online resources page at 60; the sync and bulk resources page at 1,000. |
| Fetch every page | Follows Exact Online's own next-page link until it runs out, and refuses past 25,000 records rather than answering a short list. |
| Cursor | Paste a previous run's Next cursor to read the page after it. |
Technical details
| Key | Value |
|---|---|
connection | texta connection id from `requires.connections` (provider `exact-online`) |
division | text |
resource | text |
select | text |
filter | text |
orderBy | text |
top | number, by default 60 |
returnAll | true/false, by default false |
cursor | text |
Output
| Field | Type |
|---|---|
records | array |
recordCountRecords in this answer | number |
hasMoreMore records are waiting behind this page | boolean |
nextLinkExact Online's own link to the next page | string |
divisionThe division these records came from | string |
nextCursorCursor for the next page | string |
Sample output, and the expression for each field
- division"123"
- hasMorefalse
- nextLink""
- recordCount0
- records[]
Errors
When a step of this node stops a run, the run page shows a code. Look it up:
Example step
The step as a flow file holds it. Replace each value in <…>.
{
"config": {
"connection": "<connection id>",
"cursor": "",
"division": "",
"filter": "",
"orderBy": "",
"resource": "<resource>",
"returnAll": false,
"select": "",
"top": 60
},
"label": "Get",
"type": "exact.get",
"version": 2
}Older versions
A flow that already has this version keeps running it. A new step always gets the newest.
Version 1
| Setting | What it is |
|---|---|
| ConnectionRequired | The Exact Online connection the step signs in with. |
| Division | Leave empty to use the administration the connection signed in to. |
| ResourceRequired | The Exact Online resource path after the division — its documentation calls this the endpoint. |
| Fields | The fields to return, comma-separated. Fewer fields is faster and counts the same against your limit. |
| Filter | An OData filter, spelled as Exact Online spells it. |
| Order by | text |
| Records per call | Records per call. Most Exact Online resources page at 60; the sync and bulk resources page at 1,000. |
| Fetch every page | Follows Exact Online's own next-page link until it runs out, and refuses past 25,000 records rather than answering a short list. |
Technical details
| Key | Value |
|---|---|
connection | texta connection id from `requires.connections` (provider `exact-online`) |
division | text |
resource | text |
select | text |
filter | text |
orderBy | text |
top | number, by default 60 |
returnAll | true/false, by default false |