How to use the CSV to JSON Command and iterate over the results?
The OneCloud JSON BizApp has many powerful features that include the following commands:
- Array to CSV
- CSV to JSON
- Object to CSV
- Validate Schema
This article will explore configuring OneCloud to convert a CSV to JSON Array and subsequently iterate over the JSON.
COL1,COL2,COL3 AA1,AA2,AA3 BB1,BB2,BB3 CC1,CC2,CC3
CSV to JSON Configuration
Command Output - LIst File Content
Command Configuration & Output - Find String Sample Iteration
With the Find Command, search the file with each element in the iteration. In this case, we are iterating over the values in "COL1". Note: in this example Chain, the "Find" Command has been renamed to "Find String" to accurately represent what the operation is doing.
Run the Chain and review each of the iterations of the "Find" Command. Notice that the "Find Pattern" alternates from "AA1" to "BB1" to "CC1".
As always, we welcome questions on this post or feel free to contact us at firstname.lastname@example.org.