You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OIC DB Adapter and REST API - Looping

Accepted answer
58
Views
2
Comments
edited Oct 22, 2023 7:36PM in Integration 2 comments

Summary:



1) GetProductInfo is using DB Adapter named 'Product Information' to get all the rows from Oracle database; results are fetched using SQL statement based on the conditions.

2) Based on the rows returns from database and response, attributes are mapped to RequestProductDetails named 'ProductTransactionDetails' REST API

3) Based on the response from REST API (ProductTransactionDetails), values are mapped to UpdateProduct using DB Adapter named 'Product Information'; this will invoke a stored procedure to insert and update database tables.

Currently, this is working for one row. However for multiple records, it is not working as intended. I reckon this is because of looping the calls and invokes.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!