Using the Mailchimp Adapter with Oracle Integration Generation 2

Oracle® Cloud

Using the Mailchimp Adapter with Oracle

Integration Generation 2

E85512-11

December 2022

Oracle Cloud Using the Mailchimp Adapter with Oracle Integration Generation 2,

E85512-11

Primary Author: Oracle Corporation

This software and related documentation are provided under a license agreement containing restrictions on

use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your

license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,

transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse

engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is

prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If

you find any errors, please report them to us in writing.

If this is software, software documentation, data (as defined in the Federal Acquisition Regulation), or related

documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S.

Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software,

any programs embedded, installed, or activated on delivered hardware, and modifications of such programs)

and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end

users are "commercial computer software," "commercial computer software documentation," or "limited rights

data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental

regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation

of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated

software, any programs embedded, installed, or activated on delivered hardware, and modifications of such

programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and

limitations specified in the license contained in the applicable contract. The terms governing the U.S.

Government's use of Oracle cloud services are defined by the applicable contract for such services. No other

rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications.

It is not developed or intended for use in any inherently dangerous applications, including applications that

may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you

shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its

safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this

software or hardware in dangerous applications.

Oracle®, Java, and MySQL are registered trademarks of Oracle and/or its affiliates. Other names may be

trademarks of their respective owners.

Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are

used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc,

and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered

trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products,

and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly

disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise

set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be

responsible for any loss, costs, or damages incurred due to your access to or use of third-party content,

products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents

Preface

Audience v

Documentation Accessibility v

Diversity and Inclusion v

Related Resources vi

Conventions vi

Understand the Mailchimp Adapter

Mailchimp Adapter Capabilities 1-1

What Application Version Is Supported? 1-1

About Mailchimp Adapter Use Cases 1-1

Workflow to Create and Add a Mailchimp Adapter Connection to an Integration 1-2

Create a Mailchimp Adapter Connection

Prerequisites for Creating a Connection 2-1

Create a Connection 2-2

Configure Connection Security 2-3

Test the Connection 2-3

Upload an SSL Certificate 2-4

Add the Mailchimp Adapter Connection to an Integration

Basic Info Page 3-1

Invoke Operations Page 3-1

Summary Page 3-2

Troubleshoot the Mailchimp Adapter

Mailchimp Website Authentication Error 4-1

SSL Error When Providing Consent 4-2

iii

Specify the Port Number with the Authorized Redirect URL 4-2

Preface

This guide describes how to configure this adapter as a connection in an integration in Oracle

Integration.

Note:

The use of this adapter may differ depending on the features you have, or whether

your instance was provisioned using Standard or Enterprise edition. These

differences are noted throughout this guide.

Topics:

• Audience

• Documentation Accessibility

• Diversity and Inclusion

• Related Resources

• Conventions

Audience

This guide is intended for developers who want to use this adapter in integrations in Oracle

Integration.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility

Program website at

http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My

Oracle Support. For information, visit

http://www.oracle.com/pls/topic/lookup?

ctx=acc&id=info

or visit

http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs

if you

are hearing impaired.

Diversity and Inclusion

Oracle is fully committed to diversity and inclusion. Oracle respects and values having a

diverse workforce that increases thought leadership and innovation. As part of our initiative to

build a more inclusive culture that positively impacts our employees, customers, and

partners, we are working to remove insensitive terms from our products and

documentation. We are also mindful of the necessity to maintain compatibility with our

customers' existing technologies and the need to ensure continuity of service as

Oracle's offerings and industry standards evolve. Because of these technical

constraints, our effort to remove insensitive terms is ongoing and will take time and

external cooperation.

Related Resources

See these Oracle resources:

• Oracle Cloud

http://cloud.oracle.com

• Using Integrations in Oracle Integration Generation 2

• Using the Oracle Mapper with Oracle Integration Generation 2

Conventions

The following text conventions are used in this document:

Convention Meaning

boldface

Boldface type indicates graphical user interface elements associated

with an action, or terms defined in text or the glossary.

italic Italic type indicates book titles, emphasis, or placeholder variables for

which you supply particular values.

monospace

Monospace type indicates commands within a paragraph, URLs, code

in examples, text that appears on the screen, or text that you enter.

Preface

Understand the Mailchimp Adapter

Review the following conceptual topics to learn about the Mailchimp Adapter and how to use

it as a connection in Oracle Integration integrations. A typical workflow of adapter and

integration tasks is also provided.

Topics:

• Mailchimp Adapter Capabilities

• What Application Version Is Supported?

• About Mailchimp Adapter Use Cases

