Pokemon card prices in Google Sheets

=IMPORTDATA("https://api.tickermint.cards/products/517045.csv")

=INDEX(IMPORTDATA("https://api.tickermint.cards/products/517045.csv"), 2, 7)
=INDEX(IMPORTDATA("https://api.tickermint.cards/products/"&A2&".csv"), 2, 7)

=IMPORTDATA("https://api.tickermint.cards/sets/23237.csv")
=XLOOKUP(A2, Prices!B:B, Prices!G:G, "not in set")

/**
 * Latest TickerMint market price of a card, in US dollars.
 * =TICKERMINT(517045) or =TICKERMINT("charizard ex 199/165")
 *
 * @param {number|string} card TickerMint id, or what you would type in search
 * @return {number} TCGplayer market price of the card's main printing
 * @customfunction
 */
function TICKERMINT(card) {
  const text = String(card).trim();
  if (!text) return "";
  const cache = CacheService.getScriptCache();
  const cached = cache.get("tm:" + text.toLowerCase());
  if (cached !== null) return cached ? Number(cached) : "no price";

  let id = text;
  if (!/^\d+$/.test(text)) {
    const q = encodeURIComponent(text);
    const hits = JSON.parse(UrlFetchApp.fetch(`https://api.tickermint.cards/products/search?q=${q}`).getContentText());
    if (!hits.length) return "not found";
    id = hits[0].product_id;
  }
  const rows = Utilities.parseCsv(UrlFetchApp.fetch(`https://api.tickermint.cards/products/${id}.csv`).getContentText());
  const price = rows[1][6]; // market_price_usd
  cache.put("tm:" + text.toLowerCase(), price, 21600); // 6 hours: prices change once a day
  return price ? Number(price) : "no price";
}