Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
| AdobeAnalytics | CloseSource | The CloseAdobeAnalyticsSource activity closes the specified source connection |
|---|---|---|
GetNextRecord
The GetNextAdobeAnalyticsRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupAdobeAnalyticsRecord activity fetches a specific record from a source connection
AzureAnalysisServices
CloseSource
The CloseSource activity closes the specified source connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupRecord activity fetches a specific record from a source connection
GoogleAnalytics
CloseSource
The CloseGoogleAnalyticsSource activity closes the specified source connection
GetNextRecord
The GetNextGoogleAnalyticsRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupGoogleAnalyticsRecord activity fetches a specific record from a source connection
SAS
CloseSource
Closes the specified source connection
GetNextRecord
Gets the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Loads a specific record from a source connection
YouTubeAnalytics
CloseSource
The CloseYouTubeAnalyticsSource activity closes the specified source connection
GetNextRecord
The GetNextYouTubeAnalyticsRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupYouTubeAnalyticsRecord activity fetches a specific record from a source connection
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|
ApacheHBase
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a source for reading data records
LookupRecord
Fetches a specific record from a source connection
ApacheHive
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a source for reading data records
LookupRecord
Fetches a specific record from a source connection
Greenplum
CloseSource
The CloseSource activity closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
The LookupGreenplumRecord activity fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
HPCC
CloseSource
The CloseSource activity closes the specified source connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupHPCCRecord activity fetches a specific record from a source connection
SparkSQL
CloseSource
The CloseSource activity closes the specified source connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupSparkSQLRecord activity fetches a specific record from a source connection
DataRobot
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Fetches a specific record from a source connection
SFEinsteinAnalytics
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Fetches a specific record from a source connection
Splunk
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Alfresco
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Kintone
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
QuickBase
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
GoogleCalendar | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
GoogleContacts | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
AmazonS3
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
CopyObject
Copies an object from one bucket to another
DownloadObjects
Downloads objects
DownloadObjectTorrent
Uses the BitTorrent protocol to retrieve any publicly-accessible objects
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
UploadObject
Uploads objects in a single operation
AzureTables
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
CreateEntityWithTypes
Creates a new record with the given data types. If a column is not found on an existing entity, you will need to use this procedure to set the type of the property to something other than string.
CreateSchema
Creates a schema file for the specified table or view
CreateTable
Creates a new table in the Azure system
DropTable
Drops an existing table in the Azure system
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
IBMCloudObjectStorage
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
CopyObject
Copies an object from one bucket to another
DeleteRecord
Deletes the specified target record
DownloadObject
Downloads and object
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
UploadObject
Uploads an object
Wasabi
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
CopyObject
Copies an object from one bucket to another
DownloadObjects
Downloads objects
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
UploadMultipleObjects
Uploads a single object as a set of parts
UploadObject
Uploads objects in a single operation
AmazonMarketplace
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Magento
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Shopify
CloseSource
Closes the specified source connection
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Fetches a specific record from a source connection
WooCommerce
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
JIRA
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time
LookupRecord
Fetches a specific record from a source connection
ServiceNow
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time
LookupRecord
Fetches a specific record from a source connection
Zendesk
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time
LookupRecord
Fetches a specific record from a source connection
ADLSGen1
AppendToFile
Appends content or a file to a file
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
Concat
Concatenate a group of files to another file
DeletePath
Delete a file or a directory.
DownloadFile
Downloads a file
GetContentSummary
Get the content summary of a file/folder.
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MakeDirectory
Create a directory in the specified path
RenamePath
Rename a file or a directory.
SetPathOwner
Set owner and group of a path.
SetPermission
Set permission of a path
UploadFile
Uploads a File
ADLSGen2
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
CreateFile
Create a file.
CreateFolder
Create a folder
DeleteObject
Delete a file or directory
DownloadFile
Download a file
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
RenameObject
Rename a file or a directory
UploadFile
Uploads a file
AzureSynapse
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
Databricks
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
GoogleBigQuery
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Redshift
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
Snowflake
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
ActCRM | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
BullhornCRM | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Dynamics365 | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
CreateAssociation | Creates an association between two entities based on a navigation property. Set the IncludeNavigationProperties connection property to true in order to use this activity. |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeAssociationsSource | Lists associations for a given table and navigation property into a Source. Set the IncludeNavigationProperties connection property to true in order to use this workflow activity. |
InitializeNavigationPropertiesSource | Lists navigation properties for a given table and the tables they are associated with into a Source. Navigation properties are used by the Association stored procedures. Set the IncludeNavigationProperties connection property to true in order to use this workflow activity. |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
DynamicsCRM | Assign | Assigns a target record to a user or team |
AssociateRequest | Adds link between two entity instances in a many to many relationship |
CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
DisassociateRequest | Removes a link between two entity instances in a many to many relationship |
ExecuteStatements | Executes custom SQL statements on a data source |
ExecuteWorkflow | Executes a Dynamics CRM workflow request |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
SetState | Sets the state and the status of an entity instance |
Highrise | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
OracleSalesCloud | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Salesforce | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
ConvertLead | Converts a Lead into an Account, Contact, or (optionally) an Opportunity. |
DeleteRecord | Deletes the specified target record |
DownloadAttachment | Downloads the attachment or attachments associated with a specific object |
DownloadDocument | Downloads the selected document or documents |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
GetUserInformation | Retrieves personal information for the user associated with the current session. |
InitializeDeletedSource | Initializes a source of deleted records within the given timespan for the specified object. Records can be iterated using the GetNextRecord activity. |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
InitializeUpdatedSource | Initializes a source of updated records within the given timespan for the specified object. Records can be iterated using the GetNextRecord activity. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
Merge | Combines up to 3 records of the same type into 1 record. |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Undelete | Restores a deleted record from the RecycleBin |
UploadAttachment | Uploads an attachment and associates it with an object in Salesforce |
UploadDocument | Uploads a document in Salesforce |
SAPHybrisC4C | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
SugarCRM | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
SuiteCRM | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
VeevaCRM | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
ConvertLead | Converts a Lead into an Account, Contact, or (optionally) an Opportunity. |
DeleteRecord | Deletes the specified target record |
DownloadAttachment | Downloads the attachment or attachments associated with a specific object |
DownloadDocument | Downloads the selected document or documents |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
GetUserInformation | Retrieves personal information for the user associated with the current session. |
InitializeDeletedSource | Initializes a source of deleted records within the given timespan for the specified object. Records can be iterated using the GetNextRecord activity. |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
InitializeUpdatedSource | Initializes a source of updated records within the given timespan for the specified object. Records can be iterated using the GetNextRecord activity. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
Merge | Combines up to 3 records of the same type into 1 record. |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Undelete | Restores a deleted record from the RecycleBin |
UploadAttachment | Uploads an attachment and associates it with an object in Salesforce |
UploadDocument | Uploads a document in Salesforce |
ZohoCRM | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
SAPConcur | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Asana | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Box | AddMetadataTemplatestoFile | Applies an instance of a metadata template to a file. |
CloseSource | Closes the specified source |
CloseTarget | Closes the specified target |
CopyFile | Copy a File |
CopyFolder | Copy a Folder |
DeleteRecord | Deletes the specified target record |
DownloadFile | Downloads a File |
EmptyTrash | Clear the recycle bin/trash. |
GetNextRecord | Fetches the next record from the specified source |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a target for writing records |
LockFile | Lock a file |
LookupRecord | Fetches a specific record from a source |
MapRecordFields | Sets the values of the specified DataFields in a target |
SaveRecord | Saves the specified target record |
ShareAnItem | Shares a File, Folder or Bookmark. |
UnlockFile | Unlock a file. |
UploadFile | Uploads a File. |
UploadFileVersion | Uploads a new version of an existing File. |
Dropbox | CheckJobStatus | Check the status of an asynchronous job. Requires the sharing.write scope. |
CloseSource | Closes the specified source |
CloseTarget | Closes the specified target |
DeletePermanently | Delete a folder or file permanently. Requires the files.permanent_delete scope. |
DeleteRecord | Deletes the specified target record |
DownloadFile | Downloads a File. Requires the files.content.read scope. |
GetNextRecord | Fetches the next record from the specified source |
GetSpaceUsage | Check the memory space management of your Dropbox account. Requires the account_info.read scope. |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a target for writing records |
LookupRecord | Fetches a specific record from a source |
MapRecordFields | Sets the values of the specified DataFields in a target |
SaveRecord | Saves the specified target record |
ShareFolder | Shares a folder. Requires the sharing.write scope. |
UnshareFolder | Unshares a folder. Requires the sharing.write scope. |
UploadFile | Uploads a File. Requires the files.content.read scope. |
Exchange | CloseSource | The CloseExchangeSource activity closes the specified source connection |
CloseTarget | The CloseExchangeTarget activity closes the specified target connection |
DeleteRecord | The DeleteExchangeRecord activity deletes the specified target record |
GetNextRecord | The GetNextExchangeRecord activity fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | The InitializeExchangeTarget is used for initializing a connection where output records will be saved. Multiple InitializeExchangeTarget activites can be included in the workflow. |
LookupRecord | The LookupExchangeRecord activity fetches a specific record from a source connection |
MapRecordFields | The MapAndSetExchangeFields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
GoogleDrive | CloseSource | Closes the specified source |
CloseTarget | Closes the specified target |
DeleteRecord | Deletes the specified target record |
GetNextRecord | Fetches the next record from the specified source |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a target for writing records |
LookupRecord | Fetches a specific record from a source |
MapRecordFields | Sets the values of the specified DataFields in a target |
SaveRecord | Saves the specified target record |
MSTeams | CloseSource | The CloseMSTeamsSource activity closes the specified source connection |
CloseTarget | The CloseMSTeamsTarget activity closes the specified target connection |
DeleteRecord | The DeleteMSTeamsRecord activity deletes the specified target record |
GetNextRecord | The GetNextMSTeamsRecord activity fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | The InitializeMSTeamsTarget is used for initializing a connection where output records will be saved. Multiple InitializeMSTeamsTarget activites can be included in the workflow. |
LookupRecord | The LookupMSTeamsRecord activity fetches a specific record from a source connection |
MapRecordFields | The MapAndSetMSTeamsFields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Office365 | CloseSource | The CloseOffice365Source activity closes the specified source connection |
CloseTarget | The CloseOffice365Target activity closes the specified target connection |
DeleteRecord | The DeleteOffice365Record activity deletes the specified target record |
GetNextRecord | The GetNextOffice365Record activity fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | The InitializeOffice365Target is used for initializing a connection where output records will be saved. Multiple InitializeOffice365Target activites can be included in the workflow. |
LookupRecord | The LookupOffice365Record activity fetches a specific record from a source connection |
MapRecordFields | The MapAndSetOffice365Fields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
OneDrive | CloseSource | Closes the specified source |
CloseTarget | Closes the specified target |
CopyResource | Copy a resource from one directory in your drive to another. |
CreateFolder | Create a new folder in your drive |
DeleteRecord | Deletes the specified target record |
DeleteResource | Delete a resource from your drive. |
DownloadFile | Download an existing file from your drive. |
GetNextRecord | Fetches the next record from the specified source |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a target for writing records |
LookupRecord | Fetches a specific record from a source |
MapRecordFields | Sets the values of the specified DataFields in a target |
MoveResource | Move a resource from one directory in your drive to another. |
SaveRecord | Saves the specified target record |
UploadFile | Upload a new file or update content to an existing file. |
OneNote | CloseSource | The CloseOneNoteSource activity closes the specified source connection |
CloseTarget | The CloseOneNoteTarget activity closes the specified target connection |
DeleteRecord | The DeleteOneNoteRecord activity deletes the specified target record |
GetNextRecord | The GetNextOneNoteRecord activity fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | The InitializeOneNoteTarget is used for initializing a connection where output records will be saved. Multiple InitializeOneNoteTarget activites can be included in the workflow. |
LookupRecord | The LookupOneNoteRecord activity fetches a specific record from a source connection |
MapRecordFields | The MapAndSetOneNoteFields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
SharePoint | AddAttachment | Add an attachment to a SharePoint list item |
CheckInDocument | Checks in a document to SharePoint and releases the lock on the document |
CheckOutDocument | Checks out a document from SharePoint |
CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
CopyDocument | Copies a document from the SharePoint library |
CreateFolder | Creates a folder to a document library on a SharePoint site |
DeleteAttachment | Delete an attachment from a SharePoint list item |
DeleteDocument | Delete a document on the SharePoint library. |
DeleteRecord | Deletes the specified target record |
DiscardCheckOutDocument | Discards a check out on a document in SharePoint. This does not check a new file into SharePoint, it just releases the lock on the document |
DownloadDocument | Download a document from a SharePoint library |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
UploadDocument | Upload a document to a SharePoint library |
Slack | CloseSource | Closes the specified source |
CloseTarget | Closes the specified target |
DeleteRecord | Deletes the specified target record |
GetNextRecord | Fetches the next record from the specified source |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a target for writing records |
LookupRecord | Fetches a specific record from a source |
MapRecordFields | Sets the values of the specified DataFields in a target |
SaveRecord | Saves the specified target record |
Smartsheet | CloseSource | Closes the specified source |
CloseTarget | Closes the specified target |
DeleteRecord | Deletes the specified target record |
GetNextRecord | Fetches the next record from the specified source |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a target for writing records |
LookupRecord | Fetches a specific record from a source |
MapRecordFields | Sets the values of the specified DataFields in a target |
SaveRecord | Saves the specified target record |
CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Gmail | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializing a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Acumatica | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
D365BusinessCentral | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Dynamics365 | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
DynamicsGP | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
LookupRecord | Gets a specific record from a data source |
DynamicsNAV | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
NetSuite_SuiteQL | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
NetSuite_SuiteTalk | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Odoo | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
SAPBusinessOne | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
SAPERP | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
LookupRecord | Gets a specific record from a data source |
Workday | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
ExactOnline | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
FinancialEdgeNXT | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
FreshBooks | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
QuickBooks | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
QuickBooksOnline | CloseSource | The CloseQuickBooksOnlineSource activity closes the specified source connection |
CloseTarget | The CloseQuickBooksOnlineTarget activity closes the specified target connection |
DeleteRecord | The DeleteQuickBooksOnlineRecord activity deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | The InitializeQuickBooksOnlineTarget is used for initializing a connection where output records will be saved. Multiple InitializeQuickBooksOnlineTarget activites can be included in the workflow. |
LookupRecord | The LookupQuickBooksOnlineRecord activity fetches a specific record from a source connection |
MapRecordFields | The MapAndSetQuickBooksOnlineFields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
QuickBooksPOS | CloseSource | The CloseQuickBooksPOSSource activity closes the specified source connection |
CloseTarget | The CloseQuickBooksPOSTarget activity closes the specified target connection |
DeleteRecord | The DeleteQuickBooksPOSRecord activity deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | The InitializeQuickBooksPOSTarget is used for initializing a connection where output records will be saved. Multiple InitializeQuickBooksPOSTarget activites can be included in the workflow. |
LookupRecord | The LookupQuickBooksPOSRecord activity fetches a specific record from a source connection |
MapRecordFields | The MapAndSetQuickBooksPOSFields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Reckon | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Sage50UK | CloseSource | The CloseSage50UKSource activity closes the specified source connection |
CloseTarget | The CloseSage50UKTarget activity closes the specified target connection |
DeleteRecord | The DeleteSage50UKRecord activity deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | The InitializeSage50UKTarget is used for initializing a connection where output records will be saved. Multiple InitializeSage50UKTarget activites can be included in the workflow. |
LookupRecord | The LookupSage50UKRecord activity fetches a specific record from a source connection |
MapRecordFields | The MapAndSetSage50UKFields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
SageIntacct | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Xero | CloseSource | The CloseXeroSource activity closes the specified source connection |
CloseTarget | The CloseXeroTarget activity closes the specified target connection |
DeleteRecord | The DeleteXeroRecord activity deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | The InitializeXeroTarget is used for initializing a connection where output records will be saved. Multiple InitializeXeroTarget activites can be included in the workflow. |
LookupRecord | The LookupXeroRecord activity fetches a specific record from a source connection |
MapRecordFields | The MapAndSetXeroFields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Access | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Btrieve | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializing a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
DB2 | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a Source for reading data records |
InitializeTarget | Initializes a Target for saving data records |
LookupRecord | Fetches a specific record from a Source |
MapRecordFields | Setting the values of the specified DataFields in a target |
SaveRecord | Saves the specified target record |
EmbeddedDB | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Maps values to specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Firebird | CloseSource | The CloseFirebirdSource activity closes the specified source connection |
CloseTarget | The CloseFirebirdTarget activity closes the specified target connection |
DeleteRecord | The DeleteFirebirdRecord activity deletes the specified target record |
ExecuteStatements | The ExecuteFirebirdStatement activity is used to execute a custom sql statement on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | The GetNextFirebirdRecord activity fetches the next record from the specified source connection |
InitializeSource | The InitializeFirebirdSource activity initializes a connection for reading data records at run time. Multiple InitializeFirebirdSource activites can be included in the workflow. |
InitializeTarget | The InitializeFirebirdTarget is used for initializing a connection where output records will be saved. Multiple InitializeFirebirdTarget activites can be included in the workflow. |
LookupRecord | The LookupFirebirdRecord activity fetches a specific record from a source connection |
MapRecordFields | The MapAndSetFirebirdFields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Informix | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializing a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
MariaDB | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializing a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
MySQL | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializing a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Odbc | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializing a connection where output records will be saved. |
LookupRecord | Loads a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
OleDb | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
LookupRecord | Loads a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Oracle | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializing a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
PostgreSQL | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializing a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
SqlAzure | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializing a connection where output records will be saved. |
LookupRecord | Loads a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
SqlServer | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteSQLScript | Executes a SQL Server Script file |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
RunSSISPackage | Runs a SSIS package |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
SqlServerCe | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | The ExecuteSqlServerCeStatement activity is used to execute a custom sql statement on a connection |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a source for reading records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Sybase | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializing a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Teradata | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializing a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Vertica | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
xBase | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializing a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
DynamicDataSource | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a source for reading records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record |
AuthorizeNet | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
PayPal | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
Square | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Stripe | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
AmazonDynamoDB | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Cassandra | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Cloudant | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
CosmosDB | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Couchbase | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
MongoDB | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Redis | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
SimpleDB | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|
The Actions-Fields-Library-Financial module which is filled with Microsoft Excel compatible functions contains the following types:
| Type | Description |
|---|
The Fields-Field actions are grouped in the modules shown below:
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
CSVDatabase
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
DelimitedFile
AppendFile
Appends the contents of one file to another
CloseSourceFile
Closes the specified Source data source
CloseTargetFile
Closes the specified target delimited file
CopyFileRecords
Copies specific records from one file to another
CreateFileFromSource
Creates a delimited file from a Source
DeleteFile
Deletes the specified file
GetNextFileRecord
Fetches the next record from the specified delimited Source file
InitializeSourceFile
Initializes a Source for reading data records from a delimited file
InitializeTargetFile
Initializes a Target for writing data records to a delimited file
MapRecordFields
Sets the values of the specified DataFields in a target delimited file
SaveValueInNewFile
Saves a field value to a file
SplitFile
Splits a large delimited file into multiple files
WriteTargetFileRecord
Inserts a record into the specified delimited file
FileSystem
DirACLAddEntry
The DirectoryAddACLEntry activity adds an Access Control List (ACL) entry to a directory
DirACLRemoveEntry
The DirectoryACLRemoveEntry activity removes an Access Control List (ACL) entry from a directory
DirCloseDirInfoSource
The DirectoryCloseDirectoryInfoSource activity closes the Directoryinfo source and frees up resources
DirCloseFileInfoSource
The CloseSourceFileFile activity closes the DirectoryFileInfo source and frees up resources
DirectoryCreate
The DirectoryCreate activity creates all the directories and subdirectories in the specified path
DirectoryDelete
The DirectoryDelete activity deletes a directory and its subdirectories if specified
DirectoryMove
The DirectoryMove activity moves a directory from a source to a destination
DirectoryZip
The DirectoryZip activity zips a directory
DirGetNextDirInfoRecord
The DirGetNextDirInfoRecord activity loads the next record from the specified list of selected Directoryinfo
DirGetNextFileInfoRecord
The DirectoryGetNextFileInfoRecord activity loads the next record from the specified list of selected fileinfo
DirInitializeDirInfoSource
The DirectoryInitializeDirectoryInfoSource activity initializes a list of directory information that can be accessed sequentially using the GetNextDirectoryInfoRecord
DirInitializeFileInfoSource
The DirectoryInitializeFileInfoSource activity initializes a list of file information that can be accessed sequentially using the GetNextFileInfoRecord
FileACLAddEntry
The FileACLAddEntry activity adds an Access Control List (ACL) entry to a file
FileACLRemoveEntry
The FileACLRemoveEntry activity removes Access Control List (ACL) entry from a file
FileCopy
Copies files from one location to another
FileDelete
The FileDelete activity deletes a file
FileFTPDownload
The FileFTPDownload activity downloads a file from an ftp site
FileFTPUpload
The FileFTPUpload activity uploads a file from an ftp site
FileMove
Moves a file from a source to a destination
FileUnzip
The FileZip activity unzips a file
FileZip
The FileZip activity zips a file
SaveValueInNewFile
The SaveValueInNewFile activity is used for saving field values to a file
FixedLengthFile
AppendFile
Appends the contents of one file to another
CloseSourceFile
Closes the specified Source file data source
CloseTargetFile
Closes the specified target file
CopyFileRecords
Copies specific records from one file to another
DeleteFile
Deletes the specified file
GetNextFileRecord
Fetches the next record from the specified Source file data source
InitializeSourceFile
Initializes a Source for reading data records from a fixed length file
InitializeTargetFile
Initializes a Target for writing data records to a fixed length text file
MapRecordFields
Sets the values of the specified DataFields in a Target data source
SaveValueInNewFile
The SaveValueInNewFile activity is used for saving a field value to a file
SplitFile
Splits a large delimited file into multiple files
WriteTargetFileRecord
Inserts a record into the specified text file
OFX
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Fetches a specific record from a source connection
Quandl
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Gets a specific record from a data source
Propel
CloseSource
Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run
CloseTarget
Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run
ConvertLead
Converts a Lead into an Account, Contact, or (optionally) an Opportunity.
DeleteRecord
Deletes the specified target record
DownloadAttachment
Downloads the attachment or attachments associated with a specific object
DownloadDocument
Downloads the selected document or documents
ExecuteStatements
Executes custom SQL statements on a data source
GetNextRecord
Gets the next record from the specified source connection
GetUserInformation
Retrieves personal information for the user associated with the current session.
InitializeDeletedSource
Initializes a source of deleted records within the given timespan for the specified object. Records can be iterated using the GetNextRecord activity.
InitializeSource
Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity.
InitializeTarget
Initializes a connection for saving output data records.
InitializeUpdatedSource
Initializes a source of updated records within the given timespan for the specified object. Records can be iterated using the GetNextRecord activity.
LookupRecord
Gets a specific record from a data source
MapRecordFields
Sets the values of the specified DataFields in a target connection
Merge
Combines up to 3 records of the same type into 1 record.
SaveRecord
Saves the specified target record - (Insert, Update, Upsert, Skipsert)
Undelete
Restores a deleted record from the RecycleBin
UploadAttachment
Uploads an attachment and associates it with an object in Propel
UploadDocument
Uploads a document in Propel
Basecamp
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
MicrosoftProject
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
BingAds
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Fetches a specific record from a source connection
GoogleAds
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Fetches a specific record from a source connection
HubSpot
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
MailChimp
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Marketo
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
OracleEloqua
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
SurveyMonkey
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
YouTube
CloseSource
The CloseYouTubeSource activity closes the specified source connection
GetNextRecord
The GetNextYouTubeRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupYouTubeRecord activity fetches a specific record from a source connection
Bing
CloseSource
The CloseSource activity closes the specified source connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupBingRecord activity fetches a specific record from a source connection
Elasticsearch
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a source for reading data records
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
GoogleSearch
CloseSource
The CloseSource activity closes the specified source connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupGoogleSearchRecord activity fetches a specific record from a source connection
ActiveDirectory | CloseSource | The CloseSource activity closes the specified source connection |
CloseTarget | The CloseTarget activity closes the specified target connection |
DeleteRecord | The DeleteRecord activity deletes the specified target record |
ExecuteStatements | The ExecuteActiveDirectoryStatement activity is used to execute a custom sql statement on a connection |
GetNextRecord | The GetNextRecord activity fetches the next record from the specified source connection |
InitializeSource | The InitializeSource activity initializes a connection for reading data records at run time. Multiple InitializeActiveDirectorySource activites can be included in the workflow. |
InitializeTarget | The InitializeTarget is used for initializing a connection where output records will be saved. Multiple InitializeActiveDirectoryTarget activites can be included in the workflow. |
LookupRecord | The LookupRecord activity fetches a specific record from a source connection |
MapRecordFields | The MapRecordFields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
JSON | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
LDAP | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
MicrosoftDataverse | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
OData | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Execute a custom sql statement on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
REST | CloseSource | The CloseSource activity closes the specified source connection |
GetNextRecord | The GetNextRecord activity fetches the next record from the specified source connection |
InitializeSource | The InitializeSource activity initializes a connection for reading data records at run time. Multiple InitializeRESTSource activites can be included in the workflow. |
LookupRecord | The LookupRecord activity fetches a specific record from a source connection |
RSS | CloseSource | Closes the specified source connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
LookupRecord | Fetches a specific record from a source connection |
XML | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
ACCRINT | Returns the accrued interest for a security that pays periodic interest |
ACCRINTM | Returns the accrued interest for a security that pays interest at maturity |
AMORDEGRC | Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. The function is similar to AMORLINC, except that a depreciation coefficient is applied in the calculation depending on the life of the assets. |
AMORLINC | Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. |
COUPDAYS | Returns the number of days in the coupon period that contains the settlement date. |
COUPDAYSBS | Calculates the number of days from the beginning of a coupon's period to the settlement date. |
COUPDAYSNC | Returns the number of days from the settlement date to the next coupon date. |
COUPNCD | Returns a number that represents the next coupon date after the settlement date. |
COUPNUM | Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon. |
COUPPCD | Returns a number that represents the previous coupon date before the settlement date. |
CUMIPMT | Returns the cumulative interest paid on a loan between start_period and end_period. |
CUMPRINC | Returns the cumulative principal paid on a loan between start_period and end_period. |
DB | Returns the depreciation of an asset for a specified period using the fixed-declining balance method. |
DDB | Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify. |
DISC | Returns the discount rate for a security. |
DOLLARDE | Excel DOLLARDE Function |
DOLLARFR | Excel DOLLARFR Function |
DURATION | Excel DURATION Function |
EFFECT | Excel EFFECT Function |
FV | Calculates the future value of an investment based on a constant interest rate. |
FVSCHEDULE | Returns the future value of an initial principal after applying a series of compound interest rates. |
INTRATE | Returns the interest rate for a fully invested security. |
IPMT | Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. |
IRR | Returns the internal rate of return for a series of cash flows represented by the numbers in values. |
ISPMT | Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments. |
MDURATION | Returns the modified Macauley duration for a security with an assumed par value of $100. |
MIRR | Returns the modified internal rate of return for a series of periodic cash flows. MIRR considers both the cost of the investment and the interest received on reinvestment of cash. |
NOMINAL | Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year. |
NPER | Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. |
NPV | Calculates the net present value of an investment by using a discount rate and a series of future payments(negative values) and income(positive values). |
ODDFPRICE | Returns the price per $100 face value of a security having an odd (short or long) first period. |
ODDFYIELD | Returns the yield of a security that has an odd (short or long) first period. |
ODDLPRICE | Returns the price per $100 face value of a security having an odd (short or long) last coupon period. |
ODDLYIELD | Returns the yield of a security that has an odd (short or long) last period. |
PDURATION | Returns the number of periods required by an investment to reach a specified value. |
PMT | Calculates the payment for a loan based on constant payments and a constant interest rate. |
PPMT | Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate. |
PRICE | Returns the price per $100 face value of a security that pays periodic interest. |
PRICEALLOWNEGATIVEYIELD | Returns the price per $100 face value of a security that pays periodic interest. |
PRICEDISC | Returns the price per $100 face value of a discounted security. |
PRICEMAT | Returns the price per $100 face value of a security that pays interest at maturity |
PV | Calculates the present value of a loan or an investment, based on a constant interest rate. |
RATE | Returns the interest rate per period of an annuity. |
RECEIVED | Returns the amount received at maturity for a fully invested security. |
RRI | Returns an equivalent interest rate for the growth of an investment. |
SLN | Returns the straight-line depreciation of an asset for one period. |
SYD | Returns the sum-of-years' digits depreciation of an asset for a specified period. |
TBILLEQ | Returns the bond-equivalent yield for a Treasury bill. |
TBILLPRICE | Returns the price per $100 face value for a Treasury bill. |
TBILLYIELD | Returns the yield for a Treasury bill. |
VDB | Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. VDB stands for variable declining balance. |
XIRR | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. To calculate the internal rate of return for a series of periodic cash flows, use the IRR function |
XNPV | Returns the net present value for a schedule of cash flows that is not necessarily periodic. To calculate the net present value for a series of cash flows that is periodic, use the NPV function. |
YEARFRAC | Calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). |
YIELD | Returns the yield on a security that pays periodic interest. Use YIELD to calculate bond yield. |
YIELDDISC | Returns the annual yield for a discounted security. |
YIELDMAT | Returns the annual yield of a security that pays interest at maturity. |
Cache | LookupCachedCustomValue | Returns a custom value saved in the cache |
LookupCachedKeyValue | Returns a table key value that has been saved in the cache |
Counters | GetCurrentCounterValue | Returns the specified counter value |
IncrementCounter | Initializes, Increments the value of a specified counter and returns it |
Custom | Composite | Executes selected defined or pre-defined actions in sequence and returns the result of executing the last action in the list. |
Expression | The Expression action executes a simple expression (javascript). The expression must return a value |
Function | Executes a .Net custom function and returns a value |
Script | The Script field action executes a script (javascript). The script must return a value. |
DateTime | AddDaysToDate | Adds (or subtracts) the specified number of days to a date |
AddMonthsToDate | Adds (or subtracts) the specified number of months to a date |
AddTimeSpanToDateTime | Adds (or subtracts) the specified TimeSpan (00:00:00:00) to a datetime. To subtract place - in front of TimeSpan value. |
AddYearsToDate | Adds (or subtracts) the specified number of years to a date |
GetDateDay | Gets the Day (integer) from the date |
GetDateMonth | Gets the Month (integer) from the date |
GetDateThisDayLastMonth | Gets this day last month (date) |
GetDateThisDayLastWeek | Gets this day last week |
GetDateThisDayLastYear | Gets this day last year (date) |
GetDateThisDayNextMonth | Gets this day next month (date) |
GetDateThisDayNextWeek | Gets this day next week |
GetDateThisDayNextYear | Gets this day next year (date) |
GetDateThisMonthEnd | Gets this month's end date |
GetDateThisMonthStart | Gets this month's start date |
GetDateThisYearEnd | Gets this year's end date |
GetDateThisYearStart | Gets this year's start date |
GetDateTimeNow | Gets the current date/time |
GetDateToday | Gets today's date |
GetDateTomorrow | Gets tomorrow's date |
GetDateYear | Gets the Year (integer) from the date |
GetDateYesterday | Gets yesterday's date |
GetElapsedTimeDays | Returns the integer number of days between two dates |
GetElapsedTimeHours | Returns the integer number of hours between two datetimes |
GetElapsedTimeMilliseconds | Returns the integer number of milliseconds between two datetimes |
GetElapsedTimeMinutes | Returns the integer number of minutes between two datetimes |
GetElapsedTimeMonths | Returns the integer number of years between two dates |
GetElapsedTimeSeconds | Returns the integer number of seconds between two datetimes |
GetElapsedTimeWeeks | Returns the integer number of weeks between two dates |
GetElapsedTimeYears | Returns the integer number of years between two dates |
GetYearWeekNumber | Gets the number of the week in the year |
SetTime | Sets the time for a date/time |
File | GetFileContentsAsBytes | Gets the contents of a file as a string |
GetFileContentsAsString | Gets the contents of a file as a string |
GetFileRecordSubstring | Gets a substring from a fixed length file record |
Lookup | LookupBulkLoadRecordId | Gets a record Id retrieved from a bulk load on a parent target |
LookupDataFieldValue | Loads a record and returns a specific data field |
LookupMappedFieldValue | The LookupMappedFieldValue initializes a table to be used for replacing an input value with a defined output value. Useful for mapping picklist or option set values. |
LookupPickListValue | Gets the key or description for a picklist |
LookupRetrievedIdFromAuditLog | Returns a table key value that has been saved in the audit logs table |
LookupRoundRobinValue | Supports the lookup of values in a round-robin fashion. This can be used for lead distribution, record assignment, etc. |
Numeric | CalculateRunningTotal | Adds a value to a running total |
FormatNumber | Returns the string representation of an integer, adding extra 0's to the right if the string is smaller than the specified number of characters. |
GetCurrentCounterValue | Returns the current value of a counter. |
GetNextCounterValue | Increments a counter and returns the new value. |
GetRunningTotal | Gets a running total |
GetRunningTotalAverage | Gets the average value in a running total |
GetRunningTotalCount | Gets the count of number of entries in a running total |
GetRunningTotalMaximum | Gets the maximum value in running total |
GetRunningTotalMinimum | Gets the minimum value in running total |
InitializeCounter | Initializes a counter of integer values. At any time, executing this action returns the current value of the counter. Use GetNextCounterValue to increment and get next counter value. |
InitializeRunningTotal | Initializes a running total. At any time, executing this action returns the current value of the counter. Use GetNextCounterValue to increment and get next counter value. |
String | AlternateCases | Returns a string with alternated letter casing(upper/lower). First character of the string stays the same |
Base64Decode | Decodes a Base64 string |
Base64Encode | Encodes a Base64 string |
Capitalize | Capitalizes the first character in a string |
CharMid | Returns the character at a position given by the startingIndex plus the given count. |
CharRight | Returns the character in a string at a given index counting from the right. |
Concatenate | Concatenates values into a string |
ConcatenateHtml | Inserts values into Html using the Html editor |
ConvertHtmlToPlainText | Converts a string from Html to plain text |
ConvertRtfToString | Converts Rtf to a string |
ConvertStringToRtf | Converts a string to Rtf |
Format | Returns a string formatted to match the format string |
FormatDataType | Returns a formatted datetime, decimal, double, integer or single value using .Net formatting |
GetEmptyString | Returns an empty string value |
GetHashCodePolynomial | Returns the hash code of a string based on a polynomial function with a specified factor. |
GetInitials | Returns the initials of each word in a string. Words are separated according to the sepecified string sequence. |
GetKeyFromGuid | Gets a Guid key |
GetKeyFromRandomNumber | Returns a key based on randomly generated number |
GetKeyFromTimestamp | Gets a Timestamp key |
GetLength | Returns the length of a string. |
GetNullString | Returns a null string value |
GetTitle | Returns the initials of each word in a string. Words are separated according to the sepecified string sequence. |
IndentLines | Returns a string with the given number of spaces prepended to the beginning of each line. |
InsertSeparator | Returns a string with a given seperator inserted after a specified interval of characters. |
InsertString | Inserts a string at a specified index position in the source string (0 origin) |
KeepAlphaNumeric | Returns a string with only alpha-numeric characters preserved. |
KeepVowels | Returns a string with only the vowel characters. |
PadLeft | Pads a string on the left with a specified character |
PadRight | Pads a string on the right with a specified character |
PrependLinesWithCharacter | Returns a string with the given number of a specific character prepended to the beginning of each line. |
RegexReplace | Within the source input string, replaces strings that match a regular expression pattern with a specified replacement string. |
RemoveCharacter | Removes a specified character from a string |
RemoveCharacters | Deletes a specified numer of characters in a string starting an index position (0 origin) |
RemoveLetters | Returns a string with any letter characters removed. |
RemoveNumeric | Returns a string with any numeric characters removed. |
RemoveRepeats | Returns a string with all characters repeated in a row removed. |
RemoveSegment | Returns a string with the first occurence of the specified string segment removed. |
RemoveVowels | Returns a string with any vowel character removed. |
ReplaceFirstOccurence | Returns a string with the first occurence of the specified value replaced with a new value. |
ReplaceLastOccurence | Returns a string with the last occurence of the specified value replaced with a new value. |
ReplaceLeadingCharacters | Returns a string with the first given number of characters replaced with a new character. |
ReplaceString | Replaces all occurences of an old string value with new string value |
ReplaceTrailingCharacters | Returns a string with the last given number of characters replaced with a new character. |
ReplaceWithEmptyString | Replaces all occurences of an old string value with an empty string value |
ReverseCharacters | Returns a string with characters in reverse order. |
Split | Gets a string by spliting a string and selecting from an index position (0 origin) |
SplitWithCharacterLimit | Splits a string into an array each no longer than the given character limit and selecting from an index position in the result (0 origin). |
Substring | Gets a substring from a string starting at an index position (0 origin) |
SubstringOfLength | Gets a substring of a specified length from a string starting at an index position (0 origin) |
SubstringOfRange | Returns a segment of a string, marked by the start and end index (exclusive). |
SwapCases | Returns a string with the opposite letter casing for each character. |
SwapCharacters | Returns a string the swapped characters at specified indices. |
ToLowercase | Converts a string to lowercase |
ToUppercase | Converts a string to UPPERCASE |
TrimAll | Removes all whitespace from a string |
TrimLeadingCharacters | Removes all leading occurences of a specified character from a string |
TrimTrailingCharacters | Removes all trailing occurences of a specified character from a string |
UrlDecode | Decodes a Url |
UrlEncode | Encodes a Url |
WordWrap | Returns a string that is no longer than the maximum width given in pixels. Excess words are moved to a new line. |
CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
The Utility-Automation actions category includes the following modules and types:
| Module | Type | Description |
|---|---|---|
The Actions-Fields-Library-Math module contains the following types:
| Type | Description |
|---|---|
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|---|---|
The Utility-FileSystem actions category includes the following modules and types:
| Module | Type | Description |
|---|---|---|
The Execution action category contains the following actions in the modules shown below:
| Module | Type | Description |
|---|---|---|
Maintenance
PurgeLogEntries
The PurgeLogEntries activity is used for purging log entries from the project database
RefreshDataSource
This activity refreshes the metadata for a data source
RemoveDataSource
This activity removes the metadata for a data source
UnlockProjectRecords
This activity unlocks project records
Services
RunPowerShellScript
The RunPowerShellScript activity runs a PowerShell script
RunSSISPackage
The RunSSISPackage activity runs an SSIS package
StartService
The StartService activity starts a service on a server
StopService
The StopService activity stops a service running on a server
Abs
Returns the absolute value of a specified number.
Acos
Returns the angle whose cosine is the specified number.
Asin
Returns the angle whose sine is the specified number.
Atan
Returns the angle whose tangent is the specified number.
Atan2
Returns the angle whose tangent is the quotient of two specified numbers.
Cos
Returns the cosine of the specified angle.
Cosh
Returns the hyperbolic cosine of the specified angle.
DivideInt32GetQuotient
Calculates the quotient of two 32-bit signed integers
DivideInt32GetRemainder
Calculates the remainder of dividing two 32-bit signed integers
DivideInt64GetQuotient
Calculates the quotient of two 64-bit signed integers
DivideInt64GetRemainder
Calculates the remainder of dividing two 64-bit signed integers
E
Returns constant e - Euler's number
Exp
Returns e raised to the specified power
Log
Returns the natural (base e) logarithm of a specified number.
Log10
Returns the base 10 logarithm of a specified number.
Max
Returns the maximum number from a list of numbers.
Min
Returns the minimum number from a list of numbers.
Pi
Returns the value of mathematical constant pi.
Pow
Returns a double of a specified number raised to the specified power
Sin
Returns the sine of the specified angle.
Sinh
Returns the hyperbolic sine of the specified angle.
Sqrt
Returns the square root of a specified number.
Tan
Returns the tangent specified angle.
Tanh
Returns the hyperbolic tangent specified angle.
TruncateDecimal
Calculates the integral part of a specified decimal number.
TruncateDouble
Calculates the integral part of a specified double number.
FedEx
CloseSource
The CloseFedExSource activity closes the specified source connection
GetNextRecord
The GetNextFedExRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupFedExRecord activity fetches a specific record from a source connection
UPS
CloseSource
The CloseSource activity closes the specified source connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupUPSRecord activity fetches a specific record from a source connection
USPS
CloseSource
The CloseUSPSSource activity closes the specified source connection
GetNextRecord
The GetNextUSPSRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupUSPSRecord activity fetches a specific record from a source connection
Excel
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity.
InitializeTarget
Initializes a connection for saving output data records.
LookupRecord
Gets a specific record from a data source
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
ExcelOnline
CloseSource
The CloseExcelOnlineSource activity closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
ExcelServices
CloseSource
The CloseExcelServicesSource activity closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Fetches a specific record from a source connection
GoogleSheets
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Files
FileACLAddEntry
The FileACLAddEntry activity adds an Access Control List (ACL) entry to a file
FileACLRemoveEntry
The FileACLRemoveEntry activity removes Access Control List (ACL) entry from a file
FileCopy
Copies files from one location to another
FileDelete
The FileDelete activity deletes a file
FileFTPDownload
The FileFTPDownload activity downloads a file from an ftp site
FileFTPUpload
The FileFTPUpload activity uploads a file from an ftp site
FileMove
Moves a file from a source to a destination
FileUnzip
The FileZip activity unzips a file
FileZip
The FileZip activity zips a file
SaveValueInNewFile
The SaveValueInNewFile activity is used for saving field values to a file
Folders
DirACLAddEntry
The DirectoryAddACLEntry activity adds an Access Control List (ACL) entry to a directory
DirACLRemoveEntry
The DirectoryACLRemoveEntry activity removes an Access Control List (ACL) entry from a directory
DirCloseDirInfoSource
The DirectoryCloseDirectoryInfoSource activity closes the Directoryinfo source and frees up resources
DirCloseFileInfoSource
The CloseSourceFileFile activity closes the DirectoryFileInfo source and frees up resources
DirectoryCreate
The DirectoryCreate activity creates all the directories and subdirectories in the specified path
DirectoryDelete
The DirectoryDelete activity deletes a directory and its subdirectories if specified
DirectoryGetNextFileInfoRecord
The DirectoryACLRemoveEntry activity removes an Access Control List (ACL) entry from a directory
DirectoryInitializeDirectoryInfoSource
The DirectoryACLRemoveEntry activity removes an Access Control List (ACL) entry from a directory
DirectoryInitializeFileInfoSource
The DirectoryACLRemoveEntry activity removes an Access Control List (ACL) entry from a directory
DirectoryMove
The DirectoryMove activity moves a directory from a source to a destination
DirectoryZip
The DirectoryZip activity zips a directory
DirGetNextDirInfoRecord
The DirGetNextDirInfoRecord activity loads the next record from the specified list of selected Directoryinfo
Base
CallWebService
The CallWebService activity calls a web service
CloseActivity
Closes the specified activity (including any open connections)
Delay
The Delay activity delays the execution of a workflow for a specified amount of time.
EndWorkflow
The EndWorkflow activity ends the current workflow
EvaluateCondition
Evaluates a condition and returns True or False
ExecuteConnectorActivity
Executes a special activity in a connector (not a basic activity contained in BaseData)
ExecuteWorkflow
Executes a workflow and optionally passes the required parameters to it.
ExecuteWorkflowActivity
The ExecuteWorkflowActivity action executes a workflow activity
PerformAction
Performs an action
ResetActivityResult
Resets the execution result of an activity
ResetLastResult
Resets the last execution result
SendEmail
Sends an emal
SetValues
The SetValues activity is used for setting values in the workflow
UpdateWorkflowState
This activity updates the State of the currently running instance of the workflow
WriteAuditLogsEntry
This activity is used for writing entries to the audit logs detail table. The Description and/or Message property is required
WriteLogEntry
This activity is used for writing entries to the log. Log entries can include Source and Target records/statistics, messages, errors, warnings, etc.
BaseData
ClearRecord
This activity clears the values in a specific record in memory. It does not clear the record from the data source.
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
CommitTransaction
Optional action to Commit a transaction on the Target and start a new transaction
DeleteRecord
Deletes the specified target record
ExecuteSQLScript
Executes a SQL Script on a data source (Dynamics365, Salesforce, MySQL, Oracle, etc.)
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
The GetNextRecord activity loads the next record from the specified Source
InitializeSource
Initializes a connection for reading data records at run time.
InitializeSourceFile
Initializes a Source for reading data records from a file
InitializeSourceList
Initializes a Source for reading data records from a file
InitializeTarget
Initializes a connection for saving output records.
InitializeTargetFile
Initializes a Target for writing data records to a file
LookupRecord
Loads a specific record from a source
MapAndSaveRecords
Maps and saves values to specified DataFields in a target connection
MapRecordFields
Maps values to specified DataFields in a target connection
RestartSource
Restarts a source by re-executing the query and re-reading the records using the GetNextRecord activity
RollbackTransaction
Optional action to Rollback a transaction on the Target and start a new transaction
SaveRecord
Saves the specified target record
BusinessRules
EvaluateConditions
Executes a group of conditions
EvaluateDecisionTable
Defines and executes a decision table
ExecuteRuleSet
Initializes and executes a rule set
PerformActions
Executes a group of actions
Cache
LoadSourceRecordsIntoCache
The LoadSourceRecordsIntoCache action loads source records into the cache. They can be retrieved using the LookupCachedRecord action
LookupCachedRecord
Loads a record from the cache
SaveCustomValueInCache
Saves a custom value in the cache
SaveKeyValueInCache
DataSource entity record keys are automatically saved in cache when that option is set. This action allows you to save a key in cache at any time and to retrieve it using the LookupCachedKeyValue action
SaveRecordInCache
Saves a record in cache
Custom
Composite
Executes selected defined or pre-defined actions in sequence
Expression
The Expression action executes a simple expression (javascript). The expression does NOT return a value
Function
Executes a .Net custom function and does NOT returns a value.
Script
The Script field action executes a script (javascript). The script does not return a value.
DataMigration
MigrateData
Migrates, replicates or synchronizes data from one or more source data sources to one or more target data sources
Dialogs
DisplayMessage
Displays a message
EditRecord
Displays data records for viewing and editing
EditWorkflowValues
The ViewRuntimeValues activity is used for viewing selected values at run time.
PromptForValue
Prompts the user for a value
ViewRuntimeRecords
Displays data records at runtime
ViewRuntimeStatistics
The ViewRuntimeStatistics activity is used for viewing DataManager statistics at run time
ViewRuntimeValues
The ViewRuntimeValues activity is used for viewing selected values at run time.