Organization Integration Links
The organization_integration_links table contains data about Action Network integration settings created in the organization.
This table can be used to determine which settings exist in which campaigns for which Action Network integrations, as well as metadata about the integration such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| parent_id | The numerical identifier of the parent integration setting this setting is related to. Relates to the id column in the organization_integration_links table. |
INT8 | Yes |
| organization_integration_id | The numerical identifier of the Action Network integration this setting is related to. Relates to the id column in the organization_integrations table. |
INT8 | Yes |
| linkable_type | The type of object this setting relates to. One of Tag or Campaign. |
VARCHAR | Yes |
| linkable_id | The numerical identifier of the object this setting relates to. Can be used with linkable_type to look up the object itself in the appropriate table. |
INT8 | Yes |
| external_entity_id | The Action Network ID of the object being synced to. | VARCHAR | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| settings | A hash of additional settings related to this setting. | HSTORE | No |
| external_entity_type | The type of Action Network object being synced to. One of Tag or FieldName. |
VARCHAR | No |