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

3.3 KB
Raw Blame
import { GlideRow, GlideRowValue } from './types';

export function parseRequiredString(value: unknown, fieldName: string): string {
  if (typeof value !== 'string' || value.trim().length === 0) {
    throw new Error(`${fieldName} is required.`);
  }

  return value.trim();
}

export function parseGlideRow(value: unknown): GlideRow {
  if (!isGlideRow(value)) {
    throw new Error('Row must be a JSON object.');
  }

  return value;
}

export function parseGlideRows(value: unknown): GlideRow[] {
  if (!Array.isArray(value) || !value.every((row) => isGlideRow(row))) {
    throw new Error('Rows must be an array of JSON objects.');
  }

  return value;
}

export function flattenGlideRows(rows: GlideRow[]): FlatRecord[] {
  return normalizeRecords(rows.map(flattenRecord));
}


function flattenRecord(value: GlideRow): FlatRecord {
  const flattened: FlatRecord = {};
  flattenIntoRecord(value, '', flattened);
  return flattened;
}

function normalizeRecords(records: FlatRecord[]): FlatRecord[] {
  const keys = new Set<string>();

  for (const record of records) {
    for (const key of Object.keys(record)) {
      keys.add(key);
    }
  }

  const normalizedKeys = Array.from(keys);

  return records.map((record) => {
    const normalized: FlatRecord = {};

    for (const key of normalizedKeys) {
      normalized[key] = record[key] ?? null;
    }

    return normalized;
  });
}

function flattenIntoRecord(
  value: GlideRowValue | undefined,
  prefix: string,
  flattened: FlatRecord,
): void {
  if (value === undefined) {
    if (prefix) {
      flattened[prefix] = null;
    }
    return;
  }

  if (
    value === null ||
    typeof value === 'string' ||
    typeof value === 'number' ||
    typeof value === 'boolean'
  ) {
    if (prefix) {
      flattened[prefix] = value;
    }
    return;
  }

  if (Array.isArray(value)) {
    if (prefix) {
      flattened[prefix] = formatArrayValue(value);
    }
    return;
  }

  for (const [key, nestedValue] of Object.entries(value)) {
    const nextPrefix = prefix ? `${prefix}_${key}` : key;
    flattenIntoRecord(nestedValue, nextPrefix, flattened);
  }
}

function formatArrayValue(values: GlideRowValue[]): PrimitiveValue {
  if (values.length === 0) {
    return null;
  }

  return values
    .map((value) => {
      if (value === null) {
        return 'null';
      }

      if (
        typeof value === 'string' ||
        typeof value === 'number' ||
        typeof value === 'boolean'
      ) {
        return String(value);
      }

      if (Array.isArray(value)) {
        return formatArrayValue(value) ?? '';
      }

      return JSON.stringify(flattenRecord(value));
    })
    .join(', ');
}

function isGlideRow(value: unknown): value is GlideRow {
  if (typeof value !== 'object' || value === null || Array.isArray(value)) {
    return false;
  }

  return Object.values(value).every((item) => isGlideRowValue(item));
}

function isGlideRowValue(value: unknown): value is GlideRowValue {
  if (
    value === null ||
    typeof value === 'string' ||
    typeof value === 'number' ||
    typeof value === 'boolean'
  ) {
    return true;
  }

  if (Array.isArray(value)) {
    return value.every((item) => isGlideRowValue(item));
  }

  return isGlideRow(value);
}

type PrimitiveValue = string | number | boolean | null;

export type FlatRecord = Record<string, PrimitiveValue>;