Amazon Vendor Central: download remittances with a workflow

{
  "title": "Amazon Vendor Central: remittances and invoices for a period",
  "parameters": [
    {
      "key": "from_date",
      "description": "Start of the payment date range (YYYY-MM-DD)",
      "required": true
    },
    {
      "key": "to_date",
      "description": "End of the payment date range (YYYY-MM-DD)",
      "required": true
    },
    {
      "key": "erp_webhook",
      "description": "Endpoint that receives the remittance list",
      "required": true
    }
  ],
  "runSequentially": true,
  "sequentialKey": "cred_vendor_central",
  "blocks": [
    {
      "blockType": "login",
      "label": "Sign_in",
      "credentialId": "cred_vendor_central",
      "url": "https://vendorcentral.amazon.de/"
    },
    {
      "blockType": "validation",
      "label": "Home_shown",
      "criterion": "The Vendor Central home page of a signed-in vendor is shown, with the Payments menu available and no sign-in, one-time code or captcha form on the page"
    },
    {
      "blockType": "action",
      "label": "Filter_remittances",
      "instruction": "Open Payments, then Remittance, and filter the list to payment dates from {{ from_date }} to {{ to_date }}"
    },
    {
      "blockType": "extraction",
      "label": "Remittances",
      "instruction": "Every remittance in the filtered list: payment number, payment date, amount, currency, and the invoice numbers it covers",
      "schema": {
        "type": "object",
        "properties": {
          "remittances": {
            "type": "array",
            "items": {
              "type": "object",
              "properties": {
                "paymentNumber": {
                  "type": "string"
                },
                "paymentDate": {
                  "type": "string"
                },
                "amount": {
                  "type": "number"
                },
                "currency": {
                  "type": "string"
                },
                "invoiceNumbers": {
                  "type": "array",
                  "items": {
                    "type": "string"
                  }
                }
              },
              "required": [
                "paymentNumber",
                "paymentDate",
                "amount"
              ]
            }
          }
        },
        "required": [
          "remittances"
        ]
      }
    },
    {
      "blockType": "action",
      "label": "Export_list",
      "instruction": "Download the filtered remittance list using the export control the page offers (spreadsheet or CSV)"
    },
    {
      "blockType": "http_request",
      "label": "Post_to_erp",
      "method": "POST",
      "url": "{{ erp_webhook }}",
      "headers": {
        "content-type": "application/json"
      },
      "body": "{{ Remittances_output }}"
    }
  ]
}

import { Browserberg } from '@browserberg/sdk';
import template from './amazon-vendor-central-remittance.json' with { type: 'json' };

const bb = new Browserberg({
  apiKey: process.env.BROWSERBERG_API_KEY,
  baseUrl: 'https://browserberg.com',
});

// Once: the vendor login, released only on vendorcentral.amazon.de.
// With an authenticator app as the second step, add its seed as totpSeed.
const cred = await bb.credentials.create({
  name: 'Vendor Central (AP)',
  url: 'https://vendorcentral.amazon.de/',
  fields: { email: 'ap@example.de', password: process.env.VC_PASSWORD },
  totpSeed: process.env.VC_TOTP_SEED,
  nonSecretFields: ['email'],
});

const wf = await bb.workflows.publish({
  ...template,
  blocks: template.blocks.map((b) =>
    b.blockType === 'login' ? { ...b, credentialId: cred.id } : b),
});

await bb.triggers.create(wf.workflowId, {
  kind: 'schedule', name: 'Monday remittances',
  cron: '0 6 * * 1', timezone: 'Europe/Berlin',
});