salesforce-sdk-patterns

# Salesforce SDK Patterns ## Overview Production-ready patterns for jsforce (Node.js) and simple-salesforce (Python) — singleton connections, typed queries, error handling, and token refresh. ## Prerequisites - Completed `salesforce-install-auth` setup - Familiarity with async/await and TypeScript generics - Understanding of Salesforce sObject model ## Instructions ### Step 1: Singleton Connection with Auto-Refresh ```typescript // src/salesforce/connection.ts import jsforce from 'jsforce'; let conn: jsforce.Connection | null = null; export async function getConnection(): Promise<jsforce.Connection> { if (conn?.accessToken) { // Test if token is still valid try { await conn.identity(); return conn; } catch { conn = null; // Token expired, reconnect } } conn = new jsforce.Connection({ loginUrl: process.env.SF_LOGIN_URL || 'https://login.salesforce.com', version: '59.0', // Pin API version for stability }); await conn.login( process.env.SF_USERNAME!, process.env.SF_PASSWORD! + process.env.SF_SECURITY_TOKEN! ); return conn; } ``` ### Step 2: Typed sObject Interfaces ```typescript // src/salesforce/types.ts /** Standard Salesforce sObject base fields */ interface SObjectBase { Id: string; CreatedDate: string; LastModifiedDate: string; SystemModstamp: string; IsDeleted: boolean; } export interface Account extends SObjectBase { Name: string; Industry?: string; AnnualRevenue?: number; Num...