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
|
||
| approval integer |
Whether the changes in data source have been approved by user or not
|
||
| 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}