JUMP TO SECTION

• Accessing the Integrations Platform
• Core Integration Concepts
• What is a Connector?
• What is a Connection?
• Creating Projects
• Creating Connections
• What is a Recipe?
• Triggers
• Actions
• Building Recipes
• Best Practices for TrackVia Views
• What are Jobs?
• Recipe Versioning

Overview

TrackVia Integrations, powered by Workato, allows organizations to connect TrackVia with external systems using a low-code, drag-and-drop integration platform.

With Workato, you can automate business processes and synchronize data between TrackVia and thousands of other systems without writing custom integration code.

Common integration scenarios include:

• Syncing TrackVia records with Salesforce
• Creating documents with Formstack
• Sending TrackVia notifications to Slack
• Creating Outlook calendar events from TrackVia workflows
• Updating Google Sheets automatically from TrackVia data
• Integrating with ERP, HRIS, and accounting platforms

This article introduces the core concepts of the integrations platform and explains how integrations are structured within Workato.

Accessing the Integrations Platform

Requirements

To access TrackVia Integrations:

• You must be a TrackVia Super Admin
• The Integrations feature must be enabled for your account

If the feature is not enabled, contact your Account Manager or Customer Success Manager.

How to Access Workato from TrackVia

1. Log into TrackVia
2. Open the profile menu in the upper-right corner
   
    
3. Select the “Integrations” option from the menu drop down list
   
    
4. Click Take me to TrackVia Integrations
   

A new browser tab will open and automatically sign you into the integrations platform, and the menu options will appear on the upper lefthand side of the screen. Hover over the options to expand them.

Core Integration Concepts

Before building integrations, it is important to understand the foundational concepts used throughout Workato.

The primary concepts include:

• Connectors
• Connections
• Recipes
• Triggers
• Actions
• Jobs
• Recipe Versions

Each concept plays a specific role in how integrations are configured and executed.

What Is a Connector?

A connector allows Workato to communicate with a specific application or system.

Each external system requires its own connector.

Examples include:

• TrackVia
• Salesforce
• Slack
• Google Sheets
• Microsoft Outlook

Connectors define:

• Authentication methods
• Available triggers
• Available actions
• Data operations supported by the system

Example

If you want to:

• Create a Salesforce record whenever a TrackVia record is created

You would use:

• The TrackVia connector
• The Salesforce connector

If you also wanted to send a Slack message, you would additionally use:

• The Slack connector

Available Connectors

Workato provides thousands of prebuilt connectors.

To browse available connectors:

1. Open the Community Library
   
2. Use the search bar to locate a connector
   

What If a Connector Does Not Exist?

If a prebuilt connector is unavailable, integrations may still be possible using:

• HTTP APIs
• SQL connections
• SFTP connections
• Connector SDKs

Most modern systems with REST APIs can be integrated through Workato.

What Is a Connection?

A connection is the authentication relationship between Workato and another system.

Before a connector can be used, Workato must first authenticate into that system.

Examples include:

• Logging into TrackVia
• Using an API Key and Auth Token
• Signing into Google
• Authenticating into Salesforce

Connections securely store credentials and permissions needed to execute integrations.

Creating Projects

Projects help organize integration assets.

Best practice is to create a separate project for each integration area or business process.

Example Projects

• Google Sheets Integrations
• Salesforce Syncs
• HR Integrations
• ERP Automation

Creating a Project

1. Click the + button to the right of the “Search projects and folders” search bar
   
2. Enter a project name
3. Save the project

Creating Connections

Steps

1. Open a project
2. Click the “Create” menu in the upper-right corner
   
3. Select Connection from the drop down list
   
4. Search for the application using the “Search for an app” search bar
   
5. Select the connector
6. Authenticate into the system

Once connected, the connection becomes available for use within recipes.

What Is a Recipe?

A recipe is the automation workflow that defines how systems interact.

Recipes consist of:

• One trigger
• One or more actions

Triggers

A trigger defines when the recipe runs.

Examples include:

• A new TrackVia record is added to a view
• A Salesforce opportunity is updated
• A spreadsheet row changes
• A scheduled time occurs

Each recipe has exactly one trigger.

Actions

Actions define what the recipe does after it is triggered.

Examples include:

• Create a TrackVia record
• Update a Salesforce opportunity
• Send a Slack message
• Add a Google Sheets row
• Create an Outlook calendar event

Recipes may contain multiple actions.

Example Recipe Flow

Trigger

New record added to a view in TrackVia

Actions

1. Add row to Google Sheets
2. Send Slack notification
3. Create Salesforce record

Building Recipes

Creating a Recipe

1. Open a project
2. Click Create in the upper right corner of the screen
   
3. Select “Recipe” from the drop down list of options
4. Name the recipe
5. Select the trigger type
6. Configure the trigger
7. Add actions
8. Save the recipe

Using TrackVia as a Trigger

The TrackVia connector supports triggers such as:

• New Record
• Updated Record
• Deleted Record

These triggers monitor a selected TrackVia view.

Example

Trigger when:

• A new product is added to a view

Action:

• Add the product to Google Sheets

Using TrackVia as an Action

TrackVia can also act as the destination system within recipes.

Common TrackVia actions include:

• Create Record
• Update Record
• Delete Record
• Create User
• Get all view records

Important Note About Record IDs

When updating TrackVia records through Workato:

• Use the internal primary key (i.e. ID)
• Do NOT use the visible Record ID field

These are different values.

Best Practices for TrackVia Views

Avoid using default views for integrations whenever possible.

Default views often include unnecessary fields and can negatively impact performance.

Instead:

• Create integration-specific views
• Include only required fields
• Optimize filters and sorting

This improves recipe speed and reliability.

Testing Recipes

Recipes can be tested before activation.

Testing Workflow

1. Click Test
2. Trigger the event manually
3. Verify recipe execution
4. Review output data
5. Confirm downstream updates

Testing helps validate:

• Field mappings
• Authentication
• Logic
• Error handling

Activating Recipes

Once testing is complete:

1. Save the recipe
2. Exit the editor
3. Click Start Recipe

The recipe will begin running in the live environment.

What Are Jobs?

A job is a single execution instance of a recipe.

Each time a recipe runs, a job is created.

Job History

Workato stores historical job information for troubleshooting and monitoring.

Job details include:

• Execution time
• Success or failure status
• Runtime duration
• Trigger data
• Action outputs
• Error messages

Repeat Failed Jobs

If a job fails:

1. Diagnose the issue
2. Apply the fix
3. Repeat the failed job

Repeat allows integrations to recover without losing transactions. 
👀NOTE: If you attempt to repeat the failed job but the triggering record is no longer included in the triggering view, it will not work.

Recipe Versioning

Recipes maintain version history automatically.

Whenever a recipe is modified:

• A new version is created
• Previous versions remain accessible

Benefits of Versioning

Versioning allows teams to:

• Audit recipe changes
• Restore prior configurations
• Troubleshoot regressions
• Safely test updates

Restoring Previous Versions

To restore a prior recipe version:

1. Stop the recipe
2. Open the Versions tab
3. Select the desired version
4. Click Restore This Version
5. Restart the recipe