Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ParameterDescriptionTypeRequired
attachmentIdAttachment ID of the Excel file attachment to use as sourceNumericYes
skipRowsNumber of rows to skip (from the top). Defaults to 0 rows to skipNumericNo
idCellNumWhich column to use as IDNumericNo
labelCellNumWhich column to use as labelNumericNo

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 valueTextNo

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)

TextNo

Column and rows numbering starts with 0

...