Skip to content

Convert JSON text to record-list

Description

Convert a JSON text value to a record-list

Input Ports

Name dataType sourceType required description
Shape shape manual-only true The shape to select fields from
JSON text long-text link-manual true The JSON that the user wants to convert

Scenarios

  • The user wants to convert JSON text into a record-list

Use case

Command

Inputs
  • Shape: Accounting Shape
  • JSON text: json { data: [ { _id: '049633c4-8ecd-4a9a-9b17-5eb4cb2ca262', createdAt: 2021-11-09T11:45:34.000Z, updatedAt: 2021-11-09T11:45:34.000Z, accountNumber: '62657479773', filepath: 'C:\\Roboteur\\BankStatements\\csv\\62600079773.csv' }, { _id: '4b0463a4-432b-4f05-9ad6-048e8594a684', createdAt: 2021-11-09T11:45:40.000Z, updatedAt: 2021-11-09T11:45:40.000Z, accountNumber: '62854058700', filepath: 'C:\\Roboteur\\BankStatements\\csv\\62600079773.csv' }, { _id: 'cb95deb9-b9c0-4469-9a78-59ab83220859', createdAt: 2021-11-09T11:45:26.000Z, updatedAt: 2021-11-09T11:45:26.000Z, accountNumber: '62841795323-11', filepath: 'C:\\Roboteur\\BankStatements\\csv\\62600079773.csv' } ] }
Search Tags

Convert JSON text to a record-list