Account
Earned badges
Achievement: Latest Unlocked
Replies
Topics Started
Preferences
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
Thursday, July 13, 2023 at 04:26pmPFA for the code snippet
Reply to: PL SQL send pdf file via rest api
Friday, July 14, 2023 at 07:54amThank 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
Friday, July 14, 2023 at 08:59amHi 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
Sunday, July 16, 2023 at 05:07pmHi 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
Monday, July 17, 2023 at 11:53amHi 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 |