ADO.NET Provider for FreshDesk

Build 20.0.7587

Companies

Create, update, delete, and query from companies table

Table Specific Information

Select

The {i 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 {i. 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:

  • Id
  • DomainAggregate
  • CreatedAt
  • UpdatedAt

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' 

Insert

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')

Update

Following is an example of how to update a company:

UPDATE Companies SET Description = 'New description' WHERE Id = 786

Delete

Following is an example of how to delete from Companies table:

DELETE FROM Companies WHERE Id = 786

Columns

Name Type ReadOnly Description
Id [KEY] Bigint False

ID of the company.

Name String False

Name of the company.

Description String False

Description of the company.

DomainsAggregate String False

Domains associated with the company.

Note String False

Any notes about the company.

HealthScore String False

The strength of your relationship with the company.

AccountTier String False

Classification based on how much value the company brings to your business.

RenewalDate Date False

Date when your contract or relationship with the company is due for renewal.

Industry String False

The industry the company serves in.

CreatedAt Datetime True

Company creation timestamp.

UpdatedAt Datetime True

Company updated timestamp.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587