Reference
Formats and conventions
How dates, times, durations, empty values and CSV files are written.
- Dates are YYYY-MM-DD and times HH:mm, both in the activity's timezone, which every report gives in meta.activities.
- Timestamps such as last_changed_at and expires_at are ISO 8601 in UTC.
- Durations are decimal hours unless you ask otherwise (durations=minutes or hm).
- A missing value is null in JSON and an empty cell in CSV. Booleans are true or false.
- Column and field ids are snake_case. Codes (AC-0001, AG-0042) are what people see in Planifizer; ids are stable UUIDs.
- Reports read published plannings. source=live reads a week once someone has opened its live day.
- CSV is UTF-8, comma-separated, one header row, with Windows line endings. Without limit it is the whole file. Text that a spreadsheet would run as a formula (starting with =, +, - or @) begins with an apostrophe.