Mailchimp Connector
Documentation
Version: 1
Documentation

EndPoint Get User Details


Name

get_user_details

Description

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

Parameters

Parameter Label Required Options Description
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
AccountId DT_WSTR nvarchar(200) 200 False
LoginId DT_WSTR nvarchar(100) 100 False
AccountName DT_WSTR nvarchar(100) 100 False
Email DT_WSTR nvarchar(200) 200 False
FirstName DT_WSTR nvarchar(50) 50 False
LastName DT_WSTR nvarchar(50) 50 False
UserName DT_WSTR nvarchar(100) 100 False
AvatarUrl DT_WSTR nvarchar(4000) 4000 False
Role DT_WSTR nvarchar(50) 50 False
MemberSince DT_DBTIMESTAMP datetime False
PricingPlanType DT_WSTR nvarchar(100) 100 False
FirstPayment DT_WSTR nvarchar(100) 100 False
AccountTimeZone DT_WSTR nvarchar(100) 100 False
AccountIndustry DT_WSTR nvarchar(100) 100 False
ContactCompany DT_WSTR nvarchar(100) 100 False
ContactAddress1 DT_WSTR nvarchar(100) 100 False
ContactAddress2 DT_WSTR nvarchar(100) 100 False
ContactCity DT_WSTR nvarchar(100) 100 False
ContactState DT_WSTR nvarchar(50) 50 False
ContactZip DT_WSTR nvarchar(20) 20 False
ContactCountry DT_WSTR nvarchar(100) 100 False
ProEnabled DT_BOOL bit False
LastLogin DT_DBTIMESTAMP datetime False
TotalSubscribers DT_I4 int False
Links DT_NTEXT nvarchar(MAX) False

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw 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 component to read data or in API Destination component to read/write data:

Get User Details using API Source

Mailchimp
Get User Details
SSIS API Source - Read from table or endpoint

Get User Details using API Destination

Mailchimp
Get User Details
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 [LINKED_SERVER_TO_MAILCHIMP_IN_DATA_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 [LINKED_SERVER_TO_MAILCHIMP_IN_DATA_GATEWAY];