SCP Data Service ION APIs in MT Cloud

SCP Data Service is a set of ION APIs provided to import planning data into SCV and to export plan results from SCV.

The SCP data service API is implemented using the following endpoint:

<tenant>/IONSERVICES/IBP/api/dataservice/v1

The endpoint includes services to import planning data into SCV and to export plan results from SCV. These services are currently available:

  • tableDelete
  • tableImport
  • tableExport

These services accept SCV table name as input parameter to read from SCV Outbox or Export Staging tables and to write into SCV Inbox or Import Staging tables. When both reading from SCV and writing to SCV, the returned results and the input payload match the table definition (for example, schema) in SCV. A table registered in SCV can be used by services, including system-defined (standard) tables and user-defined (custom) tables.

Newline delimited JSON documents (NDJSON) are used to exchange data with the SCP data service API. Multiple records can be included in one payload where individual records are enclosed using brackets. The format uses property or value pairs. Only the columns in the specified SCV table can be used in the payload. However, all columns or properties are not required to be included in a payload; the columns or properties can be a subset of the table schema.

The services in the SCP data service are implemented as REST APIs:

  • POST IBP/api/dataservice/v1/tableDelete
  • POST IBP/api/dataservice/v1/tableImport
  • GET IBP/api/dataservice/v1/tableExport

Documentation for each of the APIs is accessible directly within the ION APIs application.

Note: This feature is currently only available for Multi-Tenant Cloud deployments. The “Supply Chain Planning” ION APIs are enabled by default for all new Tenants.

The Data Service needs a valid Infor OS user for execution of the ION APIs. If testing the service from the ION API documentation page, the current logged-in user is used.

Calling ION APIs from ION Workflows requires a special configuration with a service account. This process is covered by Infor OS documentation.