Open Data API

curl https://wisepim.com/api/open/v1/gtin/4006381333931

{
  "input": "4006381333931",
  "valid": true,
  "format": "EAN-13",
  "checkDigit": 1,
  "expectedCheckDigit": 1,
  "gtin14": "04006381333931",
  "gs1Prefix": { "prefix": "400", "name": "Germany", "kind": "country", "regions": ["DE"] },
  "error": null,
  "attribution": {
    "required": true,
    "text": "Data by WISEPIM",
    "url": "https://wisepim.com/ean-gtin-validator",
    "html": "<a href=\"https://wisepim.com/ean-gtin-validator\">Data by WISEPIM</a>",
    "markdown": "[Data by WISEPIM](https://wisepim.com/ean-gtin-validator)",
    "terms": "https://wisepim.com/developers/open-data#terms"
  }
}

<a href="https://wisepim.com/developers/open-data"><img src="https://wisepim.com/open-data/data-by-wisepim.svg" alt="Data by WISEPIM" width="132" height="20"></a>

const response = await fetch("https://wisepim.com/api/open/v1/hs-codes/8471?market=eu&lang=en");
const data = await response.json();

// Show the code tree, then the credit the terms ask for:
render(data.node, data.children);
footer.innerHTML = data.attribution.html; // <a href="https://wisepim.com/hs-codes/8471">Data by WISEPIM</a>

import requests

fees = requests.get(
    "https://wisepim.com/api/open/v1/marketplace-fees/amazon",
    params={"market": "DE", "feeType": "commission"},
    timeout=10,
).json()

for row in fees["rows"]:
    print(row["field"], "->", row["value"], "| source:", row["source"]["url"])

print(fees["attribution"]["markdown"])  # [Data by WISEPIM](https://wisepim.com/reports/marketplace-fees-europe)

// Google Sheets: Extensions > Apps Script, paste, save. Then in a cell:
//   =GTIN_VALID(A2)        TRUE or FALSE
//   =HS_SEARCH("sneakers")  best matching heading, e.g. 6402
// Keep a visible "Data by WISEPIM" link in the sheet (see the terms).

function wisepim(path) {
  const response = UrlFetchApp.fetch("https://wisepim.com/api/open/v1" + path, { muteHttpExceptions: true });
  try {
    return JSON.parse(response.getContentText());
  } catch (error) {
    return { error: { message: "WISEPIM answered " + response.getResponseCode() } };
  }
}

function GTIN_VALID(code) {
  const data = wisepim("/gtin/" + encodeURIComponent(String(code).trim()));
  return data.error ? data.error.message : data.valid;
}

function HS_SEARCH(keywords) {
  const data = wisepim("/hs-codes/search?q=" + encodeURIComponent(keywords));
  if (data.error) return data.error.message;
  const top = data.results[0];
  return top ? top.code + " " + top.description : "";
}

// Whole fee tables, no script needed:
//   =IMPORTDATA("https://wisepim.com/api/open/v1/marketplace-fees/bol?format=csv")