EndPoint Search Records - NO Sorting (Allows more than 1000 rows)

Name

get_search_export

Description

Search for ticket, user, organization, or group for specified search criteria. Sorting not allowed but you can get more than 1000 records unlike other endpoint for search which supports max 1000 rows but allows sorting if needed. [API reference]

Parameters

Parameter

Label

Required

Options

Description

query

Search Criteria

YES

Option	Value
Example: Search by Ticket ID	112233
Example: Search by Ticket Status	status
Example: Search by Some Text	SomeText
Example: Search By Status	SomeText
Example: Search by Type and Status	type:ticket status:open
Example: Search by Type and Name	type:user "Jane Doe"
Example: Search by Type and CreationDate	type:organization created< 2015-05-01
Example: Search organizations updated after some date	type:organization updated > 2015-05-01
Example: Search users updated after some date	type:user updated > 2015-05-01
Example: Search By Type and Tag	type:ticket tags:red tags:blue

The search query based on this syntax https://support.zendesk.com/hc/en-us/articles/203663226

FilterType

Option	Value
ticket	ticket
organization	organization
user	user
group	group

PageSize

Records Per Page (Max 100)

Output Columns

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.

Input Columns

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.

Examples

SSIS

Use Zendesk Connector in API Source component to read data or in API Destination component to read/write data:

Search Records - NO Sorting (Allows more than 1000 rows) using API Source

Zendesk

Search Records - NO Sorting (Allows more than 1000 rows)

SSIS API Source - Read from table or endpoint

Search Records - NO Sorting (Allows more than 1000 rows) using API Destination

Zendesk

Search Records - NO Sorting (Allows more than 1000 rows)