Salesforce Pardot - Icon

Salesforce Pardot

HubSpot - Icon

HubSpot

Klaviyo - Icon

Klaviyo

Listrak - Icon

Listrak

Salesforce Marketing Cloud - Icon

Salesforce Marketing Cloud

ActiveCampaign-icon-color

ActiveCampaign

Act-On - Icon

Act-On

Redshift - Icon

Redshift

Acoustic Campaign - Icon

Acoustic Campaign

SQL-Server

Microsoft SQL Server

Reltio - Icon

Reltio

Remarkety - Icon

Remarkety

Google BigQuery - Icon

Google BigQuery

Firebase - Icon

Firebase

Marketo - Icon

Marketo

MailChimp

Mailchimp

FreshService

Freshservice

PagerDuty - Full

PagerDuty

Azure Blob Storage - Icon

Microsoft Azure Blob Storage

Databricks - Icon

Databricks

Get campaign object fields DDL

Create or merge a contact by looking for an existing contact with a matching unique field and merges supplied data with existing data. If no unique field is supplied or if no existing contact has a matching unique field field, a new contact will be created. Recommended to avoid unwanted duplicate mailings. While merging on the unique_id field is supported, merging on the id field is not, and may cause unintended consequences.

Create or merge a contact

Get contact object fields DDL

Get a list of Contacts using various search parameters.

List contacts

Retrieve the IDs of contact objects or custom objects by their email field.

Get object IDs by email

Retrieve the meta data for the contact object.

Get contact object metadata

Get group object fields DDL

Get specific campaign info

List campaigns DDL

Get tag object fields DDL

List all fields DDL

Get a list of Campaigns using various search parameters.

List campaigns

List contacts DDL

Retrieves information about the fields and sections an object has. If a section name is passed, only the fields in that section will be returned. If a field name is passed, only that field information will be returned. By default, this endpoint returns all sections and fields for a specified object.

List fields and sections in object

Get a list of Groups using various search parameters.

List groups

List groups DDL

List the field meta data for the specified object.

List object types

List object types DDL

List objects based on given parameters. The conditions parameter will only succeed if no object IDs are given.

List objects

List objects DDL

List sections DDL

List sequences

List sequences DDL

Get a list of Tags using various search parameters.

List tags

List tags DDL

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

Raw HTTP request (advanced)

Subscribe one or more objects to one or more campaigns or sequences.

Subscribe object to campaign or sequence

Update fields and sections in an object record. The section MUST exist in order to update it. Any fields that do not already exist will be created.

Update fields and sections in object

Update an existing object with given data

Update object data

Ontraport 1

Integrations

Low-code + flexible Ontraport integrations

Ontraport 2

Automation

Ontraport automation for any use case

Ontraport 3

Use cases

Sales and marketing automation at scale

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?

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

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

Ontraport

Marketing Automation Platform (MAP)

Custom query

Create a new named internal or external stage to use for loading data from files into Snowflake tables and unloading data from tables into files.

Create stage

List table columns DDL

Modifies the properties for an existing schema, including renaming the schema or swapping it with another schema, and changing the Time Travel data retention period (if you are using Snowflake Enterprise Edition or higher).

Update schema

Modifies the properties for an existing named internal or external stage.

Update stage

Modifies the properties, columns, or constraints for an existing table.

Update table

Suspends or resumes a virtual warehouse, or aborts all queries (and other SQL statements) for a warehouse. Can also be used to rename or set/unset the properties for a warehouse.

Update warehouse

Unload data from a table (or query) into one or more files in a named internal stage, a named external stage or an external stage.

Unload data from table

This operation can be used to query Snowflake data loading history along various dimensions within the last 7 days.

List copy history

Create database

Create schema

Create table

Creates a new virtual warehouse in the system. Creating a warehouse includes specifying its size. Initial creation of a warehouse may take some time to provision the servers, unless the warehouse is set to be created initially in a SUSPENDED state.

Create warehouse

Delete database

Removes files that have been staged (i.e. uploaded from a local file system or unloaded from a table)

Delete files from stage

Delete rows from the target table using optional query and additional (non-target) tables.

Delete rows from table

Delete a schema from the current or specified database.

Delete schema

Removes the specified named internal or external stage from the current/specified schema. The status of the files in the stage depends on the stage type.

Delete stage

Delete a table from the current or specified schema.

Delete table

Removes the specified virtual warehouse from the system.

Delete warehouse

Updates a table by inserting one or more rows into the table.

Insert rows in table

Lists the databases for which you have access privileges, including the dropped databases that are still within the Time Travel retention period.

List databases

List files in stage

Lists the schemas for which you have access privileges, including the dropped schemas that are still within the Time Travel retention period.

List schemas

Lists the stages for which you have access privileges.

List stages

List table rows

Lists the tables for which you have access privileges, including the dropped tables that are still within the Time Travel retention period.

List tables

Lists the warehouses for which you have access privileges.

List warehouses

Load data from staged files to an existing table. The files must already be staged.

Load data to table

Modifies the properties for an existing database, including changing the name of the database and changing the Time Travel data retention period (if you are using Snowflake Enterprise Edition or higher).

Update database

Updates specified rows in the target table with new values.

Update row in table

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

Snowflake - Icon

Snowflake

Database

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

Ontraport and Snowflake integration + automation

Popular Ontraport and Snowflake integrations

Ontraport and Snowflake Connector Details

Ontraport

Snowflake

Tray.io is the leader in low-code automation

Similar connectors to Ontraport and Snowflake

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