Create, update, delete, and query from companies 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 Companies WHERE CreatedAt >= '2017-10-01' AND CreatedAt <= '2017-10-07'
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 companies 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 is mandatory for creating a new company. Following is an example of creating a new company:
INSERT INTO Companies (Name, Description) Values ('Example', 'Example description of new company')
Following is an example of how to update a company:
UPDATE Companies SET Description = 'New description' WHERE Id = 786
Following is an example of how to delete from Companies table:
DELETE FROM Companies WHERE Id = 786
Classification based on how much value the company brings to your business.
Company creation timestamp.
Key value pairs containing the names and values of custom fields
Description of the company.
Domains associated with the company.
The strength of your relationship with the company.
ID of the company.
The industry the company serves in.
Name of the company.
Any notes about the company.
Date when your contract or relationship with the company is due for renewal.
Company updated timestamp.