Almost every action performed in the Mitto UI has a corresponding REST API endpoint. This means you can programmatically create and manage jobs and use Mitto as a data source.

Base URL

https://{mitto_url}/api

Authentication

Mitto's API uses a revocable API key for access.

https://{mitto_url}/api/{endpoint}?API_KEY={api_key}

API Key

  1. Click on the Settings menu.
  2. Under the About tab on the settings page there is a Product Configuration section. Locate the API Key area and click on the edit icon.
  3. View, generate, and regenerate Mitto's API key.

Authorization

The Mitto API key has full admin access.

Endpoints and Methods

Mitto has Swagger documentation at /docs. You can see all the API endpoints and test them using the Swagger UI.

Responses

Mitto's APIs return data in JSON format. Here is an example from /files:

{
  files: [
    {
      name: "example.csv",
      size: 7874,
      size_hr: "7.7 KiB",
      mtime: {
        utc: "2019-08-20T20:49:22.256707+00:00",
        epoch: 1566334162.256707,
        local: "2019-08-20T15:49:22.256707-05:00",
        local_hr: "8-20 3:49:22PM CDT"
      },
      mode: "-rw-r--r--"
    }
  ],
  count: 1,
  size: 7874,
  display-size: "7.7 KiB"
}

Example Requests

See all jobs:

https://{mitto_url}/api/jobs?API_KEY={api_key}

See the top 50 jobs with the tag stage sorted by id ascending:

https://{mitto_url}/api/job?API_KEY={api_key}&desc=false&limit=50&offset=0&search=&sort=id&status=&tag=stage

See a specific job (id 17671) and its 25 last runs:

https://{mitto_url}/api/job/17671?API_KEY={api_key}&history=25

See the columns and rows from the public.jobs table in the Mitto database:

https://{mitto_url}/api/databases/mitto/schemas/public/tables/jobs?API_KEY={api_key}

See the API results in the JSON store for 1 row of a job:

https://{mitto_url}/api/store/salesforce_opportunity/00646000002w9PpAAI?API_KEY={api_key}