Salesforce-icon-color

Salesforce

Microsoft Dynamics 365 - Icon

Microsoft Dynamics 365

ServiceNow - Icon

ServiceNow

Zendesk Sell

LogicMonitor

Lever - Icon

Lever

Kazoo HR

Lodash-icon-color

Lodash

LiveRamp - Icon

LiveRamp

LeafLink - Icon

LeafLink

AgileCRM-icon-color

Agile CRM

Absorb

Aircall - Icon

Aircall

Kanban Tool

Affinity - Icon

Affinity

aeries

Aeries

Sailthru - Icon

Sailthru

Grafana

SalesforceIQ-icon-color

SalesforceIQ

Postmates-icon-color

Postmates

Removes a relationship based on 'LHS (left-hand side) sync_key' and 'RHS (right-hand side) sync_key'. If both the LHS and RHS records can be found with the sync_keys, and those records are related, then remove the relationship of the RHS record to the LHS record.

Delete relationship by sync_key field

List link names DDL

List records

List modules DDL

Run a sequence of API requests in one query. The requests are executed sequentially and their results are returned as one response.

Bulk request

Count the number of Accounts in your SugarCRM account. Optionally apply filters to count only specific records.

Count accounts

Count the number of Contacts in your SugarCRM account. Optionally apply filters to count only specific records.

Count contacts

Count the number of Employees in your SugarCRM account. Optionally apply filters to count only specific records.

Count employees

Count the number of Opportunities in your SugarCRM account. Optionally apply filters to count only specific records.

Count opportunities

Creates an email in your SugarCRM account.

Create email

Creates a new email address in your SugarCRM account.

Create email address

Create a new lead in your SugarCRM account.

Create lead

Upserts based on 'sync_key field'. It updates a record if it can be found by the 'sync_key field'. If the record does not exist, then creates it.

Create or update record by sync_key field

Create record

Create a relationship to a pre-existing record.

Create relationship

Creates a relationship based on 'LHS (left-hand side) sync_key field' and 'RHS (right-hand side) sync_key field'. If both the LHS and RHS records can be found with the respective sync_keys, then relate the RHS record to the LHS record.

Create relationship by sync_key fields

Delete record

Deletes the record with the given sync_key value

Delete record by sync_key field

Delete an existing relationship between two records.

Delete relationship

Retrieve the count of records that have been filtered.

Get filtered records count

Retrieve a list of related records by filter.

Get filtered related records count

Get record

Retrieves the record with the given sync_key value.

Get record by sync_key field

Retrieve a related record with relationship role information.

Get related record

Link call to contacts

List filtered related records

Retrieve a list of application labels for a specific language.

List labels by language

List link fields DDL

List link sync key fields DDL

List module fields DDL

Retrieve a list of recipients that match the search term.

List recipients

List records DDL

List related records

List sync key fields DDL

Perform a raw HTTP request with some pre-configuration and processing by the connector, such as authentication.

Raw HTTP request (advanced)

Updates an email in your SugarCRM account. Used for updating an archived email, updating a draft to send later, or sending a draft.

Update email

Update record

Update record sync_key

Upload file

LEAD-LIFECYCLE

How to Automate Lead-to-Account Matching

hot-topics-blog-header-3@2x

Streamline strategic sales with an automated deal desk

sales marketing mix

Sales ops best practices

pipedrive-color-logo

Pipedrive's CRM integrates with the Tray Platform to provide full visibility for sales activities and connect them to all other components of the sales & marketing stack.

Intercom - Card

Intercom unlocks new efficiencies with sales automation

Quickly operationalize outbound strategy by auto-uploading accounts + leads to your CRM

Connector Department - Sales - Cards

Udemy - Full - Dark

Udemy - Anonymous

Sales

Tray-IO Blog 6

The ultimate guide to automating the entire lead lifecycle

The State of Marketing technology eBook by Tray.io

tray-aberdeen-report-marketing-tech

Aberdeen Report: Marketing technology—controlling the chaos

BLOG - Hot Topic

Personalization is shifting from email to omni-channel. Are you ready?

Automating Lead List Uploads: Mission-Critical, and Much Easier than You Think

Jellyvision - Card

Jellyvision improves lead response speed, conversions, and win rate with automation

segment-color-logo

Segment uses Tray Platform to unlock insights synced with every component of enterprise stack.

Connector Department - Marketing - Cards

DigitalOcean - Full - Dark

David Dorman of Digital Ocean works with Tray.io

David Dorman - DigitalOcean

DigitalOcean - David Dorman

Marketing

SugarCRM - Icon

SugarCRM

Customer Relationship Management (CRM)

Delete all rows that match a specific filter.

Delete Rows By Filter

Delete Rows

Delete column

Delete columns

Export an in memory CSV data into a plain text file using a template configuration

Export File

Export an in memory CSV into a JSON file for persistence and use elsewhere.

Export JSON

Find rows in the table that match a specific filter.

Find Rows By Filter

Change the characters (such as delimiter and escape character) used in a CSV. This operation may be required for CSVs with embedded new lines and quote character in cell values.

Format CSV

Generate a list of column descriptions from a JSON object (ignoring nested arrays and objects), and provide optional column type definitions to change the types of some fields.

Generate columns from object

Return all columns from single row in the CSV.

Get Row

Return the number of rows that are available in an in memory CSV.  This doesn't take into account content.

Get Row Count

Return all columns from a number of rows from in the CSV.

Get Rows

Return a single column from a number of rows from in the CSV.

Get column from rows

Delete a specific CSV created in Current Run and Account scope.

Delete a CSV

Update a single column in multiple rows using a function

Update by Function

Add Rows

Parse Text

Sort CSV

Update Cell

Create a temporary CSV for use within the current workflow execution from an existing file. You can perform operations on this CSV within a single workflow execution, but will need to export the CSV at the end otherwise it will be deleted.

Create CSV From File

Create a temporary CSV for use within the current workflow execution from an existing XLSX file. You can perform operations on this CSV within a single workflow execution, but will need to export the CSV at the end otherwise it will be deleted.

Create CSV From XLSX File

Add Column

Export an in memory CSV into a file for persistence and use elsewhere.

Export CSV

Rename Column

Create a temporary CSV for use within the current workflow execution.  You can perform operations on this CSV within a single workflow execution, but will need to export the CSV at the end otherwise it will be deleted.

Create CSV

Duplicate

Return the number of columns that are available in an in memory CSV.

Get Column Count

Import an external CSV file into an existing in memory CSV

Import Data

Duplicate Column

Return the data in a specifc cell in the CSV.

Get Cell

Create a temporary CSV for use within the current workflow execution from an existing XML file. You can perform operations on this CSV within a single workflow execution, but will need to export the CSV at the end otherwise it will be deleted.

Create CSV From XML File

Add Row

Join two CSVs together based on a common field, using a left, inner or outer join. Indexes will automatically be created on for the columns chosen.

SugarCRM and CSV integration + automation

Popular SugarCRM and CSV integrations

SugarCRM and CSV Connector Details

SugarCRM

CSV

Tray.io is the leader in low-code automation

Similar connectors to SugarCRM and CSV

Try Tray today and see for yourself. No strings attached.