bib.gs

bib.gs

// Googleシートからは `=TOROW(BIB(A1))` のように使う。

function BIB(isbn) {
  return _getBibEntriesAsListByIsbn(isbn);
}

function _getBibEntriesAsListByIsbn(isbn) {
  const entries = _getBibEntriesAsMapByIsbn(isbn);
  return [
    entries.isbn,
    entries.title,
    entries.author,
    entries.pubdate,
    entries.publisher,
    entries.cover,
  ];
}

function _getBibEntriesAsMapByIsbn(isbn) {
  const res = _fetchBibEntriesByIsbn(isbn);
  return JSON.parse(res)[0]["summary"];
}

function _fetchBibEntriesByIsbn(isbn) {
  const cache = CacheService.getScriptCache();
  const cached = cache.get(isbn);
  if (cached != null) {
    return cached;
  }
  const url = _IsbnToBibApiURL(isbn);
  const res = UrlFetchApp.fetch(url).getContentText();
  cache.put(isbn, res);
  return res;
}

function _IsbnToBibApiURL(isbn) {
  const ENDPOINT_URL = "https://api.openbd.jp/v1/get";
  const params = {
    "isbn": isbn,
  };
  const query = Object.keys(params).map(key => {
    return `${encodeURIComponent(key)}=${encodeURIComponent(params[key])}`;
  }).join("&");
  return ENDPOINT_URL + "?" + query;
}

function _debug() {
  Logger.log(BIB("9784320123021"));
}