Zendesk Connector
Documentation
Version: 9
Documentation
Home » API Integration Hub » Zendesk Connector » EndPoints > Read Tickets (Incremental) changed after a specified date

EndPoint Read Tickets (Incremental) changed after a specified date

Name

get_tickets_incr

Description

Get a list of tickets changed after a specified date/time. If you use this endpoint to read data and insert to destination like SSIS Upsert Destination (ZappySys Product) then make sure you do not select delete option on Upsert UI. Only choose Update + Insert for Incremental fetch. [API Help]

Parameters

Parameter Label Required Options Description
start_time Start Time (e.g. yyyy-MM-dd -OR- yyyy-MM-ddTHH:mm:ss) YES
Option Value
now now
now-5h now-5h
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2022-01-31 2022-01-31
2022-01-31 23:59:59 2022-01-31 23:59:59
Start DateTime for data fetch. Records modified after this date/time is fetched. You can enter date in yyyy-MM-dd or yyyy-MM-ddTHH:mm:ss format. You can also use functions to get date. Supported functions now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start), now-5h (current time minus 5 hours), today-1m (today minus one month)
exclude_deleted Exclude Deleted NO
Option Value
true true
false false
Whether or not you'd like to exclude deleted tickets from the response
per_page Page Size (Default 1000) NO Number of results to return per page, up to a maximum of 1,000. If the parameter is not specified, the default number is 1,000.

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