• Workflow to Create and Add a Mailchimp Adapter Connection to an Integration

Note:

There are overall service limits for Oracle Integration. A service limit is the quota or

allowance set on a resource. See Service Limits.

Mailchimp Adapter Capabilities

The Mailchimp Adapter enables you to connect to Mailchimp REST APIs from Oracle

Integration.

Mailchimp is an email marketing software (EMS) program that provides options for designing,

sending, and saving email templates. You can create newsletters and share them on social

network sites such as Twitter or Facebook. You can build a list of contacts with whom you

want to market products, and save the list for later use. You can also create custom

templates for your products so that you do have to rewrite emails.

The Mailchimp Adapter is one of the many predefined adapters included with Oracle

Integration. You can configure the Mailchimp Adapter as a connection in an integration in

Oracle Integration.

What Application Version Is Supported?

For information about which application version is supported by this adapter, see the

Connectivity Certification Matrix.

See Connectivity Certification Matrix.

About Mailchimp Adapter Use Cases

The Mailchimp Adapter can be used in the following scenarios.

1-1

• You can integrate the Mailchimp Adapter with information technology service

applications to generate mailing and contact lists.

• You can integrate the Mailchimp Adapter with marketing applications to generate

marketing emails.

• You can configure the Mailchimp Adapter to return client information and statistics

including the average number of clicks made in a campaign and the number of

campaign emails opened by clients.

Note:

Oracle Integration offers a number of pre-assembled solutions, known as

recipes, that provide you with a head start in building your integrations. You

can start with a recipe, and then customize it to fit your needs and

requirements. Depending upon the solution provided, a variety of adapters

are configured in the pre-assembled solutions.

See the Recipes page on the Oracle Help Center.

Workflow to Create and Add a Mailchimp Adapter

Connection to an Integration

Follow the workflow to create an adapter connection and include the connection in an

integration in Oracle Integration.

This table lists the workflow steps for both adapter tasks and overall integration tasks,

and provides links to instructions for each workflow step.

Step Description More Information

1 Create the Mailchimp account Prerequisites for Creating a Connection

2 Create the adapter connections

for the applications you want to

integrate. The connections can

be reused in multiple

integrations and are typically

created by the administrator.

Create a Mailchimp Adapter Connection

3 Create the integration. When

you do this, you add trigger and

invoke connections to the

integration.

Create Integrations in Using Integrations in Oracle

Integration Generation 2 and Add the Mailchimp

Adapter Connection to an Integration

4 Map data between the trigger

connection data structure and

the invoke connection data

structure.

Map Data in Using Integrations in Oracle Integration

Generation 2

5 (Optional) Create lookups that

map the different values used by

those applications to identify the

same type of object (such as

gender codes or country codes).

Manage Lookups in Using Integrations in Oracle

Integration Generation 2

6 Activate the integration. Manage Integrations in Using Integrations in Oracle

Integration Generation 2

Chapter 1

Workflow to Create and Add a Mailchimp Adapter Connection to an Integration

1-2

Step Description More Information

7 Monitor the integration on the

dashboard.

Monitor Integrations in Using Integrations in Oracle

Integration Generation 2

8 Track payload fields in messages

during runtime.

Assign Business Identifiers for Tracking Fields in

Messages and Manage Business Identifiers for

Tracking Fields in Messages in Using Integrations in

Oracle Integration Generation 2

9 Manage errors at the integration

level, connection level, or

specific integration instance

level.

Manage Errors in Using Integrations in Oracle

Integration Generation 2

Chapter 1

Workflow to Create and Add a Mailchimp Adapter Connection to an Integration

1-3

Create a Mailchimp Adapter Connection

A connection is based on an adapter. You define connections to the specific cloud

applications that you want to integrate.

Topics:

• Prerequisites for Creating a Connection

• Create a Connection

• Upload an SSL Certificate

Prerequisites for Creating a Connection

Before you create the Mailchimp Adapter connection, you need to create a Mailchimp

account and add the application. You can use an existing Mailchimp account, but you need to

add the application to create a connection. Use this procedure to create a new Mailchimp

account and add the application.

Note:

To create a connection, a trusted Mailchimp public certificate is required. Typically,

the certificate is included with Oracle Integration. If you cannot locate the Mailchimp

public certificate, download it from https://login.mailchimp.com/oauth2/metadata.

Rename the public certificate file extension to

.crt

. To upload the certificate, see

Upload an SSL Certificate.

