GET /DB/Maint/{table}
Authorization key & Authorization date & Authorization hmac

Retrieve all records from the table

Path parameters

  • table string Required

    Name of the case insensitive database table. Available table names for the Maintenance database are shown below

    Values are Item, Class, Mfg, Type, Task, Process, ProcImg, Remind, Supply, Tool, or Setting.

Query parameters

  • PageLimit integer

    Maximum number of records to return

    Maximum value is 100. Default value is 25.

  • apiConsolidate integer

    Consolidate to remove empty values. To see all fields that can be returned, set this to 0

    Values are 0 or 1. Default value is 1.

  • ApiPage integer

    Page number to display

    Default value is 1.

  • SearchField string

    Field to search in (defaults to name or primary display field)

  • SortField string

    An optional field to sort by. If brief is enabled, it will add () to the end of the searchfield.

  • SortOrder string

    An optional Sort order. Defaults to ASC

    Values are asc or desc. Default value is asc.

Responses

  • 200 application/json

    Successful response

    Hide response attributes Show response attributes object
    • Data array[object]
    • Total integer
  • 404

    Nothing Found

  • 405

    Invalid Table Specified

GET /DB/Maint/{table} 
curl \
 --request GET 'https://api.wrtm.io/v1.0/DB/Maint/item' \
 --header "X-ApiKey: $API_KEY" \
 --header "X-ApiDate: $API_KEY" \
 --header "X-ApiHmac: $API_KEY"
Response examples (200) 
{
  "Data": [
    {
      "id": 10,
      "name": "John Doe",
      "email": "john@example.com"
    }
  ],
  "Total": 1
}