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...
Loading...
Loading...
appRules Actions deliver a centralized and consistent approach for performing actions in all operations. The Actions Editor is shown below:
To select an Action type, simply navigate the action tree and configure the properties for the selected type. Once an action is created, it can be executed at any point in the running project by using the PerformAction activity in the BaseActivities module or through other built-in access points in appRules (SetValues, MapRecordfields...).
| AdobeAnalytics | CloseSource | The CloseAdobeAnalyticsSource activity closes the specified source connection |
|---|---|---|
| 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 |
|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
| Module | Type | Description |
|---|
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
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
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
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
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
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
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
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)
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
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
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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) |
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 |
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|---|---|
| Module | Type | Description |
|---|---|---|
The Execution action category contains the following actions in the modules shown below:
| 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 |
|---|---|---|
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 |
|---|
The Utility-FileSystem actions category includes the following modules and types:
| Module | Type | Description |
|---|
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
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
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
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.
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
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
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
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
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.
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
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. |
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 |