WBS ODODATA API

Insert, update and select weighbridge records from Selico_KAGA.dbo.ODODATA.

All endpoints except /api/ododata/test require the API password: YourSecurePassword123!

Select

GET /api/ododata/test — health check
GET /api/ododata/dbtest?password=... — SQL Server connection check
GET /api/ododata?password=... — all rows
GET /api/ododata/{ticketId}?password=...&company=optional — one ticket
GET /api/ododata/bydate?password=...&date=yyyy-MM-dd — by first weight / pickup / last updated date
GET /api/ododata/bycompany?password=...&company=...
GET /api/ododata/bypo?password=...&po=...

Insert

POST /api/ododata — one record
POST /api/ododata/batch — many records (skips existing TicketId + Company)

{
  "password": "YourSecurePassword123!",
  "data": {
    "company": "TBCI",
    "ticketId": 1001,
    "id_ENGIN": "ABC-123",
    "driver_NAME": "Ali",
    "firstWeight": 12000,
    "dateFirstWeight": "22/09/2026 10:15:00"
  }
}

Update

PUT /api/ododata — requires TicketId. Match is TicketId + Company.

{
  "password": "YourSecurePassword123!",
  "data": {
    "company": "TBCI",
    "ticketId": 1001,
    "secondWeight": 8000,
    "dateSecondWeight": "22/09/2026 11:00:00",
    "updatedBy": "WBS"
  }
}