Azure Data Factory · Example Payload
Microsoft Azure Data Factory Dataflows_Update
Data IntegrationETLELTData PipelineData MovementOrchestrationData EngineeringChange Data CaptureIntegration RuntimeCloudAzureData Factory
Microsoft Azure Data Factory Dataflows_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",
"dataFlow": {
"properties": {
"type": "MappingDataFlow",
"description": "Sample demo data flow to convert currencies showing usage of union, derive and conditional split transformation.",
"typeProperties": {
"scriptLines": [
"source(output(",
"PreviousConversionRate as double,",
"Country as string,",
"DateTime1 as string,",
"CurrentConversionRate as double",
"),",
"allowSchemaDrift: false,",
"validateSchema: false) ~> USDCurrency",
"source(output(",
"PreviousConversionRate as double,",
"Country as string,",
"DateTime1 as string,",
"CurrentConversionRate as double",
"),",
"allowSchemaDrift: true,",
"validateSchema: false) ~> CADSource",
"USDCurrency, CADSource union(byName: true)~> Union",
"Union derive(NewCurrencyRate = round(CurrentConversionRate*1.25)) ~> NewCurrencyColumn",
"NewCurrencyColumn split(Country == 'USD',",
"Country == 'CAD',disjoint: false) ~> ConditionalSplit1@(USD, CAD)",
"ConditionalSplit1@USD sink(saveMode:'overwrite' ) ~> USDSink",
"ConditionalSplit1@CAD sink(saveMode:'overwrite' ) ~> CADSink"
],
"sinks": [
{
"name": "USDSink",
"dataset": {
"type": "DatasetReference",
"referenceName": "USDOutput"
}
},
{
"name": "CADSink",
"dataset": {
"type": "DatasetReference",
"referenceName": "CADOutput"
}
}
],
"sources": [
{
"name": "USDCurrency",
"dataset": {
"type": "DatasetReference",
"referenceName": "CurrencyDatasetUSD"
}
},
{
"name": "CADSource",
"dataset": {
"type": "DatasetReference",
"referenceName": "CurrencyDatasetCAD"
}
}
]
}
}
},
"dataFlowName": "exampleDataFlow",
"factoryName": "exampleFactoryName",
"ifMatch": null,
"resourceGroupName": "exampleResourceGroup",
"subscriptionId": "12345678-1234-1234-1234-123456789012"
},
"responses": {
"200": {
"body": {
"name": "exampleDataFlow",
"type": "Microsoft.DataFactory/factories/dataflows",
"etag": "0a0068d4-0000-0000-0000-5b245bd30002",
"id": "/subscriptions/12345678-1234-1234-1234-123456789012/resourceGroups/exampleResourceGroup/providers/Microsoft.DataFactory/factories/exampleFactoryName/datasets/exampleDataset",
"properties": {
"type": "MappingDataFlow",
"description": "Sample demo data flow to convert currencies showing usage of union, derive and conditional split transformation.",
"typeProperties": {
"scriptLines": [
"source(output(",
"PreviousConversionRate as double,",
"Country as string,",
"DateTime1 as string,",
"CurrentConversionRate as double",
"),",
"allowSchemaDrift: false,",
"validateSchema: false) ~> USDCurrency",
"source(output(",
"PreviousConversionRate as double,",
"Country as string,",
"DateTime1 as string,",
"CurrentConversionRate as double",
"),",
"allowSchemaDrift: true,",
"validateSchema: false) ~> CADSource",
"USDCurrency, CADSource union(byName: true)~> Union",
"Union derive(NewCurrencyRate = round(CurrentConversionRate*1.25)) ~> NewCurrencyColumn",
"NewCurrencyColumn split(Country == 'USD',",
"Country == 'CAD',disjoint: false) ~> ConditionalSplit1@(USD, CAD)",
"ConditionalSplit1@USD sink(saveMode:'overwrite' ) ~> USDSink",
"ConditionalSplit1@CAD sink(saveMode:'overwrite' ) ~> CADSink"
],
"sinks": [
{
"name": "USDSink",
"dataset": {
"type": "DatasetReference",
"referenceName": "USDOutput"
}
},
{
"name": "CADSink",
"dataset": {
"type": "DatasetReference",
"referenceName": "CADOutput"
}
}
],
"sources": [
{
"name": "USDCurrency",
"dataset": {
"type": "DatasetReference",
"referenceName": "CurrencyDatasetUSD"
}
},
{
"name": "CADSource",
"dataset": {
"type": "DatasetReference",
"referenceName": "CurrencyDatasetCAD"
}
}
]
}
}
},
"headers": {
"Date": "Sat, 16 Jun 2019 00:37:38 GMT",
"X-Content-Type-Options": "nosniff",
"x-ms-correlation-request-id": "ce95d6dd-c04d-4b02-b7ad-fe79c9b26df0",
"x-ms-ratelimit-remaining-subscription-writes": "1193",
"x-ms-request-id": "ce95d6dd-c04d-4b02-b7ad-fe79c9b26df0"
}
}
},
"operationId": "DataFlows_CreateOrUpdate",
"title": "DataFlows_Update"
}
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-DataFlows_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.