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).
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.