I have an spreadsheet that has title as 1st row and values starting from 2nd row
However, on http request, i was returned as following
May i know how do i map the 1st value to 2nd and 3rd and so on to create json values.
for example
I have an spreadsheet that has title as 1st row and values starting from 2nd row
However, on http request, i was returned as following
May i know how do i map the 1st value to 2nd and 3rd and so on to create json values.
for example
Why are you using the HTTP node instead of the Google sheets node? The node does the mapping for you.
Hello @RicardoE105 sorry for not explaining in detail earlier.
I was using Lark suite , which comes with their version of sheet. Therefore, I am extracting the data from the Lark suite using http request.
Hi @Benjamin123, so “use first item as keys for all other items” isn’t an option included in the http request node yet. Based on your example data, I’d probably use a bit of custom JS to use the strings in the first array as keys, for example like so:
The above example turns this:
Into this:
Awesome, glad to hear and thanks so much for confirming!