TwinfieldFind
Looks up Twinfield master data — articles, VAT codes, periods, users and more.
Settings
| Setting | What it is |
|---|---|
| ConnectionRequired | The Twinfield connection the step signs in with. |
| Company code | Leave empty to use the company code on the connection. |
| What to look up | The Twinfield type code. Use Find dimensions for customers and suppliers. |
| Search for | A * stands for any run of characters, so *btw* finds every name holding btw. |
| Search in | "0" or "1" or "2" |
| Extra settings | The type's own narrowing settings — vattype is purchase or sales, dimtype is DEB, CRD, BAS, PNL, KPL or PRJ. |
| First row | Where the page starts; the first row is 1. |
| Rows per call | How many rows one Finder call asks for. |
| Fetch every page | Follows the Finder's row counter, and refuses past 5,000 rows 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 `twinfield`) |
office | text |
type | text, by default "ART" |
pattern | text, by default "*" |
field | "0" or "1" or "2", by default "0" |
options | object of text, by default {} |
firstRow | number, by default 1 |
maxRows | number, by default 100 |
returnAll | true/false, by default false |
cursor | text |
Output
| Field | Type |
|---|---|
rowsMatches | array |
columnsColumn names | array |
rowCountMatches in this answer | number |
totalRowsMatches Twinfield counted | number |
hasMoreMore matches are waiting behind this page | boolean |
nextCursorCursor for the next page | string |
Sample output, and the expression for each field
- columns
- [0]"Code"
- [1]"Name"
- hasMorefalse
- rowCount1
- rows
- [0]
- Code"VH"
- Name"VAT high"
- [0]
- totalRows1
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": "",
"field": "0",
"firstRow": 1,
"maxRows": 100,
"office": "",
"options": {},
"pattern": "*",
"returnAll": false,
"type": "ART"
},
"label": "Find",
"type": "twinfield.find",
"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 Twinfield connection the step signs in with. |
| Company code | Leave empty to use the company code on the connection. |
| What to look up | The Twinfield type code. Use Find dimensions for customers and suppliers. |
| Search for | A * stands for any run of characters, so *btw* finds every name holding btw. |
| Search in | "0" or "1" or "2" |
| Extra settings | The type's own narrowing settings — vattype is purchase or sales, dimtype is DEB, CRD, BAS, PNL, KPL or PRJ. |
| First row | Where the page starts; the first row is 1. |
| Rows per call | How many rows one Finder call asks for. |
| Fetch every page | Follows the Finder's row counter, and refuses past 5,000 rows rather than answering a short list. |
Technical details
| Key | Value |
|---|---|
connection | texta connection id from `requires.connections` (provider `twinfield`) |
office | text |
type | text, by default "ART" |
pattern | text, by default "*" |
field | "0" or "1" or "2", by default "0" |
options | object of text, by default {} |
firstRow | number, by default 1 |
maxRows | number, by default 100 |
returnAll | true/false, by default false |