Get Records Count

Description

FreshDesh: Get Records Count step will retrieve the count of FreshDesk records matching the criteria query.

Reference

To check the Field Value type required for the specified Field Name supported for the given Form Name, use the following links: https://developers.freshdesk.com/api/#filter_tickets

Configurations

No.	Field Name	Description
1	Step Name	Specify the name of the step. This name has to be unique in a single workflow.
	Connection:
2	Base URL	Specify the base URL of the FreshDesk cloud instance. For example, https://XXXXX. freshdesk.com. The field data type is String. This field is mandatory.
3	Accept value as variable/static	Leave checkbox unchecked to accept API Key value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for API Key field to appear as text box.
4	API Key	Specify the API Key to authenticate FreshDesk cloud instance. The field data type is String. This field is mandatory.
5	Test Connection	Verifies whether the connection is established or not. Note: For the purpose of verification, fields coming from previous steps are not allowed since field values can only be accessed when workflow is in running state. The Test Connection button will only work with static (hardcoded) values and environment variables.
	Input Fields:
1	Form Name	Specify the name of the form to get the count of matching records. The field data type is String. This field is mandatory.
2	Criteria Query	Provide the criteria query to fetch all FreshDesk records. For sample criteria query, see Annexure.
	Output Fields:
1	Total Records	Holds the count of records returned by given criteria. Default value: TotalRecords

Annexure

(ticket_field:integer OR ticket_field:'string') AND ticket_field:boolean Sample criteria query

• priority:3
• status:3 OR status:4
• group_id:11
• (type:'Question' OR type:'Problem') AND (due_by:>'2017-10-01' AND due_by:<'2024-10-07')