Skip to main content
curl -X POST https://api.hellotracks.com/api/createreport \
--header 'API-Key: ...' -d \
'{
  "data": {
    "from": 1619568000000,
    "until": 1619654399999,
    "accounts": ["john@company.com", "jane@company.com"],
    "format": "xlsx",
    "reporttype": "jobs",
    "columns": [
      {"key": "member"},
      {"key": "title"},
      {"key": "status"},
      {"key": "address"}
    ]
  }
}' > jobs-report.xlsx
You can create reports programmatically via an API request. Reports are generated based on specified date ranges, members, and places.

REQUEST

POST https://api.hellotracks.com/api/createreport

{
	data: {
		day: 20210428,
		from: 1619568000000,
		until: 1619654399999,
		accounts: ["<account-username-or-uid>"],
		places: ["<place-uid>"],
		format: "xlsx",
		reporttype: "jobs",
		columns: [
			{"key": "member"},
			{"key": "title"},
			{"key": "status"}
		]
	}
}
reporttype
string
required
Type of report to generate. See Report Types section below for available options.
format
string
required
Output format for the report. Available formats depend on report type:
  • xlsx - Excel spreadsheet (most reports)
  • csv - Comma-separated values (most reports)
  • pdf - PDF document (most reports)
  • geojson - GeoJSON format (location-based reports)
  • zip - Compressed archive (GPX tracks, time allocation)
day
number
Single day for the report in YYYYMMDD format (e.g., 20210428). Use this OR the from/until parameters.
from
long
Start timestamp in milliseconds for date range. Use with until instead of day for multi-day reports.
until
long
End timestamp in milliseconds for date range. Use with from instead of day for multi-day reports.
accounts
array
required
Array of member usernames or UIDs to include in the report. Required for most report types. Use empty array [] for all members (when applicable).
places
array
Array of place UIDs to include in the report. Only applicable for place-related reports.
columns
array
Optional array of column configurations to customize report output. Each column object can contain:
  • key (string, required): Column identifier (see report-specific columns below)
  • rename (string, optional): Custom column name in output
  • isCheck (boolean, optional): Whether this is a checkbox/boolean column
If omitted, report uses default columns.

Report Types

Job Reports

jobs - Jobs Report

Complete job information across multiple days.
  • Formats: xlsx, csv, pdf, geojson
  • Date Range: Up to 10,000 days
  • Requires: accounts (members)
  • Available Columns: member, date, title, status, status_ts, status_response, address, place, contact_name, contact_phone, teams, orderid, type, scheduled_window, check_ins, check_outs, onsite, priority, created, saved, accepted, pickup_items, dropoff_items, manual_checks, notes, latitude, longitude, comments, signature, signature_name, signature_date, attachments, custom_fields, form_fields, public_url

dayroute - Day Route Report

Single-day route with sequence and routing information.
  • Formats: xlsx, csv, pdf, geojson
  • Date Range: Single day only
  • Requires: accounts (members)
  • Available Columns: number, member, date, title, status, status_ts, status_response, routeinfo, address, place, contact_name, contact_phone, teams, orderid, type, scheduled_window, check_ins, check_outs, onsite, priority, created, saved, accepted, pickup_items, dropoff_items, manual_checks, notes, latitude, longitude, signature, attachments, custom_fields, form_fields, public_url

Activity & Location Reports

activities - Activities Report

Member activity log and events.
  • Formats: xlsx, csv, pdf, geojson
  • Date Range: Up to 30 days
  • Requires: accounts (members)

checkins - Check-ins Report

Place and job check-in records.
  • Formats: xlsx, csv, pdf, geojson
  • Date Range: Up to 10,000 days
  • Requires: accounts (members)

gpx - GPX Tracks Export

GPS track data in GPX format (compressed).
  • Formats: zip (containing .gpx files)
  • Date Range: Up to 120 days
  • Requires: accounts (members)

Time & Attendance Reports

