AFAS ProfitGet records
Reads rows from AFAS Profit, like employees or debtors.
Settings
| Setting | What it is |
|---|---|
| ConnectionRequired | The AFAS Profit connection the step signs in with. |
| GetConnectorRequired | Picked from the list AFAS Profit offers. |
| Max rows | Rows per call, 1 to 1,000 — or -1 with Skip rows -1 for every row in one call. With Fetch every page on, this is the page size. |
| Skip rows | How many rows to pass over first — pairs with Max rows to read page by page. Set both to -1 for every row in one call. |
| Fetch every page | Fetches page after page until the connector runs out, and refuses past 10,000 rows rather than answering a short list. Set a sort first — paging without an order can repeat or miss rows. |
| Sort by field ids | Comma-separated AFAS Profit field ids; put a minus in front of one to sort it descending. |
| Filter field ids | Comma-separated AFAS Profit field ids — one per filter, in the same order as below. |
| Filter values | One value per field id above, in the same order. |
| Filter operators | AFAS Profit operator type ids, comma-separated — one per field id above, in the same order. |
| 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 `afas-profit`) |
connector | texta value from the vendor's own list |
take | number, by default 100 |
skip | number, by default 0 |
returnAll | true/false, by default false |
sort | text |
filterFieldIds | text |
filterValues | text |
operatorTypes | text |
cursor | text |
Output
| Field | Type |
|---|---|
rows | array |
rowCount | number |
hasMoreMore rows are waiting behind this page | boolean |
nextCursorCursor for the next page | string |
Sample output, and the expression for each field
- hasMorefalse
- rowCount0
- rows[]
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>",
"connector": "<getconnector>",
"cursor": "",
"returnAll": false,
"skip": 0,
"sort": "",
"take": 100
},
"label": "Get records",
"type": "afas.get",
"version": 3
}Older versions
A flow that already has this version keeps running it. A new step always gets the newest.
Version 2
| Setting | What it is |
|---|---|
| ConnectionRequired | The AFAS Profit connection the step signs in with. |
| GetConnectorRequired | Picked from the list AFAS Profit offers. |
| Max rows | Rows per call, 1 to 1,000 — or -1 with Skip rows -1 for every row in one call. With Fetch every page on, this is the page size. |
| Skip rows | How many rows to pass over first — pairs with Max rows to read page by page. Set both to -1 for every row in one call. |
| Fetch every page | Fetches page after page until the connector runs out, and refuses past 10,000 rows rather than answering a short list. Set a sort first — paging without an order can repeat or miss rows. |
| Sort by field ids | Comma-separated AFAS Profit field ids; put a minus in front of one to sort it descending. |
| Filter field ids | Comma-separated AFAS Profit field ids — one per filter, in the same order as below. |
| Filter values | One value per field id above, in the same order. |
| Filter operators | AFAS Profit operator type ids, comma-separated — one per field id above, in the same order. |
Technical details
| Key | Value |
|---|---|
connection | texta connection id from `requires.connections` (provider `afas-profit`) |
connector | texta value from the vendor's own list |
take | number, by default 100 |
skip | number, by default 0 |
returnAll | true/false, by default false |
sort | text |
filterFieldIds | text |
filterValues | text |
operatorTypes | text |
Version 1
| Setting | What it is |
|---|---|
| ConnectionRequired | The AFAS Profit connection the step signs in with. |
| GetConnectorRequired | Picked from the list AFAS Profit offers. |
| Max rows | Rows per call, 1 to 1,000. With Fetch every page on, this is the page size. |
| Skip rows | How many rows to pass over first — pairs with Max rows to read page by page. |
| Fetch every page | Fetches page after page until the connector runs out, and refuses past 10,000 rows rather than answering a short list. Set a sort first — paging without an order can repeat or miss rows. |
| Sort by field ids | Comma-separated AFAS Profit field ids; put a minus in front of one to sort it descending. |
| Filter field ids | Comma-separated AFAS Profit field ids — one per filter, in the same order as below. |
| Filter values | One value per field id above, in the same order. |
| Filter operators | AFAS Profit operator type ids, comma-separated — one per field id above, in the same order. |
Technical details
| Key | Value |
|---|---|
connection | texta connection id from `requires.connections` (provider `afas-profit`) |
connector | texta value from the vendor's own list |
take | number, by default 100 |
skip | number, by default 0 |
returnAll | true/false, by default false |
sort | text |
filterFieldIds | text |
filterValues | text |
operatorTypes | text |