How to Export RESTful APIs in Oracle Application Express

By admin · January 30, 2023

Seven steps to export a RESTful service definition from SQL Workshop in Oracle APEX, including its resources, methods and the PL/SQL behind them.

Log in to the Oracle Application Express Development environment.
Click on the SQL Workshop.
Click on the RESTful Services.
Select the RESTful Service you want to export.
Click the Export button in the RESTful Services page.
Choose a format for the export file.
Save the file to your local file system.

This will export the RESTful API definition, including all its resources, methods, and associated PL/SQL code. Keep it with the rest of your application exports; on managed Oracle APEX hosting those exports are scheduled and retained for you.

We value your privacy

We use cookies to run this site, remember your preferences, and understand how visitors use Revion. You can accept all, reject non-essential cookies, or choose which categories to allow. See our Privacy Policy.

We use cookies to run this site, remember your preferences, and understand how visitors use Revion. Accept all, reject non-essential cookies, or choose which categories to allow. See our Privacy Policy.

Customize Consent Preferences

Choose what this site is allowed to load. Essential is always on, because without it we cannot remember what you decide here. The other three stay off until you turn them on, and you can come back and change them whenever you like from our Privacy Policy or Cookie Policy page.

Always on

Needed for the site to work and to remember the choice you make here. Nothing in this category identifies you or follows you between visits, and it cannot be switched off.

reCAPTCHA v3

Google. Requested only when you submit a form. Sets nothing before that.

The contact and quote forms are checked by reCAPTCHA v3 so that the inbox stays usable. It is fetched from Google at the moment you press the send button and at no other time. Read a page and leave without submitting a form and your browser never contacts Google at all, and no reCAPTCHA cookie is set, which is why it is not in the table below.

Essential cookies
Cookie	Duration	What it does, and who sets it
revion_consent	12 months	Set by revion.com. Remembers which categories you allowed here, and which version of this notice you were shown, so that we do not ask again until it changes. It holds a setting and nothing else: no visitor identifier, and nothing that follows you between visits.

Loads Google Analytics 4, so we can see which pages are read and which are not, and fix the ones nobody finds. Off by default, and while it is off this site loads no analytics tag at all, so there is nothing for it to send.

Google Analytics 4

Google. Loaded only once you allow it. The cookies it writes are listed below.

Counts page views, and records which site or search sent you here, so we know which pages earn their place. It is a plain gate rather than a consent signal: while this category is off the tag is not requested, no measurement cookie is written, and nothing about your visit reaches Google from this site in any form. Turn it back off later and the tag is taken out of the page and both cookies are deleted.

Analytics cookies
Cookie	Duration	What it does, and who sets it
_ga	400 days	Set by Google Analytics, on the revion.com domain. Tells one visitor apart from another so that visits can be counted without identifying anyone. Two page views from the same browser count as one visitor rather than two. Written only after you allow this category.
_ga_T94F03YGES	400 days	Set by Google Analytics, on the revion.com domain. Keeps track of the visit you are in the middle of, for our own measurement property: the letters on the end are that property, and no other site shares it. Written only after you allow this category.

Loads the scheduling calendar on our meeting request page. Off by default, and the page still gives you three other ways to reach us while it is off.

Calendly scheduling widget

Calendly. Loaded on /meeting-request/ only, and only once you allow it.

The booking calendar. Calendly loads it in a frame of its own, and that frame is Calendly's page rather than ours, so it carries Calendly's own suppliers. We measured it contacting Cloudflare, Stripe, Google, Facebook, Segment, Braze, Sprig and Airbrake. Two of those store a cookie on your device, Cloudflare and Stripe, and those are the two listed below. While this category is off the calendar is not requested and not one of those companies is contacted, and the page offers you the booking link, our phone number and our email address instead.

Functional cookies
Cookie	Duration	What it does, and who sets it
__cf_bm	30 minutes	Set by Cloudflare, inside the Calendly calendar. Tells automated traffic apart from real visitors so that the calendar stays available to people. It reads how the request was made, not who made it.
_cfuvid	Until you close your browser	Set by Cloudflare, inside the Calendly calendar. Groups the requests that make up a single visit, so that Cloudflare can apply its limits per visitor rather than per request. It is deleted when you close your browser.
m	400 days	Set by Stripe, which Calendly loads inside its calendar to take payments. It records what kind of device you are on so that Stripe can tell genuine payment traffic from fraud. Revion takes no payment through this website.