/
/
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.
On this page
Connector
Connect Constant Contact, pick your AI tool and paste the prompt.
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.
**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.
02
Match
It finds the Business Central contact for each member by email.
03
Compare
It compares company, title and phone, ignoring blanks in Business Central.
04
Confirm
You choose all, some or none, then only changed fields are updated.
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.
constant-contact-get-contact-list-member
constant-contact-get-contact
constant-contact-update-contact
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.
The outcome
Current details in your email audience
Related use cases
More ways to put this data to work
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.

.webp)
