Skip to main content
Web API – Expenses
Updated this week

List Expenses

Request URL

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

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"
}
]
}

Did this answer your question?