EndPoint Read Tickets changed after date (Incremental)

Contents

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

Name

get_tickets_incr

Description

Get a list of tickets changed after specified date/time [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
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. Tickets 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)

Output Columns

Label	DataType	Length	Raw
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
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