Table JSON Parse
Description
Section titled “Description”Reads a column holding JSON text and expands it into output rows — one per value found in the document. The counterpart to Table XML Parse, and the PlaidCloud equivalent of the Alteryx JSON Parse tool.
Use it when an upstream system hands you a JSON payload in a single column and you need its contents as ordinary rows and columns.
Unique Configuration Items
Section titled “Unique Configuration Items”JSON Field
Section titled “JSON Field”The column holding the JSON text to parse.
Output Shape
Section titled “Output Shape”- Name and value only (default) — each output row carries
JSON_NameandJSON_ValueString. Simplest, and enough when everything downstream treats the values as text. - Typed values — turn the single-field option off to add the type-specific value columns alongside, so numbers and booleans arrive as numbers and booleans rather than strings.
Carry Input Columns
Section titled “Carry Input Columns”Off by default. Turn it on to repeat the input record’s other columns on every value row, so parsed values stay joined to the record they came from without a separate join step.