get_mileage
Retrieve mileage entries from TimeChimp with filtering options for users, projects, dates, and custom queries.
Instructions
Retrieve all mileage entries from TimeChimp
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Maximum number of mileage entries to return (1-10000, default: 100) | |
| skip | No | Number of mileage entries to skip for pagination (default: 0) | |
| count | No | Whether to include the total count of results (default: true) | |
| expand | No | Comma-delimited list of properties to expand (e.g., "user,project,customer") | |
| user_id | No | Filter by specific user ID | |
| project_id | No | Filter by specific project ID | |
| customer_id | No | Filter by specific customer ID | |
| from_date | No | Start date for filtering (YYYY-MM-DD format) | |
| to_date | No | End date for filtering (YYYY-MM-DD format) | |
| filter | No | OData filter expression (e.g., "distance gt 50" or "approved eq true") | |
| orderby | No | OData orderby expression (e.g., "date desc" or "distance desc") |