How can we help?

Use Intervals as a data source

Resources

Data Source Type: REST/URL
Authentication: Basic HTTP Authentication
Sample Query: https://api.myintervals.com/task/

More samples available here: Intervals API examples
API Documentation: Intervals API docs
Date Ranges: Klipfolio Date Ranges

Step-by-Step

Creating a data source using Intervals

To create a data source using Intervals data, you need to accomplish 4 tasks:

  • Start the data source creation process.
  • Find your Intervals API token.
  • Authenticate with Intervals.
  • Write a query and enter it into Klipfolio.

Note: This guide assumes that you already have an active Intervals account.

Step 1: Start the data source creation process

To create a data source using Intervals, go to the Connector Gallery page in Klipfolio and select Intervals.

Step 2: Find your Intervals API Token

Go here for information on finding your Intervals API token-based authentication.

Step 3: Authenticate with Intervals

  1. At Username enter your Intervals username.
  2. At Password enter your Intervals password.

Note: The user token is a unique 11-character alphanumeric (eg: 6bv066nezv4) and is entered in the Username field. An arbitrary value such as x is entered in the password field.

Step 4: Write a query and enter it in Klipfolio

You will need to refer to the Intervals documentation to write a query.

  1. Enter our query in the URL field in the Klipfolio REST connector.

Example: https://api.myintervals.com/task/?excludeclosed=true&sortfield=datedue&limit=50

Edit the query date ranges and save

Many Klips that use Intervals data need a date range that is dynamic (for example, past 30 days). In this section we're going to change the query from a fixed range to a dynamic one.

  1. Enter start-date={date.last30Days} at the end of your Query URL (after the ?).
  2. Enter &end-date={date.today} at the end of your Query URL (after the start-date parameter).
  3. Click the Submit button.
    Note: In addition to your raw data source, you can create a modelled version of your data source at this stage. To create a modelled data source, ensure that the checkbox next to Model this data source is selected before clicking Continue.
    To learn more about creating a modelled data source, click here.
  4. Click the Continue button once you verify you have retrieved the correct data to Save your data source.

Example: https://api.myintervals.com/task/?excludeclosed=true&sortfield=datedue&limit=50&start-date={date.last30Days}&end-date={date.today}

Common date range expressions:

Related Links

Updated
Have more questions? Submit a request