Name |
A unique name for this data source. |
Import set table label |
A label for the import set staging table to use. |
Import set table name |
The Now Platform uses the label you entered to
construct a unique table name. This prevents namespace
collision with an already existing table. |
Type |
REST (IntegrationHub). |
Format |
The default XML-based file format (.xlsx) is supported,
unless saved as "Strict Open XML Document." |
Request action |
Data source request action that will be invoked to get
data. You can choose only published request actions.
Click the link in the dialog box below to
create/configure a new Data Source request action in IntegrationHub. After the request action
is published in IntegrationHub, you can
choose it as a Request action in
the Data Source record. For more information, see Define action properties. |
Support pagination |
Selected to enable pagination for the request action.
Pagination helps you reduce processing overhead by
processing a specified number of records at a time, instead
of processing all records at once. |
Limit |
Maximum number of records per page. For example, to
process 50 records at a time, enter a
Limit of 50. |
Offset |
The initial offset used for pagination. The offset is the
starting record number. For example, to process 50 records
at a time, starting with the first record, enter a
Limit of 50 and an
Offset of 0. |
Parsing script |
Type the script used to parse a single line of input.
Three parameters are available in this function:
- line: the current line to be
parsed by the script
- lineNumber: the line number
of the current line in the entire response
payload
- result: output result
|
Path for each row |
The path expression used to select JSON objects, which
will become rows in the import set table. The path should be
// for JSON objects. |
Discard Arrays |
Selected to discard JSON arrays as a value. Unselected to
serialize JSON arrays as a value. |
Expand node children |
Selected if child elements of the XML node or JSON object
should be converted into additional columns. Unselected if
the parent column value should be an XML or JSON fragment.
For JSON, note that selecting this option expands objects
only, not arrays. For nested array support, see Importing JSON files. |
Data in single column |
Selected to store data in a single column. |
Xpath for each row |
XPath expression that selects the nodes which become rows
in the import table. The children of the selected nodes will
become the columns in the rows. |