All pages
Powered by GitBook
1 of 37

Action Categories

Actions-DataSource

Accounting

Module
Type
Description

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

AIMachineLearning

Module
Type
Description

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

Analytics

AdobeAnalytics
CloseSource
The CloseAdobeAnalyticsSource activity closes the specified source connection

GetNextRecord

The GetNextAdobeAnalyticsRecord activity fetches the next record from the specified source connection

InitializeSource

Initializes a connection for reading data records at run time.

LookupRecord

The LookupAdobeAnalyticsRecord activity fetches a specific record from a source connection

AzureAnalysisServices

CloseSource

The CloseSource activity closes the specified source connection

GetNextRecord

The GetNextRecord activity fetches the next record from the specified source connection

InitializeSource

Initializes a connection for reading data records at run time.

LookupRecord

The LookupRecord activity fetches a specific record from a source connection

GoogleAnalytics

CloseSource

The CloseGoogleAnalyticsSource activity closes the specified source connection

GetNextRecord

The GetNextGoogleAnalyticsRecord activity fetches the next record from the specified source connection

InitializeSource

Initializes a connection for reading data records at run time.

LookupRecord

The LookupGoogleAnalyticsRecord activity fetches a specific record from a source connection

SAS

CloseSource

Closes the specified source connection

GetNextRecord

Gets the next record from the specified source connection

InitializeSource

Initializes a connection for reading data records at run time.

LookupRecord

Loads a specific record from a source connection

YouTubeAnalytics

CloseSource

The CloseYouTubeAnalyticsSource activity closes the specified source connection

GetNextRecord

The GetNextYouTubeAnalyticsRecord activity fetches the next record from the specified source connection

InitializeSource

Initializes a connection for reading data records at run time.

LookupRecord

The LookupYouTubeAnalyticsRecord activity fetches a specific record from a source connection

ApplicationPlatforms

Module
Type
Description

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

BigData

Module
Type
Description

ApacheHBase

CloseSource

Closes the specified source connection

GetNextRecord

Fetches the next record from the specified source connection

InitializeSource

Initializes a source for reading data records

LookupRecord

Fetches a specific record from a source connection

ApacheHive

CloseSource

Closes the specified source connection

GetNextRecord

Fetches the next record from the specified source connection

InitializeSource

Initializes a source for reading data records

LookupRecord

Fetches a specific record from a source connection

Greenplum

CloseSource

The CloseSource activity closes the specified source connection

CloseTarget

Closes the specified target connection

DeleteRecord

Deletes the specified target record

ExecuteStatements

Executes custom SQL statements on a connection

GetNextRecord

The GetNextRecord activity fetches the next record from the specified source connection

InitializeSource

Initializes a connection for reading data records at run time.

InitializeTarget

Initializes a connection where output records will be saved.

LookupRecord

The LookupGreenplumRecord activity fetches a specific record from a source connection

MapRecordFields

Sets the values of the specified DataFields in a target connection

SaveRecord

Saves the specified target record

HPCC

CloseSource

The CloseSource activity closes the specified source connection

GetNextRecord

The GetNextRecord activity fetches the next record from the specified source connection

InitializeSource

Initializes a connection for reading data records at run time.

LookupRecord

The LookupHPCCRecord activity fetches a specific record from a source connection

SparkSQL

CloseSource

The CloseSource activity closes the specified source connection

GetNextRecord

The GetNextRecord activity fetches the next record from the specified source connection

InitializeSource

Initializes a connection for reading data records at run time.

LookupRecord

The LookupSparkSQLRecord activity fetches a specific record from a source connection

CalendarsAndContactMgrs

Module
Type
Description

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

CloudStorage

Module
Type
Description

AmazonS3

CloseSource

Closes the specified source connection

CloseTarget

Closes the specified target connection

CopyObject

Copies an object from one bucket to another

DownloadObjects

Downloads objects

DownloadObjectTorrent

Uses the BitTorrent protocol to retrieve any publicly-accessible objects

GetNextRecord

Fetches the next record from the specified source connection

InitializeSource

Initializes a connection for reading data records at run time.

InitializeTarget

Initializes a connection where output records will be saved.

LookupRecord

Fetches a specific record from a source connection

