Custom field mapping

Allow users to map their fields to your schema

Behavior

Custom field mapping allows your users to map fields in their connected system to your data model.

Your users will see your app's schema on the left, and available fields in their source system on the right.

Uses

  • Fetch available custom fields in your customer's external system without creating new custom fields in your app.
  • Define schemas tenant-by-tenant for granular control over mapping.

πŸ“˜

If you need to fetch custom fields, hotglue will first need to fetch available fields in your user's account (a "discover"). There are two ways to do this, both of which can be turned on in your jobs settings:

  • Trigger a discover when your user links.
  • Force a discover on every job

Syntax

Pass the schemas object as an option to the hotglue widget. There are three parameters in this object:

  • FlowId: The shortcode for your flow
  • schema.table: The name of the table inside your system. This can be any string.
  • Your data model's field id and name: The id is the field name in your data model, as a string. The name is a user-friendly string that is familiar to your users.
{
      schemas: [
        {
          flowId: flowId,
          schema: [
            {
              table: 'Leads',
              fields: [
                {
                  id: 'interest',
                  name: "Interest Level"
                },
                {
                  id: 'cat',
                  name: 'Test Company category'
                }
              ]
            }
          ]
        }
      ]
}