Skip to content

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

1.8 KB
Raw Blame
import { SeekPage } from '@activepieces/core-utils';
import {
  CreateRecordsRequest,
  DeleteRecordsRequest,
  ListRecordsRequest,
  PopulatedRecord,
  UpdateRecordRequest,
} from '@activepieces/shared';

import { api } from '@/lib/api';

import { FieldsMapping } from '../utils/utils';

export const recordsApi = {
  list(request: ListRecordsRequest): Promise<SeekPage<PopulatedRecord>> {
    return api.get<SeekPage<PopulatedRecord>>('/v1/records', request);
  },

  create(request: CreateRecordsRequest): Promise<PopulatedRecord[]> {
    return api.post<PopulatedRecord[]>('/v1/records', request);
  },

  getById(id: string): Promise<PopulatedRecord> {
    return api.get<PopulatedRecord>(`/v1/records/${id}`);
  },

  update(id: string, request: UpdateRecordRequest): Promise<PopulatedRecord> {
    return api.post<PopulatedRecord>(`/v1/records/${id}`, request);
  },

  delete(request: DeleteRecordsRequest): Promise<void> {
    return api.delete<void>(`/v1/records/`, undefined, request);
  },

  async importCsv({
    csvRecords,
    tableId,
    fieldsMapping,
    maxRecordsLimit,
  }: {
    csvRecords: string[][];
    tableId: string;
    fieldsMapping: FieldsMapping;
    maxRecordsLimit: number;
  }) {
    const records: CreateRecordsRequest['records'] = csvRecords.map(
      (recordCells) => {
        return recordCells
          .map((value, index) => {
            const fieldMapping = fieldsMapping[index];
            if (!fieldMapping) {
              return null;
            }
            return {
              value: value,
              fieldId: fieldMapping,
            };
          })
          .filter((cell) => cell !== null);
      },
    );
    return await recordsApi.create({
      tableId,
      records: records.slice(0, maxRecordsLimit),
    });
  },
};