All actions in EasyMorph

Import / File

Icon Action name Description
Import dataset import dataset from a file in the native EasyMorph data format (.dset).
Import delimited text file import data from a delimited text files (e.g. .csv).
Import Excel spreadsheet import data from Excel spreadsheets (.xls,.xlsx).
Import fixed width text import tabular data with fixed width columns from text file.
Import from Apache Parquet import columns or metadata from an Apache Parquet file.
Import JSON from file import JSON from a text file.
Import plain text import a text file as is without parsing.
Import Qlik QVD file import data or metadata from a QVD file.
Import SAS file import data from a SAS file (.sas7bdat).
Import SPSS file import data from a SPSS/PSPP file (.sav).
Import XML file import data from an XML file.
Project metadata project metadata such as list of connectors or parameters.
Split delimited file split large file into smaller chunks without loading it into EasyMorph.

Import / Database

Icon Action name Description
Import from database import data from a database.
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

Icon Action name Description
Import from Airtable import a table from Airtable.
Import from Google Analytics import metrics from Google Analytics.
Import from Google Search Console import metrics from Google Search Console.
Import from Jira import information from Jira.
Import from Microsoft Dataverse import an entity or entity metadata from Microsoft Dataverse.
Import from OData import data via the Microsoft Graph API and other OData sources.
Import from Pipedrive import deals, organizations, persons from the Pipedrive CRM.
Import from Power BI import data from a Power BI semantic model.
Import from Salesforce import rows from a Salesforce object.
Import from Zendesk import ticket and user data from Zendesk.
Import Google Sheets import data from a Google Sheets spreadsheet.
Import SharePoint list import a SharePoint list.
Retrieve Catalog asset retrieve a dataset, file, or URL from the Catalog.

Import / API

Icon Action name Description
Import from Web API import data from a Web API.
Incoming HTTP Request receive an HTTP request from a custom API endpoint of EasyMorph Server.
Incoming webhooks import incoming webhook messages from EasyMorph Gateway.

Create / Generate

Icon Action name Description
Calendar create a sequence of dates in specified date range
Create list create a list of up to 100 manually entered values
List of files create a list of files in specified folder
List of folders create a list of folders in specified folder
Parameter table creates a single-row table with parameter values as columns
Sequence generate a sequence of numbers from 1 to N
System information obtain system information (such as current Windows account or free RAM).

Create / Input

Icon Action name Description
Input obtain input dataset from a calling project
Sandbox create a table with temporary static snapshot of data
Uploaded files lists all files uploaded by use of "File upload" parameters.

Transform / Basic

Icon Action name Description
Aggregate calculate aggregates (subtotals) like sum or count grouped by one or more fields.
Append another table Append another table as new rows or columns.
Calculate new column(s) built using arithmetical operations and various functions.
Clean up remove particular values from one or more columns.
Concatenate text concatenate column values into delimited text.
Convert data type convert text dates into number dates.
Enumerate rows add column with row numbers.
Keep/remove columns retain or delete selected columns.
Lookup replace values in a column using a lookup table.
Merge another table merge (join) one or more columns from another table where certain columns in both tables match.
Modify column names add prefixes and/or suffixes to column names.
Modify column(s) .
Peek create a new column using a single value from another table.
Rename columns assign new names to selected columns.
Reorder columns rearrange the sequence of the columns within a dataset.
Replace replace particular values in a column with new ones.
Rule calculate or replace a column using multiple nested IF..THEN…ELSE conditions.
Sort sort table by one or more columns.

Transform / Advanced

