Salesforce-icon-color

Salesforce

Microsoft Dynamics 365 - Icon

Microsoft Dynamics 365

ServiceNow - Icon

ServiceNow

Zendesk Sell

Snowflake - Icon

Snowflake

Lever - Icon

Lever

SQL-Server

Microsoft SQL Server

AgileCRM-icon-color

Agile CRM

Firebase - Icon

Firebase

Aircall - Icon

Aircall

Redshift - Icon

Redshift

Reltio - Icon

Reltio

SalesforceIQ-icon-color

SalesforceIQ

Azure Blob Storage - Icon

Microsoft Azure Blob Storage

Mindbody - Icon

Mindbody

FreshService

Freshservice

PagerDuty - Full

PagerDuty

PostgreSQL-icon-color

PostgreSQL

IBMDB2-icon-color

IBM DB2

Pipedrive - Icon

Pipedrive

List datasets DDL

Create a new, empty table in the dataset.

Create table

Add or update one or more columns in a table in BigQuery via the API, so you don't have to create them manually. Useful when you're looking to ensure that a table matches a schema before running an "Insert Rows" operation.

Add or update columns in table

Delete the table specified by table_id from the dataset. If the table contains data, all the data will be deleted.

Delete table

Get job

Gets full details about a Google BigQuery table.

Get table

Insert job

Inserts up to 500 rows into a Google BigQuery table.

Insert rows

Uploads a CSV file to BigQuery, saves the rows into a table.

Insert rows from CSV file

List datasets

List job query results

List jobs

List jobs DDL

List all the projects you have in your Google BigQuery account.

List projects

List projects DDL

List tables

List tables DDL

Run query

MongoDB-Logo

How to integrate MongoDB

postgresql-logo

How to integrate PostgresSQL

aws redshift

How to integrate Amazon Redshift

flow-data-between-csv-and-your-stack-with-csv-processor blog post cover image

flow-data-between-csv-and-your-stack-with-csv-processor

Learn How to Automate Your CSV and Flat File Management

Connector Department - Developers - Cards

New Relic - Full - Dark

New Relic - Anonymous

Developers

Google BigQuery - Icon

Google BigQuery

Database

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)

Watch the demo CTA Item - Used in main nav

Navigation CTA - Get Started

Product - Experiences

Product - Capabilities

Product - Platform Features

See Pricing / see packages

TUAC Platform Menu Packaging CTA - Option B

Enabling your entire organization to deliver on the promise of automation

Universal Automation Cloud

logo - ibm

IBM gets 95% boost in data delivery and reporting using the Tray.io Universal Automation Cloud

Customer Spotlight

UAC Solutions - By Team

UAC Solutions - By Use Case

TUAC Solutions - by application column - view all connectors CTA

UAC Solutions - By Application

A strategic platform with solutions for mission critical use cases

Solutions

Tuac Solutions Customer Spotlight: mixpanel cta item

Tuac Solutions Customer Spotlight: mixpanel cta

Mixpanel - White - Full

Mixpanel accelerates mission-critical order-to-cash process by 25%

Resources - Learn & Evaluate

Resources - Success

Your journey to automation excellence starts here

Resources

Eventbrite accelerates high-quality integration delivery at scale and lifts customer satisfaction

Google BigQuery and SugarCRM integration + automation

Popular Google BigQuery and SugarCRM integrations

Google BigQuery and SugarCRM Connector Details

Google BigQuery

SugarCRM

Tray.io is the leader in low-code automation

Similar connectors to Google BigQuery and SugarCRM

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