MERGEJSON Function

The MERGEJSON function allows you to parse the data from multiple rows of a JSON column. The JSON column would contain an array of objects.

Syntax

MERGEJSON(LOOKUP([sheet.jsonColumn]))

Where

  • sheet: is the sheet that contains a JSON column
  • jsonColumn: is the column that contains an array of objects.

Example

MERGEJSON( LOOKUP([Prod_depend_Doc.json_array]))

which would return an array of JSON objects.

To further understand how to use the MERGEJSON function, refer to this article here.