Create, update, delete, and query from contacts table

Table Specific Information

Select

The add-in 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 add-in.

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