Connectors

/

Constant Contact

/

Sync Constant Contact contact details from Dynamics 365 Business Central
Write
Cross-Connector

Bring Constant Contact details in line with Business Central

For marketers who want company, title and phone updated in Constant Contact from Business Central, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Sync Constant Contact contact details from Dynamics 365 Business Central
Update our Customers list in Constant Contact with the latest company, title and phone from Business Central.
18 of 320 members differ from Business Central. - Jordan Lee: title Buyer becomes Purchasing Manager - Alex Morgan: company Fabrikam becomes Fabrikam Inc - Skipped: 4 members with several matches Which of the 18 changes should I apply?
Constant Contact
Sample figures. Your results come from your own account.
constant-contact-get-contact-list-member
constant-contact-get-contact
constant-contact-update-contact

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Constant Contact

Constant Contact
Run it on your own Constant Contact data.

Connect Constant Contact, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Constant Contact keeps last year's titles and phones

Job titles, company names and phones change in Business Central while Constant Contact keeps the old values. Comparing a whole list by hand is slow, and it is easy to wipe a good value with a blank one.

Without PopdockAI

  • Export a list from Constant Contact
  • Look up each member in Business Central
  • Compare company, title and phone by eye
  • Overwrite good values with blanks

With PopdockAI

  • Each member is matched to a Business Central contact by email
  • Blanks in Business Central never count as differences
  • Members with several matches are left alone
  • Only the fields you choose are updated, email and permission untouched

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** For members of the Constant Contact list `{list-name}`, compare company name, job title and phone with the matching Business Central contact, treating Business Central as correct, and update Constant Contact once the user confirms.

**Step 1: Read the list members in Constant Contact**

Call `constant-contact-get-contact-list-member` with `list-name` set to `{list-name}`. If nothing comes back, try `list-name.contains`, and if that matches several lists, show them and stop. Keep `contact-id` and `email-address`. For each member, call `constant-contact-get-contact` with `contact-id` for `company-name`, `job-title`, `phone-number`, `first-name` and `last-name`.

**Step 2: Find the Business Central contact**

For each member, call `business-central-get-contact` with `email` set to the member's `email-address`. If nothing comes back, report the member as not in Business Central and move on. If several come back, list them and leave that member unchanged.

**Step 3: Compare**

Compare `company-name`, `job-title` and phone (Business Central `phone-number`, or `mobile-phone-number` if that is empty) ignoring case, spaces and phone punctuation. Do not count a value that is empty in Business Central as a difference.

**Step 4: Confirm**

Show a table of differences: email, field, Constant Contact value, Business Central value. Ask the user to confirm all, some, or none. Do not proceed without a clear answer.

**Step 5: Update**

For each confirmed contact, call `constant-contact-update-contact` with `contact-id` and only the changed fields (`company-name`, `job-title`, `phone`). Stop and report on the first error.

**Step 6: Report**

Updated, unchanged, not in Business Central, and ambiguous, with counts.

**Rules & Guidelines:**

* `constant-contact-get-contact-list-member`, `constant-contact-get-contact` and `constant-contact-update-contact` are on the constant-contact server; `business-central-get-contact` is on the business-central server.
* The only write tool allowed is `constant-contact-update-contact`, on the constant-contact server, after confirmation. Never change the email address or `permission-to-send`.
* Do NOT call `business-central-update-contact` or any other Business Central create or update tool.
* Pass `company` to the Business Central tool only if the user names a company.

**Validation:**

* If no member differs, say so and stop.
* If the list has more than 200 members, process the first 200 and say how many remain.

Who it's for

One answer, three teams that use it

Email marketers

Personalise with current details

Titles and companies come from Business Central, so greetings and segments stay right.

Sync company, title and phone from Business Central into our VIP Customers list in Constant Contact.

Marketing operations

Keep two systems in line

A table of differences lets you choose exactly what changes.

Show differences between our Partners list in Constant Contact and Business Central contacts, then update the ones I pick.

Sales coordinators

Stop old phone numbers spreading

Phone changes recorded in Business Central reach Constant Contact without retyping.

Update phone numbers in our Contoso Accounts list from Business Central.

How it works

What PopdockAI does when you ask

You name a Constant Contact list and your AI assistant compares its members with Business Central contacts. Only the differences you choose are updated, and Business Central is not changed.

01

Ask

You name the Constant Contact list.

Your AI tool

02

Match

It finds the Business Central contact for each member by email.

constant-contact-get-contact-list-member
constant-contact-get-contact

03

Compare

It compares company, title and phone, ignoring blanks in Business Central.

No items found.

04

Confirm

You choose all, some or none, then only changed fields are updated.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Constant Contact and one secure connection to your AI tool. No code, no exports.

get-data

constant-contact-get-contact-list-member

Returns the members of Constant Contact contact lists with their email permission. Filter by list name or ID, contact, email address and permission.
get-data

constant-contact-get-contact

Returns Constant Contact contacts with their name, email, company, job title, phone, location, tags and email permission. Filter by email address or domain, last name, company, state, permission and created date.
run-action

constant-contact-update-contact

Updates a Constant Contact contact's name, email, phone, job title, company or email permission. Values left out keep their current values.
Read only.Nothing in Constant Contact Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

Current details in your email audience

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation