jsforce

import jsforce from 'jsforce'; async function connectAndQuery() { const conn = new jsforce.Connection({ // When using OAuth2, configure it here. For username/password flow, loginUrl is sufficient. // oauth2: { // loginUrl: process.env.SF_LOGIN_URL ?? 'https://login.salesforce.com', // clientId: process.env.SF_CLIENT_ID ?? '', // clientSecret: process.env.SF_CLIENT_SECRET ?? '', // redirectUri: process.env.SF_REDIRECT_URI ?? '', // } loginUrl: process.env.SF_LOGIN_URL ?? 'https://login.salesforce.com' }); try { // Authenticate using username-password flow (convenient for scripts, but consider OAuth for broader applications) await conn.login( process.env.SF_USERNAME ?? '', process.env.SF_PASSWORD_TOKEN ?? '' // password + security token (if enabled) ); console.log('Successfully connected to Salesforce!'); console.log('Instance URL:', conn.instanceUrl); console.log('User ID:', conn.userInfo?.id); // Perform a SOQL query to fetch the first 5 Account records const result = await conn.query<{ Id: string; Name: string }>('SELECT Id, Name FROM Account LIMIT 5'); console.log('Query Results (first 5 Accounts):'); result.records.forEach(record => { console.log(` ID: ${record.Id}, Name: ${record.Name}`); }); // Example: Create a new Lead record const createResult = await conn.sobject('Lead').create({ LastName: `JSforce Lead ${Date.now()}`, Company: 'JSforce Corp', Status: 'Open - Not Contacted' }); console.log(`Created Lead with ID: ${createResult.id}, success: ${createResult.success}`); // Example: Retrieve the newly created Lead record if (createResult.success) { const retrievedLead = await conn.sobject('Lead').retrieve(createResult.id); console.log(`Retrieved Lead: ${retrievedLead.LastName} from ${retrievedLead.Company}`); } } catch (err: any) { console.error('Error connecting or performing Salesforce operations:', err.message); } } connectAndQuery();