TwinfieldFind dimensions
Finds Twinfield customers, suppliers or accounts by name or code.
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. |
| Kind | "DEB" or "CRD" or "BAS" or "PNL" or "KPL" or "PRJ" |
| Search for | A * stands for any run of characters, so *acme* finds every name holding acme. |
| Search in | Which column the pattern is matched against. |
| Level | Restricts the search to one dimension level; leave empty for all of them. |
| 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 |
dimtype | "DEB" or "CRD" or "BAS" or "PNL" or "KPL" or "PRJ", by default "DEB" |
pattern | text, by default "*" |
field | "0" or "1" or "2", by default "0" |
level | text |
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"1000"
- Name"Acme"
- [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": "",
"dimtype": "DEB",
"field": "0",
"firstRow": 1,
"level": "",
"maxRows": 100,
"office": "",
"pattern": "*",
"returnAll": false
},
"label": "Find dimensions",
"type": "twinfield.findDimensions",
"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. |
| Kind | "DEB" or "CRD" or "BAS" or "PNL" or "KPL" or "PRJ" |
| Search for | A * stands for any run of characters, so *acme* finds every name holding acme. |
| Search in | Which column the pattern is matched against. |
| Level | Restricts the search to one dimension level; leave empty for all of them. |
| 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 |
dimtype | "DEB" or "CRD" or "BAS" or "PNL" or "KPL" or "PRJ", by default "DEB" |
pattern | text, by default "*" |
field | "0" or "1" or "2", by default "0" |
level | text |
firstRow | number, by default 1 |
maxRows | number, by default 100 |
returnAll | true/false, by default false |