Beacon CRM Exporter

📘

The Beacon CRM Exporter connector enables data ingestion into Beacon CRM from external systems, facilitating consistent updates of key CRM records like contacts, events, and financial data.

To find out more about the Beacon CRM Exporter API, please look at their documentation: Beacon CRM API Docs, you will need your login for access.

🚧

Important Note on Data Management

• We recommend testing this connector using credentials from a staging environment to ensure data flows as intended. Given that the reports can overwrite existing data or create new entries, please proceed with caution when executing them to prevent any unintended changes.

Set up

---

To set up the Beacon CRM Exporter connector, you will need your Account ID and API Key.

To locate your Account ID and API Key in your Beacon account, please follow these steps:

Account ID Steps:

Go to the Beacon CRM API Docs, log in, and head to the 'Introduction' tab on the left.
Here your Account ID will be present.

API Key Steps:

Log in to your Beacon Admin Account, and ask the support team in the chat widget on the bottom right for your API Key as stated in the documentation:

Reverse ETL Setup Steps

1. Log into the Kleene platform and navigate to the Beacon CRM Reverse ETL connector.
2. Enter your Beacon Account ID and API Key in the setup form.
3. Save the configuration and activate the connector.
4. For each extract, set up the data tables to sync from your source system to Beacon CRM.

Features

---

Reports detail

Each report in the Beacon CRM Reverse ETL connector supports "Upsert" functionality, meaning it can either create a new entry or update an existing one.

• When an entry with the specified "primary_field_key" does not exist in Beacon, a new record is created.
• If a record with this identifier is already present, the connector updates it with the incoming data, ensuring that information in Beacon remains accurate and up-to-date without creating duplicates.
• This "primary_field_key" value is adjustable per report, enabling flexibility in defining unique record identifiers for each report.

Report Descriptions and Requirements

The Beacon CRM Reverse ETL connector supports various reports, each with an adjustable "primary_field_key":

• Contact Profiles Upsert: Creates or updates individual contact records, adding or refreshing details like c_notes, c_reference, c_email, and c_profile_type.
• Events Upsert: Adds or updates event records in Beacon CRM, including fields such as name, notes, website, start_date, end_date, location, and campaign-specific attributes.
• Event Fundraisers Upsert: Syncs fundraiser details, like c_name, c_notes, c_fundraising_target, and c_platform.
• Gift Aid Declarations Upsert: Adds Gift Aid declarations with fields like declaration_date, method, and donor confirmation.
• Payouts Upsert: Inserts payout details into Beacon CRM, including fields like name, banked_date, and c_bank_account_name.
• Social Media Upsert: Syncs social media records linked to contacts, using fields like c_name, c_platform, and c_url_text.
• Subscriptions Upsert: Updates or creates subscription data, including amount, frequency, type, and reference.

These examples highlight just a few of the fields available. For a complete list of fields, please refer to the appropriate endpoint in the Beacon CRM documentation. To understand the structure and configurations of field values, see the Beacon API Field Type Validation on Notion.

Note: The "file" or "attachments" fields are not fully documented. Contact Beacon support for guidance on submitting these fields.

🚧

Limitations

• Unique Identifiers: Ensure unique identifiers for each record type to avoid duplicate entries.
• Data Formatting: Only correctly formatted records will be accepted in Beacon CRM; otherwise, updates will fail. There is a requirement to have tables in a format where there is the "primary_field_key", and all of the parameters are inside of an "entity" object. This is shown clearly in the documentation linked again below.
• Mandatory Fields: Some fields are mandatory based on configuration and data requirements.

For more details on Beacon API configuration, refer to the Beacon CRM documentation.