Job Scripting Examples
Check for duplicates using xref
I needed to check for duplicate attachments in a system and remove the duplicates. I created a Job that used the same origin and destination and pulled all records from the Attachments table. I had a before operation that would read and write to the ...
Interact with the local file system
Read files from a folder Function ScriptedVariable Dim fso, folder, files, sFolder, res Set fso = CreateObject("Scripting.FileSystemObject") sFolder = "C:\Results" Set folder = fso.GetFolder(sFolder) Set files = folder.Files For each folderIdx In ...
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 ...
Retrieve Records Modified After Last Run DateTime
To only run data modified after the last time Connect Creatio was run, we need to do two things: Set the last time Connect Creatio ran. Filter the origin based on the last time Connect Creatio ran. Set Last Run DateTime Create an After Operation ...
Use Before Save and After Save operations to loop through a single origin record multiple times
There are many reasons why you might want to loop through a single origin row multiple times. In Act for example, the contact record may contain an Account and one or more Contacts. Another example would be a Note that needs to be related to multiple ...
Use the same job to loop through multiple origins
This example looks at reading from multiple mailboxes for email. Use a variable in the origin connection string. If the job needs to run for another mailbox, it calls the GotoJob function in the “Once After Conn” and pass in the Job's ID. Similar ...
Using Row Hashing for Incremental Integrations
Hashing The Whole Record Typically when setting up an ongoing integration, we only want to pull data from your origin which has changed since the last time Connect Creatio ran. This is accomplished using LastRunDate and applying it as a filter ...