Getting the Possible Object Mappings Using Selected Strategies

Usage

Gets the list of possible object mappings that have been found using the given strategies.

These strategies apply in the order specified in the request until one object match is found. If no data provider is specified, the request is run on all the existing data providers in the document.

Request

PUT /documents/<documentID>/dataproviders/mappings?originDataproviderIds=<dataProviderID[,...]>&targetDatasourceId=<dataSourceID>

Where:

  • <dataProviderID[,...]> is the list of data provider identifiers to consider for the mapping, separated by commas. This parameter is optional.
  • <dataSourceID> is the target data source identifier to use for the proposal mapping. This parameter is mandatory.

Request body:

<policy qualificationTolerance="Low|Normal|High" dataTypeTolerance="Low|Normal|High"> 
    <strategies mappingSourceIds="string"> 
        <strategy name="string" targetId="string"/>
See Mappings Request and Response Body Schemas for request body description.
Response

Response type: application/xml or application/json

Response body: the details of the mappings, described in Mappings Request and Response Body Schemas.

Example

PUT /documents/7278/dataproviders/mappings?targetDatasourceId=6610

Request body:

{"policy":
    {"strategies": [
       {"strategy": [
          {"@name":"SamePath"},
          {"@name":"SameTechnicalName"},
          {"@name":"SameName"},
          {"@name":"Removal"}]
      },
      {
        "@mappingSourceIds":"DS0.DO2,DS0.DO7, DS0.DO18, DS0.DO4",
        "strategy": [
          {"@name":"SameId"},
          {"@name":"CloseName"}]
      },
      {
        "@mappingSourceIds":"DS0.DO25",
        "strategy": {
          "@name":"Selection",
          "@targetId":"M[Measures].[Customer Count]"}
      },
      {
        "@mappingSourceIds":"DS0.DO7",
        "strategy": {
          "@name":"Selection",
          "@targetId":"M[Measures].[Internet Sales Amount]"}
      }
    ]
  }
}

Response:

{"mappings": {
    "policy": {
      "strategies": [
        {
          "strategy": [
            {"@name":"SamePath"},
            {"@name":"SameTechnicalName"},
            {"@name":"SameName"},
            {"@name":"Removal"}]
        },
        {
          "@mappingSourceIds":"DS0.DO2,DS0.DO7, DS0.DO18, DS0.DO4",
          "strategy": [
            {"@name":"SameId"},
            {"@name":"CloseName"}]
        },
        {
          "@mappingSourceIds":"DS0.DO25",
          "strategy": {
            "@name":"Selection",
            "@targetId":"M[Measures].[Customer Count]"}
        },
        {
          "@mappingSourceIds":"DS0.DO7",
          "strategy": {
            "@name":"Selection",
            "@targetId":"M[Measures].[Internet Sales Amount]"}
        }
      ]
    },
    "content": {
      "mapping": [
        {
          "@status":"Ambiguous",
          "source": {"id":"DS0.DO12"},
          "target": {"id": "L[Sales Territory].[Sales Territory].[Region]"}
       },
        {
          "@status":"Ambiguous",
          "source": {"id":"DS0.DO13"},
          "target": {"id": "A[Customer].[City]"}
        },
        {
          "@status":"NotFound",
          "source": {"id":"DS0.DO17"}
        },
        {
          "@status":"Ambiguous",
          "source": {"id":"DS0.DO18"},
          "target": {"id":"A[Customer].[City]"}
        },
        {
          "@status":"Ambiguous",
          "source": {"id":"DS0.DO2"},
          "target": {"id":"A[Product].[Color]"}
        },
        {
          "@status":"Ambiguous",
          "source": {"id":"DS0.DO25"},
          "target": {"id":"M[Measures].[Customer Count]"}
        },
        {
          "@status":"Ambiguous",
          "source": {"id":"DS0.DO4"},
          "target": {"id":"L[Internet Sales Order Details].[Internet Sales Orders].[Order Line]"}
        },
        {
          "@status":"Ambiguous",
          "source": {"id": "DS0.DO6"},
          "target": {"id":"A[Customer].[Country]"}
        },
        {
          "@status":"Ambiguous",
          "source": {"id":"DS0.DO7"},
          "target": {"id":"M[Measures].[Internet Sales Amount]"}
        },
        {
          "@status":"Ambiguous",
          "source": {"id":"DS0.DO84"},
          "target": {"id":"A[Customer].[Country]"}
        }
      ]
    }
  }
}