Action Types

The action type defines what type of operation will be performed. Variable-type actions create a user-defined variable for use throughout the job.

Action Type	Description
Variable/SQL	Set a variable through the execution of a SQL SELECT statement run against the Destination database. Set the variable value equal to the first column of the first row returned by the statement.
Variable/VBScript	Set a variable through the execution of a custom VBScript function. A shell function is provided called “ScriptedVariable”, the value of the variable will be what is returned out of the function.
Variable/C#	Set a variable through the execution of a custom C# function. A shell function is provided called “ScriptedVariable()”, the value of the variable will be what is returned out of the function.
Variable/JavaScript	Set a variable through the execution of a custom JavaScript function. A shell function is provided called “scriptedVariable()”, the value of the variable will be what is returned out of the function.
Execute SQL	Execute any kind of statement against the Destination database. Useful for calling DELETE or UPDATE statements before or after a job for cleanup purposes.
VBScript Procedure	Execute any statements desired in a VBScript Sub. A shell sub called “VBScriptProcedure” is provided. Any kind of VBScript processing can be called here. Useful for before-job file manipulation, or any kind of pre- or post-processing.
C# Procedure	Execute any statements desired in a C# Sub. A shell sub called “ CSharpProcedure()” is provided. Any kind of C# processing can be called here. Useful for before-job file manipulation, or any kind of pre- or post-processing.
JavaScript Procedure	Execute any statements desired in a JavaScript Sub. A shell sub called “jsProcedure()” is provided. Any kind of JavaScript processing can be called here. Useful for before-job file manipulation, or any kind of pre- or post-processing.
Xref Write	​Writes to the selected Xref List given the provided old ID and new ID.

• Related Articles

• Table of Contents

  General Help Frequently Asked Questions Projects Renaming, Copying and Deleting Projects Renaming, Copying and Deleting Jobs Creating a Project Creating a New Job Jobs Create a New Job Renaming, Copying and Deleting Jobs Scheduling Jobs (IN PROGRESS) ...

• Executing Pre/Post-Process Operations

  Any number of functional operations can be performed before or after a job is processed. To set up the operations, first navigate to job within the project you wish to add the operations to. Once you have selected a job navigate to the mappings tab. ...

• Scripting Class Object

  From within VBScript operations (ScriptedVariable, VBScriptProcedure, ScriptedField) in additional to normal VBScript functions, the developer has access to a custom “Connect Creatio” class. The tables below define its usage. This class may also be ...

• Pull data from a source and write to file

  With this map, I wanted to pull all accounts from a Sugar instance and dump a few fields into a pipe delineated file. In this map I used the same Sugar instance as both the Origin and Destination. There were no Stages created, so no action was taken ...

• Working with Variables

  Variables can be used to store configurable information used by jobs and scripts. In the example below, several Variables have been defined. cc Use the following steps to walk through Viewing variables Selecting and changing a variable Navigate to ...