EndPoint Read User(s) by ID

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

get_users_by_ids

Description

Get a list of users in your account for specific id(s) [API reference]

Parameters

Parameter	Label	Required	Options	Description
user_ids	User ID(S) - Use Comma for multiple (e.g. 111,222)	YES

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_I8`	`bigint`		False
name	`DT_WSTR`	`nvarchar(255)`	255	False
email	`DT_WSTR`	`nvarchar(500)`	500	False
active	`DT_BOOL`	`bit`		False
role	`DT_WSTR`	`nvarchar(32)`	32	False
created_at	`DT_DBTIMESTAMP`	`datetime`		False
updated_at	`DT_DBTIMESTAMP`	`datetime`		False
time_zone	`DT_WSTR`	`nvarchar(100)`	100	False
iana_time_zone	`DT_WSTR`	`nvarchar(100)`	100	False
phone	`DT_WSTR`	`nvarchar(100)`	100	False
url	`DT_WSTR`	`nvarchar(500)`	500	False
shared_phone_number	`DT_BOOL`	`bit`		False
locale_id	`DT_I8`	`bigint`		False
locale	`DT_WSTR`	`nvarchar(20)`	20	False
organization_id	`DT_I8`	`bigint`		False
role_type	`DT_I8`	`bigint`		False
verified	`DT_BOOL`	`bit`		False
external_id	`DT_WSTR`	`nvarchar(500)`	500	False
tags	`DT_WSTR`	`nvarchar(1000)`	1000	False
tags_1	`DT_WSTR`	`nvarchar(50)`	50	False
tags_2	`DT_WSTR`	`nvarchar(50)`	50	False
tags_3	`DT_WSTR`	`nvarchar(50)`	50	False
tags_4	`DT_WSTR`	`nvarchar(50)`	50	False
tags_5	`DT_WSTR`	`nvarchar(50)`	50	False
alias	`DT_WSTR`	`nvarchar(255)`	255	False
shared	`DT_BOOL`	`bit`		False
shared_agent	`DT_BOOL`	`bit`		False
last_login_at	`DT_DBTIMESTAMP`	`datetime`		False
two_factor_auth_enabled	`DT_BOOL`	`bit`		False
signature	`DT_WSTR`	`nvarchar(80)`	80	False
details	`DT_WSTR`	`nvarchar(4000)`	4000	False
notes	`DT_WSTR`	`nvarchar(4000)`	4000	False
custom_role_id	`DT_I8`	`bigint`		False
moderator	`DT_BOOL`	`bit`		False
ticket_restriction	`DT_WSTR`	`nvarchar(80)`	80	False
only_private_comments	`DT_BOOL`	`bit`		False
restricted_agent	`DT_BOOL`	`bit`		False
suspended	`DT_BOOL`	`bit`		False
default_group_id	`DT_I8`	`bigint`		False
report_csv	`DT_BOOL`	`bit`		False
photo_url	`DT_WSTR`	`nvarchar(500)`	500	False
photo_id	`DT_I8`	`bigint`		False
photo_file_name	`DT_WSTR`	`nvarchar(148)`	148	False
photo_content_url	`DT_WSTR`	`nvarchar(500)`	500	False
photo_mapped_content_url	`DT_WSTR`	`nvarchar(500)`	500	False
photo_content_type	`DT_WSTR`	`nvarchar(40)`	40	False
photo_size	`DT_I8`	`bigint`		False
photo_width	`DT_I8`	`bigint`		False
photo_height	`DT_I8`	`bigint`		False
photo_inline	`DT_BOOL`	`bit`		False
photo_deleted	`DT_BOOL`	`bit`		False
photo_thumbnails	`DT_WSTR`	`nvarchar(4000)`	4000	False
user_field_dt_[$parent.key$]	`DT_WSTR`	`nvarchar(4000)`	4000	False
user_field_[$parent.key$]	`DT_WSTR`	`nvarchar(4000)`	4000	False

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_I8`	`bigint`		False
name	`DT_WSTR`	`nvarchar(120)`	120	False
email	`DT_WSTR`	`nvarchar(160)`	160	False
alias	`DT_WSTR`	`nvarchar(255)`	255	False
time_zone	`DT_WSTR`	`nvarchar(104)`	104	False
phone	`DT_WSTR`	`nvarchar(80)`	80	False
shared_phone_number	`DT_BOOL`	`bit`		False
photo_id	`DT_WSTR`	`nvarchar(1020)`	1020	False
locale_id	`DT_I8`	`bigint`		False
locale	`DT_WSTR`	`nvarchar(20)`	20	False
organization_id	`DT_I8`	`bigint`		False
organization_name	`DT_WSTR`	`nvarchar(200)`	200	False
role	`DT_WSTR`	`nvarchar(100)`	100	False
verified	`DT_BOOL`	`bit`		False
external_id	`DT_WSTR`	`nvarchar(500)`	500	False
tags	`DT_WSTR`	`nvarchar(4000)`	4000	True
signature	`DT_WSTR`	`nvarchar(4000)`	4000	False
details	`DT_WSTR`	`nvarchar(4000)`	4000	False
notes	`DT_WSTR`	`nvarchar(4000)`	4000	False
remote_photo_url	`DT_WSTR`	`nvarchar(4000)`	4000	False
custom_role_id	`DT_I8`	`bigint`		False
moderator	`DT_BOOL`	`bit`		False
ticket_restriction	`DT_WSTR`	`nvarchar(80)`	80	False
only_private_comments	`DT_BOOL`	`bit`		False
restricted_agent	`DT_BOOL`	`bit`		False
suspended	`DT_BOOL`	`bit`		False
default_group_id	`DT_I8`	`bigint`		False
photo	`DT_WSTR`	`nvarchar(4000)`	4000	True
user_fields	`DT_WSTR`	`nvarchar(4000)`	4000	True
identities	`DT_WSTR`	`nvarchar(4000)`	4000	True
$$user_ids	`DT_WSTR`	`nvarchar(2000)`	2000	False

Required columns that you need to supply are bolded.