Question

Import data from third-party web service

I've seen the example "Import data from third-party database" (see https://academy.bpmonline.com/documents/technic-bpms/7-12/call-web-service-process-element#XREF_22633_Fig_50_Selecting)

I'm not able to find the way to configure the business process blocks "Login to bpm'online" and "Insert contacts to bpm'online").

All the examples I found about consuming BPM'online web services concern custom applications: how can I call BPM'online web services from a business process to import/update data?

If I need to import data from third-party web services inside a business process, the only solution is to call BPM'online web services?

Thank's

Like 0

Like

5 comments

this is the business process I'm talking about:

Dear Massimiliano,

Could you please describe the business task you are implementing in details, so we could provide with the solution?

Let us know the step-by-step data transition, so we will be on the same page.

Thank you in advance,

Anastasia

Thank you Anastasia.

In the first step we call an external web service that responds with a JSON structure containing an array of data (accounts) that we must import into BPM'online.

In the second step we must insert into BPM'online accounts all the data read from the external web service (possibly checking if each account to be imported is not present in BPM'online).

Thank's in advance

Massimiliano

 

Dear Massimiliano,

Thank you for clarifying the task.



According to the provided information and answering your question "Is the only solution is to call BPM'online web services?":

You can fill the business process parameter with the collection type by the data that taken from the external API and afterward, use this collection in the business process ScriptTask element to iterate. Here you can find the information about how you can do it:

https://community.bpmonline.com/questions/use-collection-parameter-script-task



And for each element, you can call the Select (https://academy.bpmonline.com/documents/technic-sdk/7-8/use-entityschemaquery-creation-queries-database) method to check if the record already exists, and Insert ( https://academy.bpmonline.com/documents/technic-sdk/7-8/composing-add-d… ) method to create a new one.

Regards,

Anastasia

Massimiliano Mazzacurati,

Hi Massimiliano,

 

My name is Raz Rosman and I'm also trying to get data from a third party application into creatio.

 

Could you please share with me how did you configured the web service process element to do so?

 

Thank you very much

Best Regards,

Raz

Show all comments