get response from webservice to datasbase

[Former Member]

Dear Experts,

A file is picked , and a sync webservice call made. The records which could not be inserted using the webservice should be put to a database, along with the error code . Please suggest the options available.

Thanks,

Aju

[Former Member]

You could have that logic in the webservice itself. Is the webservice performing any busincess logic apart from inserting records to DB? If not then use the stored procedure to achieve the task. Give more details

[Former Member]

Hi Anand,

It is file to webservice, get the respsonse back and pass the response to the database.

webservice can't be modified. what i thought was to use a soap lookup to call the webservice and send the response to jdbc reciever .

a second option was to do a file to webservice sync .. and in the response mapping call a udf which will insert it to the database.

i think it should be handled with bpm . i am searching for altenatives ..

Thanks ,

Aju

[Former Member]

Hi ,

can we call rpc style webservice from PI. Our webservice is RPC style .

Thanks,

AJu

[Former Member]

avoid using BPM.

try using soap lookup and then using JDBC adapter. That will be better way. U can use RFC Style..