Populating your Custom Tables with data

Populating your Custom Tables with data

Importing data into custom tables is essential for keeping records up to date and integrating data from external sources. This section covers different import methods and best practices.

Import Methods

  • CSV Imports: This manual method allows users to upload structured data files to populate custom tables.

  • Integrations: Delivra supports data syncing from third-party applications, making it easier to update custom tables automatically.

  • API: Users with technical expertise can use Delivra’s API to automate data transfers and maintain data integrity.

CSV Import Process

  1. Navigate to Contacts Dashboard. This is the starting point for importing new data.

  2. Click Import Data. The option is located at the top-right of the page.

  3. Select a CSV file to upload. Users should ensure the file format follows Delivra’s field structure to prevent import errors.

  4. Match CSV columns to custom table fields. The system requires each column in the CSV file to correspond to a field in the custom table.

  5. Configure import settings. These settings determine how data is processed, including assigning categories and handling duplicate records.

  6. Click Import. The system will process the file and update the custom table.

Import Limitations

  • Some tables (e.g., integration-based tables) do not support manual imports. Users should verify if manual import is available for their specific table type.

  • Relational tables require structured segment clauses for data mapping. Data being added to a custom table must include both the email address of the related contact as well as the primary key field(s) of the table.

Importing via API

  1. Data can be imported into any custom table by using our REST API. Please see all related endpoints here.

    • Related Articles

    • Using Custom Tables in Delivra

      Custom tables solve various data challenges, allowing businesses to store and organize information effectively. By leveraging custom tables, companies can improve data management, enhance segmentation, and personalize marketing efforts. Key Use Cases ...

    • How to Create and Manage Custom Tables

      How to Create and Manage Custom Tables in Delivra Creating a custom table in Delivra allows users to extend their contact data and better manage structured information. This section provides a step-by-step guide to creating and managing custom tables ...

    • Introduction to Custom Tables in Delivra

      Custom tables in Delivra provide a flexible way to store and manage structured data beyond the default contact record. This article introduces the concept of custom tables, their benefits, and when they should be used. What is a Custom Table? A ...

    • Understanding Table Relationships in Delivra

      Custom tables in Delivra support different types of relationships based on data needs. Choosing the right table relationship is crucial for ensuring efficient data retrieval and management. Table Relationships One-to-One Relationship In a one-to-one ...

    • Using Many-to-Many Relational Tables in Delivra

      Sometimes your data is more complex and multiple records in each table can relate to multiple records in another table. This is where Many-to-Many relationships can help. Many-to-many relationships make use of a junction table to help relate your two ...