topic Re: Call webservice in Talend Studio

Call webservice

Anonymous — Sat, 16 Nov 2024 03:01:55 GMT

Hi all,

I want to create a job but I don't know the good method.

- I want to get data from a database A.
- I want to verify that these data exist or not in another database B. For this I have a web service that I can call
- If the data doesn't exist, I create these data in the database B (with a webservice that I can call), if not, I get the column "adress" from the database B (with a webservice that I can call) and update the data in the database A with these column

For example :

- I get two invoices from the database A where the column "adress" is null (with a SQL request). I get two columns "name" and "firstname"
- I call a webservice who exists with these two columns (I don't know how to do to pass parameters to a web service.) The webservice replies that the first invoice doesn't exist and the second exists
- I create the first invoice in the database B by calling a webservice (who exists)
- I get the column "adress" from the database B by calling a webservice (who exists) and update this second invoice in the database A by update the column "adress"

Thanks you

Re: Call webservice

Anonymous — Tue, 10 Mar 2020 11:31:26 GMT

Hi
To get data from database, you can use tDBxxxInput component such as tOracleInput.
To call a soap webservice, use tSOAP or tWebserviceInput.
To call a restful webservice, use a tRest component.
As a newbie, please read the component documentation and learn these component.

Feel free to post if you have any questions.

Regards
Shong

Re: Call webservice

Anonymous — Tue, 10 Mar 2020 12:43:42 GMT

Hi @shong

Thanks for your reponse.

So, the good method is :

tMySqlInput (database 1) - tMap - tSOAP (to check result) - (if result ko => tSOAP (to insert in database 2)) - (if result ok=> tSOAP (to get "adress" field) - tMySQLOutput (database 2)

How to check the result of tSOAP ? Can I map tMySQLInput with tMap ?

Re: Call webservice

Anonymous — Tue, 10 Mar 2020 22:42:51 GMT

How to do to create an object « Invoice » and after get data with my tMySqlInput , supply this object and send it to my web service (by url) that I call ?