| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
| transformations:start [2023/10/05 00:34] – [Transform / Filters] dmitry | transformations:start [2024/02/03 17:51] – craigt |
|---|
| * [[transformations:importexcel|Import Excel spreadsheet]] - import data from Excel spreadsheets (.xls,.xlsx). | * [[transformations:importexcel|Import Excel spreadsheet]] - import data from Excel spreadsheets (.xls,.xlsx). |
| * [[transformations:importfixedwidthtext|Import fixed width text]] - import tabular data with fixed width columns from text file. | * [[transformations:importfixedwidthtext|Import fixed width text]] - import tabular data with fixed width columns from text file. |
| | * [[transformations:importapacheparquet|Import from Apache Parquet]] - import columns or metadata from an Apache Parquet file. |
| * [[transformations:importjson|Import JSON from file]] - import JSON from a text file. | * [[transformations:importjson|Import JSON from file]] - import JSON from a text file. |
| * [[transformations:importplaintext|Import plain text]] - import a text file as is without parsing. | * [[transformations:importplaintext|Import plain text]] - import a text file as is without parsing. |
| * [[transformations:catalogcommand|Catalog command]] - list/create/update/delete Catalog directories, items, and item fields. | * [[transformations:catalogcommand|Catalog command]] - list/create/update/delete Catalog directories, items, and item fields. |
| * [[transformations:sqlcommand|Database command]] - create/delete/truncate DB table or send a custom SQL command to a database (e.g. to bulk load a file). | * [[transformations:sqlcommand|Database command]] - create/delete/truncate DB table or send a custom SQL command to a database (e.g. to bulk load a file). |
| * [[transformations:deletedbrows|Delete database rows]] - delete rows in a database table that satisfy query condition. | * [[transformations:deletedbrows|Delete database rows]] - delete rows in a database table that satisfy query conditions. |
| * [[transformations:deletedbrowsbykeys|Delete matching database rows]] - delete rows in a database table where key values match/don't match key values in an EasyMorph table. | * [[transformations:deletedbrowsbykeys|Delete matching database rows]] - delete rows in a database table where key values match/don't match key values in an EasyMorph table. |
| * [[transformations:downloadfile|Download file]] - download a file from the internet. | * [[transformations:downloadfile|Download file]] - download a file from the internet. |
| | * [[transformations:emailcommand|Email command]] - performs various operations with email messages. |
| * [[transformations:excelcommand|Excel command]] - perform file/sheet operations and run VBA macros in Excel files. | * [[transformations:excelcommand|Excel command]] - perform file/sheet operations and run VBA macros in Excel files. |
| * [[transformations:fetchemail|Fetch email]] - fetch email messages and their attachments from a mail server (Exchange or IMAP). | * [[transformations:fetchemail|Fetch email]] - fetch email messages and their attachments from a mail server (Exchange or IMAP). |
| * [[transformations:filetransfer|File transfer]] - transfer files over SFTP or SCP to or from a remote computer. | * [[transformations:filetransfer|File transfer]] - transfer files over SFTP or SCP to or from a remote computer. |
| * [[transformations:generatedocumentation|Generate documentation]] - generate HTML documentation for an EasyMorph project. | * [[transformations:generatedocumentation|Generate documentation]] - generate HTML documentation for an EasyMorph project. |
| * [[transformations:iterateprogram|Iterate program]] - execute external application once for each row in table. | * [[transformations:iterateprogram|Iterate program]] - execute external application once for each row in a table. |
| * [[transformations:iteratewebrequest|Iterate Web Request]] - send multiple uniform HTTP requests to a web API and append responses into one table. | * [[transformations:iteratewebrequest|Iterate Web Request]] - send multiple uniform HTTP requests to a web API and append responses into one table. |
| * [[transformations:powershell|PowerShell]] - executes one or more PowerShell statements. | * [[transformations:powershell|PowerShell]] - executes one or more PowerShell statements. |
| * [[transformations:runprogram|Run program]] - execute external application once. | * [[transformations:runprogram|Run program]] - execute external application once. |
| * [[transformations:sendemail|Send email]] - send an email with attachment to one or more recipients. | * [[transformations:sendemail|Send email]] - send an email with an attachment to one or more recipients. |
| * [[transformations:sshcommand|SSH command]] - run one or several commands on a remote computer using the SSH protocol. | * [[transformations:sshcommand|SSH command]] - run one or several commands on a remote computer using the SSH protocol. |
| * [[transformations:updatedb|Update database table]] - update a database table with values from EasyMorph. | * [[transformations:updatedb|Update database table]] - update a database table with values from EasyMorph. |
| * [[transformations:webrequest|Web Request]] - send an HTTP request to a web API and receive a response. | * [[transformations:webrequest|Web Request]] - send an HTTP request to a web API and receive a response. |
| * [[transformations:xslt|XSLT transformation]] - transform given XML file using XSLT stylesheets. | * [[transformations:xslt|XSLT transformation]] - transform a given XML file using XSLT stylesheets. |
| | |
| | |
| |
| ==== Workflow / Apps and cloud ==== | ==== Workflow / Apps and cloud ==== |
| * [[transformations:amazoncommand|Amazon command]] - perform an operation with AWS S3 , e.g. upload/download a file. | * [[transformations:amazoncommand|Amazon command]] - perform an operation with AWS S3 , e.g. upload/download a file. |
| | * [[transformations:chatgpt|Ask ChatGPT]] - sends free-form prompts to ChatGPT. |
| * [[transformations:azureblobstoragecommand|Azure Blob Storage command]] - performs various file and folder operations with Azure Blob Storage. | * [[transformations:azureblobstoragecommand|Azure Blob Storage command]] - performs various file and folder operations with Azure Blob Storage. |
| * [[transformations:dropboxcommand|Dropbox command]] - performs various file and folder operations with Dropbox. | * [[transformations:dropboxcommand|Dropbox command]] - performs various file and folder operations with Dropbox. |
| * [[transformations:tableaucommand|Tableau Server command]] - trigger extract refresh or run a flow on Tableau Server / Online. | * [[transformations:tableaucommand|Tableau Server command]] - trigger extract refresh or run a flow on Tableau Server / Online. |
| * [[transformations:airtablecommand|Update/delete rows in Airtable]] - update or delete rows in Airtable. | * [[transformations:airtablecommand|Update/delete rows in Airtable]] - update or delete rows in Airtable. |
| | * [[transformations:salesforcecommand|Update/delete records in Salesforce]] - update/delete records in a Salesforce object. |
| * [[transformations:sharepointlistcommand|Update/delete rows in SharePoint list]] - update or delete rows in a SharePoint list. | * [[transformations:sharepointlistcommand|Update/delete rows in SharePoint list]] - update or delete rows in a SharePoint list. |
| |
| :?: If you need an action that is not currently available in EasyMorph please feel free to make a feature request on the [[https://community.easymorph.com|Community forum]]. | :?: If you need an action that is not currently available in EasyMorph please feel free to make a feature request on the [[https://community.easymorph.com|Community forum]]. |
