Azure Data Factory · Example Payload
Microsoft Azure Data Factory Changedatacapture_Update
Data IntegrationETLELTData PipelineData MovementOrchestrationData EngineeringChange Data CaptureIntegration RuntimeCloudAzureData Factory
Microsoft Azure Data Factory Changedatacapture_Update is an example object payload from Azure Data Factory, with 4 top-level fields. It illustrates the shape of data this provider's APIs accept or return.
Top-level fields
parametersresponsesoperationIdtitle
Example Payload
{
"parameters": {
"api-version": "2018-06-01",
"changeDataCapture": {
"properties": {
"description": "Sample demo change data capture to transfer data from delimited (csv) to Azure SQL Database. Updating table mappings.",
"allowVNetOverride": false,
"policy": {
"mode": "Microbatch",
"recurrence": {
"frequency": "Minute",
"interval": 15
}
},
"sourceConnectionsInfo": [
{
"connection": {
"type": "linkedservicetype",
"commonDslConnectorProperties": [
{
"name": "allowSchemaDrift",
"value": true
},
{
"name": "inferDriftedColumnTypes",
"value": true
},
{
"name": "format",
"value": "delimited"
},
{
"name": "dateFormats",
"value": [
"MM/dd/yyyy",
"dd/MM/yyyy",
"yyyy/MM/dd",
"MM-dd-yyyy",
"dd-MM-yyyy",
"yyyy-MM-dd",
"dd.MM.yyyy",
"MM.dd.yyyy",
"yyyy.MM.dd"
]
},
{
"name": "timestampFormats",
"value": [
"yyyyMMddHHmm",
"yyyyMMdd HHmm",
"yyyyMMddHHmmss",
"yyyyMMdd HHmmss",
"dd-MM-yyyy HH:mm:ss",
"dd-MM-yyyy HH:mm",
"yyyy-M-d H:m:s",
"yyyy-MM-dd\\'T\\'HH:mm:ss\\'Z\\'",
"yyyy-M-d\\'T\\'H:m:s\\'Z\\'",
"yyyy-M-d\\'T\\'H:m:s",
"yyyy-MM-dd\\'T\\'HH:mm:ss",
"yyyy-MM-dd HH:mm:ss",
"yyyy-MM-dd HH:mm",
"yyyy.MM.dd HH:mm:ss",
"MM/dd/yyyy HH:mm:ss",
"M/d/yyyy H:m:s",
"yyyy/MM/dd HH:mm:ss",
"yyyy/M/d H:m:s",
"dd MMM yyyy HH:mm:ss",
"dd MMMM yyyy HH:mm:ss",
"d MMM yyyy H:m:s",
"d MMMM yyyy H:m:s",
"d-M-yyyy H:m:s",
"d-M-yyyy H:m",
"yyyy-M-d H:m",
"MM/dd/yyyy HH:mm",
"M/d/yyyy H:m",
"yyyy/MM/dd HH:mm",
"yyyy/M/d H:m",
"dd MMMM yyyy HH:mm",
"dd MMM yyyy HH:mm",
"d MMMM yyyy H:m",
"d MMM yyyy H:m",
"MM-dd-yyyy hh:mm:ss a",
"MM-dd-yyyy HH:mm:ss",
"MM/dd/yyyy hh:mm:ss a",
"yyyy.MM.dd hh:mm:ss a",
"MM/dd/yyyy",
"dd/MM/yyyy",
"yyyy/MM/dd",
"MM-dd-yyyy",
"dd-MM-yyyy",
"yyyy-MM-dd",
"dd.MM.yyyy",
"MM.dd.yyyy",
"yyyy.MM.dd"
]
},
{
"name": "enableCdc",
"value": true
},
{
"name": "skipInitialLoad",
"value": true
},
{
"name": "columnNamesAsHeader",
"value": true
},
{
"name": "columnDelimiter",
"value": ","
},
{
"name": "escapeChar",
"value": "\\\\"
},
{
"name": "quoteChar",
"value": "\\\""
}
],
"isInlineDataset": true,
"linkedService": {
"type": "LinkedServiceReference",
"referenceName": "amjaAdls03"
},
"linkedServiceType": "AzureBlobFS"
},
"sourceEntities": [
{
"name": "source/customer",
"properties": {
"schema": [
{
"name": "CustId",
"dataType": "short"
},
{
"name": "CustName",
"dataType": "string"
},
{
"name": "CustAddres",
"dataType": "string"
},
{
"name": "CustDepName",
"dataType": "string"
},
{
"name": "CustDepLoc",
"dataType": "string"
}
],
"dslConnectorProperties": [
{
"name": "container",
"value": "source"
},
{
"name": "fileSystem",
"value": "source"
},
{
"name": "folderPath",
"value": "customer"
},
{
"name": "allowSchemaDrift",
"value": false
},
{
"name": "inferDriftedColumnTypes",
"value": false
}
]
}
},
{
"name": "source/employee",
"properties": {
"schema": [],
"dslConnectorProperties": [
{
"name": "container",
"value": "source"
},
{
"name": "fileSystem",
"value": "source"
},
{
"name": "folderPath",
"value": "employee"
}
]
}
},
{
"name": "lookup",
"properties": {
"schema": [
{
"name": "EmpId",
"dataType": "short"
},
{
"name": "EmpName",
"dataType": "string"
},
{
"name": "HomeAddress",
"dataType": "string"
},
{
"name": "OfficeAddress",
"dataType": "string"
},
{
"name": "EmpPhoneNumber",
"dataType": "integer"
},
{
"name": "DepName",
"dataType": "string"
},
{
"name": "DepLoc",
"dataType": "string"
},
{
"name": "DecimalCol",
"dataType": "double"
}
],
"dslConnectorProperties": [
{
"name": "container",
"value": "lookup"
},
{
"name": "fileSystem",
"value": "lookup"
},
{
"name": "allowSchemaDrift",
"value": false
},
{
"name": "inferDriftedColumnTypes",
"value": false
}
]
}
},
{
"name": "source/justSchema",
"properties": {
"schema": [
{
"name": "CustId",
"dataType": "string"
},
{
"name": "CustName",
"dataType": "string"
},
{
"name": "CustAddres",
"dataType": "string"
},
{
"name": "CustDepName",
"dataType": "string"
},
{
"name": "CustDepLoc",
"dataType": "string"
}
],
"dslConnectorProperties": [
{
"name": "container",
"value": "source"
},
{
"name": "fileSystem",
"value": "source"
},
{
"name": "folderPath",
"value": "justSchema"
},
{
"name": "allowSchemaDrift",
"value": false
},
{
"name": "inferDriftedColumnTypes",
"value": false
}
]
}
}
]
}
],
"status": "Stopped",
"targetConnectionsInfo": [
{
"connection": {
"type": "linkedservicetype",
"commonDslConnectorProperties": [
{
"name": "allowSchemaDrift",
"value": true
},
{
"name": "inferDriftedColumnTypes",
"value": true
},
{
"name": "format",
"value": "table"
},
{
"name": "store",
"value": "sqlserver"
},
{
"name": "databaseType",
"value": "databaseType"
},
{
"name": "database",
"value": "database"
},
{
"name": "deletable",
"value": false
},
{
"name": "insertable",
"value": true
},
{
"name": "updateable",
"value": false
},
{
"name": "upsertable",
"value": false
},
{
"name": "skipDuplicateMapInputs",
"value": true
},
{
"name": "skipDuplicateMapOutputs",
"value": true
}
],
"isInlineDataset": true,
"linkedService": {
"type": "LinkedServiceReference",
"referenceName": "amjaSql"
},
"linkedServiceType": "AzureSqlDatabase"
},
"dataMapperMappings": [
{
"attributeMappingInfo": {
"attributeMappings": [
{
"name": "CustAddres",
"type": "Derived",
"attributeReferences": [
{
"name": "CustAddres",
"entity": "source/customer",
"entityConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
}
}
],
"expression": "trim(CustAddres)",
"functionName": "trim"
},
{
"name": "CustDeptName",
"type": "Direct",
"attributeReference": {
"name": "CustDepName",
"entity": "source/customer",
"entityConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
}
},
"functionName": ""
},
{
"name": "CustEmail",
"type": "Direct",
"attributeReference": {
"name": "CustName",
"entity": "source/customer",
"entityConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
}
},
"functionName": ""
},
{
"name": "CustId",
"type": "Direct",
"attributeReference": {
"name": "CustId",
"entity": "source/customer",
"entityConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
}
},
"functionName": ""
},
{
"name": "CustName",
"type": "Direct",
"attributeReference": {
"name": "CustName",
"entity": "source/customer",
"entityConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
}
},
"functionName": ""
}
]
},
"sourceConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
},
"sourceEntityName": "source/customer",
"targetEntityName": "dbo.customer"
},
{
"attributeMappingInfo": {
"attributeMappings": [
{
"name": "Name",
"type": "Derived",
"attributeReferences": [
{
"name": "EmpName",
"entity": "lookup",
"entityConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
}
}
],
"expression": "upper(EmpName)",
"functionName": "upper"
},
{
"name": "PersonID",
"type": "Direct",
"attributeReference": {
"name": "EmpId",
"entity": "lookup",
"entityConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
}
},
"functionName": ""
}
]
},
"sourceConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
},
"sourceEntityName": "lookup",
"targetEntityName": "dbo.data_source_table"
},
{
"attributeMappingInfo": {
"attributeMappings": []
},
"sourceConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
},
"sourceEntityName": "source/employee",
"targetEntityName": "dbo.employee"
},
{
"attributeMappingInfo": {
"attributeMappings": [
{
"name": "CustAddres",
"type": "Derived",
"attributeReferences": [
{
"name": "CustAddres",
"entity": "source/justSchema",
"entityConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
}
}
],
"expression": "trim(CustAddres)",
"functionName": "trim"
},
{
"name": "CustDepLoc",
"type": "Direct",
"attributeReference": {
"name": "CustDepLoc",
"entity": "source/justSchema",
"entityConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
}
}
},
{
"name": "CustDepName",
"type": "Derived",
"attributeReferences": [
{
"name": "CustName",
"entity": "source/justSchema",
"entityConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
}
},
{
"name": "CustDepName",
"entity": "source/justSchema",
"entityConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
}
}
],
"expression": "concat(CustName, \" -> \", CustDepName)",
"functionName": ""
},
{
"name": "CustId",
"type": "Direct",
"attributeReference": {
"name": "CustId",
"entity": "source/justSchema",
"entityConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
}
},
"functionName": ""
},
{
"name": "CustName",
"type": "Direct",
"attributeReference": {
"name": "CustName",
"entity": "source/justSchema",
"entityConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
}
}
}
]
},
"sourceConnectionReference": {
"type": "linkedservicetype",
"connectionName": "amjaAdls03"
},
"sourceEntityName": "source/justSchema",
"targetEntityName": "dbo.justSchema"
}
],
"relationships": [],
"targetEntities": [
{
"name": "dbo.employee",
"properties": {
"schema": [],
"dslConnectorProperties": [
{
"name": "schemaName",
"value": "dbo"
},
{
"name": "tableName",
"value": "employee"
}
]
}
},
{
"name": "dbo.justSchema",
"properties": {
"schema": [],
"dslConnectorProperties": [
{
"name": "schemaName",
"value": "dbo"
},
{
"name": "tableName",
"value": "justSchema"
},
{
"name": "allowSchemaDrift",
"value": true
},
{
"name": "inferDriftedColumnTypes",
"value": true
}
]
}
},
{
"name": "dbo.customer",
"properties": {
"schema": [
{
"name": "CustId",
"dataType": "integer"
},
{
"name": "CustName",
"dataType": "string"
},
{
"name": "CustAddres",
"dataType": "string"
},
{
"name": "CustDeptName",
"dataType": "string"
},
{
"name": "CustEmail",
"dataType": "string"
}
],
"dslConnectorProperties": [
{
"name": "schemaName",
"value": "dbo"
},
{
"name": "tableName",
"value": "customer"
},
{
"name": "allowSchemaDrift",
"value": false
},
{
"name": "inferDriftedColumnTypes",
"value": false
}
]
}
},
{
"name": "dbo.data_source_table",
"properties": {
"schema": [
{
"name": "PersonID",
"dataType": "integer"
},
{
"name": "Name",
"dataType": "string"
},
{
"name": "LastModifytime",
"dataType": "timestamp"
}
],
"dslConnectorProperties": [
{
"name": "schemaName",
"value": "dbo"
},
{
"name": "tableName",
"value": "data_source_table"
},
{
"name": "allowSchemaDrift",
"value": false
},
{
"name": "inferDriftedColumnTypes",
"value": false
},
{
"name": "defaultToUpsert",
"value": false
}
]
}
}
]
}
]
}
},
"changeDataCaptureName": "exampleChangeDataCapture",
"factoryName": "exampleFactoryName",
"ifMatch": null,
"resourceGroupName": "exampleResourceGroup",
"subscriptionId": "12345678-1234-1234-1234-123456789012"
},
"responses": {
"200": {
"body": {
"name": "exampleChangeDataCapture",
"type": "Microsoft.DataFactory/factories/adfcdcs",
"etag": "43008e18-0000-0100-0000-641aafca0000",
"id": "/subscriptions/d3bb3b2e-9a7e-4194-9960-5171bd192117/resourceGroups/amja-rg-03/providers/Microsoft.DataFactory/factories/amja-adf-04/adfcdcs/exampleChangeDataCapture",
"properties": {
"description": "Sample demo change data capture to transfer data from delimited (csv) to Azure SQL Database. Updating table mappings.",
"allowVNetOverride": false,
"policy": {
"mode": "Microbatch",
"recurrence": {
"frequency": "Minute",
"interval": 15
}
},
"sourceConnectionsInfo": [
{
"connection": {
"type": "linkedservicetype",
"commonDslConnectorProperties": [
{
"name": "allowSchemaDrift",
"value": true
},
{
"name": "inferDriftedColumnTypes",
"value": true
},
{
"name": "format",
"value": "delimited"
},
{
"name": "dateFormats",
"value": [
"MM/dd/yyyy",
"dd/MM/yyyy",
"yyyy/MM/dd",
"MM-dd-yyyy",
"dd-MM-yyyy",
"yyyy-MM-dd",
"dd.MM.yyyy",
"MM.dd.yyyy",
"yyyy.MM.dd"
]
},
{
"name": "timestampFormats",
"value": [
"yyyyMMddHHmm",
"yyyyMMdd HHmm",
"yyyyMMddHHmmss",
"yyyyMMdd HHmmss",
"dd-MM-yyyy HH:mm:ss",
"dd-MM-yyyy HH:mm",
"yyyy-M-d H:m:s",
"yyyy-MM-dd\\'T\\'HH:mm:ss\\'Z\\'",
"yyyy-M-d\\'T\\'H:m:s\\'Z\\'",
"yyyy-M-d\\'T\\'H:m:s",
"yyyy-MM-dd\\'T\\'HH:mm:ss",
"yyyy-MM-dd HH:mm:ss",
"yyyy-MM-dd HH:mm",
"yyyy.MM.dd HH:mm:ss",
"MM/dd/yyyy HH:mm:ss",
"M/d/yyyy H:m:s",
"yyyy/MM/dd HH:mm:ss",
"yyyy/M/d H:m:s",
"dd MMM yyyy HH:mm:ss",
"dd MMMM yyyy HH:mm:ss",
"d MMM yyyy H:m:s",
"d MMMM yyyy H:m:s",
"d-M-yyyy H:m:s",
"d-M-yyyy H:m",
"yyyy-M-d H:m",
"MM/dd/yyyy HH:mm",
"M/d/yyyy H:m",
"yyyy/MM/dd HH:mm",
"yyyy/M/d H:m",
"dd MMMM yyyy HH:mm",
"dd MMM yyyy HH:mm",
"d MMMM yyyy H:m",
"d MMM yyyy H:m",
"MM-dd-yyyy hh:mm:ss a",
"MM-dd-yyyy HH:mm:ss",
"MM/dd/yyyy hh:mm:ss a",
"yyyy.MM.dd hh:mm:ss a",
"MM/dd/yyyy",
"dd/MM/yyyy",
"yyyy/MM/dd",
"MM-dd-yyyy",
"dd-MM-yyyy",
"yyyy-MM-dd",
"dd.MM.yyyy",
"MM.dd.yyyy",
"yyyy.MM.dd"
]
},
{
"name": "enableCdc",
"value": true
},
{
"name": "skipInitialLoad",
"value": true
},
{
"name": "columnNamesAsHeader",
"value": true
},
{
"name": "columnDelimiter",
"value": ","
},
{
"name": "escapeChar",
"value": "\\\\"
},
{
"name": "quoteChar",
"value": "\\\""
}
],
"isInlineDataset": true,
"linkedService": {
"type": "LinkedServiceReference",
"referenceName": "amjaAdls03"
},
"linkedServiceType": "AzureBlobFS"
},
"sourceEntities": [
{
"name": "source/customer",
"properties": {
"schema": [
{
"name": "CustId",
"dataType": "short"
},
{
"name": "CustName",
"dataType": "string"
},
{
"name": "CustAddres",
"dataType": "string"
},
{
"name": "CustDepName",
"dataType": "string"
},
{
"name": "CustDepLoc",
"dataType": "string"
}
],
"dslConnectorProperties": [
{
"name": "container",
"value": "source"
},
{
"name": "fileSystem",
"value": "source"
},
{
"name": "folderPath",
"value": "customer"
},
{
"name": "allowSchemaDrift",
"value": false
},
{
"name": "inferDriftedColumnTypes",
"value": false
}
]
}
},
{
"name": "source/employee",
"properties": {
"schema": [],
"dslConnectorProperties": [
{
"name": "container",
"value": "source"
},
{
"name": "fileSystem",
"value": "source"
},
{
"name": "folderPath",
"value": "employee"
}
]
}
},
{
"name": "lookup",
"properties": {
"schema": [
{
"name": "EmpId",
"dataType": "short"
},
{
"name": "EmpName",
"dataType": "string"
},
{
"name": "HomeAddress",
"dataType": "string"
},
{
"name": "OfficeAddress",
"dataType": "string"
},
# --- truncated at 32 KB (50 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/microsoft-azure-data-factory/refs/heads/main/examples/microsoft-azure-data-factory-ChangeDataCapture_Update.json
Work with this as data
Every example here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for examples
4 MCP tools reach this
find_examplesBrowse and filter every example in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This example
curl "https://apis.io/api/v1/examples/microsoft-azure-data-factory-ChangeDataCapture_Update"
All examples
curl "https://apis.io/api/v1/examples?limit=25"Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.