-
Notifications
You must be signed in to change notification settings - Fork 3
/
crunchbase-appsscript.js
85 lines (72 loc) · 2.2 KB
/
crunchbase-appsscript.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
function cbsearch(company, field) {
var url = "http://api.crunchbase.com/v/1/company/" + String.toLowerCase(company) + ".js";
try{
var response = UrlFetchApp.fetch(url);
var companyInfo = Utilities.jsonParse(response.getContentText());
if (isGarbage(companyInfo) || isGarbage(companyInfo[field])){
return "Information not found in Crunchbase";
}
return companyInfo[field];
}catch(error){
return "Company not found in crunchbase.";
}
}
function cbcity(company){
var url = "http://api.crunchbase.com/v/1/company/" + String.toLowerCase(company) + ".js";
try{
var response = UrlFetchApp.fetch(url);
var companyInfo = Utilities.jsonParse(response.getContentText());
if (isGarbage(companyInfo) || isGarbage(companyInfo["offices"]) || isGarbage(companyInfo["offices"][0]) || isGarbage(companyInfo["offices"][0]["city"])){
return "Information not found in Crunchbase";
} else {
return companyInfo["offices"][0]["city"];
}
}catch(error){
//catch 404 errors when company is not found in Crunchbase
}
}
function cbmilestones(company){
var url = "http://api.crunchbase.com/v/1/company/" + String.toLowerCase(company) + ".js";
var response = UrlFetchApp.fetch(url);
var companyInfo = Utilities.jsonParse(response.getContentText());
if (isGarbage(companyInfo) || isGarbage(companyInfo["milestones"]) || isGarbage(companyInfo["milestones"][0]) || isGarbage(companyInfo["milestones"][0]["description"])){
return "Milestone information not found in Crunchbase";
} else {
return companyInfo["milestones"][0]["description"];
}
}
function isGarbage(output){
if(output == null || typeof output == null){
return true;
} else {
return false;
}
}
function monthword(month){
switch (month){
case 1:
return "January";
case 2:
return "February";
case 3:
return "March";
case 4:
return "April";
case 5:
return "May";
case 6:
return "June";
case 7:
return "July";
case 8:
return "August";
case 9:
return "September";
case 10:
return "October";
case 11:
return "November";
case 12:
return "December";
}
}