Tasks

Tasks are the basic building blocks of a Data Factory job. Each task performs a single operation (for example, importing data, transforming files, calling an API, or sending a notification) that you orchestrate inside a job’s tasks array.

This page lists the available tasks, grouped by category. For details on inputs, outputs, and examples, open the documentation page for each task.

Table schema and items

Task	Name	Description
Import Table Schema	`table-import-schema`	Import the structure of a Product-Live table.
Export Table Schema	`table-export-schema`	Export the structure of a Product-Live table.
Import Items	`table-import-items`	Import items into a Product-Live table.
Export Items	`table-export-items`	Export items from a Product-Live table.
Delete Items	`table-delete-items`	Delete items from a Product-Live table.
Refresh Items	`table-refresh-items`	Refresh items in a Product-Live table.

File transformation

Task	Name	Description
Transform XSLT	`file-transformation-xslt`	Apply an XSLT transform to one or more XML files.
Split XML	`file-transformation-split-xml`	Split one XML file into multiple XML files.
Merge XML	`file-transformation-merge-xml`	Merge multiple XML files into a single XML file.

Code Execution

Task	Name	Description
Execute Javascript Code	`code-execute-javascript`	Execute JavaScript code.
JSON JQ Transform	`json-transform-jq`	Apply a JQ transformation to a JSON object.

File conversion

Task	Name	Description
XLSX to XML	`file-conversion-xlsx-to-xml`	Transform one or many `.xlsx` files to a generic `.xml` file.
CSV to XML	`file-conversion-csv-to-xml`	Transform one or more CSV files to a generic XML file.
JSON to XML	`file-conversion-json-to-xml`	Transform one or more JSON files to a generic XML file.
Unarchive	`file-conversion-unarchive`	Uncompress files from a `.zip` archive.

File generation

Task	Name	Description
Generate Excel	`file-generation-xlsx`	Generate one or many Excel files.
Generate PDF	`file-generation-pdf`	Generate one or many PDF files.
Generate Archive	`file-generation-archive`	Compress files into one or many `.zip` archives.

File validation

Task	Name	Description
XSD	`file-validation-xsd`	Perform an XSD validation.

FTP

Task	Name	Description
FTP List	`protocol-ftp-list`	List files on an FTP/SFTP server.
FTP Get	`protocol-ftp-get`	Get one or many files from an FTP/SFTP server.
FTP Post	`protocol-ftp-post`	Send one or many files to an FTP/SFTP server.
FTP Move	`protocol-ftp-move`	Move one or many files on an FTP/SFTP server.
FTP Delete	`protocol-ftp-delete`	Delete one or many files from an FTP/SFTP server.

APIs

Task	Name	Description
HTTP API	`protocol-http-perform`	Perform HTTP calls (future replacement of `protocol-rest-perform`).
REST API	`protocol-rest-perform`	Perform HTTP calls to a REST API.
SOAP API	`protocol-soap-perform`	Perform SOAP calls over HTTP.

Notifications

Task	Name	Description
Send Email	`notification-send-email`	Send emails programmatically.
Display message	`notification-display-message`	Display HTML content in the actions panel.

Rules engine

Task	Name	Description
Import Rules	`rules-engine-import-rules`	Import rules of the rules engine.
Execute Rules	`rules-engine-execute-rules`	Execute rules of the rules engine.
Export Rules	`rules-engine-export-rules`	Export rules of the rules engine.
Generate rules report	`rules-engine-generate-rules-report`	Generate a rules report.

Storages

Task	Name	Description
Azure Storage List	`azure-storage-blob-list`	List blobs in Microsoft Azure Storage.
Azure Storage Put	`azure-storage-blob-put`	Upload blobs to Microsoft Azure Storage.

Exchange

Task	Name	Description
Send Items	`exchange-send-items`	Send items during exchanges with partners.
Receive items	`exchange-receive-items`	Receive items during exchanges with partners.
Apply suggestions	`exchange-apply-suggestions`	Programmatically manage suggestions.