Icon Action name Description
Anonymize/Hash anonymizes data without affecting its cardinality.
Compare tables compares two tables and produces a list of differences based on column metadata.
Create buckets create ranges of fixed width and assign each row to one of the ranges.
Cross merge create a table with all possible combinations (i.e. Cartesian product) of rows in two tables.
Distribute total break down a total/subtotal proportionally to a group of numbers (weights).
Enumerate groups enumerate all combinations of values in given columns.
Fill down fill down empty cells.
Fill right fill empty cells to the right.
Generate unique identifiers creates a randomly generated global unique identifier for each row.
Group assign a group name (or flag) to selected column values.
Hierarchy path generate a parent-child hierarchy path.
Interval merge merge columns from another table where key values fall into an interval defined by two columns.
Label columns name columns using values from top rows.
Linear regression build a linear regression. Interpolate/extrapolate values if needed.
Make date/time columns create column(s) with date/time attributes derived from a date column.
Match find text strings in another table, that are contained in the current table.
Natural merge merges two tables based on columns with the same names.
Pivot create a matrix table by pivoting.
Regular expression create a new column with regular expression matches.
Remove empty columns remove columns where all values are the same or empty.
Remove empty rows remove rows where all values are empty or whitespace.
Rename columns with lookup rename multiple columns using a lookup table.
Repeat rows repeat each row as many times as specified in given column.
Replace with lookup replace all substrings in one or many columns using a lookup table.
Roll up adds amounts up through a hierarchy.
Running total calculate rank, cumulative count, sum or % from total sum.
Sanitize text remove hidden system characters, extra spaces, and line breaks.
Select columns by lookup select columns using a lookup table.
Shift column up/down shifts column values up or down.
Sliding aggregation calculates an aggregate (average, sum, etc.) over N sliding values.
Split delimited text into columns split delimited values of a column into new columns.
Split delimited text into rows split delimited values of a column into rows.
Split fixed width text split a column with fixed width text values into new columns.
Statistical aggregation calculate median, percentile, standard error, standard deviation, or variance.
Table metadata obtain column names, total row count and other table metadata.
Table-wide replace remove or replace values across selected columns.
Total/subtotals add column total or group subtotals as a new column.
Unpivot convert a matrix table into a straight table.
Verify data in another table perform multiple data quality checks on a table.

Transform / Filters

