ConnectorMapping Type Definition

[This topic is pre-release documentation and is subject to change.]

Once a Connector channel is established, a ConnectorMapping can be created to define the metadata and data sources for each Profile or Interaction type.

Properties

Property names appended with asterisks* are required.

ConnectorMapping properties

Property JSON type Description
connectorName string Name of the Connector
connectorMappingName string Name of the mapping (readonly)
connectorType string [ "None" | "CRM" | "AzureBlob" | "Salesforce" | "ExchangeOnline" | "Outbound" ]
created string (Datetime) Creation time of the mapping (readonly)
displayName string Display name for the mapping
description string Description for the mapping
dataFormatId string Identifier of the data format (readonly)
entityType* string Mapped entity type ["None | "Profile" | "Interaction" | "Relationship"]
entityTypeName* string Name of the mapped entity type
lastModified string (Datetime) Last modified time of the mapping
mappingProperties* ConnectorMappingProperties[ ] Collection of additional properties for the mapping (see below)
nextRunTime string (Datetime) Next run time based on customer's settings
runId string Execution identifier (readonly)
state string [ "Creating" | "Created" | "Ready" | "Expiring" | "Deleting" | "Failed" ] (readonly)
tenantId string Hub name


ConnectorMappingProperties properties

Property JSON type Description
folderPath string Folder path for the mapping
fileFilter string File filter for the mapping
hasHeader boolean Indicates whether the file contains header or not
availability* ConnectorMappingAvailability Availability of mapping property (see below)
completeOperation* ConnectorMappingCompleteOperation Operation to perform on import file after mapping (see below)
errorManagement* ConnectorMappingErrorManagement Error management behavior (see below)
format* ConnectorMappingFormat Format of mapping property (see below)
structure* ConnectorMappingStructure[ ] Ingestion mapping information at property level (see below)

ConnectorMappingAvailability properties

Property JSON type Description
frequency string Time unit: ["Minute" | "Hour" | "Day" | "Week" | "Month"]
interval* int Combined with Frequency to specify time interval. The minimal frequency we allowed is 15 minutes.

ConnectorMappingCompleteOperation properties

Property JSON type Description
completionOperationType string Operation to perform on the import file after successful mapping: [ "DoNothing"
destinationFolder string Destination folder where files are moved after importation

ConnectorMappingErrorManagement properties

Property JSON type Description
errorManagementType* string Specifies action on error: ["RejectAndContinue" | "StopImport" | "RejectUntilLimit"]
errorLimit int Specifies the maximum number of errors allowed in a data import operation

ConnectorMappingFormat properties

Property JSON type Description
formatType* string Type of formatting, currently only: "TextFormat"
columnDelimiter string Column delimiter used, e.g. ",", ";", "-"
acceptLanguage string OData language spec
quoteCharacter string Quote character to indicate enquoted fields
quoteEscapeCharacter string Escape character for quotes, if required
arraySeparator string Character to separate array elements

ConnectorMappingStructure properties

Property JSON type Description
propertyName* string Property name of the mapping entity
columnName* string Column name within the import file
customFormatSpecifier string Custom format specifier for input parsing
isEncrpted boolean True if the the column is encrypted

JSON example

{
    "connectorMappingName": "testMapping12491",
    "connectorName": "testConnector8858",
    "connectorType": "AzureBlob",
    "dataFormatId": "4619d4e7e8a64c1e9bc34907f9f46505",
    "description": "Test mapping for data #12491",
    "displayName": "Test Mapping #12491",
    "entityType": "Interaction",
    "entityTypeName": "TestInteractionType2967",
    "fileFilter": "unknown",
    "folderPath": "http://contoso.com/file",
    "hasHeader": false,
    "state": "Created",
    "tenantId": "sdktesthub"
    "type": "Microsoft.CustomerInsights/hubs/connectors/mappings"
    "mappingProperties": {
        "availability": {
            "frequency": "Hour",
            "interval": 5
        },
        "completeOperation": {
            "completionOperationType": "DeleteFile",
            "destinationFolder": "fakePath"
        },
        "errorManagement": {
            "errorLimit": 10,
            "errorManagementType": "StopImport"
        },
        "format": {
            "columnDelimiter": "|",
            "acceptLanguage": "",
            "quoteCharacter": "\\\"",
            "quoteEscapeCharacter": "\\\"",
            "formatType": "TextFormat",
            "arraySeparator": ";"
        },
        "structure": [{
            "columnName": "unknown1",
            "isEncrypted": false,
            "propertyName": "unknwon1"
            },
            {
            "columnName": "unknown2",
            "isEncrypted": true,
            "propertyName": "unknwon2"
        }]
    },
}