Knowledge Base

Appearance

Data Factory > Available tasks ​

Table and Items ​

Task KeyDescription
table-import-schemaCreate and update the structure of a table
table-export-schemaExport the structure of a table
table-import-itemsImport items into a table
table-export-itemsExport items from a table
table-delete-itemsDelete items from a table
table-refresh-itemsRefresh items in a table

File transformation ​

Task KeyDescription
file-transformation-xsltApply an XSLT transformation to one or many files
file-transformation-split-xmlSplit an XML one or many XML file into multiple files
file-transformation-merge-xml Merge XML files into a single XML file

File conversion ​

Task KeyDescription
file-conversion-xlsx-to-xmlConvert an Excel file into an XML file
file-conversion-csv-to-xmlConvert a CSV file into an XML file
file-conversion-json-to-xmlConvert a JSON file into an XML file
file-conversion-unarchiveUnarchive a file

File generation ​

Task KeyDescription
file-generation-xlsxGenerate one or many Excel files
file-generation-pdfGenerate one or many PDF files
file-generation-archiveArchive one or many files

File validation ​

Task KeyDescription
file-validation-xsdApply an XSD validation to one or many files

FTP/SFTP communication ​

Task KeyDescription
protocol-ftp-listList files in a FTP/SFTP server
protocol-ftp-getGet files from a FTP/SFTP server
protocol-ftp-postPost files to a FTP/SFTP server
protocol-ftp-moveMove files in a FTP/SFTP server
protocol-ftp-deleteDelete files in a FTP/SFTP server

Web Service communication ​

Task KeyDescription
protocol-http-performPerform one or many HTTP request (replacement of protocol-rest-perform)
protocol-rest-perform Perform one or many HTTP request
protocol-soap-performPerform one or many SOAP request

Notifications ​

Task KeyDescription
notification-send-emailSend one or many emails
notification-display-messageAllows the display of a personalized message to the user on the app.product-Live.com and settings.product-live.com interface

Storage ​

Task KeyDescription
azure-storage-blob-listList blobs in an Azure Storage account
azure-storage-blob-putPut blobs in an Azure Storage account

Publication / Collect ​

Task KeyDescription
exchange-send-itemsSend items
exchange-receive-itemsReceive items
exchange-apply-suggestions Apply suggestions

Data Factory Logic ​

Task KeyDescription
decision Perform a decision inside a Job
terminateTerminate a Job (in success or failure)
wait Wait for a given amount of time
switchPerform a decision inside a Job
loop Perform a loop inside a Job

Mapping ​

Task KeyDescription
rules-engine-execute-rulesExecute mapping rules
rules-engine-export-rulesExport mapping rules
rules-engine-import-rulesImport mapping rules

Code Execution ​

Task KeyDescription
code-execute-javascript Execute javascript code.

Content ​

Task KeyDescription
data-fetch-accounts Fetch accounts.
data-create-comment-threads Create comment threads.
data-fetch-comment-threads Fetch comment threads.
data-create-comment-thread-replies Create comment thread replies.
data-fetch-jobs Fetch jobs.
data-fetch-job-executions Fetch job executions.
data-fetch-levels Fetch levels.
data-fetch-partitions Fetch partitions.
data-fetch-suggestions Fetch suggestions.
data-fetch-tables Fetch tables.
data-fetch-users Fetch users.

Job Context ​

Task KeyDescription
job-fetch-current-account Fetch the current account.
job-fetch-current-user Fetch the current user.

JSON transformation ​

Task KeyDescription
json-transform-jq Apply a JQ transformation to a JSON object.