Logic

Task	Name	Description
Decision	`decision`	Similar to a `case` / `switch` statement in a programming language.
Terminate	`terminate`	Terminate a job in success or error.
Loop	`loop`	Perform a loop inside a job.
Set variable	`set-variable`	Set a variable in the job context.
Switch	`switch`	Similar to a `case` / `switch` statement in a programming language.
Wait	`wait`	Wait a certain amount of time before continuing the job.

Product-Live data

Account

Task	Name	Description
Find accounts	`data-account-find`	Find accounts.

Audit Log

Task	Name	Description
Find audit logs	`data-audit-log-find`	Find audit logs.

Comment Thread

Task	Name	Description
Find comment threads	`data-comment-thread-find`	Find comment threads.
Create comment thread	`data-comment-thread-create`	Create a comment thread.
Create comment thread reply	`data-comment-thread-create-reply`	Create a comment thread reply.

Context

Task	Name	Description
Get current account	`context-account-get`	Get the current account.
Get current user	`context-user-get`	Get the current user.

Field

Task	Name	Description
Find fields	`data-field-find`	Find fields.

Field value

Task	Name	Description
Find field values	`data-field-value-find`	Find field values.

Item

Task	Name	Description
Find items	`data-item-find`	Find items.
Create or update item	`data-item-create-or-update`	Create or update an item based on its identifier.

Job

Task	Name	Description
Find jobs	`data-job-find`	Find jobs.

Job execution

Task	Name	Description
Find job executions	`data-job-execution-find`	Find job executions.
Create job execution	`data-job-execution-create`	Create a job execution.

Project

Task	Name	Description
Find projects	`data-project-find`	Find projects.
Create project	`data-project-create`	Create a project.
Partially update project	`data-project-patch`	Partially update a project.
Delete project	`data-project-delete`	Delete a project.

Screen

Task	Name	Description
Find screens	`data-screen-find`	Find screens.

Screen column

Task	Name	Description
Find screen columns	`data-screen-column-find`	Find screen columns.

Screen section

Task	Name	Description
Find screen sections	`data-screen-section-find`	Find screen sections.

Section

Task	Name	Description
Find sections	`data-section-find`	Find sections.

Suggestion

Task	Name	Description
Find suggestions	`data-suggestion-find`	Find suggestions.
Create suggestion	`data-suggestion-create`	Create a suggestion.
Partially apply suggestion	`data-suggestion-apply`	Partially apply a suggestion (based on a list of fields to update).
Apply suggestion	`data-suggestion-apply`	Apply a suggestion (the whole suggestion).

Table

Task	Name	Description
Find tables	`data-table-find`	Find tables.

User

Task	Name	Description
Find users	`data-user-find`	Find users.

User group

Task	Name	Description
Find user groups	`data-user-group-find`	Find user groups.
Create user group	`data-user-group-create`	Create a user group.
Partially update user group	`data-user-group-patch`	Partially update a user group.
Delete user group	`data-user-group-delete`	Delete a user group.
Add user to user group	`data-user-group-add-members`	Add a user to a user group.
Remove user from user group	`data-user-group-remove-members`	Remove a user from a user group.

Variable

Task	Name	Description
Find variables	`data-variable-find`	Find variables.
Update variable	`data-variable-update`	Update a variable.

Tasks ​

Table schema and items ​

File transformation ​

Code Execution ​

File conversion ​

File generation ​

File validation ​

FTP ​

APIs ​

Notifications ​

Rules engine ​

Storages ​

Exchange ​

Logic ​

Product-Live data ​

Account ​

Audit Log ​

Comment Thread ​

Context ​

Field ​

Field value ​

Item ​

Job ​

Job execution ​

Project ​

Screen ​

Screen column ​

Screen section ​

Section ​

Suggestion ​

Table ​

User ​

User group ​

Variable ​