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 Anupama, 





 

One of the ways to create a loop in your process to work with the collection of records is  to create a sub-process and pass the collection into the subprocess. 

You can refer to the example below and create the process you need: 

Signal "Contact Added" element: 

Read Data "Read Contact" element:

For the sub-process, you would need to specify the [Parameters] of it:

And make a filter of the element within the sub-process based on the ID:

And finally, you would need to specify this parameter in the parent Business Process:

You may also find these academy Articles useful:

https://academy.creatio.com/docs/user/bpm_tools/process_elements_refere…

https://academy.creatio.com/docs/user/bpm_tools/bpm_process_examples/us…

Hope this helps!

Thank you!

Regards,

Yurii

Danyil 

Thanks Yurii Sokil for the detailed instruction and the sequential  Execution Mode is something I haven't tried it before. Would definitely try that.

In between I tried another approach where-in at the entry point where the Signal action is placed, I unchecked the option of "Run following elements in the background". With this, until the process is completed, I was able to read the required values and add/edit/delete multiple records.

Dear Julius,

Unfortunately, it is impossible to handle parameters that have the “collection of object” type without using the source code.

Therefore, in this case we recommend using “ScriptTask” element for both calling the web-service and processing the results of call.

For more detailed assistance, please contact technical support.

Best regards,

Norton

Norton Lingard, Thank you. Is there anything like this in the academy? Because there is a special bpm'online syntax to go by in the source-code.

Dear Julius,



The service call in a "Script task” business process element can be implemented via native C#. Please find a lot of examples on how to do that in Google. For example, several links below:

https://stackoverflow.com/questions/9620278/how-do-i-make-calls-to-a-rest-api-using-c

https://code-maze.com/different-ways-consume-restful-api-csharp/

Please note that it is possible to use the native C# collections instead of working with the the special bpmonline collections.

Best regards,

Norton

Hi Julius,

Did you manage to solve this?

I'm struggling with the same issue and didn't manage to get it to work.

Looking forward to having Your answer.

Raz

Norton Lingard,

Hi Norton,

Is there another example on how to do it in the script task?

I tried implementing it based on the links you posted and I'm getting many error messages when posting the code.

Thanks,

Raz

Dear Raz,

Please find another example in the article by the link below:

https://stackoverflow.com/questions/3900371/how-can-i-call-a-webservice-from-c-sharp-with-http-post

If you still can’t resolve the issue please provide us with a source code that you wrote and errors that you got.

Best regards,

Norton

Dear Mariia,

To add a record to account address for specific account you can use a business process with a parameter like on the screenshot http://prntscr.com/me25i0. This process will add one record to account address detail for "Test" account. To edit existing records in this detail you can build a business process like on the screenshot http://prntscr.com/me25ys. This process will change ZIP code for an account "Test" and it will be done for the record which have ZIP code set for 322. You can also add parameters to your business process and use them when triggering a process. You can also bind a business process to a page so to be able to trigger this process for a particular account record. Please read more about binding business process to a page here.

Best regards,

Oscar