Utilities

Export Data

Create and download a CSV export of user activities or projects. This should be extensible enough to support most third-pary use cases. View the columns and params options below to craft your perfect export.

POST /api/v2/export HTTP/1.1
{
  "resource": "activities",
  "columns": {
    "Date": "date:YY-MM-DD",
    "Duration": "duration:hours",
    "Unit": "\"Hours\"",
    "Project": "project_name",
    "Description": "description",
    "Name": "user_full_name",
    "Timezone": "timezone"
  },
  "params": {
    "per_page": 10000,
    "page": 1,
    "filter": "status:complete",
    "start_date": "2018-01-05T08:00:00.000Z",
    "end_date": "2018-01-10T08:00:00.000Z"
  }
}

Resource

Type of Tali resource to export. Options: activities, projects.

Columns

Define your header labels and row cell values in the order they should appear as the columns body parameter. The key will be the header label, and the value will be the row cell value.

To use a literal string for a row cell value, simply wrap it in double quotes. (You may need to escape them in your JSON). Example: "Company": "\"My Company USA\""

Available row cell values are listed below for each resource:

Optional values

  • user_first_name
  • user_last_name
  • user_full_name
  • user_email
  • user_id
  • timezone

Activity-only values

  • created_at (optional format: date:YYYY-MM-DD)
  • date (optional format: date:YYYY-MM-DD)
  • duration (optional unit: duration:hours, :minutes, :seconds, :time)
  • description
  • project_name
  • project_id
  • project_source

Project-only values

  • name
  • description
  • source
  • code
  • location
  • bill_rate
  • bill_unit
  • is_billable

Params

This should be familiar to you, as it matches the same format as the activities and projects endpoints for paginated results. No values are required – it just helps you define the exported resources.