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

RESTful API - Oracle DB call - broken JSON payload (missing elements)

in EPM Platform and Freeform 1 comment

Summary:


Content (please ensure you mask any confidential information):

I'm trying to get data from a RESTful API using a PLSQL procedure developed in an Oracle DB (Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Version 19.23.0.0.0). I'm using SQL developer.

My problem is that the payload received in Oracle DB, using utl_http.read_text or utl_http.read_raw, is broken. Some payload elements are missing (doublecheck with POSTMAN call where the received payload is complete).

Rest API call header parameters are configured similar for both calls ( Postman and OracleDB).

How could I identify which is the source problem for the broken payload received in Oracle DB?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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