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
}