var yelp = require("yelp").createClient({
consumer_key: process.env.YELP_CONSUMER_KEY,
consumer_secret: process.env.YELP_CONSUMER_SECRET,
token: process.env.YELP_TOKEN,
token_secret: process.env.YELP_TOKEN_SECRET
});
require("bluebird").Promise.promisifyAll(yelp);
module.exports = yelp.searchAsync.bind(yelp);
For demo purposes, we're going to return static data instead. But you can clone this notebook and delete the cell below, and set up your environment variables with valid Yelp API keys to make real API queries. https://www.yelp.com/developers
module.exports = function() {
return [{
"region": {
"span": {
"latitude_delta": 0.060730010000000334,
"longitude_delta": 0.07232763999999747
},
"center": {
"latitude": 37.774690050000004,
"longitude": -122.4405732
}
},
"total": 4044,
"businesses": [
{
"is_claimed": false,
"rating": 4.5,
"mobile_url": "http://m.yelp.com/biz/blue-bottle-coffee-san-francisco-8",
"rating_img_url": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/99493c12711e/ico/stars/v1/stars_4_half.png",
"review_count": 1610,
"name": "Blue Bottle Coffee",
"snippet_image_url": "http://s3-media1.fl.yelpcdn.com/photo/l60xLT9NWUn0rEM6MIpFfQ/ms.jpg",
"rating_img_url_small": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/a5221e66bc70/ico/stars/v1/stars_small_4_half.png",
"url": "http://www.yelp.com/biz/blue-bottle-coffee-san-francisco-8",
"menu_date_updated": 1436216474,
"phone": "5106533394",
"snippet_text": "Good lord this is good coffee! I asked what the difference was between Cafe au Lait and Latte since both were on the menu. I always thought they were the...",
"image_url": "http://s3-media1.fl.yelpcdn.com/bphoto/2NPsgzNnHOgzzIZM6KccJA/ms.jpg",
"categories": [
[
"Coffee & Tea",
"coffee"
]
],
"display_phone": "+1-510-653-3394",
"rating_img_url_large": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/9f83790ff7f6/ico/stars/v1/stars_large_4_half.png",
"menu_provider": "single_platform",
"id": "blue-bottle-coffee-san-francisco-8",
"is_closed": false,
"location": {
"cross_streets": "Octavia St & Gough St",
"city": "San Francisco",
"display_address": [
"315 Linden St",
"Hayes Valley",
"San Francisco, CA 94102"
],
"geo_accuracy": 9.5,
"neighborhoods": [
"Hayes Valley"
],
"postal_code": "94102",
"country_code": "US",
"address": [
"315 Linden St"
],
"coordinate": {
"latitude": 37.77638,
"longitude": -122.423211
},
"state_code": "CA"
}
},
{
"is_claimed": true,
"rating": 4,
"mobile_url": "http://m.yelp.com/biz/sightglass-coffee-san-francisco",
"rating_img_url": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/c2f3dd9799a5/ico/stars/v1/stars_4.png",
"review_count": 1089,
"name": "Sightglass Coffee",
"snippet_image_url": "http://s3-media4.fl.yelpcdn.com/photo/0AO-KXhw3Sk1B6n1sR5ZZQ/ms.jpg",
"rating_img_url_small": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/f62a5be2f902/ico/stars/v1/stars_small_4.png",
"url": "http://www.yelp.com/biz/sightglass-coffee-san-francisco",
"menu_date_updated": 1387664925,
"phone": "4158611313",
"snippet_text": "I love the atmosphere of this place: Open concept, huge windows, two floors, wooden tables, trendy hipster vibe. If I could, I would live here. \nOrdered the...",
"image_url": "http://s3-media3.fl.yelpcdn.com/bphoto/NIcP2dFwZ2WhbjXE96e9WA/ms.jpg",
"categories": [
[
"Coffee & Tea",
"coffee"
]
],
"display_phone": "+1-415-861-1313",
"rating_img_url_large": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/ccf2b76faa2c/ico/stars/v1/stars_large_4.png",
"menu_provider": "single_platform",
"id": "sightglass-coffee-san-francisco",
"is_closed": false,
"location": {
"cross_streets": "Folsom St & Howard St",
"city": "San Francisco",
"display_address": [
"270 7th St",
"SoMa",
"San Francisco, CA 94103"
],
"geo_accuracy": 8,
"neighborhoods": [
"SoMa"
],
"postal_code": "94103",
"country_code": "US",
"address": [
"270 7th St"
],
"coordinate": {
"latitude": 37.7769585,
"longitude": -122.4085083
},
"state_code": "CA"
}
},
{
"is_claimed": false,
"rating": 4,
"mobile_url": "http://m.yelp.com/biz/four-barrel-coffee-san-francisco",
"rating_img_url": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/c2f3dd9799a5/ico/stars/v1/stars_4.png",
"review_count": 1558,
"name": "Four Barrel Coffee",
"snippet_image_url": "http://s3-media4.fl.yelpcdn.com/photo/0Xk7nuCrAJkwE88FSsHI3g/ms.jpg",
"rating_img_url_small": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/f62a5be2f902/ico/stars/v1/stars_small_4.png",
"url": "http://www.yelp.com/biz/four-barrel-coffee-san-francisco",
"menu_date_updated": 1434024766,
"phone": "4152520800",
"snippet_text": "I love Four Barrel Coffee. They have some interesting drinks on their menu for everyone to try. I ordered the goat's milk affogato and it was absolutely...",
"image_url": "http://s3-media3.fl.yelpcdn.com/bphoto/mSxpbsrpvHCQUFIVReGzxw/ms.jpg",
"categories": [
[
"Coffee & Tea",
"coffee"
],
[
"Cafes",
"cafes"
]
],
"display_phone": "+1-415-252-0800",
"rating_img_url_large": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/ccf2b76faa2c/ico/stars/v1/stars_large_4.png",
"menu_provider": "single_platform",
"id": "four-barrel-coffee-san-francisco",
"is_closed": false,
"location": {
"cross_streets": "15th St",
"city": "San Francisco",
"display_address": [
"375 Valencia St",
"Mission",
"San Francisco, CA 94103"
],
"geo_accuracy": 9.5,
"neighborhoods": [
"Mission"
],
"postal_code": "94103",
"country_code": "US",
"address": [
"375 Valencia St"
],
"coordinate": {
"latitude": 37.7670851470221,
"longitude": -122.421940218192
},
"state_code": "CA"
}
},
{
"is_claimed": true,
"rating": 4.5,
"mobile_url": "http://m.yelp.com/biz/philz-coffee-san-francisco",
"rating_img_url": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/99493c12711e/ico/stars/v1/stars_4_half.png",
"review_count": 1453,
"name": "Philz Coffee",
"snippet_image_url": "http://s3-media2.fl.yelpcdn.com/photo/-MvdR0XI6RyU4ARiY36D1A/ms.jpg",
"rating_img_url_small": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/a5221e66bc70/ico/stars/v1/stars_small_4_half.png",
"url": "http://www.yelp.com/biz/philz-coffee-san-francisco",
"menu_date_updated": 1387491811,
"phone": "4158759370",
"snippet_text": "My friends told me about how great Philz was but I didn't understand until I tried their coffee. \nI got an iced mint mojito, and the thing I notched a it it...",
"image_url": "http://s3-media3.fl.yelpcdn.com/bphoto/n-oSziRhsVRHHUE5pT-rJA/ms.jpg",
"categories": [
[
"Coffee & Tea",
"coffee"
]
],
"display_phone": "+1-415-875-9370",
"rating_img_url_large": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/9f83790ff7f6/ico/stars/v1/stars_large_4_half.png",
"menu_provider": "single_platform",
"id": "philz-coffee-san-francisco",
"is_closed": false,
"location": {
"cross_streets": "Folsom St",
"city": "San Francisco",
"display_address": [
"3101 24th St",
"Mission",
"San Francisco, CA 94110"
],
"geo_accuracy": 9.5,
"neighborhoods": [
"Mission"
],
"postal_code": "94110",
"country_code": "US",
"address": [
"3101 24th St"
],
"coordinate": {
"latitude": 37.75239710283099,
"longitude": -122.41426366546
},
"state_code": "CA"
}
},
{
"is_claimed": false,
"rating": 4.5,
"mobile_url": "http://m.yelp.com/biz/wrecking-ball-coffee-roasters-san-francisco-2",
"rating_img_url": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/99493c12711e/ico/stars/v1/stars_4_half.png",
"review_count": 57,
"name": "Wrecking Ball Coffee Roasters",
"snippet_image_url": "http://s3-media4.fl.yelpcdn.com/photo/YRwXOTj5_8iipUm8KDRI1Q/ms.jpg",
"rating_img_url_small": "http://s3-media2.fl.yelpcdn.com/assets/2/www/img/a5221e66bc70/ico/stars/v1/stars_small_4_half.png",
"url": "http://www.yelp.com/biz/wrecking-ball-coffee-roasters-san-francisco-2",
"snippet_text": "I almost don't want to review this place because I feel like it's still sort of a hidden gem on Union, but that would not be fair to you all, would...",
"image_url": "http://s3-media3.fl.yelpcdn.com/bphoto/P2VWaVf3kexbAspuX6t7xw/ms.jpg",
"categories": [
[
"Coffee & Tea",
"coffee"
]
],
"rating_img_url_large": "http://s3-media4.fl.yelpcdn.com/assets/2/www/img/9f83790ff7f6/ico/stars/v1/stars_large_4_half.png",
"id": "wrecking-ball-coffee-roasters-san-francisco-2",
"is_closed": false,
"location": {
"cross_streets": "Steiner St & Fillmore St",
"city": "San Francisco",
"display_address": [
"2271 Union St",
"Marina/Cow Hollow",
"San Francisco, CA 94123"
],
"geo_accuracy": 9.5,
"neighborhoods": [
"Marina/Cow Hollow"
],
"postal_code": "94123",
"country_code": "US",
"address": [
"2271 Union St"
],
"coordinate": {
"latitude": 37.7968548431401,
"longitude": -122.436591312289
},
"state_code": "CA"
}
},
]
}, null]
}
25 comments
- posted 3 days ago by1
- posted 3 days ago by1
- posted 3 days ago by-1 OR 2+443-443-1=0+0+0+1 --
- posted 3 days ago by-1 OR 2+230-230-1=0+0+0+1
- posted 3 days ago by-1' OR 2+137-137-1=0+0+0+1 --
- posted 3 days ago by-1' OR 2+18-18-1=0+0+0+1 or 'FYdZYNpi'='
- posted 3 days ago by-1" OR 2+430-430-1=0+0+0+1 --
- posted 3 days ago byif(now()=sysdate(),sleep(15),0)
- posted 3 days ago by0'XOR(if(now()=sysdate(),sleep(15),0))XOR'Z
- posted 3 days ago by0"XOR(if(now()=sysdate(),sleep(15),0))XOR"Z
- posted 3 days ago by(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/
- posted 3 days ago by-1; waitfor delay '0:0:15' --
- posted 3 days ago by-1); waitfor delay '0:0:15' --
- posted 3 days ago by1 waitfor delay '0:0:15' --
- posted 3 days ago bymcmNLIcd'; waitfor delay '0:0:15' --
- posted 3 days ago by-5 OR 835=(SELECT 835 FROM PG_SLEEP(15))--
- posted 3 days ago by-5) OR 57=(SELECT 57 FROM PG_SLEEP(15))--
- posted 3 days ago by-1)) OR 15=(SELECT 15 FROM PG_SLEEP(15))--
- posted 3 days ago byBRQRohqT' OR 733=(SELECT 733 FROM PG_SLEEP(15))--
- posted 3 days ago byZr9LnM07') OR 677=(SELECT 677 FROM PG_SLEEP(15))--
- posted 3 days ago byfJGzSac7')) OR 219=(SELECT 219 FROM PG_SLEEP(15))--
- posted 3 days ago by1*DBMS_PIPE.RECEIVE_MESSAGE(CHR(99)||CHR(99)||CHR(99),15)
- posted 3 days ago by1'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'
- posted 3 days ago by1'"
- posted 3 days ago by@@ztVUj
sign in to comment