LogicMonitor

Kazoo HR

LiveRamp - Icon

LiveRamp

Lodash-icon-color

Lodash

LeafLink - Icon

LeafLink

Snowflake - Icon

Snowflake

Absorb

Redshift - Icon

Redshift

aeries

Aeries

SQL-Server

Microsoft SQL Server

Grafana

Reltio - Icon

Reltio

Sailthru - Icon

Sailthru

Kanban Tool

Google BigQuery - Icon

Google BigQuery

Firebase - Icon

Firebase

Postmates-icon-color

Postmates

FreshService

Freshservice

PagerDuty - Full

PagerDuty

Azure Blob Storage - Icon

Microsoft Azure Blob Storage

Fetches an array of all the global fields that exist on organizations.

Get global fields organizations

Deletes an opportunity with a specified opportunity ID.

Delete opportunity

Creates a new field value with the supplied parameters.

Create field value

Creates a new note with the supplied parameters.

Create note

Creates a new opportunity with the supplied parameters.

Create opportunity

Creates a new organization with the supplied parameters.

Create organization

Creates a new person with the supplied parameters.

Create person

Deletes an organization with a specified organization ID.

Delete organization

Deletes a person with a specified person ID.

Delete person

Download an entity file with a specified entity file ID.

Download entity file

Fetch an entity with a specified Entity file ID.

Get entity file

Fetches an array of all the global fields that exist on people and return an array of the global fields that exist on people for your team.

Get global fields persons

Returns all the list entries in the list with the supplied list ID.

Get list entries

Gets the details for a specific note given the existing note ID.

Get note

Fetches an opportunity with a specified opportunity ID.

Get opportunity

Fetches an organization with a specified organization ID.

Get organization

Fetches a person with a specified person ID.

Get person

List all entity files within your organization. The result will be an object with two fields: 'entity_files' and 'next_page_token'. You can set the value of next_page_token to be sent as the query parameter page_token in another request to retrieve the next page of results.

List entity files

Returns all fields based on the parameters provided.

List fields

List fields DDL

Returns a collection of all the lists visible to you.

List lists

List lists DDL

Returns all field values attached to a person, organization, opportunity.

List notes

Searches your team’s data and fetches all the opportunities that meet the search criteria. The search term can be a part of an opportunity’s name.

Search opportunities

Searches your team’s data and fetches all the organizations that meet the search criteria. The search term can be a part of an organization’s name or domain.

Search organizations

Searches your teams data and fetches all the persons that meet the search criteria. The search term can be part of an email address, a first name or a last name.

Search persons

Updates an existing opportunity with opportunity ID with the supplied parameters.

Update opportunity

Updates an existing organization with organization ID with the supplied parameters.

Update organization

Updates an existing person with person_id with the supplied parameters. Only attributes that need to be changed must be passed in.

Update person

Uploads files attached to the entity with the given ID. The file will display on the entity’s profile, provided that the entity is not a person internal to the user’s organization.

Upload entity files

Affinity1

Integrations

Easily integrate Affinity

Affinity2

Automation

Limitless Affinity automation

Affinity3

Use cases

In-depth Affinity automations

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

Affinity - Icon

Affinity

Contact Management

Counts the number of rows that meet a given set of conditions.

Count rows

Create or update a table from a CSV file export.

Create or update table from csv

Deletes rows in your database based on criteria of your choosing.

Delete rows

Export table as csv

Find rows in your database based on criteria of your choosing.

Find rows

Insert one or more rows into your MySQL database.

Insert new rows

List table fields DDL

List tables DDL

Updates rows in your database based on criteria of your choosing.

Update rows

Execute the specified SQL code on the chosen database

Run SQL query

Create or update a table using MySQl LOAD DATA. local_infile global variable must be set to true in your MySQL database. Max file size allowed is 300MB.

Create or update table with load data

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

MySQL - Icon

MySQL

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

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

Resources - Company

Your journey to automation excellence starts here

Resources

TUAC Resources Spotlight - Eventbrite

TUAC Resources Customer Spotlight

Eventbrite - White - Full

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

See all our connectors (Tertiary)

Similar connectors to Affinity and MySQL

Connector Awards

Tray.io is the leader in low-code automation

DigitalOcean - Full - Dark

David Dorman of Digital Ocean works with Tray.io

David Dorman - DigitalOcean

DigitalOcean - David Dorman

Details - Single & Double

"Request 1:1 demo" -> Demo LP [Primary style] | MAIN SITEWIDE CTA

MAIN SITEWIDE CTA | Demo Landing Page

Affinity and MySQL integrations couldn’t be easier with the Tray Platform’s robust Affinity and MySQL connector, which connects any services without the need for separate integration tools.

Affinity and MySQL integrations couldn’t be easier with the Tray Platform’s robust Affinity and MySQL connectors, which can connect to any service without the need for separate integration tools.

Integrate Affinity and MySQL with any SaaS application or service using the Tray Platform’s generic connectivity options, such as the HTTP Client, Webhook Trigger, and our Connector Builder. Configure them to connect to Affinity and MySQL and any other API, database, webhook, and more.

Affinity and MySQL integration + automation

Popular Affinity and MySQL integrations

Affinity and MySQL Connector Details

Affinity

MySQL

Tray.io is the leader in low-code automation

Similar connectors to Affinity and MySQL

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