transformations using BPM - File -webservice-merge-File

[Former Member]

Friends,

I have a requirement something like this.

1. i get the file through the sender file adapter

2. one field out of those sent by the sender will be used to make a webservice call to get dateofbirth and name details.

3. i need to merge these data (from file + webservice response) and send it to the receiver using FTP

Can you please elaborate as to how we can achieve this?

Thanks and Regards,

Pavan

[Former Member]

Friends,

I designed a BPM which took care of this requirement.

Thanks for all your ideas.

[Shabarish_Nair]

Use a SOAP lookup;

/people/bhavesh.kantilal/blog/2006/11/20/webservice-calls-from-a-user-defined-function

More about the lookup api - https://help.sap.com/javadocs/NW04S/current/pi/index.html

[former_member181962]

Hi Pavan,

INstead of using a BPM for your requirement, you can make use of a UDF to call the Webservice to retrieve information from it.

Read this blog for more:

/people/bhavesh.kantilal/blog/2006/11/20/webservice-calls-from-a-user-defined-function

Regards,

Ravi

[Former Member]

Thanks,

I will try to work on the Lookup function.

If i use SOAP Lookup:

1. will i have a problem if the message size is large?

2. will the UDF call webservice for each record?

Regards,

Pavan

[Former Member]

Hi Pavan,

If you are using PI 7.1 then it will call only once. But if you use earlier versions than this then it will call for each record. To avoid you may use global container and store the values and use it for the whole mapping.

Regards,

---Satish