Last active
September 9, 2023 16:56
-
-
Save ozzieliu/9fbbc83b354c568709dc4e6a30fea54f to your computer and use it in GitHub Desktop.
Proof of Concept task to get ticket prices and event info using StubHub's API with Python
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Quick intro to accessing Stubhub API with Python | |
# Ozzie Liu (ozzie@ozzieliu.com) | |
# Related blog post: http://ozzieliu.com/2016/06/21/scraping-ticket-data-with-stubhub-api/ | |
# Updated 3/5/2017 for Python 3 and Stubhub's InventorySearchAPI - v2 | |
import requests | |
import base64 | |
import json | |
import pprint | |
import pandas as pd | |
import datetime | |
#### Step 1: # Obtaining StubHub User Access Token #### | |
## Enter user's API key, secret, and Stubhub login | |
app_token = input('Enter app token: ') | |
consumer_key = input('Enter consumer key: ') | |
consumer_secret = input('Enter consumer secret: ') | |
stubhub_username = input('Enter Stubhub username (email): ') | |
stubhub_password = input('Enter Stubhub password: ') | |
## Generating basic authorization token | |
combo = consumer_key + ':' + consumer_secret | |
basic_authorization_token = base64.b64encode(combo.encode('utf-8')) | |
# print(basic_authorization_token) | |
## POST parameters for API call | |
headers = { | |
'Content-Type':'application/x-www-form-urlencoded', | |
'Authorization':'Basic '+basic_authorization_token.decode('utf-8'),} | |
body = { | |
'grant_type':'password', | |
'username':stubhub_username, | |
'password':stubhub_password, | |
'scope':'PRODUCTION'} | |
## Making the call | |
url = 'https://api.stubhub.com/login' | |
r = requests.post(url, headers=headers, data=body) | |
token_respoonse = r.json() | |
access_token = token_respoonse['access_token'] | |
user_GUID = r.headers['X-StubHub-User-GUID'] | |
#### Step 2 - Searching inventory for an event #### | |
inventory_url = 'https://api.stubhub.com/search/inventory/v2' | |
headers['Authorization'] = 'Bearer ' + access_token | |
headers['Accept'] = 'application/json' | |
headers['Accept-Encoding'] = 'application/json' | |
## Enter event ID | |
eventid = '9837052' | |
data = {'eventid':eventid} | |
## GET request and change to Pandas dataframe | |
inventory = requests.get(inventory_url, headers=headers, params=data) | |
inv = inventory.json() | |
listing_df = pd.DataFrame(inv['listing']) | |
## Getting ticket prices out of the currentPice column of dicts - assuming they're all in USD | |
listing_df['amount'] = listing_df.apply(lambda x: x['currentPrice']['amount'], axis=1) | |
## Export to a csv file | |
listing_df.to_csv('tickets_listing.csv', index=False) | |
#### Step 3 - Adding Event and Venue Info #### | |
## Calling the eventsearch api | |
info_url = 'https://api.stubhub.com/catalog/events/v2/' + eventid | |
info = requests.get(info_url, headers=headers) | |
# pprint.pprint(info.json()) | |
info_dict = info.json() | |
event_date = datetime.datetime.strptime(info_dict['eventDateLocal'][:10], '%Y-%m-%d') | |
event_name = info_dict['title'] | |
event_date = info_dict['eventDateLocal'][:10] | |
venue = info_dict['venue']['name'] | |
snapshot_date = datetime.datetime.today().strftime('%m/%d/%Y') | |
listing_df['snapshotDate'] = snapshot_date | |
listing_df['eventName'] = event_name | |
listing_df['eventDate'] = event_date | |
listing_df['venue'] = venue | |
my_col = ['snapshotDate','eventName','eventDate', 'venue', 'sectionName', 'row', | |
'seatNumbers', 'quantity', 'deliveryTypeList', 'amount'] | |
final_df = listing_df[my_col] | |
## Exporting final report | |
final_df.to_csv('tickets_listing_with_info.csv', index=False) |
@Chris123xc that's what you'll have to provide with your stubhub API credentials (if the API is still available, it's been a few years since i wrote this up)
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
What are you using for app token input?