Upsert a Lookup Table

Upsert a Lookup Table

Create or update a lookup table by name and read back the result.

1. List existing lookups so the workflow can detect whether the target lookup name already exists.
2. Update the existing lookup table with the supplied description and columns.
3. Create a new lookup table with the supplied name, description, and columns when no existing lookup matched.
4. Read the lookup back by name to confirm the persisted definition.

What you'll need to have ready

• lookupName: The lookup table name (e.g. COUNTRY_CODES).
• description: Human-readable description of the lookup table.
• columns: The list of column names for the lookup table.

For your developer

Arazzo workflow oracle-integration:upsert-lookup, 4 operations: listLookups → updateLookup → createLookup → getLookup. Specs on APIs.io.