Microsoft PowerBI - Icon

Microsoft Power BI

LogicMonitor

Kazoo HR

LiveRamp - Icon

LiveRamp

Lodash-icon-color

Lodash

LeafLink - Icon

LeafLink

Qlik - Icon

Qlik

Absorb

Affinity - Icon

Affinity

aeries

Aeries

Grafana

Sailthru - Icon

Sailthru

Kanban Tool

Postmates-icon-color

Postmates

Zuora - Icon

Zuora

PowerSchool

ellucian-ethos (1)

Ellucian Ethos

Clubhouse

ZoomInfo - Icon

ZoomInfo

Evisort - Icon

Evisort

Add user to group

Create API 3 credentials for the specified user.

Create API 3 credentials

Create SQL Runner query

Create a password reset token for a user.

Create password reset token

Create two factor login information for the specified user.

Create two factor login information

Create user

Add email credentials to an existing user.

Create user email credentials

Delete a user including all looks and other information owned by the user.

Delete user

Delete a user attribute value from a user’s account settings

Delete user attribute value

Delete user from group

Delete a web login session for a given user.

Delete web login session

Get SQL Runner query

Get current user

Get group

Get user

List all groups

List all groups DDL

Retrieve information about all the groups in a group.

List all groups in group

Retrieve information about all the users directly included in a group.

List all users in group

Retrieve user attribute values for a given user.

List attribute values

List attribute values DDL

Retrieve information about roles of a given user.

List user roles

List users

List users DDL

Retrieve information about web login sessions for a given user.

List web login sessions

List web login sessions DDL

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

Raw HTTP request (advanced)

Execute a SQL Runner query in a given "result format".

Run SQL Runner query

Return all user accounts where first name, last name, or email field values match a pattern based on SQL LIKE expression. Any additional search fields will be combined into a logical AND expression.

Search user names

Search all users on a given search criteria. Please provide a field to search by to return results or use list users to list all users.

Search users

Update user

Update email credentials of an existing user.

Update user email credentials

marketing tools by tray.io

How Automation is Changing the Face of Business

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

Streamline strategic sales with an automated deal desk

Tray-IO Blog 6

The ultimate guide to automating the entire lead lifecycle

Vox Media is on the Tray platform

Vox Media connects and automates pre- and post-sales to streamline workflow

business-automation blog post cover image

business-automation

GDPR compliance for US companies: What you need to know

Connector Department - All - Cards

New Relic - Full - Dark

New Relic - Anonymous

Looker - Icon

Looker

Business Intelligence (BI)

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.

Join CSVs

Rename Columns

Set new values in all rows matching given filters, in the CSV

Update Rows by Filter

Find the first row in the table that matches a specific filter.

Find Row

Delete Row

CSV 1

Integration

Integrate your CSVs with any data source, fast

CSV 2

Automation

Powerful CSV automation

CSV 3

Use cases

Take full control of your CSV data

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

CSV-icon-color

Contact Management

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

Looker and CSV integration + automation

Popular Looker and CSV integrations

Looker and CSV Connector Details

Looker

CSV

Tray.io is the leader in low-code automation

Similar connectors to Looker and CSV

Discover the ultimate AI-powered iPaaS that supercharges your business with quick, seamless ecosystem integrations.