1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107
| await conn.query('SELECT Id, Name FROM Account') await conn.sobject("Contact").count() conn.sobject('Contact').count({}) conn.sobject("Contact") .find( { LastName : { $like : 'A%', $ne: null $not: { $ne: null } }, CreatedDate: { $gte : jsforce.Date.YESTERDAY }, 'Account.Name' : 'Sony, Inc.' }, { Id: 1, Name: 1, CreatedDate: 1 } ) .sort({ CreatedDate: -1, Name : 1 }) .limit(5) .skip(10) .execute(function(err, records) { if (err) { return console.error(err); } console.log("fetched : " + records.length); });
conn.sobject("Contact") .select('*, Account.*') .where("CreatedDate = TODAY") .limit(10) .offset(20) .execute(function(err, records) { for (var i=0; i<records.length; i++) { var record = records[i]; console.log("First Name: " + record.FirstName); } });
conn.sobject("Contact") .select('*, Account.*') .include("Cases") .select("*") .where({ Status: 'New', OwnerId : conn.userInfo.id, }) .orderby("CreatedDate", "DESC") .end() .where("CreatedDate = TODAY") .limit(10) .offset(20) .execute()
conn.sobject("Contact").find({ CreatedDate: jsforce.Date.TODAY }) conn.sobject("Contact").find({ CreatedDate: jsforce.Date.TODAY }, '*')
conn.search("FIND {Un*} IN ALL FIELDS RETURNING Account(Id, Name), Lead(Id, Name)", function(err, res) { if (err) { return console.error(err); } console.log(res); } );
await conn.sobject("Account").retrieve("0017000000hOMChAAO"); await conn.sobject("Account").retrieve(["0017000000hOMChAAO", "0017000000hOMChAAO"]);
await conn.sobject("Account").create({ Name : 'My Account #1' }); await conn.sobject("Account").create([{ Name : 'My Account #1'}, { Name : 'My Account #2'} ]); await conn.sobject("Account").create(accounts, {allowRecursive: true});
await conn.sobject("Account").update({ Id : '0017000000hOMChAAO', Name : 'Updated Account #1' }; await conn.sobject("Account").update([ { Id : '0017000000hOMChAAO', Name : 'Updated Account #1' }, { Id : '0017000000iKOZTAA4', Name : 'Updated Account #2' } ]; await conn.sobject('Opportunity') .find({ 'Account.Name' : 'Salesforce.com' }) .update({ CloseDate: '2013-08-31' }
await conn.sobject("UpsertTable__c").upsert({ Name : 'Record #1', ExtId__c : 'ID-0000001' }, 'ExtId__c')
await conn.sobject("Account").destroy('0017000000hOMChAAO'); await conn.sobject('Account').find({xxx}).destroy() conn.sobject("Account").del(['0017000000hOMChAAO','0017000000iKOZTAA4'];
|