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}