Tag: APIs
-
From one API to another: Using ORDS Auto-REST to update a table
I think in this new age of AI/LLMs it is important to understand prompting. Eventually, whether we like it or not, we’ll all need to become “prompt engineers.” And as you’ll see in that thread, you actually have to know what you are doing to be able to ask the right questions and to challenge…
Written by

-
Example: an ORDS API that returns a user-configured JSON object
This actually came about from a Support Request. We were troubleshooting a JWT issue, that had ORDS in the mix. Ultimately, this is looking more and more like a networking issue (maybe something to do with routing rules between the load balancer and the backend server). But in the course of our troubleshooting, we wanted…
Written by

-
A simple ORDS GET request using the Go language
Venkata this one’s for you 😀 It took me the rest of the afternoon, but here is a pretty simple GET request example, using a user-defined ORDS API. This API is derived from one of our LiveLabs, a Python + JavaScript application. But this particular scenario pretty well exemplifies what we discussed in our presentation…
Written by

-
ORDS as a JotForm webhook: An actual customer use case
Recently, we (one of our Support engineers and I) worked with a customer who had integrated various ORDS POST APIs with a web-based form application called JotForm. JotForm offers integrations for numerous workflows, some official and others you can create independently. That’s where we come in. In this example, a user would enter information into…
Written by
-
ORDS 24.4 Release Highlights
So what even is new in ORDS 24.4? How about an abbreviated list of some fan favorites? Pre-Authenticated endpoints Using the new ORDS_PAR PL/SQL package, users can create, revoke, issue and set tokens and token life for specific resources. Your REST-enabled schema will automatically have access to this new feature in 24.4. You can execute…
Written by

-
New ORDS feature: handling multiple files from a multipart/form-data POST request
A new feature An ORDS user (or application) can now upload multiple files as part of a multipart/form-data POST request under various conditions. How can this be achieved with an ORDS endpoint? NOTE: Before you continue, it might be helpful to refresh your memory on, or learn more about multipart/form-data as a Content-Type. Details here.…
Written by

-
Python script to retrieve objects from Oracle Cloud Bucket
For…reasons, I needed a way to retrieve all the .CSV files in a regional bucket in Oracle Cloud Object Storage, located at this address: https://objectstorage.us-phoenix-1.oraclecloud.com/n/dwcsprod/b/moviestream_data_load_workshop_20210709/o You can visit it; we use it for one of our LiveLabs (this one), so I’m sure it will stay live for a while 😘. Once there, you’ll see all…
Written by

-
Build an ORDS API Resource Module, GET request with JavaScript fetch, display in HTML
Really trying to optimize SEO with that title 👆🏼! Recap 💡 All the code you’ll see in this post can be found in my moviestreamjs github repository.💡 This post is a continuation of a previous one, which can be found here. In this post, I’ll: If you are coming from the previous related post, then…
Written by
-
Create a view from a JSON Collection and REST-enable it with ORDS
The DBMS_CLOUD PL/SQL Package You can use this PL/SQL procedure (in the DBMS_CLOUD package) along with the file_uri_list URL (seen in the code below) to create and then add JSON documents to a JSON Collection (good info on JSON Collections in the Oracle database). In this example, we call this collection Movie_Collection. 👆🏻 This is…
Written by
