SSIS Components for Freshdesk

Build 24.0.9063

Products

Query from products table

Table Specific Information

Note: Only users with admin privileges can access the following Table.

Select

Following is an example to select all entries from Products table:

SELECT * FROM Products

You can also select a specific entry from Products table:

SELECT * FROM Products WHERE Id = 100

Columns

Name Type ReadOnly Description
Id [KEY] Bigint False

Product ID.

Description String True

Description of the product.

Name String True

Name of the product.

CreatedAt Datetime True

Product creation timestamp.

UpdatedAt Datetime True

Product updated timestamp.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063