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

Get User Details using API Destination
Mailchimp
Get User Details

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