Hello,
I have a scheduled process that once a day will be executed and will call an API. This API returns a string like the following "entry1,entry2,entry3" ecc.
What I need to do is to insert those received value in a table, let's say that is called CCC_Api. So, after the process has been executed, in the table I want to find the record
UID (automatically generated), entry1
UID (automatically generated),entry2
UID (automatically generated),entry3
How to do that in a safe way? The SQLComponent Insert process step can insert only one record, so I need to find a way to a kind of loop in which every time the sql component Insert step insert a different record based on the Api result.