| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| transformations:start [2019/04/29 19:20] – dmitry | transformations:start [2024/04/12 00:30] (current) – [Import / File] craigt |
|---|
| ====== Actions ====== | ====== Actions ====== |
| |
| List of all actions available in EasyMorph: | All the actions available in EasyMorph: |
| |
| ==== Import ==== | ==== Import / File ==== |
| * [[transformations:importtext|Import delimited text file]] - import data from a delimited text files (e.g. CSV). | |
| * [[transformations:importexcel|Import Excel file]] - import data from Excel spreadsheets (.xls,.xlsx). | |
| * [[transformations:importdataset|Import dataset]] - import dataset from a file in the native EasyMorph data format (.dset). | * [[transformations:importdataset|Import dataset]] - import dataset from a file in the native EasyMorph data format (.dset). |
| * [[transformations:importfixedwidthtext|Import fixed width text file]] -import tabular data with fixed width columns from text file. | * [[transformations:importtext|Import delimited text file]] - import data from a delimited text files (e.g. .csv). |
| * [[transformations:importsql|Import from database]] - import data from a database. | * [[transformations:importexcel|Import Excel spreadsheet]] - import data from Excel spreadsheets (.xls,.xlsx). |
| * [[transformations:importgooglesheets|Import from Google Sheets]] - import data from a Google Sheets spreadsheet. | * [[transformations:importfixedwidthtext|Import fixed width text]] - import tabular data with fixed width columns from text file. |
| * [[transformations:importqlikview|Import Qlik file]] - import data from a QVD 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:importplaintext|Import plain text]] - import a text file as is without parsing. |
| | * [[transformations:importqlikview|Import Qlik QVD file]] - import data or metadata from a QVD file. |
| * [[transformations:importsas|Import SAS file]] - import data from a SAS file (.sas7bdat). | * [[transformations:importsas|Import SAS file]] - import data from a SAS file (.sas7bdat). |
| * [[transformations:importspss|Import SPSS file]] - import data from a SPSS/PSPP file (.sav). | * [[transformations:importspss|Import SPSS file]] - import data from a SPSS/PSPP file (.sav). |
| * [[transformations:importxml|Import XML file]] - import data from an XML file. | * [[transformations:importxml|Import XML file]] - import data from an XML file. |
| * [[transformations:selectdbrowsbykeys|Select matching database rows]] - import rows from a database table where key values match (or don't match) key values in EasyMorph table. | * [[transformations:projectmetadata|Project metadata]] - project metadata such as list of connectors or parameters. |
| * [[transformations:filesplitter|Split delimited text file]] - split large file into smaller chunks without loading it into EasyMorph. | * [[transformations:filesplitter|Split delimited file]] - split large file into smaller chunks without loading it into EasyMorph. |
| * [[transformations:spreadsheetmetadata|Spreadsheet metadata]] - create a list with names of all sheets in a spreadsheet. | |
| | ==== Import / Database ==== |
| | * [[transformations:importsql|Import from database]] - import data from a database. |
| | * [[transformations:selectdbrowsbykeys|Select matching database rows]] - import rows from a database table where key values match (or don't match) key values in an EasyMorph table. |
| | |
| | ==== Import / App & Cloud ==== |
| | * [[transformations:importairtable|Import from Airtable]] - import a table from Airtable. |
| | * [[transformations:importgoogleanalytics|Import from Google Analytics]] - import metrics from Google Analytics. |
| | * [[transformations: importgooglesearchconsole|Import from Google Search Console]] - import metrics from Google Search Console. |
| | * [[transformations:importjira|Import from Jira]] - import information from Jira. |
| | * [[transformations:importpipedrive|Import from Pipedrive]] - import deals, organizations, persons from the Pipedrive CRM. |
| | * [[transformations:importsalesforce|Import from Salesforce]] - import rows from a Salesforce object. |
| | * [[transformations:importgooglesheets|Import Google Sheets]] - import data from a Google Sheets spreadsheet. |
| | * [[transformations:importsharepointlist|Import SharePoint list]] - import a SharePoint list. |
| |
| ==== Create ==== | ==== Import / API ==== |
| | * [[transformations:importwebapi|Import from Web API]] - import data from a Web API. |
| | * [[transformations:incominghttprequest|Incoming HTTP Request]] - receive an HTTP request from a custom API endpoint of EasyMorph Server. |
| | * [[transformations:incomingwebhooks|Incoming webhooks]] - import incoming webhook messages from EasyMorph Gateway. |
| | ==== Create / Generate ==== |
| * [[transformations:calendar|Calendar]] - create a sequence of dates in specified date range | * [[transformations:calendar|Calendar]] - create a sequence of dates in specified date range |
| * [[transformations:createlist|Create List]] - create a list of up to 100 manually entered values | * [[transformations:createlist|Create list]] - create a list of up to 100 manually entered values |
| * [[transformations:filelist|File List]] - create a list of files in specified folder | * [[transformations:filelist|List of files]] - create a list of files in specified folder |
| * [[transformations:folderlist|Folder List]] - create a list of folders in specified folder | * [[transformations:folderlist|List of folders]] - create a list of folders in specified folder |
| * [[transformations:parametertable|Parameter table]] - creates a single-row table with parameter values as columns | * [[transformations:parametertable|Parameter table]] - creates a single-row table with parameter values as columns |
| * [[transformations:sequence|Sequence]] - generate a sequence of numbers from 1 to N | * [[transformations:sequence|Sequence]] - generate a sequence of numbers from 1 to N |
| | * [[transformations:systeminformation|System information]] - obtain system information (such as current Windows account or free RAM). |
| | ==== Create / Input ==== |
| * [[transformations:input|Input]] - obtain input dataset from a calling project | * [[transformations:input|Input]] - obtain input dataset from a calling project |
| * [[transformations:sandbox|Sandbox]] - create a table with temporary static snapshot of data | * [[transformations:sandbox|Sandbox]] - create a table with temporary static snapshot of data |
| * [[transformations:aggregate|Aggregate]] - calculate aggregates (subtotals) like sum or count grouped by one or more fields. | * [[transformations:aggregate|Aggregate]] - calculate aggregates (subtotals) like sum or count grouped by one or more fields. |
| * [[transformations:append|Append another table]] - Append another table as new rows or columns. | * [[transformations:append|Append another table]] - Append another table as new rows or columns. |
| * [[transformations:addcolumn|Calculate new column]] - calculate new column with [[syntax:start|expression]] built using arithmetical operations and various functions. | * [[transformations:addcolumn|Calculate new column(s)]] - calculate new column with [[syntax:start|expression]] built using arithmetical operations and various functions. |
| * [[transformations:cleanup|Clean up]] - remove particular values from a column. | * [[transformations:cleanup|Clean up]] - remove particular values from one or more columns. |
| | * [[transformations:concatenatetext|Concatenate text]] - concatenate column values into delimited text. |
| * [[transformations:convert|Convert data type]] - convert text dates into number dates. | * [[transformations:convert|Convert data type]] - convert text dates into number dates. |
| * [[transformations:enumerate|Enumerate rows]] - add column with row numbers. | * [[transformations:enumerate|Enumerate rows]] - add column with row numbers. |
| | * [[transformations:keepremovecolumns|Keep/remove columns]] - retain or delete selected columns. |
| * [[transformations:lookup|Lookup]] - replace values in a column using a lookup table. | * [[transformations:lookup|Lookup]] - replace values in a column using a lookup table. |
| * [[transformations:merge|Merge another table]] - merge (join) one or more columns from another table where certain columns in both tables match. | * [[transformations:merge|Merge another table]] - merge (join) one or more columns from another table where certain columns in both tables match. |
| * [[transformations:replacecolumn|Modify column]] - replace existing column with a calculated [[syntax:start|expression]]. | * [[transformations:replacecolumns|Modify column(s)]] - replace existing column with a calculated [[syntax:start|expression]]. |
| * [[transformations:peek|Peek]] - create a new column using a single value from another table. | * [[transformations:peek|Peek]] - create a new column using a single value from another table. |
| * [[transformations:remove|Remove columns]] | * [[transformations:rename|Rename columns]] - assign new names to selected columns. |
| * [[transformations:rename|Rename columns]] | * [[transformations:reorder|Reorder columns]] - rearrange the sequence of the columns within a dataset. |
| * [[transformations:reorder|Reorder columns]] | |
| * [[transformations:replace|Replace]] - replace particular values in a column with new ones. | * [[transformations:replace|Replace]] - replace particular values in a column with new ones. |
| * [[transformations:rule|Rule]] - calculate or replace a column using multiple nested IF..THEN...ELSE conditions. | * [[transformations:rule|Rule]] - calculate or replace a column using multiple nested IF..THEN...ELSE conditions. |
| * [[transformations:select|Select columns]] | |
| * [[transformations:sort|Sort]] - sort table by one or more columns. | * [[transformations:sort|Sort]] - sort table by one or more columns. |
| * [[transformations:subtotal|Total/subtotals]] - add column total or group subtotals as a new column. | |
| |
| ==== Transform / Advanced ==== | ==== Transform / Advanced ==== |
| * [[transformations:crossmerge|Cross merge]] - Create a table with all possible combinations (i.e. Cartesian product) of rows in two tables. | * [[transformations:anonymizehash|Anonymize/Hash]] - anonymizes data without affecting its cardinality. |
| * [[transformations:fillgaps|Fill down]] - Fill down empty cells. | * [[transformations:compare|Compare tables]] - compares two tables and produces a list of differences based on column metadata. |
| * [[transformations:fillright|Fill right]] - Fill empty cells to the right. | * [[transformations:createbuckets|Create buckets]] - create ranges of fixed width and assign each row to one of the ranges. |
| * [[transformations:generateuids|Generate UIDs]] | * [[transformations:crossmerge|Cross merge]] - create a table with all possible combinations (i.e. Cartesian product) of rows in two tables. |
| * [[transformations:group|Group]] - Assign a group name (or flag) to selected column values. | * [[transformations:distributetotal|Distribute total]] - break down a total/subtotal proportionally to a group of numbers (weights). |
| * [[transformations:intervalmerge|Interval merge]] - Merge columns from another table where key values fall into an interval defined by two columns. | * [[transformations:enumerategroups|Enumerate groups]] - enumerate all combinations of values in given columns. |
| * [[transformations:labelcolumns|Label columns]] - Name columns using values from top rows. | * [[transformations:fillgaps|Fill down]] - fill down empty cells. |
| * [[transformations:match|Match]] - Find text strings in another table, that are contained in the current table. | * [[transformations:fillright|Fill right]] - fill empty cells to the right. |
| * [[transformations:pivot|Pivot]] - Create a matrix table by pivoting. | * [[transformations:generateuids|Generate unique identifiers]] - creates a randomly generated global unique identifier for each row. |
| * [[transformations:regexp|Regular expression]] - Create a new column with regular expression matches. | * [[transformations:group|Group]] - assign a group name (or flag) to selected column values. |
| * [[transformations:removeemptycolumns|Remove empty columns]] - Remove columns where all values are the same or empty. | * [[transformations:hierarchypath|Hierarchy path]] - generate a parent-child hierarchy path. |
| * [[transformations:removeemptyrows|Remove empty rows]] - Remove rows where all values are empty or whitespace. | * [[transformations:intervalmerge|Interval merge]] - merge columns from another table where key values fall into an interval defined by two columns. |
| * [[transformations:lookuprename|Rename columns with lookup]] - Rename multiple columns using a lookup table. | * [[transformations:labelcolumns|Label columns]] - name columns using values from top rows. |
| * [[transformations:runningtotal|Running total]] - Calculate rank, cumulative count, sum or % from total sum. | * [[transformations:linearregression|Linear regression]] - build a linear regression. Interpolate/extrapolate values if needed. |
| * [[transformations:sanitize|Sanitize]] - Remove hidden system characters, extra spaces, and line breaks. | * [[transformations:makedatetimecolumns|Make date/time columns]] - create column(s) with date/time attributes derived from a date column. |
| * [[transformations:selectbylookup|Select columns by lookup]] - Select columns using a lookup table. | * [[transformations:match|Match]] - find text strings in another table, that are contained in the current table. |
| * [[transformations:shiftcolumn|Shift column up/down]] - Shifts column values up or down. | * [[transformations:naturalmerge|Natural merge]] - merges two tables based on columns with the same names. |
| * [[transformations:splitdelimitedtext|Split delimited text into columns]] - Split delimited values of a column into new columns. | * [[transformations:pivot|Pivot]] - create a matrix table by pivoting. |
| * [[transformations:subfield|Split delimited text into rows]] - Split delimited values of a column into rows. | * [[transformations:regexp|Regular expression]] - create a new column with regular expression matches. |
| * [[transformations:splitfixedwidthtext|Split fixed width text]] - Split a column with fixed width text values into new columns. | * [[transformations:removeemptycolumns|Remove empty columns]] - remove columns where all values are the same or empty. |
| * [[transformations:metadata|Table metadata]] - Obtain column names, total row count and other table metadata. | * [[transformations:removeemptyrows|Remove empty rows]] - remove rows where all values are empty or whitespace. |
| * [[transformations:massreplace|Table-wide replace]] - Remove or replace values across selected columns. | * [[transformations:lookuprename|Rename columns by lookup]] - rename multiple columns using a lookup table. |
| * [[transformations:unpivot|Unpivot]] - Convert a matrix table into a straight table. | * [[transformations:repeatrows|Repeat rows]] - repeat each row as many times as specified in given column. |
| | * [[transformations:replacewithlookup|Replace with lookup]] - replace all substrings in one or many columns using a lookup table. |
| | * [[transformations:rollup|Roll up]] - adds amounts up through a hierarchy. |
| | * [[transformations:runningtotal|Running total]] - calculate rank, cumulative count, sum or % from total sum. |
| | * [[transformations:sanitize|Sanitize text]] - remove hidden system characters, extra spaces, and line breaks. |
| | * [[transformations:selectbylookup|Select columns by lookup]] - select columns using a lookup table. |
| | * [[transformations:shiftcolumn|Shift column up/down]] - shifts column values up or down. |
| | * [[transformations:splitdelimitedtext|Split delimited text into columns]] - split delimited values of a column into new columns. |
| | * [[transformations:subfield|Split delimited text into rows]] - split delimited values of a column into rows. |
| | * [[transformations:splitfixedwidthtext|Split fixed width text]] - split a column with fixed width text values into new columns. |
| | * [[transformations:statisticalaggregation|Statistical aggregation]] - calculate median, percentile, standard error, standard deviation, or variance. |
| | * [[transformations:metadata|Table metadata]] - obtain column names, total row count and other table metadata. |
| | * [[transformations:massreplace|Table-wide replace]] - remove or replace values across selected columns. |
| | * [[transformations:subtotal|Total/subtotals]] - add column total or group subtotals as a new column. |
| | * [[transformations:unpivot|Unpivot]] - convert a matrix table into a straight table. |
| |
| ==== Transform / Filters ==== | ==== Transform / Filters ==== |
| * [[transformations:keepduplicates|Keep duplicates]] - keep only duplicate rows based on all or selected columns. | * [[transformations:keepduplicates|Keep duplicates]] - keep only duplicate rows based on all or selected columns. |
| * [[transformations:filterminmax|Keep min/max]] - keep/remove rows with the top N biggest/smallest values. | * [[transformations:filterminmax|Keep min/max]] - keep/remove rows with the top N biggest/smallest values. |
| * [[transformations:keepdifferent|Keep mismatching]] - keep rows with values that don't exist in another table. | * [[transformations:keepremovematching|Keep/remove matching]] - keep or remove rows with values that exist in another table. |
| * [[transformations:keepexisting|Keep matching]] - keep rows with values that exist in another table. | * [[transformations:trimtable|Trim table]] - keep/remove top/bottom N rows. |
| * [[transformations:keeptop|Trim table]] - keep/remove top/bottom N rows. | |
| * [[transformations:trimbycondition|Trim table by condition]] - keep/remove rows above/below first row matching condition. | * [[transformations:trimbycondition|Trim table by condition]] - keep/remove rows above/below first row matching condition. |
| |
| ==== Export ==== | |
| * [[transformations:exportdb|Export into database]] - export EasyMorph table into database table | ==== Transform / Web ==== |
| | * [[transformations:constructhttpresponse|Construct HTTP response]] - construct fields required for an HTTP response of the API Server. |
| | * [[transformations:constructjson|Construct JSON]] - construct a JSON object. |
| | * [[transformations:extractjson|Extract JSON properties]] - extract values of one or more JSON properties specified by JSON path. |
| | * [[transformations:modifyjson|Modify JSON]] - delete, replace, or rename a JSON property or format JSON. |
| | * [[transformations:parsejson|Parse JSON]] - parse a JSON object into a tabular dataset. |
| | * [[transformations:parseformsubmission|Parse web form submission]] - parse web form submissions in the "x-www-form-urlencoded" format. |
| | * [[transformations:parsexml|Parse XML]] - parse XML into a tabular dataset. |
| | * [[transformations:splitjsonarray|Split JSON array]] - split a JSON array into rows. |
| | ==== Export / File ==== |
| | * [[transformations:exportdataset|Export dataset]] - export dataset into a file in the native EasyMorph data format (.dset). |
| * [[transformations:exporttext|Export into delimited text file]] - export data into CSV or another delimited text format. | * [[transformations:exporttext|Export into delimited text file]] - export data into CSV or another delimited text format. |
| * [[transformations:exportexcel|Export into Excel spreadsheet]] - export data into an Excel spreadsheet. | * [[transformations:exportexcel|Export into Excel file]] - export data into an Excel spreadsheet. |
| * [[transformations:exportgooglesheets|Export into Google Sheets]] - export data into a Google Sheets spreadsheet. | * [[transformations:exportplaintext|Export as plain text]] - export a column as a plain text file without formatting or delimiting. |
| * [[transformations:exportdataset|Export dataset]] - export dataset into a file in the native EasyMorph data format (.dset). | |
| * [[transformations:exportqlikview|Export into Qlik file]] - export data into a Qlik QVD file. | * [[transformations:exportqlikview|Export into Qlik file]] - export data into a Qlik QVD file. |
| * [[transformations:export1010data|Export into 1010data]] - export into 1010data (experimental, not supported). | * [[transformations:exporttableau|Export to Tableau]] - export data into a Tableau TDE/Hyper file or publish to Tableau Server/Online. |
| * [[transformations:exporttableau|Export into Tableau]] - export data into a Tableau Data Extract or publish to Tableau Server. | * [[transformations:exportxml|Export to XML]] - export data into an XML file. |
| * [[transformations:exportxml|Export into XML file]] - export data into a XML file. | |
| | ==== Export / Database ==== |
| | * [[transformations:bulkexportdb|Bulk export to database]] - bulk export into a database table (some RDBMS). |
| | * [[transformations:exportdb|Export to database]] - export EasyMorph table into database table (all RDBMS). |
| | |
| | ==== Export / App & Cloud ==== |
| | * [[transformations:exportairtable|Export to Airtable]] - export to a table in Airtable base. |
| | * [[transformations:exportgooglesheets|Export into Google Sheets]] - export data into a Google Sheets spreadsheet. |
| | * [[transformations:exportpowerbi|Export to Power BI]] - export to Power BI push-dataset. |
| | * [[transformations:exportsalesforce|Export to Salesforce]] - insert records into a Salesforce object. |
| | * [[transformations:exportsharepointlist|Export to SharePoint list]] - append rows to a SharePoint list. |
| | * [[transformations:exporttableau|Export to Tableau]] - export data into a Tableau TDE/Hyper file or publish to Tableau Server/Online. |
| |
| ==== Workflow / Internal ==== | ==== Workflow / Internal ==== |
| * [[transformations:call|Call]] - pass table data to another project and run it once. | * [[transformations:breakpoint|Breakpoint]] - stop project execution. |
| | * [[transformations:call|Call another module/project]] - pass table data to another project and run it once. |
| * [[transformations:either|Either table]] - between current table and another table choose one that is not empty. | * [[transformations:either|Either table]] - between current table and another table choose one that is not empty. |
| * [[transformations:halt|Halt on condition]] - stop project execution with an error if a condition is TRUE for any row. | * [[transformations:haltontypemismatch|Halt on data type mismatch]] - abort project execution if a value in specified column(s) has a wrong type. |
| * [[transformations:iterate|Iterate]] - run another EasyMorph project once for each row in table. | * [[transformations:halt|Halt/Warn on condition]] - abort project execution, or display a warning and continue, if the specified condition is fulfilled. |
| * [[transformations:iteratetable|Iterate table]] | * [[transformations:iterate|Iterate]] - run another module/project once for each row in table. |
| | * [[transformations:iteratecolumn|Iterate column]] - run another module/project once for each column in table and automatically append all returned columns into one table. |
| | * [[transformations:iteratetable|Iterate table]] - run another module/project once for each row in table and pass another table to it. |
| | * [[transformations:play|Play sound]] - Play a system sound or .wav file. |
| | * [[transformations:repeat|Repeat]] - run another module/project until/while its output is empty. |
| | * [[transformations:sharedmemory|Shared memory]] - perform operations on shared memory, a key-value data respository. |
| | * [[transformations:skiponcondition|Skip actions on condition]] - skip the rest of actions in table if the specified condition is fulfilled. |
| | * [[transformations:skiponconditioninanothertable|Skip on condition in another table]] - skip the rest of the actions in table if the condition in another table is fulfilled. |
| | * [[transformations:exclusiveaccess|Start/finish exclusive access]] - enforce mutually exclusive access to a resource for simultaneously executed projects (tasks). |
| * [[transformations:status|Status]] - display custom project execution status message. | * [[transformations:status|Status]] - display custom project execution status message. |
| * [[transformations:synchronize|Synchronize with another table]] - wait until another table is calculated. | * [[transformations:synchronize|Synchronize]] - wait until another table is calculated. |
| | * [[transformations:todo|To-do]] - add a to-do item to the workflow. |
| * [[transformations:wait|Wait]] - pause execution for specified number of seconds. | * [[transformations:wait|Wait]] - pause execution for specified number of seconds. |
| |
| ==== Workflow / External ==== | ==== Workflow / External ==== |
| * [[transformations:amazoncommand|Amazon command]] - perform an operation with AWS S3 , e.g. upload/download a file. | * [[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 (or don't match) key values in 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:morphservercommand|EasyMorph Server command]] - Trigger a task, or upload/download/delete a file on a remote EasyMorph Server. | * [[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: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:filecommand|File command]] - performs basic file operations such as copy/move/rename/delete/unzip. | * [[transformations:filecommand|File command]] - performs basic file operations such as copy/move/rename/delete/unzip. |
| * [[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:googledrivecommand|Google Drive command]] - perform an operation with Google Drive, e.g. download a file. | * [[transformations:generatedocumentation|Generate documentation]] - generate HTML documentation for an EasyMorph project. |
| * [[transformations:iterateprogram|Iterate external 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: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: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: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:xslt|XSLT transformation]] - transform a given XML file using XSLT stylesheets. |
| | |
| | |
| | |
| | |
| | ==== Workflow / Apps and cloud ==== |
| | * [[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:dropboxcommand|Dropbox command]] - performs various file and folder operations with Dropbox. |
| | * [[transformations:morphservercommand|EasyMorph Server command]] - trigger a task, or upload/download/delete a file on a remote EasyMorph Server. |
| | * [[transformations:googledrivecommand|Google Drive command]] - perform an operation with Google Drive, e.g. download a file. |
| | * [[transformations:jiracommand|Jira command]] - perform a Jira command. |
| | * [[transformations:onedrivecommand|OneDrive command]] - perform file operations within OneDrive. |
| | * [[transformations:powerbicommand|Power BI command]] - trigger a Power BI action, such as refreshing a dataset or triggering a workflow. |
| | * [[transformations:qlikcloudcommand|Qlik Cloud command]] - execute a Qlik Cloud command remotely. |
| * [[transformations:qliksensecommand|Qlik Sense command]] - execute a Qlik Sense command remotely. | * [[transformations:qliksensecommand|Qlik Sense command]] - execute a Qlik Sense command remotely. |
| * [[transformations:runprogram|Run external program]] - execute external application once. | * [[transformations:sendntfymessage|Send message to ntfy]] - send a message through ntfy. |
| * [[transformations:sendemail|Send email]] - send an email with attachment to one or more recipients. | * [[transformations:sendpushovermessage|Send message to Pushover]] - send a message through the Pushover service. |
| * [[transformations:sshcommand|SSH command]] - run one or several commands on a remote computer using the SSH protocol. | * [[transformations:sharepointcommand|SharePoint command]] - perform file operations within SharePoint. |
| * [[transformations:tableaucommand|Tableau Server command]] - trigger extract refresh on a Tableau Server. | * [[transformations:slackbot|Slack Bot]] - send notifications to Slack. |
| * [[transformations:xslt|XSLT]] - transform given XML file using XSLT stylesheets. | * [[transformations:tableaucommand|Tableau Server command]] - trigger extract refresh or run a flow on Tableau Server / Online. |
| | * [[transformations:teamsbot|Teams Bot]] - send a message to Microsoft Teams. |
| | * [[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. |
| | |
| | :?: 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]]. |
