Retrieve the main properties of an application.

Table Specific Information

Select

The Apps table fetches the primary features of an application.

The add-in uses the Quickbase API to process search criteria when filtering by the Id column. All other filters are applied client-side within the add-in.

For example, the following queries are processed server side:

SELECT * FROM [Apps] 
SELECT * FROM [Apps] WHERE [Id] = 'bvadwmxrn';

Insert

The Quickbase add-in adds a new row to the Apps table with the specified column values.

For example:

INSERT INTO [Apps](Name, Description, AssignToken, SecurityPropertiesAllowClone, SecurityPropertiesAllowExport, SecurityPropertiesEnableAppTokens, SecurityPropertiesHideFromPublic,  SecurityPropertiesMustBeRealmApproved, SecurityPropertiesUseIPFilter, Variables) VALUES('MyApp2', 'app2 description', true, false, false, false, false, true, true, '[{"name":"Variable1","value":"Value1"},{"name":"Variable2","value":"Value2"}]');

Update

The Quickbase add-in modifies the row in the Apps table, where Id matches the specified value.

For example:

UPDATE [Apps] SET Name='MyAppFromAPI2', Description='Description of MyAppFromAPI2', Variables='[{"name":"Variable1","value":"ValueOfVariable1"},{"name":"Variable3","value":"Value3"}]' WHERE [Id] = 'bvajvby2n'

Note: Updating a non-existing app variable will insert it as a new app variable.

Delete

The Quickbase add-in removes rows from the Apps table where both the Id and Name match.

For example:

DELETE FROM [Apps] WHERE [Id] = 'bvajvby2n' AND [Name] = 'MyAppFromAPI2'

Columns

Name	Type	ReadOnly	References	SupportedOperators	Description
Id [KEY]	String	True		=	The unique identifier for this application.
Name	String	False		=	The name of the application.
Description	String	False			The description of the application.
TimeZone	String	True			The time zone used when displaying time values in this application.
DateFormat	String	True			The format used for displaying date values in the application.
Created	Datetime	True			The time and date the app was created, in the ISO 8601 time format YYYY-MM-DDThh:mm:ss.sssZ (in UTC time zone).
Updated	Datetime	True			The time and date the app was last updated, in the ISO 8601 time format YYYY-MM-DDThh:mm:ss.sssZ (in UTC time zone).
DataClassification	String	True			The data classification label assigned to the application.
HasEveryoneOnTheInternet	Boolean	True			Indicates if the application is accessible to everyone on the internet.
MemoryInfoEstMemory	Int64	True			The estimated memory usage of the application in gigabytes.
MemoryInfoEstMemoryInclDependentApps	Int64	True			The estimated memory usage including dependent applications in gigabytes.
SecurityPropertiesAllowClone	Boolean	False			Indicates if non-admin users can clone the application.
SecurityPropertiesAllowExport	Boolean	False			Indicates if non-admin users can export data from the application.
SecurityPropertiesEnableAppTokens	Boolean	False			Indicates if application tokens are required.
SecurityPropertiesHideFromPublic	Boolean	False			Indicates if the application is hidden from public searches.
SecurityPropertiesMustBeRealmApproved	Boolean	False			Indicates if only realm-approved users can access the application.
SecurityPropertiesUseIPFilter	Boolean	False			Indicates if access is restricted to approved IP addresses.
Variables	String	False			Variables available in this application.
AncestorId	String	True	Apps.Id		The Id of the source application from which this one was copied.

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
AssignToken	Boolean	Indicates if the application should be assigned to the user token used during creation (default: false).