REST API connector tables for Zero Copy Connector for ERP

The REST API connector in Zero Copy Connector for ERP (Enterprise Resource Planning) uses these tables to store service definitions, endpoint definitions, and model metadata.

For an overview of the REST API connector, see REST API for Zero Copy Connector for ERP.

For process details, see Add a REST entity to a model operation.

For information about adding a service, see Add a REST service manually in Zero Copy Connector for ERP.

Oracle E-Business Suite services described by WADL documents use their own set of tables.

Table Description sn_erp_integration_rest_service_catalog Stores imported REST API service definitions (name, version, base URL). sn_erp_integration_rest_service_endpoint Stores individual endpoint definitions (path, HTTP method, inputs, outputs, return type). sn_erp_integration_model_operation Stores model operations, including the rest operation type, the pagination_type choice field, and the http_method column. sn_erp_integration_model_entity Stores model entities, including the rest entity type used for REST API operations. A WADL entity type is also available for Oracle E-Business Suite services. sn_erp_integration_input_mapping Stores input mappings, including the pagination_type field and the pagination_operator field used for offset and limit tracking. sn_erp_integration_model_table_field Stores field metadata parsed from service definitions, whether OpenAPI specifications or WADL and XML Schema Definition documents.