SEC API Airtable Tracker

const config = input.config();
const rapidapiKey = input.secret.RAPIDAPI_KEY;
const tickers = config.tickers || "AAPL,MSFT,NVDA";
const since = config.since || "2026-07-01";
const table = base.getTable("SEC Filings");

const params = new URLSearchParams({
  tickers,
  since,
  limit: "25"
});

const response = await fetch(
  `https://sec-event-intelligence.p.rapidapi.com/v1/sec/watchlist/changes?${params}`,
  {
    headers: {
      "x-rapidapi-host": "sec-event-intelligence.p.rapidapi.com",
      "x-rapidapi-key": rapidapiKey
    }
  }
);

if (!response.ok) {
  throw new Error(await response.text());
}

const payload = await response.json();
const records = [];

for (const group of payload.data || []) {
  for (const change of group.changes || []) {
    const filing = change.filing || {};
    records.push({
      fields: {
        Ticker: group.ticker,
        Form: filing.form || "",
        Company: filing.companyName || "",
        "Filed At": filing.filedAt || "",
        Accession: filing.accessionNo || "",
        URL: filing.filingUrl || ""
      }
    });
  }
}

const insertedCount = records.length;
while (records.length) {
  await table.createRecordsAsync(records.splice(0, 50));
}

output.set("insertedCount", insertedCount);