Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Call webservice

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


Labels (2)
3 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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 ?


Anonymous
Not applicable
Author

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 ?