Hi there.
I got stuck in a seemingly simple place…
All I want to do is extract a range of values (A1:D100) from a Google sheet and create a JSON file out of that. Leaving out empty lines (so, there are 28 rows at the moment).
I tried with “Create JSON” and “Transform to JSON” but although I see 28 bundles in the output of the module “Get Range Values” I can’t see them in the JSON modules.
Am I misunderstanding something here? I may be overcomplicating things?
Hi @Magganpice
You will only see the first budle output while mapping but it takes all the bundles one by one. Hence, this is not to worry.
Now, to create json file, you should use “Aggregate to JSON” module. That will combine all 28 rows into one json file.
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
Thanks! Simple and good to know.
Hai @Magganpice,
Glad to know that your issue is resolved
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
