Returns apps available in the Zendesk Marketplace, including rating, pricing, and organization details.

View-Specific Information

Select

The following queries are processed server-side while other filters are processed client-side within the provider.

SELECT * FROM Apps
SELECT * FROM Apps WHERE Id = 1

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		The total number of ratings submitted for the app.
RatingAverage	Integer		The average rating of the app.
RatingCount	String		The total rating count for the app.
SingleInstall	Boolean		Indicates whether the 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		The Universal Google Analytics (UA-) tracking Id for the app's detail page on the Zendesk Marketplace.
RemoteInstallationUrl	String		The URL for the app's remote 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		The date and time when the app was created.
UpdatedAt	Datetime		The date and time when the app was last updated.
TermsConditionsUrl	String		URL for the app's terms and conditions.
AppOrganizationId	Integer		The Id of the organization that submitted the app to the Zendesk Marketplace.
AppOrganizationName	String		The name of the organization that submitted the app to the Zendesk Marketplace.
AppOrganizationEmail	String		The email address of the organization that submitted the app to the Zendesk Marketplace.
AppOrganizationWebsite	String		The website of the organization that submitted the app to the Zendesk Marketplace.
AppOrganizationCountryCode	String		The country code of the organization that submitted the app to the Zendesk Marketplace.
AppOrganizationStripeAccountId	String		The Stripe account Id of the organization that submitted the app to the Zendesk Marketplace.
Locations	String		The location Ids for the app.
DatePublished	Datetime		The date and time when the app was published on the Zendesk Marketplace.
HasThirdPartyPricing	Boolean		Indicates whether the app has third-party pricing information.
ThirdPartyPricingUrl	String		The URL for the app's third-party pricing page.
OwnerId	Long		The Id of the app developer who owns 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 visibility setting of the app, indicating whether it is private (visible only to the account) or public.
Promoted	Boolean		Indicates whether the app is promoted in the Zendesk Marketplace.
Featured	Boolean		Indicates whether the app is featured in the Zendesk Marketplace.
Paid	Boolean		Indicates whether the app is a paid app.
Deprecated	Boolean		Indicates whether the app is deprecated.
Obsolete	Boolean		Indicates whether the app is obsolete.
Installable	Boolean		Indicates whether the app can be installed.
MarketingOnly	Boolean		Indicates whether the app is a marketing-only integration app.
SmallIcon	String		The URL for the app's small logo icon.
LargeIcon	String		The URL for the app's large icon.
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 more granular control over the data returned from the data source.

Name	Type	Description
Owned	Boolean		Filters results to return only apps owned by the current account when set to true.