How do I connect Klipfolio and Basecamp?

You can set up a connection between Klipfolio and Basecamp 2 or Basecamp 3 to show your project management data on a dashboard. Use the steps in this article to learn how set up that connection.

What is Klipfolio?

Klipfolio integrates with many cloud services and tools to create beautiful data visualizations.

How do I get started with Basecamp?

You have the following options for visualizing your data on a dashboard in Klipfolio:

Try the Klip Gallery Use the Connector Gallery
The Klip Gallery allows you to track your key metrics using pre-built Klips for some of the most popular services and data sources. The Connector Gallery helps you get your data fast with pre-built queries. Use this article as a guide to build your own Basecamp data source.

If you want to build a data source entirely from scratch, use the Advanced section below.

Prerequisite: Authenticate with Basecamp

  • Click Connect Your Account.
  • Enter your Basecamp login credentials.
  • Allow access to Basecamp 2 and/or Basecamp 3.
  • Click Next Step.
    Note: You now have an OAuth Token for your Connected Account. You can manage your tokens in your Account Section in Klipfolio.

Creating a new data source? Find your Basecamp Account ID and Project ID

If you are creating Basecamp 2 or Basecamp 3 data sources, you'll need to find your Account ID and Project ID.

To find your Account ID and Project ID,

  • Log in to your Basecamp account.
  • In Basecamp, navigate to the URL at the top of the page and copy the Account ID into Klipfolio:
    https://basecamp.com/123456/.
  • In Basecamp, select a project. Navigate to the URL and copy the Project ID into Klipfolio:
    https://basecamp.com/123456/projects/123456.
Save your Account ID and Project ID on your notepad. You'll need them to complete your Basecamp queries.

Click the image to enlarge

Advanced: Build a data source yourself

Klipfolio connects to hundreds of services in the cloud that have a REST API. If you take the time to learn how to get data into Klipfolio using APIs, your possibilities are endless. Here's a quick and simple overview video on APIs and Klipfolio:

  Klipfolio API's 101

If APIs are a bit too tricky for you, enlist a data analyst or developer to help you.

If you want to edit a Basecamp data source that you already created, check out How to edit or reconfigure a data source, and get step-by-step instructions.

Basecamp 2 and Basecamp 3 API quick reference table

Data Source Type REST/URL
Authentication OAuthToken Authentication
API Documentation Basecamp 2 API Documentation
Basecamp 3 API Documentation

Advanced query examples

Basecamp 2

For Basecamp Historical Follower Stats over the past 90 days:

https://api.Basecamp.com/v1/companies/your-company-id/historical-follow-statistics?format=json&time-granularity=day&start-timestamp={date.add(-90).format('epochTime')}000

See the Basecamp 2 API documentation to discover more data requests.

Basecamp 3

For data on a specific project:

https://3.basecampapi.com/your-account-ID/projects/your-project-ID.json

For a list of people with access to a certain project:

https://3.basecampapi.com/your-account-ID/projects/your-project-ID/people.json

See the Basecamp 3 API documentation to discover more data requests.

When you are happy with your query, click Get Resource, and then save and name your new data source. You're now ready to use it to build a Basecamp Klip.

Related Links