maintainx-data-handling

# MaintainX Data Handling ## Overview Patterns for synchronizing, transforming, and exporting data between MaintainX and external systems (databases, data warehouses, ERPs). ## Prerequisites - MaintainX API access configured - Node.js 18+ with `axios` - Target database or data warehouse available ## Instructions ### Step 1: Incremental Sync with Cursor Pagination ```typescript import { MaintainXClient } from './client'; import { writeFileSync, existsSync, readFileSync } from 'fs'; const SYNC_STATE_FILE = '.maintainx-sync-state.json'; interface SyncState { lastSyncAt: string; workOrderCursor?: string; assetCursor?: string; } function loadSyncState(): SyncState { if (existsSync(SYNC_STATE_FILE)) { return JSON.parse(readFileSync(SYNC_STATE_FILE, 'utf-8')); } return { lastSyncAt: new Date(0).toISOString() }; } function saveSyncState(state: SyncState) { writeFileSync(SYNC_STATE_FILE, JSON.stringify(state, null, 2)); } async function incrementalSync(client: MaintainXClient) { const state = loadSyncState(); const syncStart = new Date().toISOString(); console.log(`Syncing changes since ${state.lastSyncAt}`); // Sync work orders updated since last run let cursor: string | undefined; let totalWOs = 0; do { const response = await client.getWorkOrders({ updatedAtGte: state.lastSyncAt, limit: 100, cursor, }); for (const wo of response.workOrders) { await upsertWorkOrder(wo); // Your DB write function to...