QuerySourceΒΆ

Field NULL Description Note
id
string (GUID)
  The id  
name
string
  The query source name qualified with schema name
Example: dbo.Table1
 
realName
string
  The name of the query source  
type
string
  Either “Table”, “View”, “Stored Procedure” or “Function”  
parentQuerySourceId
string (GUID)
Y Place-holder  
categoryId
string (GUID)
Y The id of the category (user schema)  
selected
boolean
  Is this query source selected in data model  
deleted
boolean
  Is this query source removed from data model  
connectionId
string (GUID)
  The id of the connection containing the query source  
connectionName
string
  The name of the connection containing the query source  
childs
array of objects
Y An array of children QuerySource objects if available  
dataSourceCategoryId
string (GUID)
Y The id of the data source category containing the query source  
dataSourceCategoryName
string
  The name of the data source category containing the query source  
alias
string
  The alias entered by user  
originalAlias
string
  The original alias  
querySourceFields
array of objects
  An array of QuerySourceField objects  
querySourceCategoryName
string
  The schema name  
querySourceCategory
object
  A QuerySourceCategory object (schema)  
modified
datetime in ISO 8601 format
Y The modification time  
extendedProperties
string
  The extended properties if available (for stored procedures)  
physicalChange
integer
 

Has the query source changed

  • 0 = None
  • 1 = Added
  • 2 = Modified
  • 3 = Deleted
 
approval
integer
 

Whether the changes in data source have been approved by user or not

  • 0 = The change is still pending for approval
  • 1 = The change is at Query Source level
  • 2 = The change is at Query Source Field level
 
existed
boolean
  Exist flag  
checked
boolean
  Is selected for copy in Copy Management  
belongToCopiedReport
boolean
  Whether this query source belongs to a copied report  
customDefinition
string
  Definition of the view in case this is a custom query source  
isCustomQuerySource
boolean
  Whether this is a custom query source  
disable
boolean
  Whether this query source is a real query source and has a custom query source which has the same name  
Sample:
{
   "id" : "24fa8fec-afe0-489d-b036-aaca514a7a0b",
   "name" : "dbo.CustomerDemographics",
   "type" : "Table",
   "parentQuerySourceId" : null,
   "categoryId" : null,
   "selected" : false,
   "connectionId" : "48733501-c57d-48ca-aded-501d5ebdaad9",
   "connectionName" : "Northwind",
   "childs" : null,
   "dataSourceCategoryId" : "feb74cd9-bc6d-4933-bf72-296b394d0f77",
   "dataSourceCategoryName" : "Cat_Customer",
   "alias" : "Cus_D",
   "querySourceFields" : [],
   "querySourceCategory" : null,
   "modified" : null,
   "extendedProperties" : null,
   "physicalChange" : 0,
   "approval" : 0,
   "existed" : false
}