timesheet - Timesheet Report

Working hours and time tracking.
  • Formats: xlsx, pdf
  • Date Range: Up to 120 days
  • Requires: accounts (members)

timeline - Timeline Report

Chronological activity timeline.
  • Formats: xlsx, csv
  • Date Range: Up to 14 days
  • Requires: accounts (members)

worksheet - Worksheet Report

Daily work summary.
  • Formats: xlsx, csv, pdf, geojson
  • Date Range: Up to 14 days
  • Requires: accounts (members)

timeallocation - Time Allocation Report

Time spent on different activities.
  • Formats: xlsx, pdf, zip
  • Date Range: Up to 14 days
  • Requires: accounts (members)

On-Site & Stop Reports

placeonsite - Place On-Site Report

Time spent at each place/location.
  • Formats: xlsx, csv, pdf, geojson
  • Date Range: Up to 10,000 days
  • Requires: places (locations)

memberonsite - Member On-Site Report

Member time spent at locations.
  • Formats: xlsx, pdf
  • Date Range: Up to 120 days
  • Requires: accounts (members)

stopsreport - Stops Report

All stop locations with duration.
  • Formats: xlsx, csv, pdf, geojson
  • Date Range: Up to 120 days
  • Requires: accounts (members)

Distance & Mileage Reports

mileage - Mileage Report

Distance tracking and trip details.
  • Formats: xlsx
  • Date Range: Up to 10,000 days
  • Requires: accounts (members)
  • Available Columns: date, member, start, end, distance, duration, minutes, maxspeed, avgspeed, from, to, purpose, comment, approvalstatus, approvedby, placesheet

Alerts & Statistics

alerts - Alerts Report

Alert events and notifications.
  • Formats: xlsx, csv, pdf, geojson
  • Date Range: Up to 10,000 days
  • Requires: None (company-wide)

statistics - Statistics Report

Performance metrics and KPIs.
  • Formats: xlsx, csv, pdf, geojson
  • Date Range: Up to 10,000 days
  • Requires: accounts (members)
  • Available Columns: member, distance, speed, maxspeed, tracks, jobs, ontime, delays, success, issues, engagement, totalJobOnsite, avgJobOnsite, totalPlaceOnsiteTime, avgPlaceOnsiteTime, totalPauseTime, avgPauseTime, totalTravelTime, avgTravelTime, totalTimeBetweenJobs, avgTimeBetweenJobs

Directory Reports

members - Members Report

Member/user directory information.
  • Formats: xlsx, csv, pdf, geojson
  • Date Range: Current data (no date filter)
  • Requires: accounts (members)

places - Places Report

Places/locations directory.
  • Formats: xlsx, csv, pdf, geojson
  • Date Range: Current data (no date filter)
  • Requires: places (locations)

RESPONSE

If the request is successful, the response output can be saved as the content of the specified format file. Success Response:
  • For structured formats (xlsx, csv, pdf): Binary file content
  • For geojson: JSON structure with GeoJSON features
  • For zip: Compressed archive binary
Error Response:
{
  "status": <error_code>,
  "error": "Error message description"
}

Example Usage

curl -X POST https://api.hellotracks.com/api/createreport \
--header 'API-Key: ...' -d \
'{
  "data": {
    "from": 1619568000000,
    "until": 1619654399999,
    "accounts": ["john@company.com", "jane@company.com"],
    "format": "xlsx",
    "reporttype": "jobs",
    "columns": [
      {"key": "member"},
      {"key": "title"},
      {"key": "status"},
      {"key": "address"}
    ]
  }
}' > jobs-report.xlsx

Notes

  • Maximum date ranges vary by report type to ensure performance
  • Some reports require specific parameters (e.g., places for place-based reports)
  • Column customization is optional; reports use sensible defaults
  • Binary formats (xlsx, pdf, zip) should be saved directly to files
  • GeoJSON format is useful for mapping and GIS applications
I