After signing in, you can create credentials that can be used to call the Platform APIs.
Download OpenAPI specification:Download
Data Prep allows data engineers to map, transform, and validate data to and from Experience Data Model (XDM). Use the Data Prep API to programmatically create mapping sets and functions, and transform your data between source and destination schemas.
Related documentation:
API paths:
Required headers:
Authorization
, x-gw-ims-org-id
, and x-api-key
. For more information on how to obtain these values, see the authentication tutorial.x-sandbox-name
whose value is the all-lowercase name of the sandbox the operation will take place in (for example, "prod"). See the sandboxes overview for more information.Content-Type
header with a value of application/json
.API error handling:
You can now interact with the Experience Platform API endpoints directly from this API reference page. Get your authentication credentials and use the Try it functionality in the right rail. Note that by using this functionality, you are making real API calls. Keep this in mind when you interact with production sandboxes.
Mapping-set functions allow you to transform your data between source and destination schemas. You can use these functions to validate your expressions and get a list of all the available mapping-set functions and operations.
Authorization required | string The access token which can be copied from your Experience Platform integration, prefixed with "Bearer ". For more information on how to obtain this value, visit the authentication tutorial. |
Content-Type required | string The type of content being sent in the body of the request. This value generally is |
x-api-key required | string The API key which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-gw-ims-org-id required | string The IMS Organization ID which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-sandbox-name required | string All resources in Experience Platform are isolated to specific virtual sandboxes. Requests to Platform APIs require a header that specifies the name of the sandbox in which the operation will take place. See the sandboxes overview for more information. |
The expression you are validating.
Validation status returned
Invalid expression error
Unauthorized request
Internal server error
Service unavailable
{- "expression": {
- "expression": "concat(\"Hi\", \",\", \"there\", \"!\")"
}
}
false
Authorization required | string The access token which can be copied from your Experience Platform integration, prefixed with "Bearer ". For more information on how to obtain this value, visit the authentication tutorial. |
x-api-key required | string The API key which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-gw-ims-org-id required | string The IMS Organization ID which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-sandbox-name required | string All resources in Experience Platform are isolated to specific virtual sandboxes. Requests to Platform APIs require a header that specifies the name of the sandbox in which the operation will take place. See the sandboxes overview for more information. |
List of mapping-set functions retrieved
Invalid request error
Unauthorized access
Internal server error
Service unavailable
[- {
- "category": "Date / Time",
- "function": "date",
- "description": "Function that converts date string into a ZonedDateTime object.",
- "syntax": "ZonedDateTime date(String, String, ZonedDateTime)",
- "returns": "Returns the date object that is formatted in given format or a default date if the expression evaluates to a null date.",
- "returnType": "java.time.ZonedDateTime",
- "example": "",
- "result": "",
- "params": [ ],
- "since": 1
}, - {
- "category": "Hierarchies - Arrays",
- "function": "first",
- "description": "Function to retrieve the first element of the given array.",
- "syntax": "T first(T...)",
- "returns": "The first element or null if the array is null or empty.",
- "returnType": "java.lang.Object",
- "example": "first(\"1\", \"2\", \"3\")",
- "result": "\"1\"",
- "params": [
- {
- "name": "values",
- "description": "Zero or more arguments",
- "type": "object",
- "dataType": "[Ljava.lang.Object;",
- "position": 1
}
], - "since": 1
}
]
Authorization required | string The access token which can be copied from your Experience Platform integration, prefixed with "Bearer ". For more information on how to obtain this value, visit the authentication tutorial. |
x-api-key required | string The API key which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-gw-ims-org-id required | string The IMS Organization ID which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-sandbox-name required | string All resources in Experience Platform are isolated to specific virtual sandboxes. Requests to Platform APIs require a header that specifies the name of the sandbox in which the operation will take place. See the sandboxes overview for more information. |
List of valid operators retrieved
Invalid request error
Unauthorized access
Internal server error
Service unavailable
[- {
- "operatorSymbol": "+",
- "methodName": "add",
- "numberOfOperands": 2,
- "description": "Simple arithmetic addition",
- "example": "1 + 2"
}, - {
- "operatorSymbol": "/",
- "methodName": "divide",
- "numberOfOperands": 2,
- "description": "Simple arithmetic division",
- "example": "1 / 2"
}, - {
- "operatorSymbol": "~",
- "methodName": "complement",
- "numberOfOperands": 1,
- "description": "The usual ~ operator is used, e.g., ~33, ~0010 0001 = 1101 1110 = -34.",
- "example": "~44"
}, - {
- "operatorSymbol": "-",
- "methodName": "negate",
- "numberOfOperands": 1,
- "description": "The unary - operator is used. For example, -12",
- "example": "-12"
}, - {
- "operatorSymbol": "!",
- "methodName": "not",
- "numberOfOperands": 1,
- "description": "The usual ! operator can be used as well as the word not, e.g., !cond1 and not cond1 are equivalent",
- "example": "!cond1"
}
]
Mapping sets can be used to define how data in a source schema maps to that of a destination schema.
Authorization required | string The access token which can be copied from your Experience Platform integration, prefixed with "Bearer ". For more information on how to obtain this value, visit the authentication tutorial. |
x-api-key required | string The API key which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-gw-ims-org-id required | string The IMS Organization ID which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-sandbox-name required | string All resources in Experience Platform are isolated to specific virtual sandboxes. Requests to Platform APIs require a header that specifies the name of the sandbox in which the operation will take place. See the sandboxes overview for more information. |
List of mapping sets retrieved
Invalid request error
Unauthorized request
Internal server error
Service unavailable
{- "data": {
- "id": "428beb15b4864daaaa9dc3f005448005",
- "version": 1,
- "createdDate": 1582250953000,
- "modifiedDate": 1582251156000,
- "createdBy": "acp_xql_gateway",
- "modifiedBy": "acp_ui_platform",
- "supportVersion": "1.1",
- "inputSchema": {
- "id": "e660142cab8e438382abc5691b364b30",
- "version": 0,
- "sampleId": "f9e83882e3e34c1f8b873a3b8113c01e"
}, - "outputSchema": {
- "id": "1956affc28be468aa452e5e47c680c6b",
- "version": 0,
}, - "mappings": [
- {
- "id": "af809223484341009ce0db13d4b32a3a",
- "version": 0,
- "createdDate": 1582250953000,
- "modifiedDate": 1582250953000,
- "createdBy": "acp_xql_gateway",
- "modifiedBy": "acp_xql_gateway",
- "sourceType": "text/x.schema-path",
- "source": "id",
- "destination": "person.name.firstName",
- "identity": false,
- "primaryIdentity": false,
- "matchScore": 0,
- "functionVersion": 1,
- "sourceAttribute": "id",
- "destinationXdmPath": "person.name.firstName"
}
], - "status": "PUBLISHED",
- "strictMapping": false,
- "allowNullValues": false,
- "xdmVersion": "1.0",
}
}
Authorization required | string The access token which can be copied from your Experience Platform integration, prefixed with "Bearer ". For more information on how to obtain this value, visit the authentication tutorial. |
Content-Type required | string The type of content being sent in the body of the request. This value generally is |
x-api-key required | string The API key which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-gw-ims-org-id required | string The IMS Organization ID which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-sandbox-name required | string All resources in Experience Platform are isolated to specific virtual sandboxes. Requests to Platform APIs require a header that specifies the name of the sandbox in which the operation will take place. See the sandboxes overview for more information. |
The details of the mapping set you want to create.
Mapping set created successfully
Invalid mapping set request
Unauthorized request
Internal server error
Service unavailable
{- "mappings": [
- {
- "sourceType": "ATTRIBUTE",
- "source": "id",
- "destination": "_id",
- "name": "id",
- "description": "Identifier field"
}, - {
- "sourceType": "ATTRIBUTE",
- "source": "firstName",
- "destination": "person.name.firstName"
}, - {
- "sourceType": "ATTRIBUTE",
- "source": "lastName",
- "destination": "person.name.lastName"
}
], - "outputSchema": {
- "schemaRef": {
- "contentType": "application/vnd.adobe.xed-full+json;version=1"
}
}
}
{- "id": "e7c80e4c0d8f4a98a7d400b4e178b635",
- "version": 0,
- "createdDate": 1614901254724,
- "modifiedDate": 1614901254724,
- "createdBy": "{CREATED_BY}",
- "modifiedBy": "{MODIFIED_BY}"
}
Authorization required | string The access token which can be copied from your Experience Platform integration, prefixed with "Bearer ". For more information on how to obtain this value, visit the authentication tutorial. |
Content-Type required | string The type of content being sent in the body of the request. This value generally is |
x-api-key required | string The API key which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-gw-ims-org-id required | string The IMS Organization ID which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-sandbox-name required | string All resources in Experience Platform are isolated to specific virtual sandboxes. Requests to Platform APIs require a header that specifies the name of the sandbox in which the operation will take place. See the sandboxes overview for more information. |
The mapping set you want to validate.
Mapping set validation successful
Invalid mapping set request
Unauthorized request
Internal server error
Service unavailable
{- "mappings": [
- {
- "sourceType": "ATTRIBUTE",
- "source": "id",
- "destination": "_id",
- "name": "id",
- "description": "Identifier field"
}, - {
- "sourceType": "ATTRIBUTE",
- "source": "firstName",
- "destination": "person.name.firstName"
}, - {
- "sourceType": "ATTRIBUTE",
- "source": "lastName",
- "destination": "person.name.lastName"
}
], - "outputSchema": {
- "schemaRef": {
- "contentType": "application/vnd.adobe.xed-full+json;version=1"
}
}
}
{- "validationResponse": [
- {
- "status": "SUCCESS",
- "errors": null
}, - {
- "status": "SUCCESS",
- "errors": null
}, - {
- "status": "SUCCESS",
- "errors": null
}
]
}
Authorization required | string The access token which can be copied from your Experience Platform integration, prefixed with "Bearer ". For more information on how to obtain this value, visit the authentication tutorial. |
Content-Type required | string The type of content being sent in the body of the request. This value generally is |
x-api-key required | string The API key which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-gw-ims-org-id required | string The IMS Organization ID which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-sandbox-name required | string All resources in Experience Platform are isolated to specific virtual sandboxes. Requests to Platform APIs require a header that specifies the name of the sandbox in which the operation will take place. See the sandboxes overview for more information. |
The data you want to run through as a preview, which will be transformed by the mapping sets within the body.
Array of objects (JsonNode) | |
object (MappingSet) |
Mapped data preview successful
Invalid request error
Unauthorized request
Internal server error
Service unavailable
{- "data": {
- "id": 1234,
- "firstName": "Jim",
- "lastName": "Seltzer"
}, - "mappingSet": {
- "outputSchema": {
- "schemaRef": {
- "contentType": "application/vnd.adobe.xed-full+json;version=1"
}
}, - "mappings": [
- {
- "sourceType": "ATTRIBUTE",
- "source": "id",
- "destination": "_id",
- "name": "id",
- "description": "Identifier field"
}, - {
- "sourceType": "ATTRIBUTE",
- "source": "firstName",
- "destination": "person.name.firstName"
}, - {
- "sourceType": "ATTRIBUTE",
- "source": "lastName",
- "destination": "person.name.lastName"
}
]
}
}
{- "data": {
- "person": {
- "name": {
- "firstName": "Jim",
- "lastName": "Seltzer"
}
}, - "_id": "1234"
}
}
Authorization required | string The access token which can be copied from your Experience Platform integration, prefixed with "Bearer ". For more information on how to obtain this value, visit the authentication tutorial. |
x-api-key required | string The API key which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-gw-ims-org-id required | string The IMS Organization ID which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-sandbox-name required | string All resources in Experience Platform are isolated to specific virtual sandboxes. Requests to Platform APIs require a header that specifies the name of the sandbox in which the operation will take place. See the sandboxes overview for more information. |
Mapping set details retrieved
Invalid request error
Unauthorized request
Internal server error
Service unavailable
{- "mappings": [
- {
- "sourceType": "ATTRIBUTE",
- "source": "id",
- "destination": "_id",
- "name": "id",
- "description": "Identifier field"
}, - {
- "sourceType": "ATTRIBUTE",
- "source": "firstName",
- "destination": "person.name.firstName"
}, - {
- "sourceType": "ATTRIBUTE",
- "source": "lastName",
- "destination": "person.name.lastName"
}
], - "outputSchema": {
- "schemaRef": {
- "contentType": "application/vnd.adobe.xed-full+json;version=1"
}
}
}
Authorization required | string The access token which can be copied from your Experience Platform integration, prefixed with "Bearer ". For more information on how to obtain this value, visit the authentication tutorial. |
Content-Type required | string The type of content being sent in the body of the request. This value generally is |
x-api-key required | string The API key which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-gw-ims-org-id required | string The IMS Organization ID which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-sandbox-name required | string All resources in Experience Platform are isolated to specific virtual sandboxes. Requests to Platform APIs require a header that specifies the name of the sandbox in which the operation will take place. See the sandboxes overview for more information. |
The updated content of the mapping set.
Mapping set updated successfully
Invalid request error
Unauthorized request
Internal server error
Service unavailable
{- "mappings": [
- {
- "sourceType": "ATTRIBUTE",
- "source": "id",
- "destination": "_id",
- "name": "id",
- "description": "Identifier field"
}, - {
- "sourceType": "ATTRIBUTE",
- "source": "firstName",
- "destination": "person.name.firstName"
}, - {
- "sourceType": "ATTRIBUTE",
- "source": "lastName",
- "destination": "person.name.lastName"
}
], - "outputSchema": {
- "schemaRef": {
- "contentType": "application/vnd.adobe.xed-full+json;version=1"
}
}
}
{- "mappings": [
- {
- "sourceType": "ATTRIBUTE",
- "source": "id",
- "destination": "_id",
- "name": "id",
- "description": "Identifier field"
}, - {
- "sourceType": "ATTRIBUTE",
- "source": "firstName",
- "destination": "person.name.firstName"
}, - {
- "sourceType": "ATTRIBUTE",
- "source": "lastName",
- "destination": "person.name.lastName"
}
], - "outputSchema": {
- "schemaRef": {
- "contentType": "application/vnd.adobe.xed-full+json;version=1"
}
}
}
Authorization required | string The access token which can be copied from your Experience Platform integration, prefixed with "Bearer ". For more information on how to obtain this value, visit the authentication tutorial. |
x-api-key required | string The API key which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-gw-ims-org-id required | string The IMS Organization ID which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-sandbox-name required | string All resources in Experience Platform are isolated to specific virtual sandboxes. Requests to Platform APIs require a header that specifies the name of the sandbox in which the operation will take place. See the sandboxes overview for more information. |
All mappings retrieved successfully
Invalid request error
Unauthorized request
Internal server error
Service unavailable
{- "id": "394bec970d54410b98e1d4c55a3843ca",
- "version": 0,
- "createdDate": 1614909614000,
- "modifiedDate": 1614909614000,
- "createdBy": "{CREATED_BY}",
- "modifiedBy": "{MODIFIED_BY}",
- "sourceType": "text/x.schema-path",
- "source": "firstName",
- "destination": "person.name.firstName",
- "identity": false,
- "primaryIdentity": false,
- "matchScore": 0,
- "functionVersion": 1,
- "sourceAttribute": "firstName",
- "destinationXdmPath": "person.name.firstName"
}
Authorization required | string The access token which can be copied from your Experience Platform integration, prefixed with "Bearer ". For more information on how to obtain this value, visit the authentication tutorial. |
x-api-key required | string The API key which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-gw-ims-org-id required | string The IMS Organization ID which can be copied from your Experience Platform integration. For more information on how to obtain this value, visit the authentication tutorial. |
x-sandbox-name required | string All resources in Experience Platform are isolated to specific virtual sandboxes. Requests to Platform APIs require a header that specifies the name of the sandbox in which the operation will take place. See the sandboxes overview for more information. |
Specific mapping details retrieved
Invalid request error
Unauthorized request
Internal server error
Service unavailable
{- "id": "394bec970d54410b98e1d4c55a3843ca",
- "version": 0,
- "createdDate": 1614909614000,
- "modifiedDate": 1614909614000,
- "createdBy": "{CREATED_BY}",
- "modifiedBy": "{MODIFIED_BY}",
- "sourceType": "text/x.schema-path",
- "source": "firstName",
- "destination": "person.name.firstName",
- "identity": false,
- "primaryIdentity": false,
- "matchScore": 0,
- "functionVersion": 1,
- "sourceAttribute": "firstName",
- "destinationXdmPath": "person.name.firstName"
}