Create, update, delete, and query from contacts table
Table Specific Information
The component will use the FreshDesk API to process WHERE clause conditions built with the following columns and operators. Most of the columns support server side filtering with the following operators: = > < <= >= AND OR. The rest of the filter is executed client side within the component.
For example, the following query is processed server side:
SELECT * FROM Contacts WHERE Active = false AND (Email = 'firstname.lastname@example.org' OR CompanyId = 1)
The API allows only a subset of columns to be used as filter criteria in the WHERE clause. The following columns can be used:
Note: To filter all contacts created on a specific day (e.g: 2019-09-23), query should be structured as:
WHERE CreatedAt >= '2019-09-22' AND CreatedAt <= '2019-09-24'
Name and Email are mandatory for creating a new contact. Following is an example of creating a new contact:
INSERT INTO Contacts (Name, Email, Language) Values ('Example', 'email@example.com', 'English')
Following is an example of how to update a contact:
UPDATE Contacts SET Active = true WHERE Id = 786
Following is an example of how to delete from Contacts table:
DELETE FROM Contacts WHERE Id = 786
True if contact has been verified.
Address of the contact.
Id of primary company of the contact.
Contact creation timestamp.
Key value pairs containing the names and values of custom fields
True if the contact has been deleted.
A short description of the contact.
Email of the contact.
ID of the contact.
Job title of the contact.
Language of the contact.
Name of the contact.
Additional emails associated with the contact.
Telephone number of the contact.
Time zone of the contact.
Tag associated with the contact.
Contact updated timestamp.
True if the contact can see all tickets that are associated with the company to which he belong.