DataTable

Import data rows

Creates and/or updates up to 200 rows in a single API call. When creating or updating a large number of rows, this method is significantly faster than sending a separate API request for each row.

By default, a new row will be created for each item. To update existing rows, set the lookup_key parameter to match rows by ID, contact, or the value of a custom variable.

post/v1/projects/{project_id}/tables/{id}/import_rows

Request

  • Base URL: https://api.telerivet.com
  • URL: https://api.telerivet.com/v1/projects/{project_id}/tables/{id}/import_rows
  • Auth: one of:
    • HTTP basic
    • OAuth 2 (authorization code, authorization URL https://telerivet.com/oauth/authorize, token URL https://api.telerivet.com/oauth/token)

Path parameters

project_idstring required

ID of the Project

idstring required

ID of the DataTable

Request body

lookup_key'none' | 'id' | 'contact_id' | 'vars.variable_name'

The field used to search for a matching row, or 'none' to always create a new row. To search by a custom variable, precede the variable name with 'vars.'.

Response

Successful response

Changes

No recorded changes to this operation across all 1 revision of this API.