Zendesk Connector
Zendesk Connector Help
Version 8
ZappySys Logo File Version: v8
Supported Engine: 7

EndPoint Read Tickets for Organization


Name

get_tickets_by_org

Description

Get all tickets for specified organization_id [API Help]

Parameters

Parameter Label Required Options Description
organization_id Organization ID YES

Output Columns

Label DataType Length Raw Description
id DT_I8 0 False
recipient DT_WSTR 255 False
subject DT_WSTR 1000 False
status DT_WSTR 28 False
type DT_WSTR 255 False
priority DT_WSTR 24 False
description DT_NTEXT 0 False
external_id DT_WSTR 255 False
created_at DT_DBTIMESTAMP 0 False
updated_at DT_DBTIMESTAMP 0 False
raw_subject DT_WSTR 1000 False
url DT_WSTR 500 False
comment_count DT_I8 0 False
requester_id DT_I8 0 False
submitter_id DT_I8 0 False
assignee_id DT_I8 0 False
organization_id DT_I8 0 False
group_id DT_I8 0 False
collaborator_ids DT_WSTR 1000 False
collaborator_ids_1 DT_WSTR 20 False
collaborator_ids_2 DT_WSTR 20 False
collaborator_ids_3 DT_WSTR 20 False
follower_ids DT_WSTR 1000 False
follower_ids_1 DT_WSTR 20 False
follower_ids_2 DT_WSTR 20 False
follower_ids_3 DT_WSTR 20 False
email_cc_ids DT_WSTR 1000 False
email_cc_ids_1 DT_WSTR 20 False
email_cc_ids_2 DT_WSTR 20 False
email_cc_ids_3 DT_WSTR 20 False
forum_topic_id DT_WSTR 255 False
problem_id DT_WSTR 255 False
has_incidents DT_BOOL 0 False
is_public DT_BOOL 0 False
due_at DT_DBTIMESTAMP 0 False
tags DT_WSTR 1000 False
tags_1 DT_WSTR 50 False
tags_2 DT_WSTR 50 False
tags_3 DT_WSTR 50 False
tags_4 DT_WSTR 50 False
tags_5 DT_WSTR 50 False
custom_fields DT_WSTR 1000 False
custom_fields_1_id DT_WSTR 20 False
custom_fields_1_value DT_WSTR 1000 False
custom_fields_2_id DT_WSTR 20 False
custom_fields_2_value DT_WSTR 1000 False
custom_fields_3_id DT_WSTR 20 False
custom_fields_3_value DT_WSTR 1000 False
custom_fields_4_id DT_WSTR 20 False
custom_fields_4_value DT_WSTR 1000 False
custom_fields_5_id DT_WSTR 20 False
custom_fields_5_value DT_WSTR 1000 False
via_followup_source_id DT_I8 0 False
satisfaction_rating_id DT_I8 0 False
satisfaction_rating_score DT_WSTR 20 False
satisfaction_rating_comment DT_WSTR 1000 False
sharing_agreement_ids DT_WSTR 255 False
fields DT_WSTR 1000 False
followup_ids DT_WSTR 1000 False
brand_id DT_I8 0 False
allow_channelback DT_BOOL 0 False
allow_attachments DT_BOOL 0 False
via_channel DT_WSTR 100 False
via_source_rel DT_WSTR 255 False
via_source_from_address DT_WSTR 500 False
via_source_from_name DT_WSTR 500 False
via_source_to_name DT_WSTR 500 False
via_source_to_address DT_WSTR 500 False
via_source_from_ticket_id DT_I8 0 False
via_source_from_subject DT_WSTR 1000 False
via_source_from_channel DT_WSTR 50 False
custom_field_[$parent.id$] DT_WSTR 4000 False

Input Columns

Label DataType Length Raw Description
subject DT_WSTR 1012 False
recipient DT_WSTR 255 False
status DT_WSTR 28 False
type DT_WSTR 255 False
priority DT_WSTR 24 False
comment_body DT_NTEXT 0 False
comment_body_html DT_NTEXT 0 False
comment_public DT_BOOL 0 False
comment_author_id DT_I8 0 False
tags DT_WSTR 1000 True
custom_fields DT_WSTR 1000 True
external_id DT_WSTR 255 False
requester_name DT_WSTR 255 False
requester_email DT_WSTR 255 False
requester_id DT_I8 0 False
submitter_id DT_I8 0 False
assignee_id DT_I8 0 False
organization_id DT_I8 0 False
group_id DT_I8 0 False
collaborator_ids DT_WSTR 1000 False
follower_ids DT_WSTR 1000 True
email_cc_ids DT_WSTR 1000 True
forum_topic_id DT_WSTR 255 False
problem_id DT_WSTR 255 False
is_public DT_BOOL 0 False
due_at DT_DBTIMESTAMP 0 False
sharing_agreement_ids DT_WSTR 255 True
fields DT_WSTR 1000 True
followup_ids DT_WSTR 1000 True
brand_id DT_I8 0 False
allow_channelback DT_BOOL 0 False
allow_attachments DT_BOOL 0 False