Oracle Hospitality Export API
The Export Service provides operations used by Opera to configure and generate file exports of Opera data.
Operations 22
Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay
Ask an LLM
“Which data exports are set up and available for my hotels?”
“Can I include each export's columns, destination setup and generate configuration in the listing?”
Tell an agent
List the exports available for hotels {hotels}.
Show available exports in file group {file_group}, including inactive ones.
GET
/columnsAndFunctions
List columns and functions usable in exports · Operation to fetch export columns and functions
#
Ask an LLM
“What database columns and functions can I use when building an export?”
“Can I see the pre and post procedures available for an export data source?”
Tell an agent
Show export columns and functions for data source {data_source}.
List columns available to export file {export_file}.
Ask an LLM
“How do I add new mapping codes for an export?”
“Can I define fresh export mapping codes for a property?”
Tell an agent
Create export mapping codes {codes} for hotel {hotel}.
Add new mapping codes to the export setup.
Ask an LLM
“How do I change the codes that an export mapping translates values into?”
“Can I edit existing export mapping codes for one hotel?”
Tell an agent
Update export mapping codes {codes} for hotel {hotel}.
Edit the existing export mapping codes.
PUT
/exportMappingLinkedTypes
Update export mapping linked codes · Operation to update export mapping linked types
#
Ask an LLM
“How do I link OPERA codes to an export mapping type?”
“Can I change which codes are linked to an export mapping?”
Tell an agent
Link OPERA codes {linked} to their export mapping types at hotel {hotel}.
Relink codes to export mapping types.
GET
/exportMappings
List export mappings across the chain · Operation to fetch export mappings by chain
#
Ask an LLM
“What export mappings are configured at the chain level?”
“Can I see chain export mappings without naming a single property in the path?”
Tell an agent
List export mappings across the chain.
Show chain-level export mappings filtered to hotel {hotel}.
Ask an LLM
“How do I schedule an export to run automatically?”
“Can I set up a new recurring export job?”
Tell an agent
Create export schedule {schedule}.
Schedule a new recurring export job.
DELETE
/exportSchedules
Remove export schedules by job name · Operation to remove export schedules
#
Ask an LLM
“How do I stop and delete a scheduled export job?”
“Can I remove several export schedules by their job names?”
Tell an agent destructive · confirm first
Delete export schedules for jobs {jobs}.
Remove the scheduled export job named {jobs}.
PUT
/exportSchedules/{exportFileId}
Change an export's schedule at chain level · Operation to change export schedules
#
Ask an LLM
“How do I change the chain-wide schedule of an export file?”
“Can I reschedule an export for the whole chain rather than one hotel?”
Tell an agent
Change the chain-level schedule for export file {export_file}.
Update chain export {export_file} to schedule {schedule}.
GET
/hotels/{hotelId}/configTypes/{configType}/exportMappingCodesToLink
List codes available to link to an export mapping · Operation to fetch export mapping codes to link
#
Ask an LLM
“Which OPERA codes of a configuration type can I still link to an export mapping?”
“Can I search linkable codes by code or description?”
Tell an agent
List {config_type} codes available to link at hotel {hotel}.
Find linkable {config_type} codes matching {code} at hotel {hotel}.
GET
/hotels/{hotelId}/exportActivityLog
View the export activity log · Operation to fetch activity logs for Export Data
#
Ask an LLM
“What export activity happened at a property over a date range?”
“Can I filter the export activity log by activity type or user?”
Tell an agent
Show {activity_type} export activity at hotel {hotel} from {from} to {to}.
Search the export log at hotel {hotel} for {text} between {from} and {to}, type {activity_type}.
DELETE
/hotels/{hotelId}/exportMappingId/{exportMappingId}/exportMappings
Delete an export mapping · Operation to remove export mappings
#
Ask an LLM
“How do I remove an entire export mapping from a property?”
“Can I delete an export mapping by its ID?”
Tell an agent destructive · confirm first
Delete export mapping {mapping_id} at hotel {hotel}.
Remove the whole export mapping {mapping_id} from hotel {hotel}.
GET
/hotels/{hotelId}/exportMappingTypes/{exportMappingTypeId}/exportMappingCodes
Get codes for an export mapping type · Operation to fetch export mapping codes
#
Ask an LLM
“What mapping codes belong to a given export mapping type?”
“Which translated values does an export mapping type use at my hotel?”
Tell an agent
Show mapping codes for export mapping type {type_id} at hotel {hotel}.
List the codes defined under mapping type {type_id} for hotel {hotel}.
GET
/hotels/{hotelId}/exportMappings
List a hotel's export mappings · Operation to fetch export mappings
#
Ask an LLM
“What export mappings are set up for a specific hotel?”
“Can I fetch export mapping configs for one property?”
Tell an agent
List export mappings for hotel {hotel}.
Show export mapping configs {configs} at hotel {hotel}.
POST
/hotels/{hotelId}/exportMappings
Create an export mapping for a hotel · Operation to create export mappings
#
Ask an LLM
“How do I set up a new export mapping at a property?”
“Can I define a fresh mapping for how values appear in an export?”
Tell an agent
Create an export mapping at hotel {hotel}.
Add export mapping {mapping} for hotel {hotel}.
PUT
/hotels/{hotelId}/exportMappings
Update a hotel's export mappings · Operation to update export mappings
#
Ask an LLM
“How do I change an existing export mapping at a property?”
“Can I edit the export mapping definition for one hotel?”
Tell an agent
Update export mappings for hotel {hotel}.
Change hotel {hotel}'s export mapping to {mapping}.
GET
/hotels/{hotelId}/exportMappings/linkedCodes
List codes already linked to export mappings · Operation to fetch export mapping linked codes
#
Ask an LLM
“Which codes are already linked to an export mapping at my hotel?”
“Can I filter linked codes by configuration type?”
Tell an agent
Show export mapping linked codes at hotel {hotel}.
List linked codes of type {config_type} at hotel {hotel}.
DELETE
/hotels/{hotelId}/exportMappings/{exportMappingId}/mappingTypes/{mappingTypeCode}/exportMappingCodes
Remove a mapping type's codes from an export mapping · Operation to remove export mapping codes
#
Ask an LLM
“How do I delete the codes of one mapping type inside an export mapping?”
“Can I remove mapping codes without deleting the whole export mapping?”
Tell an agent destructive · confirm first
Delete {type_code} codes from export mapping {mapping_id} at hotel {hotel}.
Remove mapping type {type_code} codes on mapping {mapping_id}, hotel {hotel}.
GET
/hotels/{hotelId}/exportSchedules
List a hotel's export schedules · Operation to fetch export schedules
#
Ask an LLM
“Which exports are scheduled to run at a property, and how often?”
“Can I filter export schedules by frequency or export name?”
Tell an agent
List export schedules for hotel {hotel}.
Show {frequency} export schedules at hotel {hotel}.
PUT
/hotels/{hotelId}/exportSchedules/{exportFileId}
Change an export's schedule at one hotel · Operation to change export schedules
#
Ask an LLM
“How do I change when an export runs at a single property?”
“Can I reschedule one hotel's export file?”
Tell an agent
Change the schedule of export file {export_file} at hotel {hotel}.
Set hotel {hotel}'s export {export_file} to schedule {schedule}.
Ask an LLM
“Is the data export service up?”
“How can I health-check the export service?”
Tell an agent
Ping the export service.
Check export service availability for hotel {hotel}.
GET
/{exportFileId}/generatedExports
List files generated by an export · Operation to fetch exports generated
#
Ask an LLM
“Which files has a given export already produced?”
“Can I page through the generated output of an export file?”
Tell an agent
List generated exports for export file {export_file}.
Show generated export data {data_id} for export file {export_file}.
Documentation
📖
Documentation
https://docs.oracle.com/cd/F29336_01/doc.201/f27480/c_oracle_hospitality_distribution_apis.htm
📖
Documentation
https://docs.oracle.com/cd/F29336_01/doc.201/f27480/c_oracle_hospitality_nor1_integrated_upsell_apis.htm
📖
Documentation
https://docs.oracle.com/cd/F29336_01/doc.201/f27480/c_property_apis.htm