LogicMonitor

Kazoo HR

LiveRamp - Icon

LiveRamp

Lodash-icon-color

Lodash

LeafLink - Icon

LeafLink

Absorb

aeries

Aeries

Grafana

Sailthru - Icon

Sailthru

Kanban Tool

Postmates-icon-color

Postmates

Zuora - Icon

Zuora

PowerSchool

ellucian-ethos (1)

Ellucian Ethos

Clubhouse

Evisort - Icon

Evisort

Constant Contact - Icon

Constant Contact

Criteo

Talkdesk - Icon

Talkdesk

Cue - Icon

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

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

Powerful CSV automation

CSV 3

Take full control of your CSV data

Tray-IO Blog 6

The ultimate guide to automating the entire lead lifecycle

The State of Marketing technology eBook by Tray.io

Affinity and CSV integration + automation

Popular Affinity and CSV integrations

Affinity and CSV Connector Details

Affinity

CSV

Tray.io is the leader in low-code automation

Similar connectors to Affinity and CSV

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