DataModelSchemaΒΆ

Field NULL Description Note
querySources
array of objects
  An array of QuerySourceSchema objects  
relationships
array of objects
  An array of RelationshipSchema objects  
Sample:
{
   "querySources": [{
      "id": "8aa52ba9-8324-4b8e-bf42-619a3f050aa5",
      "name": "dbo.Customers",
      "type": "Table",
      "color": null,
      "connectionId": "8195a480-ddd8-4915-95a0-432e24fed0ad",
      "modified": "2016-04-19T03:08:56.091528",
      "fields": [{
           "name": "ContactName",
           "properties": ""
      }, {
           "name": "CustomerID",
           "properties": "{\"PrimaryKey\":true}"
      }]
   }, {
      "id": "66dcf36e-e4b0-4c9b-9919-b9ba49377784",
      "name": "dbo.Orders",
      "type": "Table",
      "color": null,
      "connectionId": "8195a480-ddd8-4915-95a0-432e24fed0ad",
      "modified": "2016-12-19T03:08:56.091528",
      "fields": [{
           "name": "CustomerID",
           "properties": ""
      }, {
           "name": "OrderDate",
           "properties": ""
      }, {
           "name": "OrderID",
           "properties": "{\"PrimaryKey\":true}"
      }]
   }, {
      "id": "26efbdf4-c724-4824-bd9c-6ae1e2dc7435",
      "name": "dbo.Order Details",
      "type": "Table",
      "color": null,
      "connectionId": "8195a480-ddd8-4915-95a0-432e24fed0ad",
      "modified": "2016-12-19T03:08:56.091528",
      "fields": [{
           "name": "OrderID",
           "properties": "{\"PrimaryKey\":true}"
      }, {
           "name": "ProductID",
           "properties": "{\"PrimaryKey\":true}"
      }, {
           "name": "Quantity",
           "properties": ""
      }, {
           "name": "UnitPrice",
           "properties": ""
      }]
   }],
   "relationships": [{
      "joinQuerySourceId": "8aa52ba9-8324-4b8e-bf42-619a3f050aa5",
      "foreignQuerySourceId": "66dcf36e-e4b0-4c9b-9919-b9ba49377784",
      "twoWays": false
   }, {
      "joinQuerySourceId": "66dcf36e-e4b0-4c9b-9919-b9ba49377784",
      "foreignQuerySourceId": "26efbdf4-c724-4824-bd9c-6ae1e2dc7435",
      "twoWays": true
   }]
}