Discovery Pattern – JSON Parsing with “Create Table Variable” creates multiple records from array.

[Pavan Nagidi]

Hi,

In a ServiceNow Discovery Pattern, I’m using Run Operation to retrieve a JSON response and then Parse JSON to create a Table Variable, where table columns are populated by selecting values from the JSON response.

When I create the table variable, ServiceNow creates one row per array element, which results in multiple records for the same response. My requirement is to store these values in a single record.

Is there any supported way, using Pattern UI only (no scripting), to merge or transform table-variable rows into one record?

"custom_fields":[{"metadata_id":1790,"label":"cc","value":"IND.01.01.1.1.01.1"},
{"metadata_id":1837,"label":"sac:","value":"GA"}]

Thanks in advance

Thanks
Pawan