...
| Parameter | Description | Type | Required |
|---|---|---|---|
| attachmentId | Attachment ID of the Excel file attachment to use as source | Numeric | Yes |
| skipRows | Number of rows to skip (from the top). Defaults to 0 rows to skip | Numeric | No |
| idCellNum | Which column to use as ID | Numeric | No |
| labelCellNum | Which column to use as label | Numeric | No |
lookupValue Since 2.27.21 | Can supply a lookup value for the service to lookup. The subset returned will be filtered to match (as substring) the given value | Text | No |
lookupField Since 2.27.23 | Limiting the matching logic to specific field (cell) Example: cell1 to limit to cell1 value only. If not specified then the match for given lookupValue is done against the whole row (all cells) | Text | No |
exactMatch Since 2.27.23 | You can set the search to use "exact match", by default (when exactMatch is unspecified or false) the search is done as text substring match (case insensitive) | Boolean | No |
| Info |
|---|
Column and rows numbering starts with 0 |
NB! Only the first sheet from excel file is currently supported!
...