Skip to Content
1

OData lookup from CPI

Apr 12 at 01:37 PM

48

avatar image
Former Member

Hi Experts,

My requirement is to extract data from SF employee central API and then do a look up using Odata(similar to what we do in RFC/JDBC look up in sap pi/po).

Could you please help me with the OData lookup from CPI.

Thanks & Regards,

Merina Acharya

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Sriprasad Shivaram Bhat
Apr 12 at 01:48 PM
0

Hello Merina,

Its possible to lookup using odata using request-reply or content enricher.

Regards,

Sriprasad Shivaram Bhat

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Sriprasad,

In the encricher, it adds another field for the corresponding request. can we just pass in the values in the requesting field instead of creating another field?

Regards,

Merina

0

Hi Merina,

Probably after putting an enricher you could add a message mapping and adjust the field structure.

Hope this helps !

thanks and regards,

Praveen T

0
Praveen Tirumareddy

Hi,

I've used content enricher with the below but it is not fetching me anything :

enricher.png (13.3 kB)
0
Merina Acharya Apr 16 at 11:46 AM
0

Thanks Sriprasad, it worked

Share
10 |10000 characters needed characters left characters exceeded
Sriprasad Shivaram Bhat
Apr 16 at 11:05 AM
0

Hello Merina,

I could see there is extra node LookUp Message " Path to Node" field.

Please make it as FODepartment/FODepartment then it should work.And best way to find these XPATH is just do simple query from FODepartment and capture the XPATH so it would be correct.

Regards,

Sriprasad Shivaram Bhat

Share
10 |10000 characters needed characters left characters exceeded