UploadObject

Uploads objects in a single operation

AzureTables

CloseSource

Closes the specified source connection

CloseTarget

Closes the specified target connection

CreateEntityWithTypes

Creates a new record with the given data types. If a column is not found on an existing entity, you will need to use this procedure to set the type of the property to something other than string.

CreateSchema

Creates a schema file for the specified table or view

CreateTable

Creates a new table in the Azure system

DropTable

Drops an existing table in the Azure system

GetNextRecord

Fetches the next record from the specified source connection

InitializeSource

Initializes a connection for reading data records at run time.

InitializeTarget

Initializes a connection where output records will be saved.

LookupRecord

Fetches a specific record from a source connection

MapRecordFields

Sets the values of the specified DataFields in a target connection

SaveRecord

Saves the specified target record

IBMCloudObjectStorage

CloseSource

Closes the specified source connection

CloseTarget

Closes the specified target connection

CopyObject

Copies an object from one bucket to another

DeleteRecord

Deletes the specified target record

DownloadObject

Downloads and object

GetNextRecord

Fetches the next record from the specified source connection

InitializeSource

Initializes a connection for reading data records at run time.

InitializeTarget

Initializes a connection where output records will be saved.

LookupRecord

Fetches a specific record from a source connection

MapRecordFields

Sets the values of the specified DataFields in a target connection

SaveRecord

Saves the specified target record

UploadObject

Uploads an object

Wasabi

CloseSource

Closes the specified source connection

CloseTarget

Closes the specified target connection

CopyObject

Copies an object from one bucket to another

DownloadObjects

Downloads objects

GetNextRecord

Fetches the next record from the specified source connection

InitializeSource

Initializes a connection for reading data records at run time.

InitializeTarget

Initializes a connection where output records will be saved.

LookupRecord

Fetches a specific record from a source connection

UploadMultipleObjects

Uploads a single object as a set of parts

UploadObject

Uploads objects in a single operation

Collaboration

Module
Type
Description

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

CRM

Module
Type
Description

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)

CustomerService

Module
Type
Description

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

Databases

Module
Type
Description

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

DataWarehouse

Module
Type
Description

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

ECommercePlatforms

Module
Type
Description

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

EmailSystems

Module
Type
Description

Email

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

ERP

Module
Type
Description

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)

ExpenseManagement

Module
Type
Description

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

Files

Module
Type
Description

CSVDatabase

CloseSource

Closes the specified source connection

CloseTarget

Closes the specified target connection

DeleteRecord

Deletes the specified target record

ExecuteStatements

Executes custom SQL statements on a connection

GetNextRecord

Fetches the next record from the specified source connection

InitializeSource

Initializes a connection for reading data records at run time.

InitializeTarget

Initializes a connection where output records will be saved.

LookupRecord

Fetches a specific record from a source connection

MapRecordFields

Sets the values of the specified DataFields in a target connection

SaveRecord

Saves the specified target record

DelimitedFile

AppendFile

Appends the contents of one file to another

CloseSourceFile

Closes the specified Source data source

CloseTargetFile

Closes the specified target delimited file

CopyFileRecords

Copies specific records from one file to another

CreateFileFromSource

Creates a delimited file from a Source

DeleteFile

Deletes the specified file

GetNextFileRecord

Fetches the next record from the specified delimited Source file

InitializeSourceFile

Initializes a Source for reading data records from a delimited file

InitializeTargetFile

Initializes a Target for writing data records to a delimited file

MapRecordFields

Sets the values of the specified DataFields in a target delimited file

SaveValueInNewFile

Saves a field value to a file

SplitFile

Splits a large delimited file into multiple files

WriteTargetFileRecord

Inserts a record into the specified delimited file

FileSystem

DirACLAddEntry

The DirectoryAddACLEntry activity adds an Access Control List (ACL) entry to a directory

DirACLRemoveEntry

The DirectoryACLRemoveEntry activity removes an Access Control List (ACL) entry from a directory

DirCloseDirInfoSource

The DirectoryCloseDirectoryInfoSource activity closes the Directoryinfo source and frees up resources

DirCloseFileInfoSource

The CloseSourceFileFile activity closes the DirectoryFileInfo source and frees up resources

