Rest Adapte Receiver

[silentbull]

Hi

I have a requirement to fetch data from Oracle DB and post it to webservices via Rest adapter. Please do clarify the following

1.The REST url pattern will be part static and part dynamic based on Purchase Order Number which is coming in the payload. So I assume we can generate this based on the xpath expression. Please confirm.

2. If the fetched records from Oracle is 10k , will the REST receiver adapter process record by record based on the purchase order number or do I need to enable some batch settings. Is it going to be 10k API calls by the receiver adapter assuming I have unique PO number for each record?

3. Do I need to talk to webservice guys to enable batch processing?

4. I need this to be asynchronous. Is this possible?

[silentbull]

Hi

Additionally, I also want to split my messages. Does REST Receiver adapter supports Enhanced Interface Determination of splitting messages.

[aashish_sinha]

Few cents!

You are planning to generate an API URL in rest adapter based on PO number, can be done but not a feasible solution if your source have multiple records. Generating URL based on PO number will make URL unique for each API call (API call will be made for each PO).

Solution -

Tell your API team to give you a static API in which you can pass all XML records in one shot. They can make it and provide you that URL. Tell them making an URL for each PO is not a feasible solution and it will affect processing.

[silentbull]

Hi Vikas

Thanks for your comments!

Please do shed me more light on the 3rd point.

If the URL pattern is dynamic based on PO number, wouldn't it still be 10k url calls or are you saying the JSON array will send the 10k records dynamically based on PO number changing the url.

[vicky20691]

Hi,

This is what I understand. your requirement is JDBC to REST

1. The dynamic part you can do using ASMA (dymanic configuration udf) or xpath your choice. udf gives you more control to manipulate the dynamic data

2. No , 10k API calls will not be made. 10K records will go in one shot.

3. You need to tell your API team that you are going to send multiple purchase orders (10k) in one shot and they need to consider the json 1 array as one PO

4. Yes this can be asynchronous.

Regards,

Vikas Singh