ReportDataSourceConnectionΒΆ

Field NULL Description Note
id
string (GUID)
Y The id of the object  
name
string
  The name of the connection  
querySource
array of objects
  An array of ReportQuerySource objects  
serverTypeId
string
  The id of the server type  
serverTypeName
string
  The type of the server  
Sample:
{
   "id": "83554d8c-3383-42b6-be73-0bb31cdb40db",
   "name": "Northwind-MSSQL",
   "querySource": [{
      "connectionId": "83554d8c-3383-42b6-be73-0bb31cdb40db",
      "connectionName": "Northwind-MSSQL",
      "dataSourceCategoryId": "518033c3-9db5-4ac1-9cb0-c4581d052b76",
      "dataSourceCategoryName": "MSSQL",
      "fields": [{
         "alias": "",
         "allowDistinct": true,
         "allowToSave": false,
         "approval": 0,
         "calculatedTree": null,
         "categoryName": null,
         "checked": false,
         "created": null,
         "createdBy": "System Admin",
         "dataBaseType": 0,
         "dataType": "int",
         "deleted": false,
         "existed": false,
         "expression": null,
         "expressionFields": [],
         "extendedProperties": null,
         "filterLookupStatus": 0,
         "filterLookupType": 0,
         "filterable": true,
         "filteredValue": "{}",
         "fullName": null,
         "fullPath": null,
         "functionName": null,
         "groupPosition": 0,
         "hasAggregatedFunction": false,
         "hasSupportDefaultTotal": true,
         "id": "7de99693-eb74-4209-80b4-12b530837211",
         "inaccessible": false,
         "inputFeatures": null,
         "inserted": true,
         "isAlias": false,
         "isCalculated": false,
         "isCheck": false,
         "isCompositeField": false,
         "isParameter": false,
         "isPredicated": false,
         "isRunningField": false,
         "izendaDataType": "Numeric",
         "matchedTenant": false,
         "modelName": null,
         "modified": "0001-01-01T00:00:00",
         "modifiedBy": null,
         "name": "OrderID",
         "originalAlias": null,
         "originalId": "00000000-0000-0000-0000-000000000000",
         "originalName": "OrderID",
         "parentId": null,
         "physicalChange": 0,
         "position": 0,
         "querySource": null,
         "querySourceId": "ec16146f-5873-4146-9a89-3c7b36f2d1bf",
         "querySourceName": null,
         "relationColumn": null,
         "reportId": null,
         "state": 0,
         "supportDefaultTotal": null,
         "targetValue": null,
         "type": 0,
         "version": null,
         "visible": true
      }, {
         "alias": "",
         "allowDistinct": true,
         "allowToSave": false,
         "approval": 0,
         "calculatedTree": null,
         "categoryName": null,
         "checked": false,
         "created": null,
         "createdBy": "System Admin",
         "dataBaseType": 0,
         "dataType": "nchar",
         "deleted": false,
         "existed": false,
         "expression": null,
         "expressionFields": [],
         "extendedProperties": null,
         "filterLookupStatus": 0,
         "filterLookupType": 0,
         "filterable": true,
         "filteredValue": "{}",
         "fullName": null,
         "fullPath": null,
         "functionName": null,
         "groupPosition": 0,
         "hasAggregatedFunction": false,
         "hasSupportDefaultTotal": true,
         "id": "bb2f13f3-eba8-45bc-90ea-cac543691c04",
         "inaccessible": false,
         "inputFeatures": null,
         "inserted": true,
         "isAlias": false,
         "isCalculated": false,
         "isCheck": false,
         "isCompositeField": false,
         "isParameter": false,
         "isPredicated": false,
         "isRunningField": false,
         "izendaDataType": "Text",
         "matchedTenant": false,
         "modelName": null,
         "modified": "0001-01-01T00:00:00",
         "modifiedBy": null,
         "name": "CustomerID",
         "originalAlias": null,
         "originalId": "00000000-0000-0000-0000-000000000000",
         "originalName": "CustomerID",
         "parentId": null,
         "physicalChange": 0,
         "position": 0,
         "querySource": null,
         "querySourceId": "ec16146f-5873-4146-9a89-3c7b36f2d1bf",
         "querySourceName": null,
         "relationColumn": null,
         "reportId": null,
         "state": 0,
         "supportDefaultTotal": null,
         "targetValue": null,
         "type": 0,
         "version": null,
         "visible": true
      }],
      "id": "ec16146f-5873-4146-9a89-3c7b36f2d1bf",
      "isAlias": false,
      "isCheck": false,
      "isDynamic": false,
      "name": "Orders",
      "numOfCheckedChilds": 0,
      "numOfChilds": 2,
      "originalName": "Orders",
      "querySourceCategoryName": "dbo",
      "selected": false,
      "visible": true,
      "type": "Table"
   }],
   "serverTypeId": "572bd576-8c92-4901-ab2a-b16e38144813",
   "serverTypeName": "MSSQL",
}