Working with Variables

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.

Use the following steps to walk through
  1. Viewing variables
  2. Selecting and changing a variable

  1. Navigate to the Project’s Variables tab


  1. Modify the server time offsets to reflect the time differences of each server
  2. ServerTimeOffset-HubSpot – typically US Central time
  3. ServerTimeOffset-Creatio
  4. Connect Creatio's iPaaS is on US Central Time


  1. Change ClosedWon and ClosedLost Opportunity Type Ids if different from current selection


  1. Specify User Ids for each Connect Creatio user


  1. Specify the default sales representative for Creatio. This will be used to assign the Leads.


New variables can be created by selecting the New action at the upper left most part of the Variable grid.
    • Related Articles

    • Working with Cross References (Xref files)

      Working with Cross References (Xref files) Xref files servermany purposes. The most common case is as foreign key lookups. Another common case is to use Xrefs as pick list lookups. Tables can be created manually. They can be created by importing the ...
    • Working with MultiSelect Lists

      For this example we use SugarCRM, where MultiSelect fields are supplied as a JSON string, i.e. [{"value1","value2"} First, I check to make sure my origin value ('reg') and existing value in Sugar ('existing') are not empty, as either case is easy to ...
    • Active Directory Connector

      Origin There may be some trial and error with capitalization required to get this Origin working. For example, ldap:// vs LDAP:// or LDAP:// vs LDAP:// Parameter Description Access Key Connection String Active ...
    • Previewing Jobs

      Before running a job for the first time, you can check to make sure all your formulas and translations are working correctly by stepping through each row on the Preview tab. No data will be modified in your destination system, and you may click Log ...
    • Parse XML

      First I add code and External Assemblies to the .NET GLobal section of the Mapping tab: using System; using System.Collections.Generic; using System.Xml; XmlDocument demographicsXML = new XmlDocument(); XmlNodeList nodes; External Assemblies: ...