Apps
Query Apps in Zendesk.
Table Specific Information
Select
The following queries are processed server side while other filters are processed client side within the connector.SELECT * FROM Apps SELECT * FROM Apps WHERE Id = 1
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The id of the app. | |
| Name | String | The name of the app. | |
| State | String | Publication state for the app on the Zendesk Marketplace. | |
| Version | String | The version of the app. | |
| FrameworkVersion | String | The app framework version for which the app was written. | |
| Parameters | String | The parameters for the app. | |
| Plans | String | Payment plans for the app. | |
| RatingTotalCount | Integer | Total count of the ratings of the app. | |
| RatingAvergae | Integer | Average rating of the app. | |
| RatingCount | String | Rating count of the app. | |
| SingleInstall | Boolean | Whether or not this app can only be installed once. | |
| DefaultLocale | String | The default locale for translations for the app. | |
| FeatureColor | String | Hexadecimal color value used to feature the app on the Zendesk Marketplace. | |
| GoogleAnalyticsCode | String | Universal Google Analytics (UA-) tracking id for the app's detail page on the Zendesk Marketplace. | |
| RemoteInstallationUrl | String | URL for the app's installation instructions. | |
| Products | String | Zendesk products supported by the app. | |
| Categories | String | Zendesk Marketplace categories to which the app belongs. | |
| Collections | String | Zendesk Marketplace collections to which the app belongs. | |
| StripePublishableKey | String | Publishable key for the app developer's Stripe account. | |
| CreatedAt | Datetime | When the app was created. | |
| UpdatedAt | Datetime | When the app was last updated. | |
| TermsConditionsUrl | String | URL for the app's terms and conditions. | |
| AppOrganizationId | Integer | Organization Id that submitted the app to the Zendesk Marketplace. | |
| AppOrganizationName | String | Organization name that submitted the app to the Zendesk Marketplace. | |
| AppOrganizationEmail | String | Organization email that submitted the app to the Zendesk Marketplace. | |
| AppOrganizationWebsite | String | Organization website that submitted the app to the Zendesk Marketplace. | |
| AppOrganizationCountryCode | String | Organization country code that submitted the app to the Zendesk Marketplace. | |
| AppOrganizationStripeAccountId | String | Organization Stripe account id that submitted the app to the Zendesk Marketplace. | |
| Locations | String | Location ids for the app. | |
| DatePublished | Datetime | When the app was published on the Zendesk Marketplace. | |
| HasThirdPartyPricing | Boolean | Third-party pricing information for the app. | |
| ThirdPartyPricingUrl | String | Third-party pricing url for the app. | |
| OwnerId | Long | The app developer id corresponding to the app. | |
| AuthorName | String | The app author's name. | |
| AuthorEmail | String | The app author's email. | |
| AuthorUrl | String | The app author's URL. | |
| ShortDescription | String | The short description of the app in the Zendesk Marketplace. | |
| LongDescription | String | The app's long description in the Zendesk Marketplace. | |
| InstallationInstructions | String | Instructions for installing the app. | |
| RawLongDescription | String | The raw long description for the app in the Zendesk Marketplace. | |
| RawInstallationInstructions | String | The raw installation instructions. | |
| Visibility | String | The app is a private app, which is only visible to your account, or a public app. An example value is 'private'. | |
| Promoted | Boolean | Whether or not the app is a promoted app in the Zendesk Marketplace. | |
| Featured | Boolean | Whether or not the app is featured in the Zendesk Marketplace. | |
| Paid | Boolean | If true, the app is a paid app. | |
| Deprecated | Boolean | If true, the app is deprecated. | |
| Obsolete | Boolean | If true, the app is obsolete. | |
| Installable | Boolean | Whether or not the app can be installed. | |
| MarketingOnly | Boolean | If true, the app is an integration app. | |
| SmallIcon | String | The url for the small logo for the app. | |
| LargeIcon | String | The large icon url for an app. | |
| Screenshots | String | Screenshots for the app when displayed in the Zendesk Marketplace. | |
| InstallationCount | Integer | Current number of installations of the app. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| Owned | Boolean | Boolean value that needs to be set when you want to lists the apps owned by the current account. |