Reference

Endpoint Get User Details

Name

get_user_details

Description

Gets details about the current Mailchimp user account. [API reference]

Parameters

Parameter Required Options
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
AccountId DT_WSTR nvarchar(200) 200
LoginId DT_WSTR nvarchar(100) 100
AccountName DT_WSTR nvarchar(100) 100
Email DT_WSTR nvarchar(200) 200
FirstName DT_WSTR nvarchar(50) 50
LastName DT_WSTR nvarchar(50) 50
UserName DT_WSTR nvarchar(100) 100
AvatarUrl DT_WSTR nvarchar(4000) 4000
Role DT_WSTR nvarchar(50) 50
MemberSince DT_DBTIMESTAMP datetime
PricingPlanType DT_WSTR nvarchar(100) 100
FirstPayment DT_WSTR nvarchar(100) 100
AccountTimeZone DT_WSTR nvarchar(100) 100
AccountIndustry DT_WSTR nvarchar(100) 100
ContactCompany DT_WSTR nvarchar(100) 100
ContactAddress1 DT_WSTR nvarchar(100) 100
ContactAddress2 DT_WSTR nvarchar(100) 100
ContactCity DT_WSTR nvarchar(100) 100
ContactState DT_WSTR nvarchar(50) 50
ContactZip DT_WSTR nvarchar(20) 20
ContactCountry DT_WSTR nvarchar(100) 100
ProEnabled DT_BOOL bit
LastLogin DT_DBTIMESTAMP datetime
TotalSubscribers DT_I4 int
Links DT_NTEXT nvarchar(MAX)
If the column you are looking for is missing, consider customizing Mailchimp Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Mailchimp Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Mailchimp
Read and write Mailchimp data effortlessly. Integrate, manage, and automate campaigns, lists, members, and reports — almost no coding required.
Mailchimp
Get User Details
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Mailchimp
Read and write Mailchimp data effortlessly. Integrate, manage, and automate campaigns, lists, members, and reports — almost no coding required.
Mailchimp
Get User Details
There are no parameters to configure.
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Read account details

<p>Gets the current authenticated user's account information (name, email, role, etc.). No parameters required.</p> 

SELECT * FROM get_user_details

Read account details (selected columns)

<p>Gets only the columns you specify from the current user's account. List the desired columns in the <code>SELECT</code> clause.</p> 

SELECT AccountId, LoginId, AccountName, Email, FirstName, LastName, UserName, AvatarUrl, Role, MemberSince, PricingPlanType, FirstPayment, AccountTimeZone, AccountIndustry, ContactCompany, ContactAddress1, ContactAddress2, ContactCity, ContactState, ContactZip, ContactCountry, ProEnabled, LastLogin, TotalSubscribers 
FROM get_user_details

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Read account details

<p>Gets the current authenticated user's account information (name, email, role, etc.). No parameters required.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_user_details';

EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_GATEWAY];

Read account details (selected columns)

<p>Gets only the columns you specify from the current user's account. List the desired columns in the <code>SELECT</code> clause.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT AccountId, LoginId, AccountName, Email, FirstName, LastName, UserName, AvatarUrl, Role, MemberSince, PricingPlanType, FirstPayment, AccountTimeZone, AccountIndustry, ContactCompany, ContactAddress1, ContactAddress2, ContactCity, ContactState, ContactZip, ContactCountry, ProEnabled, LastLogin, TotalSubscribers 
FROM get_user_details';

EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_GATEWAY];