ParseJson

Description

Parses a string in JSON format into a tuple.

Use

  • Select the input field. (String)
  • Enter the root path to specify where to parse the JSON. (Optional)

    • This can be set to parse a specific part of the JSON. If no root path is entered, the entire JSON string is parsed.
  • Enter the format for date/time values.
  • Mark the box to flatten the top level array.
    • Marking the box flattens the list and creates a new row for every line item in the JSON.
  • Enter the detecting text.
  • Click the refresh icon by the field mapping table to review the detected field names.
  • Click OK.

Type

Formulas