Your Mitto instance can also serve as an API returning data in JSON format. Here is an example from a files API request at https://<mitto_instance>.zuarbase.net/api/files?API_KEY=<api_key>:

{
  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"
}

Retrieving API Key

  1. Click on settings tab on left side of page.
  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. Now you can view and update your API key.

Base URL:

https://<mitto_instance>.zuarbase.net/api

Parameters:

API_KEY = <api_key>

limit = <integer>

offset = <integer>

history = <integer>

Endpoints:

/about

/databases

  • /databases/<database_name>
  • /databases/<database_name>/schemas
  • /databases/<database_name>/schemas/<schema_name>
  • /databases/<database_name>/schemas/<schema_name>/tables
  • /databases/<database_name>/schemas/<schema_name>/tables/<table_name>

/history

/files

/tags

/navs

/jobs

  • //job/<job_id>/run/<status_id>
  • /job/<job_id>
  • /job/<job_id>?history=
    • See the job's details and add a history list.
  • /job/<job_id>/title
  • /job/<job_id>/name
  • /job/<job_id>/type
  • /job/<job_id>/tags
  • /job/<job_id>/schedule
  • seq/<seq_id>/delay
  • /job/<job_id>/timeout
  • /seq/<seq_id>/continue_on_error
  • /seq/<seq_id>/jobs
  • /job/<job_id>/notify
  • /job/<job_id>/markdown

/store/<job_name>/<store_row_id>

Example Requests:

See all jobs:

https://stage.zuarbase.net/api/jobs?API_KEY=52b093c3f8cc41a8c5f7d1ccfacbf9fa

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

https://stage.zuarbase.net/api/job?API_KEY=52b093c3f8cc41a8c5f7d1ccfacbf9fa&desc=false&limit=50&offset=0&search=&sort=id&status=&tag=stage

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

https://stage.zuarbase.net/api/job/17671?API_KEY=52b093c3f8cc41a8c5f7d1ccfacbf9fa&history=25

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

https://stage.zuarbase.net/api/databases/mitto/schemas/public/tables/jobs?API_KEY=52b093c3f8cc41a8c5f7d1ccfacbf9fa

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

https://stage.zuarbase.net/api/store/salesforce_opportunity/00646000002w9PpAAI?API_KEY=52b093c3f8cc41a8c5f7d1ccfacbf9fa