Load Mapping From Documentation

Topics:

Use the following REST call to load mappings from Microsoft Excel into the metadata repository. This REST call is available as of Version 3.11.

POST: /api/v1/sourcesystem/integration/mapping/load?int_pt_id={id}&subjects={s1,s2}

Topics:

Parameters:

int_pt_id: the ID of the integration point to which this mapping belongs.

subjects: optionally, a comma delimited list of specific subjects to load from the spreadsheet.

excel_file: an Omni generated documentation file containing mappings from a source system to one or more subjects. These will correspond to sheet names in the spreadsheet.

When a model is deployed into Omni server, Excel spreadsheets are generated to allow users to document the mappings from external systems into Omni subjects. This service allows information captured in those spreadsheets to be loaded into the metadata repository.

Example:

POST /api/v1/sourcesystem/integration/mapping/load?int_pt_id=f9c9af9822-b9bf95ba4c&subjects=Customer

-- response --

{
  "status": "ACCEPTED",
  "code": 0,
  "message": null,
  "developerMessage": null,
  "responseType": null,
  "response": null,
  "exception": null
}