Application

The Application table contains applications that are available for deployment to users.

Column

Type

Description

Name

LocalizedString

Application name.

DisplayName

LocalizedString

Application display name.

Icon

String

Path of application icon image.

Description

LocalizedString

Application description.

Handler

String

Application handler.

TemplateName

String

Application template name.

AppType

String

Application type.

AppTypeDisplayName

String

Display name of application type.

WebAppType

String

Application web-app-type.

WebAppTypeDisplayName

String

Display name of application web-app-type.

State

String

Application state.

IsTestApp

Boolean

Whether this application is for testing only.

CorpIdentifier

String

An additional field required for login. For example, Company ID, organization code, sub-domain of a login URL, etc.

Brand

String

A specific brand name that this application is made for.

NotSelfService

Boolean

Whether this application must be configured by a Cloud Admin.

Generic

Boolean

Whether this application is implemented using a generic application template.

OnPrem

Boolean

Whether this application can be hosted on-premise.

IsGatewayed

Boolean

Whether this application is using App Gateway.

ShadowAppLink

String

Rowkey for this Gateway Shadow SAML application.

Featured

Boolean

Whether this application is featured.

Popular

Boolean

Whether this application is popular.

Category

LocalizedString

Category of this application.

Admintag

String

Application admin tag.

MobileAppSource

String

Source of this mobile application. For example, "App Store", "InHouse", "Unknown".

MobileAppType

String

Mobile application type. Target platform of this mobile application. For example, "Android", "Ios", "OSX", "Unknown".

Version

String

Version of this application.

VersionName

String

Version name or information of this application. For example, "5.1.0" or "Varies with device".

IsMarketplaceApp

Boolean

Whether this application comes from Samsung Knox Marketplace.

ProvCapable

Boolean

Whether this application is capable of User Provisioning.

ProvSettingEnabled

Boolean

Whether User Provisioning is enabled on this application.

ProvSettingPreview

Boolean

Whether User Provisioning is in Preview Mode.

ProvConfigured

Boolean

Whether User Provisioning has been configured.

Example Query

The following query searches for entries with 'test' in the name.

{Script: "Select * FROM Application 
    WHERE Name LIKE '%test%' 
    ORDER BY State COLLATE NOCASE"}

The query displays the following entries in the Application table, ordered by State.

Application table query response:

"Success": true,
"Result":
{
...
"FullCount": 2,
"Results": [
  {
    "Entities": [
      {
        "Type": "Application",
        "Key": "********-****-****-****-**************",
        "IsForeignKey": false
      }
    ],
    "Row": {
      "Featured": null,
      "ProvSettingPreview": null,
      "Category": "Social Media",
      "Name": "Test Facebook",
      "MobileAppType": null,
      "DisplayName": "Facebook",
       "AppTypeDisplayName": "Web - User Password",
      "OnPrem": null,
      "ID": "********-****-****-****-**************",
      "ShadowAppLink": null,
      "Description": "Facebook is a social utility that connects people with friends
                     and others who work, study and live around them.",
      "ProvConfigured": null,
      "Version": null,
      "IsGatewayed": null,
      "Generic": false,
      "CorpIdentifier": null,
      "MobileAppSource": null,
      "Brand": null,
      "AppType": "Web",
      "Icon": "/vfslow/lib/application/icons/facebook",
      "WebAppTypeDisplayName": "User Password",
      "IsTestApp": null,
      "WebAppType": "UsernamePassword",
      "ProvSettingEnabled": null,
      "TemplateName": "Facebook",
      "Admintag": "Social Media",
      "IsMarketplaceApp": null,
      "Handler": "cloudlib;Idaptive.Saas.apphandlers.BrowserExtensionHandler",
      "State": "Active",
      "NotSelfService": null,
      "_MatchFilter": null,
      "VersionName": null,
      "Popular": null,
      "ProvCapable": null
    }
  },
  {
    "Entities": [
      {
         "Type": "Application",
        "Key": "********-****-****-****-**************",
        "IsForeignKey": false
       }
    ],
    "Row": {
      "Featured": null,
      "ProvSettingPreview": null,
      "Category": "Design",
      "Name": "TEST Cageapp",
      "MobileAppType": null,
      "DisplayName": "Cageapp",
      "AppTypeDisplayName": "Web - User Password",
      "OnPrem": null,
      "ID": "********-****-****-****-**************",
       "ShadowAppLink": null,
      "Description": "Collaboration just got a whole lot easier. A simple way for designers and teams to share, manage and approve their creative work.",
       "ProvConfigured": null,
      "Version": null,
      "IsGatewayed": null,
      "Generic": false,
      "CorpIdentifier": "",
      "MobileAppSource": null,
      "Brand": null,
      "AppType": "Web",
      "Icon": "/vfslow/lib/Application/Icons/cageapp",
      "WebAppTypeDisplayName": "User Password",
      "IsTestApp": null,
      "WebAppType": "UsernamePassword",
      "ProvSettingEnabled": null,
      "TemplateName": "Cageapp",
      "Admintag": "Software Development",
      "IsMarketplaceApp": null,
       "Handler": "cloudlib;Idaptive.Saas.apphandlers.UserPass",
      "State": "Active",
      "NotSelfService": null,
      "_MatchFilter": null,
      "VersionName": null,
      "Popular": null,
      "ProvCapable": null
    }
  }
}