Create, update, delete, and query from contacts table

Table Specific Information

Select

The connector uses 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 connector.

For example, the following query is processed server-side:

SELECT * FROM Contacts WHERE Active = false AND (Email = '[email protected]' 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:

• Id
• Active
• CompanyId
• Email
• Language
• Tag
• TimeZone
• CreatedAt
• UpdatedAt

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'

Additional Filtering

You can use the SearchEmail column to search by secondary or alternate emails. When included in a query, the value provided is returned in the results for clarity. If no search term is specified, the column is empty.

For example:

SELECT * FROM Contacts WHERE SearchEmail='@outlook.com'

Do not combine Email and SearchEmail in the same WHERE clause.

Insert

Name and Email are mandatory for creating a new contact. The following is an example of creating a new contact:

INSERT INTO Contacts (Name, Email, Language) VALUES ('Example', '[email protected]', 'English')

Update

The following is an example of how to update a contact:

UPDATE Contacts SET Active = true WHERE Id = 786

Delete

The following is an example of how to delete a contact:

DELETE FROM Contacts WHERE Id = 786

Columns