Connectors

/

Microsoft Dynamics 365 Business Central

/

Add missing Dynamics 365 Business Central customers to a Constant Contact list
Write
Cross-Connector

Keep your Constant Contact list in step with Business Central

For marketing teams who want new Business Central customers added to a Constant Contact list without duplicates, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Add missing Dynamics 365 Business Central customers to a Constant Contact list
Add any Business Central customers in Texas who are not in Constant Contact to our Customer Newsletter list.
58 active customers in Texas have an email; 12 are not in Constant Contact. - To add: 12, such as C10420, Contoso, ops@contoso.com - Already in Constant Contact: 46, to add to the list there by hand - Permission to send: left unset unless you confirm they opted in Shall I create the 12 contacts on Customer Newsletter?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
constant-contact-get-contact-list
constant-contact-add-contact-list
constant-contact-get-contact
constant-contact-add-contact

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central
Run it on your own Microsoft Dynamics 365 Business Central data.

Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Your newsletter list falls behind your customer base

New customers open in Business Central but never reach your Constant Contact list unless someone exports them, checks each email and adds the gaps by hand. Contacts get missed, and people are added with no record of consent.

Without PopdockAI

  • Export customers from Business Central
  • Search each email in Constant Contact
  • Add the gaps one by one
  • Lose track of who actually opted in

With PopdockAI

  • Active customers with an email are checked in Constant Contact
  • Existing contacts are listed apart for you to handle
  • Permission to send stays unset unless you say they opted in
  • Nothing is created until you confirm, and Business Central is 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:** Find Business Central customers (optionally only salesperson `{salesperson-code}` or state `{state}`) whose email is not in Constant Contact, and, once the user confirms, create them as contacts on the Constant Contact list `{list-name}`.

**Step 1: Find the list in Constant Contact**

Call `constant-contact-get-contact-list` with `name` set to `{list-name}`. If several match, list them and stop. If none matches, tell the user and ask whether to create it; only on a clear yes call `constant-contact-add-contact-list` with `name` set to `{list-name}`. Keep the `list-id`.

**Step 2: List the customers in Business Central**

Call `business-central-get-customer` with `blocked` set to false, plus `salesperson-code` set to `{salesperson-code}` and `state` set to `{state}` when given. Skip customers with no `email`.

**Step 3: Find the gap**

For each customer, call `constant-contact-get-contact` with `email-address` set to the customer's `email`. Keep only customers with no matching contact. Customers who already exist in Constant Contact cannot be added to a list by these tools; list them separately so the user can add them in Constant Contact.

**Step 4: Confirm**

Show the customers to be added: customer number, name, email, phone. Show the count and the target list. Ask the user to confirm before creating anything. Do not proceed without a clear yes.

**Step 5: Create the contacts**

For each confirmed customer, call `constant-contact-add-contact` with `email` set to the customer's `email`, `company-name` set to the customer's `name`, `phone` set to `phone-number`, and `list-id` set to the list's `list-id`. Leave `permission-to-send` unset unless the user states the customers have opted in. Stop and report on the first error rather than retrying.

**Step 6: Report**

Created, skipped as already present, and failed, each with email and customer number.

**Rules & Guidelines:**

* `business-central-get-customer` is on the business-central server; `constant-contact-get-contact-list`, `constant-contact-get-contact`, `constant-contact-add-contact-list` and `constant-contact-add-contact` are on the constant-contact server.
* The only write tools allowed are `constant-contact-add-contact` and, if the user agrees, `constant-contact-add-contact-list`, both on the constant-contact server and both after confirmation.
* Do NOT call `constant-contact-update-contact`, `business-central-update-customer` or any Business Central create or update tool.
* Pass `company` to the Business Central tool only if the user names a company.

**Validation:**

* If no customer is missing from Constant Contact, say so and stop.
* Compare emails ignoring case. If a Business Central email field holds several addresses, use the first and say so.

Who it's for

One answer, three teams that use it

Email marketers

Reach every new customer with your newsletter

Find the customers your list is missing and add them in one confirmed step, instead of exporting and comparing files.

Add Business Central customers who are missing from Constant Contact to our Monthly Update list.

Marketing operations

Keep consent records honest

Permission to send is left unset unless you state the customers opted in, so your list never claims consent you do not have.

Find Business Central customers for salesperson PS who are not in Constant Contact and add them to the Customers list without opt in.

Account managers

Get your accounts onto the right list

Make sure the customers you look after hear about news and offers, without asking marketing to run an import.

Which of my Business Central customers in Florida are not on the Constant Contact Customer News list? Add them.

How it works

What PopdockAI does when you ask

You name the Constant Contact list and your AI assistant finds the Business Central customers who are not in it. You see every contact before anything is created, and it stops on the first error.

01

Ask

You name the Constant Contact list, and optionally a salesperson or state.

Your AI tool

02

Check

It reads active customers with an email and checks each in Constant Contact.

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

03

Confirm

You see every customer to add, with existing contacts listed apart.

No items found.

04

Create

It creates the contacts on the list and reports created and failed.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Microsoft Dynamics 365 Business Central and one secure connection to your AI tool. No code, no exports.

get-data

constant-contact-get-contact-list

Returns Constant Contact contact lists with their description, active member count and favorite flag. Filter by name, member count and favorite.
run-action

constant-contact-add-contact-list

Creates a Constant Contact contact list with a name, description and favorite flag.
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-add-contact

Creates a Constant Contact contact from an email address, name, company, job title, phone and email permission, optionally adding it to one contact list.
Read only.Nothing in Microsoft Dynamics 365 Business Central 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

A marketing list that keeps pace with your customers

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