1.5.0 — Reviewed AI changes, native spreadsheets and personal memory

const { session } = await storage.createUploadSession({
  name: 'price-report.xlsx',
  contentTypeHint:
    'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
  writeMode: 'staged',
  sheets: [
    {
      name: 'Prices',
      freeze: { rows: 1 },
      table: {
        header: true,
        autoFilter: true,
        columns: [
          { key: 'sku', header: 'SKU', type: 'string', width: 22 },
          {
            key: 'price', header: 'Price', type: 'number',
            style: { numFmt: '#,##0.00' },
          },
        ],
      },
    },
    { name: 'Summary' },
  ],
});

await storage.uploadPart(session.storageUploadSessionId, {
  sheets: [
    {
      sheet: 'Prices',
      rows: [
        { sku: '000100', price: 19.95 },
        { sku: '000200', price: 29.95 },
      ],
    },
    {
      sheet: 'Summary',
      cells: [
        { address: 'A1', value: 'Total price' },
        { address: 'B1', formula: 'SUM(Prices!B2:B3)', result: 49.9 },
      ],
    },
  ],
});

const { entry } =
  await storage.finalizeUploadSession(session.storageUploadSessionId);
return { storageEntryId: entry.storageEntryId };

const { session } = await storage.createUploadSession({
  name: 'customers.csv',
  contentTypeHint: 'text/csv',
  writeMode: 'direct',
  csv: { encoding: 'utf8', bom: true, delimiter: ';' },
  sheets: [{
    name: 'Customers',
    table: {
      header: true,
      columns: [
        { key: 'id', header: 'Customer ID' },
        { key: 'name', header: 'Customer name' },
      ],
    },
  }],
});
await storage.uploadPart(session.storageUploadSessionId, {
  rows: [{ id: '000042', name: 'Müller & Co.' }],
});
const result =
  await storage.finalizeUploadSession(session.storageUploadSessionId);
return { entry: result.entry, stats: result.fileStats };

const response = await api.httpCall(
  {
    url: 'https://provider.example/events',
    method: 'POST',
    headers: { Accept: 'text/event-stream' },
    data: { stream: true },
  },
  {
    requestType: 'json',
    responseType: 'stream',
    streamFormat: 'sse',
    timeout: 60000,
  },
);
let eventCount = 0;
try {
  if (response.status < 200 || response.status >= 300) {
    return { status: response.status };
  }
  for await (const event of response.data) {
    // Decode event.data according to the provider's documented format.
    if (event.event === 'completed' || event.data === '[DONE]') break;
    eventCount++;
  }
  return { eventCount };
} finally {
  await response.close();
}