別ドメインのレコードを取得（kintone JavaScript API）

get.js

(() => {
  "use strict";

  kintone.events.on(["app.record.detail.show"], async (event) => {
    const domain = "xxx.cybozu.com";
    const app = "xxx";
    const headers = {
      "X-Cybozu-API-Token": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
    };
    const query = encodeURIComponent('会社名 = "金都運総研"');

    const url = `https://${domain}/k/v1/records.json`;
    const queryString = `?app=${app}&query=${query}&fields[0]=$id&fields[1]=$revision&fields[2]=会社名&totalCount=true`;
    const res = await kintone.proxy(`${url}${queryString}`, "GET", headers, {});
    const { records, totalCount, message } = JSON.parse(res[0]);
    if (res[1] === 200) {
      console.log(records);
      console.log(totalCount);
    } else {
      console.log(message);
    }

    return event;
  });
})();

get.ts

import qs from "qs";

interface DetailEvent {
  appId: number;
  record: kintone.types.SavedFields;
  recordId: number;
  type: string;
}

interface Params {
  app: string;
  query: string;
  fields: string[];
  totalCount: boolean;
}

kintone.events.on(["app.record.detail.show"], async (event: DetailEvent) => {
  const domain = "xxx.cybozu.com";
  const app = "xxx";
  const headers = {
    "X-Cybozu-API-Token": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
  };
  const params: Params = {
    app,
    query: '会社名 = "金都運総研"',
    fields: ["$id", "$revision", "会社名"],
    totalCount: true,
  };
  
  const url = `https://${domain}/k/v1/records.json`;
  const res = await kintone.proxy(
    `${url}?${qs.stringify(params)}`,
    "GET",
    headers,
    {}
  );
  const { records, totalCount, message } = JSON.parse(res[0]);
  if (res[1] === 200) {
    console.log(records);
    console.log(totalCount);
  } else {
    console.log(message);
  }

  return event;
});

post.js

(() => {
  "use strict";

  kintone.events.on(["app.record.detail.show"], async (event) => {
    const domain = "xxx.cybozu.com";
    const app = "xxx";
    const headers = {
      "X-Cybozu-API-Token": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
      "Content-Type": "application/json",
      "X-HTTP-Method-Override": "GET",
    };
    const data = {
      app,
      query: '会社名 = "金都運総研"',
      fields: ["$id", "$revision", "会社名"],
      totalCount: true,
    };

    const url = `https://${domain}/k/v1/records.json`;
    const res = await kintone.proxy(url, "POST", headers, data);
    const { records, totalCount, message } = JSON.parse(res[0]);
    if (res[1] === 200) {
      console.log(records);
      console.log(totalCount);
    } else {
      console.log(message);
    }

    return event;
  });
})();

post.ts

interface DetailEvent {
  appId: number;
  record: kintone.types.SavedFields;
  recordId: number;
  type: string;
}

interface Params {
  app: string;
  query: string;
  fields: string[];
  totalCount: boolean;
}

kintone.events.on(["app.record.detail.show"], async (event: DetailEvent) => {
  const domain = "xxx.cybozu.com";
  const app = "xxx";
  const headers = {
    "X-Cybozu-API-Token": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
    "Content-Type": "application/json",
    "X-HTTP-Method-Override": "GET",
  };
  const params: Params = {
    app,
    query: '会社名 = "金都運総研"',
    fields: ["$id", "$revision", "会社名"],
    totalCount: true,
  };

  const url = `https://${domain}/k/v1/records.json`;
  const res = await kintone.proxy(url, "POST", headers, params);
  const { records, totalCount, message } = JSON.parse(res[0]);
  if (res[1] === 200) {
    console.log(records);
    console.log(totalCount);
  } else {
    console.log(message);
  }

  return event;
});