13.5.1 Processing REST Source Rows in Code

Use the APEX_EXEC package to process rows from REST Data Sources programmatically.

If the REST Data Source defines operations supporting all Database Action values, then you can both query and modify data. Using appropriate package functions, you open a "context" for working with rows. When querying rows, you iterate through the results in a loop. When modifying rows you add rows to the context and then execute the DML operations for those rows. When done, you close the context to release its resources.

• Querying REST Source Rows in Code
  Use OPEN_REST_SOURCE_QUERY in the APEX_EXEC package to query rows from a REST Data Source. It automatically executes the operation with the Fetch rows Database Action.
• Modifying REST Source Rows in Code
  Use OPEN_REST_SOURCE_DML_CONTEXT in the APEX_EXEC package to modify a row from a REST Data Source.