Reports
To query all the Reports.
View-Specific Information
Select
The driver uses the Shopify API to process search criteria that refer to the Id and UpdatedAt columns. The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.
For example, the following queries are processed server side.
SELECT * FROM Reports
SELECT * FROM Reports WHERE Id = '123'
SELECT * FROM Reports WHERE UpdatedAt > '2017-10-25'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | The unique numeric identifier for the report. | |
| Name | String | The name of the report. | |
| ShopifyQl | String | The ShopifyQL query that generates the report. | |
| UpdatedAt | Datetime | The date and time (ISO 8601) when the report was last modified. | |
| Category | String | The category for the report. When you create a report, the API will return custom_app_reports. |