Query and filter vehicles as a spreadsheet

Request

POST http:///fleet.roadprotect.co.il/api/v1/query/vehicle/spreadsheet

Query parameters

Parameter name Value Description Additional
mine string
via string

Possible values are:

  • all
  • owned
  • using
  • infringementProjectionsContracts
  • infringementProjectionsInfringements
  • infringementProjectionsWithoutInfringements
  • infringementProjectionsNoContracts
graphing string

Possible values are:

  • true
  • false
accountRole string

Possible values are:

  • owner
  • user
  • hybrid
startDate string
endDate string

Request body

The request body takes a complete AdvancedTableColumn resource, containing the following writable properties:

[
    {
        "isDisplaying": "boolean",
        "key": "string",
        "spreadsheetFormat": "string",
        "spreadsheetKey": "string",
        "title": "string"
    }
]

Properties

Name Type Description Additional
isDisplaying boolean
key string
spreadsheetFormat string

Possible values are:

  • currency
  • date
  • number
  • default
spreadsheetKey string
title string

Authorisation

To authenticate your client integration please put your token in the header of your requests with the key Authorization, it should look like this:

Authorization: Bearer YOUR_TOKEN_HERE

Please keep your token secured. If your token is compromised, we can issue a new token for you.

This request requires the use of one of following authorisation methods: API key .

Response

The following HTTP status codes may be returned, optionally with a response resource.

Status code Description Resource
201 Created Buffer
400 Bad Request

E112: No data to export to spreadsheet
401 Unauthorized

Unauthorized
500 Internal Server Error

Invalid query parameters