Getting a specific bundle in Google Sheets response?

I’m using the “Search Rows” module for Google Sheets and while it returns multiple bundles, it doesn’t provide a variable that contains a whole bundle or a bundle specifier (e.g. {{55.`Name (A)`[]}} based on the screenshot).

image

What I’m ultimately trying to do is set the header row value as the key to an array and a body row value as the value to that array – something like:

{"key": "{{55.Name (A)[1]}}", "value": "{{55.Name (A)[2]}}"

I know I can use the Array Aggregator and then access the bundles that way, but it seems odd that I’d need that extra step when the bundles already exist.

Other notes:

  • Is there a way to set the majorDimension parameter? That would take care of setting the array without any further manipulation.
  • How exactly does the Google Sheets “Search Rows” module work? I tried to do the API call directly, but apparently the sheets.google.com/v4/ endpoints don’t support searching/filtering by value. I looked at the input bundle and it uses a filter field that isn’t in the Google Sheets API documentation.