List Expenses

Request URL

GET https://www.triplogmileage.com/web/api/expenses

Query parameters

startDate – Format ‘yyyy-mm-dd’, e.g. ‘2015-01-31’ means midnight Jan 31, 2015 at your local timezone. Inclusive.
endDate – Format ‘yyyy-mm-dd’, e.g. ‘2015-12-31’. Inclusive.
userEmail – Email address of a particular user to search for.
activity – Trip activity, e.g. ‘Business’.
category – Income, Sales, Services, Reimburse, Dividend, Gas, Oil, Tires, Repairs, Insurance, Registration, Garage, Lease, Taxes, Interest, Other, Advertising, BusinessHome, Commissions, Contractors, CostOfGoods, Depletion, Depreciation, EmpBenefit, Gifts, InsuranceBiz, InterestMort, InterestOther, LegalProf, Meals, Office, Pension, RentEquipment, RentOther, RepairsBiz, Supplies, TaxesLicenses, Transporation, TravelBaggage, TravelLodging, TravelMisc, Utilities, Wages, OtherBiz, BankTransfer, etc.
minLastUpdated – The date when the record was modified or created. Format ‘yyyy-mm-dd’. Inclusive.
maxLastUpdated – The date when the record was modified or created. Format ‘yyyy-mm-dd’. Inclusive.
status – A = Approved, U = Unsubmitted, P = Pay Scheduled, S = Submitted, R = Rejected

Note

You need to provide at least one of the query parameters in the request.
The returned datetime in the response is in UTC time zone as in the JSON standard.

Example

GET https://www.triplogmileage.com/web/api/expenses?startDate=2024-07-01&endDate=2024-07-14

Example JSON Response

{
  "message": "OK",
  "expenses": [
    {
      "id": 20001951,
      "url": "https://www.triplogmileage.com/web/api/expenses/20001951",
      "lastUpdated": "2024-07-05T16:49:34.390Z",
      "user": {
        "id": 297603,
        "url": "https://www.triplogmileage.com/web/api/users/297603",
        "email": "[email protected]",
        "display": "Driver, TripLog"
      },
      "date": "2024-07-03T07:00:00.000Z",
      "category": "CC-Purchases",
      "subcategory": null,
      "vehicle": null,
      "odometer": null,
      "activity": "Business",
      "merchant": "tesco",
      "location": null,
      "amount": 20.0,
      "tax": 0.0,
      "tags": null,
      "notes": null,
      "status": "Not Submitted",
      "statusUpdateTime": null,
      "statusUpdatedBy": null,
      "reminder": false,
      "reminderNumIntervals": null,
      "reminderInterval": null,
      "reminderMileage": null,
      "receipts": "https://www.triplogmileage.com/web/api/expenses/20001951/receipts"
    },
    {
      "id": 20001953,
      "url": "https://www.triplogmileage.com/web/api/expenses/20001953",
      "lastUpdated": "2024-07-05T16:51:51.456Z",
      "user": {
        "id": 297603,
        "url": "https://www.triplogmileage.com/web/api/users/297603",
        "email": "[email protected]",
        "display": "Driver, TripLog"
      },
      "date": "2024-07-04T07:00:00.000Z",
      "category": "CC-Purchases",
      "subcategory": null,
      "vehicle": null,
      "odometer": null,
      "activity": "Business",
      "merchant": "MagRonalds",
      "location": null,
      "amount": 40.0,
      "tax": 0.0,
      "tags": null,
      "notes": null,
      "status": "Not Submitted",
      "statusUpdateTime": null,
      "statusUpdatedBy": null,
      "reminder": false,
      "reminderNumIntervals": null,
      "reminderInterval": null,
      "reminderMileage": null,
      "receipts": "https://www.triplogmileage.com/web/api/expenses/20001953/receipts"
    }
  ]
}

Web API – Time