Sample Request and Response

It is best to look at the "shape" of a sample request and response before discussing its structure in detail.

GET /api/odata/1.0/AgentProcedureStatuses HTTP/1.1
Host: 10.10.32.110
Authorization: Basic QWxhZGRpbjpvcGVuIHNlc2FtZQ==

The JSON response from the Kaseya VSA Data Warehouse API looks like this:

{  "@odata.context": "https://reporting-develop-vsa.dev.kaseya.net/api/odata/1.0/$metadata#AgentProcedureStatuses",  
"value": [
    {      
     "AgentId": "118551706373495", 
     "PartitionId": "1", 
     "ProcedureName": "Baseline Application Audit",
      "ProcedureId": 2007,
      "LastExecutionDateTime": "2021-11-08T00:30:53.087-08:00",
      "LastExecutionStatus": "Script Summary: Success THEN", 
     "ActionUser": "'"    
}
]
}

The Result field in the response contains one or more records of business data.

Security

Each API call returns only data for a single tenant/partition. Partition id is derived from user’s token partition. Records are returned by a request is limited by the scope and role of the VSA user, which was used to generate the API access token.