Account


Earned badges

Achievement: Latest Unlocked

Topic Started

Topics

PL SQL send pdf file via rest api

Getting below error while trying to send pdf file via rest api using Oracle utl_http

Replies Created

Reply to: PL SQL send pdf file via rest api

0 votes

Thank you Duo for the response. Yes, I am setting the URL as "https://dxxxv/api/packages/", this is an Dsign Development/SIT instance for our Organization. I am invoking this API call from Our Dev Oracle Server using PL/SQL UTL_HTTP. Please, can you share the IP Address for "sandbox.esignlive.com" servers hosting the API calls. 

For your reference, I am attaching the pdf document and I am having no issues uploading it from UI. Also, the code snippet.

 

Thanks,

Ratna.

 


Reply to: PL SQL send pdf file via rest api

0 votes

Hi Duo,

The package on Sandbox. Package ID :  fBfQWq45eC2EYYgbNqRKdwzZmmU=

 

Internal Dsign for our organization

URL for API Calls :  https://dxxxv
URL for UI : https://txxxv/ISA/login
Package ID on Internal Dsign : zGE3p5rXjHJ33kYROmrjBTlBGJU=

Thanks,

Ratna.


Reply to: PL SQL send pdf file via rest api

1 votes

Hi Duo,

Could you either test the connection against your on-premise environment with a GET or simple POST call first,

Yes, we are able to establish a connection from Oracle Server to On-prem Dsign SIT environment. In fact, we had created multiple packages using POST, and also qurey those packages using GET method. Unfortunately, we are facing issues with attach document API with 500 (Internal Server error). 

or try the code base with sandbox environment (you can find the IP address of all OSS instances in this guide)? 

I doubt if we can connect to sandbox (i.e external network) from our Internal Oracle Servers. Not sure, if our security team would allow or this request. Hope you understand this limitation on our end.

 

Thank you for the documentation provided for PL/SQL integration, I will go through it and check if I am missing anything.

Thanks,

Ratna.


Reply to: PL SQL send pdf file via rest api

0 votes

Hi Duo,

Thank you for the documentation on PL/SQL integration. I have gone through provided integration documents & examples. Everything is coved in our code, please let us know still why we are getting the 500 (Internal Server Error) ?

 

Thanks,

Ratna. 


Subscriptions

Topics Replies Freshness Views Users

PL SQL send pdf file via rest api

Getting below error while trying to send pdf file via rest api using Oracle utl_http

15 9 months 2 weeks ago 222
Profile picture for user Duo_Liang

Code Share

This user has not submitted any code shares.

Subscriptions Release Notes

This user is not subscribed to any release notes.