Use Keen IO as a data source

Resources

API Documentation: Keen IO API Documentation
Sample Query: To return data on a saved project in Keen IO:
https://api.keen.io/3.0/projects/<yourProjectID>/queries/saved/<yourSavedSearchQuery>/result
What you'll need from your Keen IO account:
  • Your Saved Query
  • Your Project ID
  • Your Read Key

Step-by-Step

Creating a data source using Keen IO

To create a data source using Keen IO, you need to accomplish 3 tasks:

  • Start the data source creation process.
  • Find and save your Keen IO Saved Query, Project ID and Read Key.
  • Complete the example query or write your own query .

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

Start the data source creation process

To create a data source using Keen IO, go to the Service Connectors page in Klipfolio and select Keen IO from the list.

Complete the example query or create your own

The example query allows you to return data on a Keen IO project: 
https://api.keen.io/3.0/projects/<yourProjectID>/queries/saved/<yourSavedSearchQuery>/result

  1. Erase <yourProjectID> and <yourSavedSearchQuery> with the your corresponding Keen IO account information. We assume you have already have events and Saved Search Queries set up in your account. If you don't, follow the steps below.
  2. At Data Format, JSON is selected for you.
  3. At Method, GET is selected for you.
  4. Under Query Parameters, replace <yourReadKey> with your own.
  5. Click Get data.
  6. Ensure this is the data you’re looking for and, optionally, select the checkbox to Model your data. Learn more about modelling your data source here.
  7. Click Continue.
  8. Name, choose refresh settings, and, optionally, share your data source.
  9. Click Save.

 

Find your saved query

  1. Log into your Keen IO account.
  2. Under Projects, decide which project you want to bring data into Klipfolio from.
  3. Select the Graph Icon beside the project name.
  1. Select Browse to see your saved queries.
    Note: If you don't have anything under Browse, click Create a new query.
  2. Select a saved query.
  1. Click on the name of your saved query. In our example, it is purchases.
  2. Below the name, copy and save the Saved Query Resource Name.

Find your Project ID and Read Key

  1. Go back to your list of projects.
  2. Select the name of your chosen project.
  1. Copy and save your Project ID.
  2. Then click Show API Keys.
  1. Copy and save your Read Key

Consult the Keen IO API Getting Started Guide

Keen IO API Documentation

 

 This is what a Keen IO request would look like in Klipfolio:

Related articles

Have more questions? Submit a request