Introduction:
This blog has the REST API Webservice details that can be used to Get the lookup values from Oracle Cloud application.
Cause of the issue:
For an integration process there are some custom configuration values being stored in application lookups. Business need to fetch the dynamic values from lookup.
How do we solve:
Oracle provides a REST API webservice which can be used to get the lookup values from Oracle Cloud in the form of payload. REST API responds with data in the form of JSON format. Below is the sample payload used to import the items.
REST API: /fscmRestApi/resources/11.13.18.05/standardLookups/
Sample Request URL: https://xx.oraclecloud.com/fscmRestApi/resources/11.13.18.05/standardLookups/XX_LOOKUP_NAME/child/lookupCodes?q=EnabledFlag=Y
Method: GET
REAT Response:
The response will have the status code.
- Success code – “200 OK”
- Error code – anything other than 200 OK
Response text,
The response text will have the lookup table data in the form of JSON.
