GAS x freeeAPIライブラリのトリセツ「定期的に届くメールからfreeeの取引を作成しよう！」その3 – 雛形オブジェクトをGETしよう

function getSampleDeal_01() {
  const accessToken = getService().getAccessToken(); // アクセストークンを取得
  const company_id = freeeAPI.myCompanies(accessToken).getMyCompanyId('開発用テスト事業所');
  const deals_freeeAPI = freeeAPI.deals(accessToken, company_id); //freeeAPIライブラリのdeals操作オブジェクトを作成
  deals_freeeAPI.queries.start_issue_date = '2022-06-01'; // 取引発生日の期間開始日を指定
  const aryAllDeals = deals_freeeAPI.getAllDeals();
  console.log(aryAllDeals);
}

deals_freeeAPI.queries.start_issue_date = '2022-06-01'; // 取引発生日の期間開始日を指定

const targetTagId = freeeAPI.tags(accessToken, company_id).getIdByName('*雛形');

{
  "deals": [
    {
      "id": 101,
      "company_id": 1,
      "issue_date": "2019-12-17",
      "due_date": "2019-12-17",
      "amount": 5250,
      "due_amount": 0,
      "type": "expense",
      "partner_id": 201,
      "partner_code": "code001",
      "ref_number": "123-456",
      "status": "settled",
      "details": [
        {
          "id": 11,
          "account_item_id": 803,
          "tax_code": 2,
          "item_id": 501,
          "section_id": 1,
          "tag_ids": [
            1,
            2,
            3
          ],
          "segment_1_tag_id": 1,
          "segment_2_tag_id": 1,
          "segment_3_tag_id": 1,
          "amount": 5250,
          "vat": 250,
          "description": "備考",
          "entry_side": "debit"
        }
      ],
      "renews": [
        {
          "id": 11,
          "update_date": "2019-12-17",
          "renew_target_id": 12,
          "renew_target_type": "detail",
          "details": [
            {
              "id": 1,
              "entry_side": "debit",
              "account_item_id": 1,
              "tax_code": 1,
              "item_id": 1,
              "section_id": 1,
              "tag_ids": [
                1
              ],
              "segment_1_tag_id": 1,
              "segment_2_tag_id": 1,
              "segment_3_tag_id": 1,
              "amount": 108000,
              "vat": 8000,
              "description": "備考"
            }
          ]
        }
      ],
      "payments": [
        {
          "id": 202,
          "date": "2019-12-17",
          "from_walletable_type": "bank_account",
          "from_walletable_id": 103,
          "amount": 5250
        }
      ],
      "receipts": [
        {
          "id": 1,
          "status": "unconfirmed",
          "description": "タクシー利用",
          "mime_type": "image/png",
          "issue_date": "2019-12-17",
          "origin": "public_api",
          "created_at": "2019-12-17T18:30:24+09:00",
          "user": {
            "id": 1,
            "email": "contact@example.com",
            "display_name": "フリー太郎"
          }
        }
      ]
    }
  ],
  "meta": {
    "total_count": 100
  }
}

const aryTatgetDeals = allDeals.filter(deal => deal.details.filter(detail => detail.tag_ids.includes(targetTagId)).length);

function getSampleDeal_02() {
  const accessToken = getService().getAccessToken(); // アクセストークンを取得
  const company_id = freeeAPI.myCompanies(accessToken).getMyCompanyId('開発用テスト事業所');

  const deals_freeeAPI = freeeAPI.deals(accessToken, company_id); //freeeAPIライブラリのdeals操作オブジェクトを作成
  deals_freeeAPI.queries.start_issue_date = '2022-06-01'; // 取引発生日の期間開始日を指定
  const aryAllDeals = deals_freeeAPI.getAllDeals(); // 指定条件の全取引を取得

  // ターゲットマーカーとなるメモタグIDを取得
  const targetTagId = freeeAPI.tags(accessToken, company_id).getIdByName('*雛形');
  // ターゲットマーカーとなるメモタグを含む取引を抽出
  const aryTatgetDeals = aryAllDeals.filter(deal => deal.details.filter(detail => detail.tag_ids.includes(targetTagId)).length);
  console.log(aryTatgetDeals);
}

function getSampleDeal_03() {
  const accessToken = getService().getAccessToken(); // アクセストークンを取得
  const company_id = freeeAPI.myCompanies(accessToken).getMyCompanyId('開発用テスト事業所');
  
  const deal_freeeAPI = freeeAPI.deal(accessToken, company_id); //freeeAPIライブラリのdeal操作オブジェクトを作成
  const deal_id = 1288629768; // 取得したい取引のID
  const targetDeal = deal_freeeAPI.getDeal(deal_id); // 指定したIDの取引を取得するメソッド
  console.log(targetDeal);
  
}