Skip to content

Convert page-list to data-list

Description

Converts a nested data-list, stored in long-text format, to a data-list. Good for Read PDF page to data-list

Input Ports

Name dataType sourceType required description
Items Field text link-manual true The field to select from the incoming data-list. The value must be a serialized JSON
Value Field text link-manual true The Field in the serialized JSON to select
Fields data-field link-manual true The columns that will be generated based with the values found in the serialized JSON text value
Data list data-list link-manual true The data-list that must be converted into an other data-list

Scenarios

  • The user has a data-list that contains a serialized json in one of the fields, the user wants to create an other data-list with the array of objects that exist in the selected field.

Use case

Command

Inputs
  • Items Field: items
  • Value Field: text
  • Fields:
    dataFields
  • Data-list:
    dataList
Experienced tips
  • If the data-list or fields are empty, the process will stop and provide you with the following error. Source Data-list and destination fields are both required
  • If the items field are empty, the process will continue and use the default value. items
  • The items field you set must contain a serialized JSON text value
  • If the value field are empty, the process will continue and use the default value. text
  • The value field must exist in the serialized JSON text value
Output

Output

Search Tags

convert serialized JSON to data-list