xMatters DataSet

Create-xMatters-DataSet.json

{
  "name": "xMatters",
  "tables": [
  {
    "name": "xMattersUsers",
      "columns": [
        { "name": "officeLocation", "dataType": "string"  },	
        { "name": "displayName", "dataType": "string" },
        { "name": "accountName", "dataType": "string"},
        { "name": "city", "dataType": "string" },
        { "name": "company", "dataType": "string"  },					
        { "name": "department", "dataType": "string"  },					
        { "name": "division", "dataType": "string"  },					
        { "name": "employeeType", "dataType": "string"  },					
        { "name": "employeeActive", "dataType": "Boolean"  },
        { "name": "managerID", "dataType": "string"  },	
        { "name": "managerName", "dataType": "string" },																						
        { "name": "postalCode", "dataType": "string"  },					
        { "name": "state", "dataType": "string"  },					
        { "name": "street", "dataType": "string"  },					
        { "name": "timezone", "dataType": "string" },					
        { "name": "title", "dataType": "string"  }	
      ]
   },
    {
      "name": "xMattersSites",
        "columns": [
          { "name": "displayName", "dataType": "string" },
          { "name": "geo", "dataType": "string" },
          { "name": "longitude", "dataType": "string" },
          { "name": "latitude", "dataType": "string" }
        ]
    }
  ],
  "relationships": [
    {
      "name": "xMattersUsers_xMattersSites_REL",
      "crossFilteringBehavior": "BothDirections",
      "fromTable": "xMattersUsers",
      "fromColumn": "officeLocation",
      "toTable": "xMattersSites",
      "toColumn": "displayName"
    }
  ]
}