← back to Filemaker Mcp

scripts/_gl_recon.mjs

12 lines

import * as fm from '../src/fm-client.js';
const FULL = '*List Wallpapers - Full View';
const byCork = await fm.findRecords('WALLPAPER', FULL, { 'combo sku': 'CORK*' }, { limit: 5 }).catch(e=>({records:[],err:e.fmCode}));
console.log('existing combo sku CORK*:', byCork.records?.length ?? 0, byCork.err||'');
byCork.records?.slice(0,3).forEach(r=>console.log('   combo=',r.fieldData['combo sku'],'| Mfr=',r.fieldData['Mfr Pattern'],'| Series=',r.fieldData['Series'],'| Supplier=',r.fieldData['Supplier'],'| Name=',r.fieldData['Name of Pattern']));
const pr = await fm.findRecords('WALLPAPER', FULL, { 'Supplier': 'Phillipe Romano' }, { limit: 3 }).catch(e=>({records:[],err:e.fmCode}));
console.log('existing Supplier=Phillipe Romano:', pr.records?.length ?? 0, pr.err||'');
pr.records?.slice(0,3).forEach(r=>console.log('   combo=',r.fieldData['combo sku'],'| Mfr=',r.fieldData['Mfr Pattern'],'| Series=',r.fieldData['Series'],'| Name=',r.fieldData['Name of Pattern'],'| vid=',r.fieldData['vid']));
const any = pr.records?.[0] || byCork.records?.[0];
if (any) console.log('KEY FIELDS:', Object.keys(any.fieldData).filter(k=>/pattern|color|series|supplier|width|vid|jpg|combo|name|sku|mfr/i.test(k)).join(' | '));
else console.log('(no sample record to list fields)');