Skip to content

Connecting to Crunchbase#

First Steps with Crunchbase#

Set up an account with Crunchbase.

Cost

This is a paid API.

Rate Limits

Your account plan tier will limit the number of requests each API key can make per minute.

How to Connect DataDistillr to Crunchbase#

To set up a data source connection for Crunchbase, you will need to have:

  • A unique name for your data source connection to be used in queries.
  • An API key generated through your Crunchbase account.

Data Source Form#

To locate the Crunchbase form, follow the steps in Connecting Your Data to DataDistillr. When you get to the window to choose the data source type, select API as shown below.

Select API from the available choices

On the API screen, select Crunchbase from the list of API types as shown in the image below.

Select Crunchbase API from available choices

The following form will appear. Instructions can be found below on how to find the information required to fill each field on the Crunchbase API form.

Once you have filled out all the fields, press the green 'Save' button, and your API will be connected!

Crunchbase form

Name#

Enter any name that will help you recognize this data source from within your query window.

Acceptable Characters Include

  • lowercase alphanumeric characters
  • underscores

API Key#

This is the user key which is emailed to you following registration.

In order to access the Crunchbase API, you must pay for an Enterprise or Applications license. See Crunchbase API Authentication for more information.

If you lose your key, contact api@crunchbase.com.

Endpoints#

Please see Crunchbase's API Reference for more on Crunchbase's endpoints.

The table below shows a list of endpoints available to connect to within the DataDistillr application. If you need to connect to any endpoints not listed in the table below, please use the Custom APIs Form.

Endpoint Required Optional Description
/entities/organizations/{entity_id} field_ids
card_ids		 Returns the records for the organizations associated with the specified entity.
entities/organizations/{entity_id}/cards/{card_id} card_field_ids
after_id
before_id
order
limit		 Returns the records for the specified card associated with the specified entity.

The endpoints above will display as follows in the nav tree once your API has successfully connected.

Crunchbase nav tree

Sample Queries#

The following queries are intended to help you get started, and make life simpler querying within your API.

For the following examples, suppose that my Crunchbase API data source was called crunchbase_1, and I want to query an endpoint. The endpoint goes after the Crunchbase data source name:

FROM Clause

FROM `crunchbase_1`.`<ENDPOINT>`

Get Organizations Endpoint#

This query returns all organizations associated with the specified entity.

SELECT *
FROM `crunchbase_1`.`/entities/organizations/:entity_id`
WHERE `entity_id`='tesla-motors'
LIMIT 1000

Get Organizations Card Endpoint#

This query returns the records for the specified card associated with the specified entity.

SELECT * FROM `crunchbase_1`.`/entities/organizations/:entity_id/cards/:card_id`
WHERE `entity_id`='crunchbase' AND `card_id`='press_references'
LIMIT 1000