DataModelΒΆ

Field NULL Description Note
querySources
array of objects		   An array of QuerySource objects  
tenantId
string (GUID)		 Y The id of the tenant if available  
Sample:
{
  "tenantId" : null,
  "querySources" : [{
        "id" : "c3330d53-cd8d-411c-9e7d-05849c7f2cc3",
        "name" : "dbo.AWBuildVersion",
        "type" : "Table",
        "parentQuerySourceId" : null,
        "categoryId" : null,
        "selected" : false,
        "connectionId" : "828e10df-dedb-42f6-8adf-b0785810837e",
        "connectionName" : "AdventureWorks2008R2",
        "childs" : null,
        "dataSourceCategoryId" : null,
        "dataSourceCategoryName" : null,
        "alias" : null,
        "querySourceFields" : [{
              "id" : "dc4eca5c-ec25-4721-9f72-f98813f9b116",
              "name" : "VersionDate",
              "alias" : "",
              "dataType" : "datetime",
              "visible" : true,
              "filterable" : true,
              "deleted" : false,
              "querySourceId" : "c3330d53-cd8d-411c-9e7d-05849c7f2cc3",
              "parentId" : null,
              "children" : null,
              "modified" : "2016-04-06T04:20:37",
              "filteredValue" : "{}",
              "type" : 0,
              "position" : 0,
              "extendedProperties" : "",
              "physicalChange" : 0,
              "approval" : 0,
              "existed" : false,
              "matchedTenant" : false
           }, {
              "id" : "a3466647-d30b-4b21-868d-c05d074cba66",
              "name" : "Database Version",
              "alias" : "dbversion",
              "dataType" : "nvarchar",
              "visible" : true,
              "filterable" : true,
              "deleted" : false,
              "querySourceId" : "c3330d53-cd8d-411c-9e7d-05849c7f2cc3",
              "parentId" : null,
              "children" : null,
              "modified" : "2016-04-06T04:20:37",
              "filteredValue" : "{}",
              "type" : 0,
              "position" : 0,
              "extendedProperties" : "",
              "physicalChange" : 0,
              "approval" : 0,
              "existed" : false,
              "matchedTenant" : false
           }
        ],
        "querySourceCategory" : null,
        "modified" : null,
        "extendedProperties" : "{}",
        "physicalChange" : 0,
        "approval" : 0,
        "existed" : false
     }, {
        "id" : "f5e3450b-2b5b-4388-bce3-05efba5b8311",
        "name" : "dbo.Categories",
        "type" : "Table",
        "parentQuerySourceId" : null,
        "categoryId" : null,
        "selected" : false,
        "connectionId" : "8143ad74-fa73-4224-9299-b115252e1cc7",
        "connectionName" : "Northwind2014",
        "childs" : null,
        "dataSourceCategoryId" : "014e42b4-979a-4a7f-80cf-492142572d10",
        "dataSourceCategoryName" : "test",
        "alias" : "Cats",
        "querySourceFields" : [],
        "querySourceCategory" : null,
        "modified" : null,
        "extendedProperties" : "{}",
        "physicalChange" : 0,
        "approval" : 0,
        "existed" : false
     }
  ]
}