Icon Action name Description
Deduplicate rows remove duplicate rows in entire table based on all or selected columns.
Filter filter rows by selecting/deselecting column values.
Filter by condition .
Filter by search filter rows that contain (or don't contain) search string.
Filter by type keep or remove only rows with values of particular data type (e.g. errors).
Keep duplicates keep only duplicate rows based on all or selected columns.
Keep min/max keep/remove rows with the top N biggest/smallest values.
Keep/remove matching keep or remove rows with values that exist in another table.
Trim table keep/remove top/bottom N rows.
Trim table by condition keep/remove rows above/below first row matching condition.

Transform / Web

Icon Action name Description
Construct HTTP response construct fields required for an HTTP response of the API Server.
Construct JSON construct a JSON object.
Extract JSON properties extract values of one or more JSON properties specified by JSON path.
Modify JSON* delete, replace, or rename a JSON property or format JSON.
Parse JSON parse a JSON object into a tabular dataset.
Parse web form submission parse web form submissions in the "x-www-form-urlencoded" format.
Parse XML parse XML into a tabular dataset.
Split JSON array split a JSON array into rows.

Export / File

Icon Action name Description
Export dataset export dataset into a file in the native EasyMorph data format (.dset).
Export into delimited text file export data into CSV or another delimited text format.
Export into Excel file export data into an Excel spreadsheet.
Export as plain text export a column as a plain text file without formatting or delimiting.
Export into Qlik file export data into a Qlik QVD file.
Export to Apache Parquet exports dataset into a file in the .parquet format.
Export to Tableau export data into a Tableau TDE/Hyper file or publish to Tableau Server/Online.
Export to XML export data into an XML file.

Export / Database

Icon Action name Description
Bulk export to database* bulk export into a database table (some RDBMS).
Export to database export EasyMorph table into database table (all RDBMS).

Export / App & Cloud

Icon Action name Description
Export to Airtable export to a table in Airtable base.
Export into Google Sheets export data into a Google Sheets spreadsheet.
Export to Power BI export to Power BI push-dataset.
Export to Salesforce insert records into a Salesforce object.
Export to SharePoint list append rows to a SharePoint list.
Export to Tableau export data into a Tableau TDE/Hyper file or publish to Tableau Server/Online.

Workflow / Internal

Icon Action name Description
Board/issue command automate operations with boards/issues in workflows.
Breakpoint stop project execution.
Call another module/project pass table data to another project and run it once.
Call with another table run another module or project, passing another table.
Either table between current table and another table choose one that is not empty.
Halt on data type mismatch abort project execution if a value in specified column(s) has a wrong type.
Halt/Warn on condition abort project execution, or display a warning and continue, if the specified condition is fulfilled.
Iterate run another module/project once for each row in table.
Iterate column run another module/project once for each column in table and automatically append all returned columns into one table.
Iterate table run another module/project once for each row in table and pass another table to it.
Play sound Play a system sound or .wav file.
Raise issue create a new issue in an Explorer board in EasyMorph Server.
Repeat run another module/project until/while its output is empty.
Shared memory perform operations on shared memory, a key-value data respository.
Skip actions on condition skip the rest of actions in table if the specified condition is fulfilled.
Skip if unchanged skip the rest of actions in table if the didn't change from previous run.
Skip on condition in another table skip the rest of the actions in table if the condition in another table is fulfilled.
Start/finish exclusive access enforce mutually exclusive access to a resource for simultaneously executed projects (tasks).
Status display custom project execution status message.
Synchronize wait until another table is calculated.
To-do add a to-do item to the workflow.
Wait pause execution for specified number of seconds.

Workflow / External

Icon Action name Description
Call Python and the input dataset, return a dataset back to EasyMorph.
Catalog command list/create/update/delete Catalog directories, items, and item fields.
Database command create/delete/truncate DB table or send a custom SQL command to a database (e.g. to bulk load a file).
Delete database rows delete rows in a database table that satisfy query conditions.
Delete matching database rows delete rows in a database table where key values match/don't match key values in an EasyMorph table.
Download file download a file from the internet.
Email command performs various operations with email messages.
Excel command* perform file/sheet operations and run VBA macros in Excel files.
Fetch email* fetch email messages and their attachments from a mail server (Exchange or IMAP).
File command performs basic file operations such as copy/move/rename/delete/unzip.
File transfer transfer files over SFTP or SCP to or from a remote computer.
Generate documentation generate HTML documentation for an EasyMorph project.
Iterate program* execute external application once for each row in a table.
Iterate Web Request send multiple uniform HTTP requests to a web API and append responses into one table.
PowerShell* executes one or more PowerShell statements.
Run program* execute external application once.
Send email send an email with an attachment to one or more recipients.
SSH command* run one or several commands on a remote computer using the SSH protocol.
Update database table* update a database table with values from EasyMorph.
Web Request send an HTTP request to a web API and receive a response.
XSLT transformation transform a given XML file using XSLT stylesheets.

Workflow / Apps and cloud

Icon Action name Description
Amazon S3 command perform an operation with AWS S3 , e.g. upload/download a file.
Ask AI sends free-form prompts to ChatGPT or other ChatGPT-compatible LLM services.
Azure Blob Storage command performs various file and folder operations with Azure Blob Storage.
Dropbox command performs various file and folder operations with Dropbox.
EasyMorph Server command trigger a task, or upload/download/delete a file on a remote EasyMorph Server.
Google Drive command perform an operation with Google Drive, e.g. download a file.
Jira command perform a Jira command.
OneDrive command perform file and folder operations within OneDrive.
Power BI command trigger a Power BI action, such as refreshing a dataset or triggering a workflow.
Qlik Cloud command execute a Qlik Cloud command remotely.
Qlik Sense command execute a Qlik Sense command remotely.
Send message to ntfy send a message through ntfy.
Send message to Pushover send a message through the Pushover service.
SharePoint command perform file and folder operations within SharePoint.
Slack Bot send notifications to Slack.
Tableau Server command trigger extract refresh or run a flow on Tableau Server / Online.
Teams Bot send a message to Microsoft Teams.
Update/delete rows in Airtable* update or delete rows in Airtable.
Update/delete records in Salesforce* update/delete records in a Salesforce object.
Update/delete rows in SharePoint list* update or delete rows in a SharePoint list.
Zendesk command create, update, and delete Zendesk tickets.