Saving each record in webservice collection to a record in a table
I am trying to save data from an API call, it returns a collection of records. I wish to save these into a table. I do not know how to loop through this collection and save each as a record. Please advise.
Like
Hi Pascal,
This can be achieved via OOTB no-code tools of Business Processes.
The response collection of an API can be sent to a sub-process with parameter filled and it can be set to run sequentially so that all the response data will be successfully inserted into the table.
Here is the article, https://customerfx.com/article/working-with-collections-from-a-web-service-element-in-a-process-in-creatio/
BR,
Bhoobalan Palanivelu.
Hi Pascal,
This can be achieved via OOTB no-code tools of Business Processes.
The response collection of an API can be sent to a sub-process with parameter filled and it can be set to run sequentially so that all the response data will be successfully inserted into the table.
Here is the article, https://customerfx.com/article/working-with-collections-from-a-web-service-element-in-a-process-in-creatio/
BR,
Bhoobalan Palanivelu.
The subprocess method is very poor performance for larger datasets though, and so when we had this problem we ended up having to write C# for it. These aspects need to be improved by Creatio if their desire is to continue to push their platform as being effective at scale with no code solutions.