DirectoryCreate

The DirectoryCreate activity creates all the directories and subdirectories in the specified path

DirectoryDelete

The DirectoryDelete activity deletes a directory and its subdirectories if specified

DirectoryMove

The DirectoryMove activity moves a directory from a source to a destination

DirectoryZip

The DirectoryZip activity zips a directory

DirGetNextDirInfoRecord

The DirGetNextDirInfoRecord activity loads the next record from the specified list of selected Directoryinfo

DirGetNextFileInfoRecord

The DirectoryGetNextFileInfoRecord activity loads the next record from the specified list of selected fileinfo

DirInitializeDirInfoSource

The DirectoryInitializeDirectoryInfoSource activity initializes a list of directory information that can be accessed sequentially using the GetNextDirectoryInfoRecord

DirInitializeFileInfoSource

The DirectoryInitializeFileInfoSource activity initializes a list of file information that can be accessed sequentially using the GetNextFileInfoRecord

FileACLAddEntry

The FileACLAddEntry activity adds an Access Control List (ACL) entry to a file

FileACLRemoveEntry

The FileACLRemoveEntry activity removes Access Control List (ACL) entry from a file

FileCopy

Copies files from one location to another

FileDelete

The FileDelete activity deletes a file

FileFTPDownload

The FileFTPDownload activity downloads a file from an ftp site

FileFTPUpload

The FileFTPUpload activity uploads a file from an ftp site

FileMove

Moves a file from a source to a destination

FileUnzip

The FileZip activity unzips a file

FileZip

The FileZip activity zips a file

SaveValueInNewFile

The SaveValueInNewFile activity is used for saving field values to a file

FixedLengthFile

AppendFile

Appends the contents of one file to another

CloseSourceFile

Closes the specified Source file data source

CloseTargetFile

Closes the specified target file

CopyFileRecords

Copies specific records from one file to another

DeleteFile

Deletes the specified file

GetNextFileRecord

Fetches the next record from the specified Source file data source

InitializeSourceFile

Initializes a Source for reading data records from a fixed length file

InitializeTargetFile

Initializes a Target for writing data records to a fixed length text file

MapRecordFields

Sets the values of the specified DataFields in a Target data source

SaveValueInNewFile

The SaveValueInNewFile activity is used for saving a field value to a file

SplitFile

Splits a large delimited file into multiple files

WriteTargetFileRecord

Inserts a record into the specified text file

Financial

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

Marketing

Module
Type
Description

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

Miscelleanous

Module
Type
Description

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

NoSQL

Module
Type
Description

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

PaymentProcessing

Module
Type
Description

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

PLM

Module
Type
Description

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

ProjectManagement

Module
Type
Description

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

Search

Module
Type
Description

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

Services

Module
Type
Description

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

ShippingAndMailing

Module
Type
Description

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

Social

Module
Type
Description

Facebook

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

Instagram

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

LinkedIn

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

Twitter

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

Spreadsheets

Module
Type
Description

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

Actions-Execution

The Execution action category contains the following actions in the modules shown below:

Module
Type
Description

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.

Actions-Fields-Field

The Fields-Field actions are grouped in the modules shown below:

Module
Type
Description

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.

Actions-Fields-Library-Financial

The Actions-Fields-Library-Financial module which is filled with Microsoft Excel compatible functions contains the following types:

Type
Description

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.

Actions-Fields-Library-Math

The Actions-Fields-Library-Math module contains the following types:

Type
Description

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.

Actions-Utility-Automation

The Utility-Automation actions category includes the following modules and types:

Module
Type
Description

Maintenance

PurgeLogEntries

The PurgeLogEntries activity is used for purging log entries from the project database

RefreshDataSource

This activity refreshes the metadata for a data source

RemoveDataSource

This activity removes the metadata for a data source

UnlockProjectRecords

This activity unlocks project records

Services

RunPowerShellScript

The RunPowerShellScript activity runs a PowerShell script

RunSSISPackage

The RunSSISPackage activity runs an SSIS package

StartService

The StartService activity starts a service on a server

StopService

The StopService activity stops a service running on a server

Actions-Utility-FileSystem

The Utility-FileSystem actions category includes the following modules and types:

Module
Type
Description

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