1. Open a web browser and browse to the Mailchimp web site (http://mailchimp.com).

2. Click Sign up Free.

3. Enter your email address, user name, and password.

4. Click Create My Account.

5. Activate your account following the instructions in the Mailchimp confirmation email.

6. Complete the Let's Get Started page.

7. Click Save and Get Started.

8. Click your user name in the upper right corner and select Account.

9. Click Extras and then select API keys.

10. Click Register and Manage Your Apps.

11. Click Register An App.

12. Complete the Register an App fields. Enter

https://server:port/icsapis/agent/

oauth/callback

in the Redirect URI field.

2-1

13. Click Create.

14. Copy or record the values in the Client ID and Client secret fields. These values

are required to create the connection in Oracle Integration.

Create a Connection

Before you can build an integration, you have to create the connections to the

applications with which you want to share data.

To create a connection in Oracle Integration:

1. In the left navigation pane, click Home > Integrations > Connections.

2. Click Create.

Note:

You can also create a connection in the integration canvas of:

• An orchestrated integration (See Define Inbound Triggers and

Outbound Invokes.)

• A basic routing integration (See Add a Trigger (Source) Connection.)

3. In the Create Connection — Select Adapter dialog, select the adapter to use for

this connection. To find the adapter, scroll through the list, or enter a partial or full

name in the Search field and click

Search.

4. In the Create Connection dialog, enter the information that describes this

connection.

a. Enter a meaningful name to help others find your connection when they begin

to create their own integrations. The name you enter is automatically added in

capital letters to the Identifier field. If you modify the identifier name, don't

include blank spaces (for example,

SALES OPPORTUNITY

b. Enter optional keywords (tags). You can search on the connection keywords

on the Connections page.

c. Select the role (direction) in which to use this connection (trigger, invoke, or

both). Only the roles supported by the adapter are displayed for selection.

When you select a role, only the connection properties and security policies

appropriate to that role are displayed on the Connections page. If you select

an adapter that supports both invoke and trigger, but select only one of those

roles, you'll get an error when you try to drag the adapter into the section you

didn't select. For example, let's say you configure a connection for the Oracle

Service Cloud (RightNow) Adapter as only an invoke. Dragging the adapter to

a trigger section in the integration produces an error.

d. Enter an optional description of the connection.

5. Click Create.

Chapter 2

Create a Connection

2-2

Your connection is created. You're now ready to configure the connection details, such as

connection properties, security policies, connection login credentials, and (for certain

connections) agent group.

Configure Connection Security

Enter connection information so your application can process requests.

1. Go to the Security section.

The Security Policy field displays MailchimpSecurityPolicy by default. This field

cannot be changed.

2. Enter the client ID and client secret values you recorded when you created your

Mailchimp account.

See Prerequisites for Creating a Connection.

3. Click Provide Consent.

4. If required, enter your Mailchimp user name and password.

5. Click Log In.

6. Return to Oracle Integration to test and save the security credentials.

Test the Connection

Test your connection to ensure that it's configured successfully.

1. In the page title bar, click Test. What happens next depends on whether your adapter

connection uses a Web Services Description Language (WSDL) file. Only some adapter

connections use WSDLs.

If Your Connection... Then...

Doesn't use a WSDL The test starts automatically and validates the inputs you provided for the

connection.

Uses a WSDL A dialog prompts you to select the type of connection testing to perform:

• Validate and Test: Performs a full validation of the WSDL, including

processing of the imported schemas and WSDLs. Complete

validation can take several minutes depending on the number of

imported schemas and WSDLs. No requests are sent to the

operations exposed in the WSDL.

• Test: Connects to the WSDL URL and performs a syntax check on

the WSDL. No requests are sent to the operations exposed in the

WSDL.

2. Wait for a message about the results of the connection test.

• If the test was successful, then the connection is configured properly.

• If the test failed, then edit the configuration details you entered. Check for typos,

verify URLs and credentials, and download the diagnostic logs for additional details.

Continue to test until the connection is successful.

3. When complete, click Save.

Chapter 2

Create a Connection

2-3

Upload an SSL Certificate

Certificates are used to validate outbound SSL connections. If you make an SSL

connection in which the root certificate does not exist in Oracle Integration, an

exception is thrown. In that case, you must upload the appropriate certificate. A

certificate enables Oracle Integration to connect with external services. If the external

endpoint requires a specific certificate, request the certificate and then upload it into

Oracle Integration.

To upload an SSL certificate:

1. In the left navigation pane, click Home > Settings > Certificates.

All certificates currently uploaded to the trust store are displayed in the Certificates

dialog. The

link enables you to filter by name, certificate expiration date, status, type, category,

and installation method (user-installed or system-installed). Certificates installed

by the system cannot be deleted.

2. Click Upload at the top of the page.

The Upload Certificate dialog box is displayed.

3. Enter an alias name and optional description.

4. In the Type field, select the certificate type. Each certificate type enables Oracle

Integration to connect with external services.

• X.509 (SSL transport)

• SAML (Authentication & Authorization)

• PGP (Encryption & Decryption)

X.509 (SSL transport)

1. Select a certificate category.

a. Trust: Use this option to upload a trust certificate.

i. Click Browse, then select the trust file (for example,

.cer

.crt

) to

upload.

b. Identity: Use this option to upload a certificate for two-way SSL

communication.

Chapter 2

Upload an SSL Certificate

2-4

i. Click Browse, then select the keystore file (

.jks

) to upload.

ii. Enter the comma-separated list of passwords corresponding to key aliases.

Note:

When an identity certificate file (JKS) contains more than one private

key, all the private keys must have the same password. If the private

keys are protected with different passwords, the private keys cannot be

extracted from the keystore.

iii. Enter the password of the keystore being imported.

c. Click Upload.

SAML (Authentication & Authorization)

1. Note that Message Protection is automatically selected as the only available certificate

category and cannot be deselected. Use this option to upload a keystore certificate with

SAML token support. Create, read, update, and delete (CRUD) operations are supported

with this type of certificate.

2. Click Browse, then select the certificate file (

.cer

.crt

) to upload.

3. Click Upload.

PGP (Encryption & Decryption)

1. Select a certificate category. Pretty Good Privacy (PGP) provides cryptographic privacy

and authentication for communication. PGP is used for signing, encrypting, and

decrypting files. You can select the private key to use for encryption or decryption when

configuring the stage file action.

a. Private: Uses a private key of the target location to decrypt the file.

i. Click Browse, then select the PGP file to upload.

ii. Enter the PGP private key password.

b. Public: Uses a public key of the target location to encrypt the file.

i. Click Browse, then select the PGP file to upload.

ii. In the ASCII-Armor Encryption Format field, select Yes or No. Yes shows the

format of the encrypted message in ASCII armor. ASCII armor is a binary-to-

textual encoding converter. ASCII armor formats encrypted messaging in ASCII.

This enables messages to be sent in a standard messaging format. This

selection impacts the visibility of message content. No causes the message to be

sent in binary format.

iii. From the Cipher Algorithm list, select the algorithm to use. Symmetric-key

algorithms for cryptography use the same cryptographic keys for both encryption

of plain text and decryption of cipher text.

c. Click Upload.

Chapter 2

Upload an SSL Certificate

2-5

Add the Mailchimp Adapter Connection to an

Integration

When you drag the Mailchimp Adapter into the invoke area of an integration, the Adapter

Endpoint Configuration Wizard appears. This wizard guides you through configuration of

Mailchimp Adapter endpoint properties.

These topics describe the wizard pages that guide you through configuration of the Mailchimp

Adapter as an invoke in an integration. The Mailchimp Adapter cannot be used as a trigger in

an integration.

Topics:

• Basic Info Page

• Invoke Operations Page

• Summary Page

Basic Info Page

You can enter a name and description on the Basic Info page of each adapter in your

integration.

Element Description

What do you want to call

your endpoint?

Provide a meaningful name so that others can understand the

responsibilities of this connection. You can include English alphabetic

characters, numbers, underscores, and hyphens in the name. You can't

include the following characters:

• No blank spaces (for example,

My Inbound Connection

)

• No special characters (for example,

#;83&

righ(t)now4

)

except underscores and hyphens

• No multibyte characters

What does this endpoint

do?

Enter an optional description of the connection’s responsibilities. For

example:

This connection receives an inbound request to

synchronize account information with the cloud

application.

Invoke Operations Page

Enter the Mailchimp Adapter invoke operation values for your integration.

The following table describes the available Mailchimp API operations on the Mailchimp

Adapter page. Select the operation to perform.

3-1

Operation Description

Get member info

Returns a list of members that are of a particular status and

potentially matching a segment.

Get interest

categories of a list

Returns all interest categories for a defined mailing list.

Get all lists

Returns all of the lists defined for a user account.

Get all segments in a

list

Returns all segments defined for a subscriber list.

Get top email clients

Returns a list of the most active subscribers and ranks the clients by

popularity.

Get all campaign

folders

Returns a list of all campaign folders for a user account.

Create Campaign

Folder

Creates a campaign folder.

Get all campaigns

Returns a the list of all existing campaigns and their details.

Send a campaign

Sends a campaign email to the specified email addresses.

Create a new

campaign

Creates a new campaign.

Create a new interest