Split incoming JSON Arrays into multiple elements.
JSON is a data format used to represent data in a structured and standardized way. It is a text-based, lightweight alternative to XML and is widely used on the web for data interchange. Arrays can be a part of a JSON object and represent data lists, which may contain zero to many elements.
Streamsheets primarily uses JSON as its data format for representing data. To work with arrays, it is sometimes necessary to divide the content into single elements. This template uses the “Loop” functionality of the Inbox to split an array into multiple messages.
How it works:
- Start the App
- The “Array simulation” sheet sends one array per second to the “Splitter” sheet
- The “Splitter” sheet loops over every array element, every time sending a message to the “Receiver” sheet
- The “Reciever” sheet adds the incoming messages to a table