Hi All,

We have a table in Google BigQuery that contains a list of orders. I am working on fetching the list of orders and their attributes for a particular customer using Data action. Since one customer can have multiple orders, the API will return multiple rows.

I am able to make the API request using a Data Action and retrieve the list of order IDs for a particular customer. However, I am unable to parse the JSON response and assigning it to an output variable/contract. 

Can you please guide me on this. 

{
  "rows.f.v": [
    [
      "kageer@cgsinc.com",
      "112335",
      "2024-04-15",
      "Pending",
      "Visa Card ending 1234",
      "2S100023546785",
      "Rodan Fields"
    ],
    [
      "kageer@cgsinc.com",
      "657845",
      "2024-03-15",
      "Shipped",
      "Visa Card ending 1234",
      "2S100023546785",
      "Rodan Fields"
    ],
    [
      "kageer@cgsinc.com",
      "566542",
      "2024-03-25",
      "Shipped",
      "Visa Card ending 1234",
      "2S100023546785",
      "Rodan Fields"
    ]
  ]
}