← back to Filemaker Mcp

scripts/_gl_recon3.mjs

15 lines

import * as fm from '../src/fm-client.js';
const FULL = '*List Wallpapers - Full View';
// bare fetch — list a few records, no filter
try {
  const r = await fm.listRecords ? await fm.listRecords('WALLPAPER', FULL, { limit: 3 }) : null;
  if(r) console.log('listRecords works:', r.records?.length);
} catch(e){ console.log('no listRecords', e.message); }
// try a findRecords with a very broad query
for (const q of [{'Supplier':'*'}, {'combo sku':'*'}]) {
  try { const r = await fm.findRecords('WALLPAPER', FULL, q, { limit: 2 });
    console.log('query', JSON.stringify(q), '→', r.records?.length, 'records');
    if(r.records?.[0]){ const f=r.records[0].fieldData; console.log('   combo sku=',f['combo sku'],'| Supplier=',f['Supplier']); console.log('   FIELD KEYS:', Object.keys(f).join(' | ').slice(0,600)); break; }
  } catch(e){ console.log('query', JSON.stringify(q), 'ERR', e.fmCode||e.message); }
}