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

    • Understanding & Creating Custom Tables

      Custom tables in Delivra are a flexible way to store and manage additional data beyond what’s available in standard contact records. Whether you're tracking multiple transactions per contact, managing complex relationships between data sets, or ...

    • 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 ...

    • Introduction to Custom Tables in Delivra

      Custom tables in Delivra provide a flexible way to manage structured data that goes beyond the standard contact record. Whether you're tracking purchases, events, or storing additional contact details, custom tables help you expand how you work with ...

    • 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 ...

    • Understanding Custom Table Relationships

      Custom tables in Delivra offer a flexible way to store and manage data beyond the standard contact record. Whether you're looking to expand contact field options, store multiple data records per contact, or create complex data relationships, tables ...