Out of my depth with Refresh Token etc for personal discord bot | Search API

xleumas · 2025-10-13T19:27:02.935000Z

Hi all, I'll be the first to admit I'm out of my depth, so apologies to anyone who actually knows what they're doing. I've used ChatGPT to try and make a simple discord bot that I can use personally to grab the recently sold items from the last 10 days for any item following a '!lastsold' command.I have no idea if I'm getting the correct token required for my python script; however, I follow the following steps:1) Log in2) Top right, hover my username and click "user access tokens".3) This loads my App, and I'm using Production not Sandbox4) I select 'OAuth' under "get a user token here", and sign into production.5) This then generates a token, starting 'v1.1' etc.I input my credentials into a notepad and copy and paste it into a Powershell, which in turn activates (turns it online) my bot within discord:$env:DISCORD_TOKEN = "YOUR_DISCORD_BOT_TOKEN"$env:EBAY_APP_ID = "YOUR_EBAY_APP_ID"$env:EBAY_CERT_ID = "YOUR_EBAY_CERT_ID"$env:EBAY_REFRESH_TOKEN = "YOUR_EBAY_REFRESH_TOKEN"python bot.pyI'm fairly confident I've accurately obtained my Discord Token, and the eBay App ID and Cert (I get these from the Application Keys screen), and I then paste the token obtained at the beginning where it's required in the above.The python script written for me by ChatGPT is below:import osimport timeimport base64import loggingimport requestsimport discordfrom discord.ext import commandsfrom datetime import datetime, timedelta, timezone# -------------------------------------------------# Setup logging# -------------------------------------------------logging.basicConfig(level=logging.INFO, format="%(asctime)s [%(levelname)s] %(message)s")# -------------------------------------------------# Environment variables# -------------------------------------------------DISCORD_TOKEN = os.getenv("DISCORD_TOKEN")EBAY_APP_ID = os.getenv("EBAY_APP_ID")EBAY_CERT_ID = os.getenv("EBAY_CERT_ID")EBAY_REFRESH_TOKEN = os.getenv("EBAY_REFRESH_TOKEN")for name, val in {"DISCORD_TOKEN": DISCORD_TOKEN,"EBAY_APP_ID": EBAY_APP_ID,"EBAY_CERT_ID": EBAY_CERT_ID,"EBAY_REFRESH_TOKEN": EBAY_REFRESH_TOKEN}.items():if not val:raise SystemExit(f"❌ Missing environment variable: {name}")# -------------------------------------------------# Discord setup# -------------------------------------------------intents = discord.Intents.default()intents.message_content = Truebot = commands.Bot(command_prefix="!", intents=intents)# -------------------------------------------------# eBay OAuth Helpers# -------------------------------------------------_access_token = None_token_expiry = 0def refresh_ebay_token():"""Refresh eBay OAuth token."""global _access_token, _token_expiryurl = "https://api.ebay.com/identity/v1/oauth2/token"creds = f"{EBAY_APP_ID}:{EBAY_CERT_ID}"encoded = base64.b64encode(creds.encode()).decode()headers = {"Authorization": f"Basic {encoded}","Content-Type": "application/x-www-form-urlencoded"}data = {"grant_type": "refresh_token","refresh_token": EBAY_REFRESH_TOKEN,"scope": "https://api.ebay.com/oauth/api_scope https://api.ebay.com/oauth/api_scope/buy.marketplace.insights"}try:resp = requests.post(url, headers=headers, data=data, timeout=15)resp.raise_for_status()info = resp.json()_access_token = info["access_token"]_token_expiry = time.time() + info.get("expires_in", 7200)logging.info("✅ eBay token refreshed.")return _access_tokenexcept Exception as e:logging.error("❌ eBay token refresh failed: %s", e)if resp.text:logging.error("Response: %s", resp.text)return Nonedef get_token():global _access_token, _token_expiryif not _access_token or time.time() >= _token_expiry:return refresh_ebay_token()return _access_token# -------------------------------------------------# eBay API Lookup# -------------------------------------------------def get_sold_items(keyword):token = get_token()if not token:return []url = "https://api.ebay.com/buy/marketplace-insights/v1/item_sales/search"headers = {"Authorization": f"Bearer {token}"}# Compute date 10 days ago (ISO format)start_date = (datetime.now(timezone.utc) - timedelta(days=10)).strftime("%Y-%m-%dT%H:%M:%SZ")params = {"q": keyword,"limit": "5","filter": f"marketplaceIds:EBAY_GB,soldDate:[{start_date}..]"}try:r = requests.get(url, headers=headers, params=params, timeout=15)r.raise_for_status()data = r.json()items = []for item in data.get("itemSummaries", []):title = item.get("title", "Unknown")price = item.get("price", {}).get("value", "?")currency = item.get("price", {}).get("currency", "")sold_date = item.get("soldDate", "Unknown")url = item.get("itemWebUrl", "")items.append((title, price, currency, sold_date, url))return itemsexcept Exception as e:logging.error("Error fetching eBay sold data: %s", e)if r.text:logging.error("Response: %s", r.text)return []# -------------------------------------------------# Discord Command# -------------------------------------------------@bot.command(name="sold")async def sold(ctx, *, search_term: str):"""Lookup last sold items on eBay UK in the last 10 days."""await ctx.send(f"🔍 Searching for sold items: **{search_term}** (UK, last 10 days)...")items = get_sold_items(search_term)if not items:await ctx.send("❌ No recent sales found or API error.")returnembed = discord.Embed(title=f"🛒 Last Sold eBay Items for '{search_term}'",color=discord.Color.blue(),timestamp=datetime.now(timezone.utc))for title, price, currency, sold_date, link in items:embed.add_field(name=f"{price} {currency} — {sold_date}",value=f"[{title}]({link})",inline=False)await ctx.send(embed=embed)# -------------------------------------------------# Run Bot# -------------------------------------------------@bot.eventasync def on_ready():logging.info(f"🤖 Logged in as {bot.user}")if __name__ == "__main__":refresh_ebay_token()bot.run(DISCORD_TOKEN)When I try and run it in Powershell, my bot activates, but I get the following errors:2025-10-13 20:10:48,234 [WARNING] PyNaCl is not installed, voice will NOT be supported2025-10-13 20:10:49,059 [ERROR] ❌ eBay token refresh failed: 400 Client Error: Bad Request for url: https://api.ebay.com/identity/v1/oauth2/token2025-10-13 20:10:49,059 [ERROR] Response: {"error":"invalid_grant","error_description":"the provided authorization refresh token is invalid or was issued to another client"}[2025-10-13 20:10:49] [INFO ] discord.client: logging in using static token2025-10-13 20:10:49,061 [INFO] logging in using static token The bot comes online, but doesn't work due to the above. I know I can ignore the PyNaCl error, I've dealt with that in previous attempts to get this bot working. The only thing I can think, is that I'm trusting ChatGPT blindly, and it's wrong. Is anyone here able to share their expertise and highlight my error/the code error, please? Thanks in advance.

Discussions

Out of my depth with Refresh Token etc for personal discord bot | Search API | eBay Community