Acceldata
ADOC

SQL View Schema

Returned by SQL Views.

Top-level Fields

Field

Type

Description

id

integer

SQL view ID

name

string

View name

query

string

SQL definition

assemblyId

integer

Source assembly

assetTypeId

integer

Asset type

Example JSON

{ 
 "id": 501, 
 "name": "regional_sales", 
 "query": "SELECT * FROM orders" 
}