Data from CrunchBase API directly into an Excel or Google Spreadsheet
Today’s API is from “crunchbase” which is a free database of corporations, people and investors. There are a number of types of query available in this API – our first one will be about relationships – companies that business leaders have worked for – this a single query API, populating multiple rows in a spreadsheet from a given name. Here’s the response to a query on “jeff-bezos”
Here’s the Excel code (included in cDataSet.xlsm downloadable from the ramblings site)
Public Sub testCrunchbaseRelationships() generalQuery "crunchbase relationships", "crunchbase relationships", _ InputBox("Enter persons name (for example steve-jobs)") End Sub
and the GAS version (included in a Google Spreadsheet) using the mcpher GAS library
function testCrunchbaseRelationships() { mcpher.generalQuery ("crunchbase relationships", "crunchbase relationships", mcpher.InputBox("Enter persons name (for example steve-jobs)") ); }
The rest library is itself implemented as REST API and can be queried like this.
For more stuff like this, visit the ramblings site or the associated blog. If you have suggestion for particular AP or contact me on our forum