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 / write MailChimp Campaigns, Lists, Members, Reports and more in without coding.
Mailchimp
Get User Details
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Mailchimp
Read / write MailChimp Campaigns, Lists, Members, Reports and more in without coding.
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:

Get the current user's account information, such as full name, user name, email address, role, etc. 

SELECT * FROM get_user_details

Get specific columns of the current user's account information, such as full name, user name, email address, role, etc. 

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:

Get the current user's account information, such as full name, user name, email address, role, etc. 

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

EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_GATEWAY];

Get specific columns of the current user's account information, such as full name, user name, email address, role, etc. 

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];