EndPoint Get Account By Id

Contents

Name

get_account

Parameter	Label	Required	Options	Description
Id	Account Id	YES

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(50)`	50	False
ContactFirst	`DT_WSTR`	`nvarchar(255)`	255	False
ContactLast	`DT_WSTR`	`nvarchar(255)`	255	False
ContactEmail	`DT_WSTR`	`nvarchar(255)`	255	False
ContactCompany	`DT_WSTR`	`nvarchar(255)`	255	False
ContactPhone	`DT_WSTR`	`nvarchar(255)`	255	False
ContactSubscribed	`DT_BOOL`	`bit`		False
AddressLine1	`DT_WSTR`	`nvarchar(255)`	255	False
AddressLine2	`DT_WSTR`	`nvarchar(255)`	255	False
City	`DT_WSTR`	`nvarchar(255)`	255	False
Region	`DT_WSTR`	`nvarchar(255)`	255	False
RegionCustom	`DT_WSTR`	`nvarchar(255)`	255	False
PostalCode	`DT_WSTR`	`nvarchar(255)`	255	False
AddressCompany	`DT_WSTR`	`nvarchar(255)`	255	False
Language	`DT_WSTR`	`nvarchar(255)`	255	False
Country	`DT_WSTR`	`nvarchar(255)`	255	False
LookupGlobal	`DT_WSTR`	`nvarchar(255)`	255	False
Url	`DT_WSTR`	`nvarchar(255)`	255	False
PaymentMethods	`DT_I8`	`bigint`		False
PaymentActive	`DT_I8`	`bigint`		False
Orders	`DT_NTEXT`	`nvarchar(MAX)`		False
Subscriptions	`DT_NTEXT`	`nvarchar(MAX)`		False
Charges	`DT_NTEXT`	`nvarchar(MAX)`		False
Subscribed	`DT_BOOL`	`bit`		False
TaxExemptionData	`DT_WSTR`	`nvarchar(4000)`	4000	False

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.