{"id":32126,"date":"2023-05-08T18:20:51","date_gmt":"2023-12-09T03:17:13","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/"},"modified":"2024-04-30T03:14:26","modified_gmt":"2024-04-29T19:14:26","slug":"%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/","title":{"rendered":"\u4f7f\u7528Node.js\u8c03\u7528Salesforce REST API\u6267\u884c\u64cd\u4f5c\uff08\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\uff09"},"content":{"rendered":"

\u9996\u5148<\/h1>\n

\u5728Salesforce\u4e2d\uff0c\u6709\u4e00\u4e2a\u540d\u4e3aSalesforce REST API\u7684\u5de5\u5177\uff0c\u53ef\u4ee5\u5bf9\u5176\u8fdb\u884c\u5404\u79cd\u64cd\u4f5c\u3002<\/p>\n

\u4f7f\u7528Salesforce\u7684REST API\u53ef\u4ee5\u5728Node.js\u4e2d\u8fdb\u884c\u64cd\u4f5c\uff0c\u5982\u6dfb\u52a0\u8bb0\u5f55\u6216\u83b7\u53d6\u8bb0\u5f55\u3002<\/p>\n

\u6211\u4f1a\u5728\u4ee5\u4e0b\u7684\u793a\u4f8b\u7a0b\u5e8f\u4e2d\u8bb0\u5f55\u4f7f\u7528Node.js\u8c03\u7528Salesforce REST API\u6765\u5411Salesforce\u7684Force.com\u81ea\u5b9a\u4e49\u5bf9\u8c61\u4e2d\u6dfb\u52a0\u8bb0\u5f55\u3002<\/p>\n

\u53e6\u5916\uff0c\u6211\u4e5f\u4e00\u5e76\u63d0\u4f9b\u4e00\u4e2a\u793a\u4f8b\u7a0b\u5e8f\uff0c\u7528\u6765\u663e\u793a\u5728Force.com\u81ea\u5b9a\u4e49\u5bf9\u8c61\u4e2d\u6ce8\u518c\u7684\u8bb0\u5f55\u5217\u8868\u3002<\/p>\n

\u73af\u5883<\/h1>\n

\u5173\u4e8e\u5728Node.js\u4e2d\u8c03\u7528Salesforce REST API\u7684\u73af\u5883\uff0c\u8bf7\u53c2\u8003\u4ee5\u4e0b\u6b65\u9aa4\uff0c\u5728AWS EC2\u5b9e\u4f8b\uff08Amazon Linux\uff09\u4e0a\u8fdb\u884c\u521b\u5efa\u3002\u53e6\u5916\uff0c\u8bf7\u53c2\u8003\u4ee5\u4e0b\u5185\u5bb9\u8fdb\u884cEC2\u5b9e\u4f8b\u5230Salesforce REST API\u7684\u8c03\u7528\u6240\u9700\u7684Salesforce OAuth\u8bbe\u7f6e\u3002<\/p>\n

\u6211\u4eec\u4f7f\u7528JSforce\u6765\u8c03\u7528Salesforce REST API\uff0c\u975e\u5e38\u611f\u8c22\u60a8\u63d0\u4f9b\u7684\u652f\u6301\u3002<\/p>\n

https:\/\/jsforce.github.io\/ \u53ef\u5c07\u9023\u7d50\u5d4c\u5165\u7db2\u9801\u4e2d\u4ecb\u7684\u5de5\u5177
\nhttps:\/\/github.com\/jsforce\/jsforce \u4e00\u500b\u95dc\u65bcjsforce\u7684GitHub\u5132\u5b58\u5eab<\/p>\n

\u5b89\u88c5 Node.js \u548c JSforce \u5230 EC2 \u5b9e\u4f8b\uff08Amazon Linux\uff09\u4e0a\u3002<\/h1>\n

(1) \u5728EC2\u5b9e\u4f8b\uff08Amazon Linux\uff09\u4e0a\u5b89\u88c5Node.js\u3002<\/p>\n

[ec2-user@example-salesforce-api-test-nodejs ~]$ uname -a\r\nLinux example-salesforce-api-test-nodejs 4.4.19-29.55.amzn1.x86_64 #1 SMP Mon Aug 29 23:29:40 UTC 2016 x86_64 x86_64 x86_64 GNU\/Linux\r\n\r\n[ec2-user@example-salesforce-api-test-nodejs ~]$ sudo yum install nodejs npm --enablerepo=epel\r\n\r\n[ec2-user@example-salesforce-api-test-nodejs ~]$ npm --version\r\n1.3.6\r\n[ec2-user@example-salesforce-api-test-nodejs ~]$ node --version\r\nv0.10.46\r\n[ec2-user@example-salesforce-api-test-nodejs ~]$\r\n<\/code><\/pre>\n
\u901a\u8fc7npm\u5b89\u88c5JSforce\u3002<\/p>\n
\u8fd9\u6b21\u7684\u4f8b\u5b50\u4e2d\uff0c\u6211\u51b3\u5b9a\u5728\u6bcf\u4e2a\u76ee\u5f55\u4e2d\u521b\u5efa\u6dfb\u52a0\u8bb0\u5f55\u548c\u663e\u793a\u8bb0\u5f55\u7684\u7a0b\u5e8f\u3002<\/p>\n
\n
\u30d7\u30ed\u30b0\u30e9\u30e0\u5185\u5bb9\u4f5c\u6210\u3059\u308b\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u540d\u30ab\u30b9\u30bf\u30e0\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\/home\/ec2-user\/insert_salesforce_api_test\u30ab\u30b9\u30bf\u30e0\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u8868\u793a\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\/home\/ec2-user\/select_salesforce_api_test<\/div>\n<\/div>\n
\u521b\u5efa\u4e00\u4e2a\u4fdd\u5b58\u81ea\u5b9a\u4e49\u5bf9\u8c61\u7684\u8bb0\u5f55\u6dfb\u52a0\u7a0b\u5e8f\u7684\u76ee\u5f55\u3002<\/p>\n
[ec2-user@example-salesforce-api-test-nodejs ~]$ mkdir \/home\/ec2-user\/insert_salesforce_api_test\r\n[ec2-user@salesforce-api-test-nodejs ~]$ \r\n\r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ pwd\r\n\/home\/ec2-user\/insert_salesforce_api_test\r\n\r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ npm install jsforce\r\n\r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ npm install date-utils\r\n\r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$\r\n<\/code><\/pre>\n
\u521b\u5efa\u4e00\u4e2a\u4fdd\u5b58\u81ea\u5b9a\u4e49\u5bf9\u8c61\u8bb0\u5f55\u663e\u793a\u7a0b\u5e8f\u7684\u76ee\u5f55\u3002<\/p>\n
[ec2-user@example-salesforce-api-test-nodejs ~]$ mkdir \/home\/ec2-user\/select_salesforce_api_test\r\n[ec2-user@example-salesforce-api-test-nodejs ~]$ \r\n\r\n[ec2-user@example-salesforce-api-test-nodejs select_salesforce_api_test]$ pwd\r\n\/home\/ec2-user\/select_salesforce_api_test\r\n\r\n[ec2-user@example-salesforce-api-test-nodejs select_salesforce_api_test]$ npm install jsforce\r\n\r\n[ec2-user@example-salesforce-api-test-nodejs select_salesforce_api_test]$ npm install date-utils\r\n\r\n[ec2-user@example-salesforce-api-test-nodejs select_salesforce_api_test]$\r\n<\/code><\/pre>\n
\u4f7f\u7528Node.js\u8c03\u7528Salesforce REST API\u6765\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u4e2d\u6dfb\u52a0\u8bb0\u5f55\u3002<\/h1>\n
\u4f7f\u7528Node.js\u8c03\u7528Salesforce REST API\uff0c\u5e76\u5c06\u8bb0\u5f55\u6dfb\u52a0\u5230\u81ea\u5b9a\u4e49\u5bf9\u8c61\u4e2d\u3002<\/p>\n
\u521b\u5efa\u4e00\u4e2aNode.js\u7a0b\u5e8f\uff0c\u7528\u4e8e\u5411Force.com\u81ea\u5b9a\u4e49\u5bf9\u8c61”\u6d4b\u8bd5\u5bf9\u8c61”(\u4f8b\u5982\uff0c\u5047\u8bbe\u5bf9\u8c61\u540d\u4e3aQuickStart__c)\u6dfb\u52a0\u8bb0\u5f55\u3002<\/p>\n
\u5f53\u6267\u884c\u6b64\u64cd\u4f5c\u65f6\uff0c\u60a8\u53ef\u4ee5\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\u3002<\/p>\n
[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ pwd\r\n\/home\/ec2-user\/insert_salesforce_api_test\r\n[ec2-user@salesforce-api-test-nodejs insert_salesforce_api_test]$ vi \/home\/ec2-user\/insert_salesforce_api_test\/index.js\r\n<\/code><\/pre>\n
[ec2-user@salesforce-api-test-nodejs insert_salesforce_api_test]$ cat \/home\/ec2-user\/insert_salesforce_api_test\/index.js\r\nrequire('date-utils');\r\nvar jsforce = require('jsforce');\r\n\r\n\/\/ Salesforce REST API\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\r\n\/\/\/\/ Sandbox\u74b0\u5883\u3078\u63a5\u7d9a\u3059\u308b\u5834\u5408\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\r\n\/\/var oauth_login_url = 'https:\/\/test.salesforce.com';\r\n\/\/\/\/ \u672c\u756a\u74b0\u5883\u3078\u63a5\u7d9a\u3059\u308b\u5834\u5408\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\r\nvar oauth_login_url = 'https:\/\/login.salesforce.com';\r\n\r\n\/\/ Salesforce REST API\u3067\u63a5\u7d9a\u3059\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u9375\u300d\u3092\u8a2d\u5b9a\u3059\u308b\r\nvar oauth_client_id = '3MV*******************************************************************************THF';\r\n\r\n\/\/ Salesforce REST API\u63a5\u7d9a\u7528\u306eSalesforce\u30e6\u30fc\u30b6\u540d\u3092\u8a2d\u5b9a\u3059\u308b\r\nvar oauth_client_username = 'example_salesforce_api_user@hoge.example.com';\r\n\r\n\/\/  Salesforce REST API\u3067\u63a5\u7d9a\u3059\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u306e\u79d8\u5bc6\u300d\u3092\u8a2d\u5b9a\u3059\u308b\r\nvar oauth_client_secret = '19***************84';\r\n\r\n\/\/ Salesforce REST API\u63a5\u7d9a\u7528\u306eSalesforce\u30e6\u30fc\u30b6\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3059\u308b\r\nvar oauth_client_authenticate_password = '*************';\r\n\r\nvar sobject_name = 'QuickStart__c';\r\n\r\n\/\/ Salesforce REST API\u3078\u63a5\u7d9a\u3059\u308b\u6642\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u9375\u300d(OAuth\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u30ad\u30fc\u7b49)\u3092\u30bb\u30c3\u30c8\u3059\u308b\r\nvar conn = new jsforce.Connection({\r\n  oauth2 : {\r\n    loginUrl : oauth_login_url,\r\n    clientId : oauth_client_id,\r\n    clientSecret : oauth_client_secret\r\n  }\r\n});\r\n\r\n\/\/ \u30ab\u30b9\u30bf\u30e0\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3078\u8ffd\u52a0\u3059\u308b\u30c7\u30fc\u30bf\u3092\u30bb\u30c3\u30c8\r\nvar date = new Date();\r\nvar insert_time = date.toFormat(\"YYYYMMDD_HH24MISS\");\r\nvar insert_name = \"testname_Node_\" + insert_time;\r\nvar insert_email = insert_name + \"@hoge.example.com\";\r\nvar create_date = date.toFormat(\"YYYY-MM-DD\");\r\n\r\nvar insert_record = {\r\n  user_name__c: insert_name,\r\n  user_email__c: insert_email,\r\n  create_date__c: create_date\r\n};\r\n\r\nconsole.log(\"Salesforce REST API Insert Record\");\r\nconsole.log(insert_record);\r\n\r\n\/\/ Salesforce REST API\u3078\u63a5\u7d9a\u3059\u308b\r\nconn.login( oauth_client_username, oauth_client_authenticate_password, function(err, res) {\r\n  if (err) { return console.error(err); }\r\n\r\n  \/\/ SalesForce REST API\u3092\u5b9f\u884c\u3057\u3066\u30ab\u30b9\u30bf\u30e0\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3078\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3059\u308b\r\n  conn.sobject( sobject_name ).create( insert_record, function(err, res) {\r\n    if (err) { return console.error(err); }\r\n    console.log(res);\r\n  });\r\n});\r\n<\/code><\/pre>\n
\u5f53\u4f60\u8fd0\u884cNode.js\u7a0b\u5e8f\u65f6\uff0c\u53ef\u4ee5\u5c06\u8bb0\u5f55\u6dfb\u52a0\u5230Force.com\u81ea\u5b9a\u4e49\u5bf9\u8c61\u4e2d\u3002<\/p>\n
[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ pwd\r\n\/home\/ec2-user\/insert_salesforce_api_test\r\n\r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ node \/home\/ec2-user\/insert_salesforce_api_test\/index.js\r\nSalesForce REST API Insert Record\r\n{ user_name__c: 'testname_Node_20160912_020629',\r\n  user_email__c: 'testname_Node_20160912_020629@hoge.example.com',\r\n  create_date__c: '2016-09-12' }\r\n{ id: 'a032800000GB179AAD', success: true, errors: [] }\r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$\r\n<\/code><\/pre>\n
\u4f7f\u7528Node.js\u6765\u6267\u884cSalesforce REST API\uff0c\u663e\u793a\u81ea\u5b9a\u4e49\u5bf9\u8c61\u7684\u8bb0\u5f55\u3002<\/h1>\n
\u4f7f\u7528Node.js\u8c03\u7528Salesforce REST API\uff0c\u5e76\u663e\u793a\u81ea\u5b9a\u4e49\u5bf9\u8c61\u7684\u8bb0\u5f55\u3002<\/p>\n
\u521b\u5efa\u4e00\u4e2a Node.js \u7a0b\u5e8f\u6765\u663e\u793a\u5df2\u6ce8\u518c\u5728 Force.com \u81ea\u5b9a\u4e49\u5bf9\u8c61\u300c\u6d4b\u8bd5\u5bf9\u8c61\u300d\u4e2d\u7684\u8bb0\u5f55\uff08\u4f8b\u5982\uff0c\u5047\u8bbe\u5bf9\u8c61\u540d\u79f0\u4e3a QuickStart__c\uff09\u3002<\/p>\n
\u6267\u884c\u6b64\u64cd\u4f5c\uff0c\u60a8\u53ef\u4ee5\u663e\u793a\u81ea\u5b9a\u4e49\u5bf9\u8c61\u7684\u8bb0\u5f55\u3002<\/p>\n
[ec2-user@example-salesforce-api-test-nodejs select_salesforce_api_test]$ pwd\r\n\/home\/ec2-user\/select_salesforce_api_test\r\n[ec2-user@example-salesforce-api-test-nodejs select_salesforce_api_test]$ vi \/home\/ec2-user\/select_salesforce_api_test\/index.js\r\n<\/code><\/pre>\n
var jsforce = require('jsforce');\r\n\r\n\/\/ Salesforce REST API\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\r\n\/\/\/\/ Sandbox\u74b0\u5883\u3078\u63a5\u7d9a\u3059\u308b\u5834\u5408\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\r\n\/\/var oauth_login_url = 'https:\/\/test.salesforce.com';\r\n\/\/\/\/ \u672c\u756a\u74b0\u5883\u3078\u63a5\u7d9a\u3059\u308b\u5834\u5408\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\r\nvar oauth_login_url = 'https:\/\/login.salesforce.com';\r\n\r\n\/\/ Salesforce REST API\u3067\u63a5\u7d9a\u3059\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u9375\u300d\u3092\u8a2d\u5b9a\u3059\u308b\r\nvar oauth_client_id = '3MV*******************************************************************************THF';\r\n\r\n\/\/ Salesforce REST API\u63a5\u7d9a\u7528\u306eSalesforce\u30e6\u30fc\u30b6\u540d\u3092\u8a2d\u5b9a\u3059\u308b\r\nvar oauth_client_username = 'example_salesforce_api_user@hoge.example.com';\r\n\r\n\/\/  Salesforce REST API\u3067\u63a5\u7d9a\u3059\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u306e\u79d8\u5bc6\u300d\u3092\u8a2d\u5b9a\u3059\u308b\r\nvar oauth_client_secret = '19***************84';\r\n\r\n\/\/ Salesforce REST API\u63a5\u7d9a\u7528\u306eSalesforce\u30e6\u30fc\u30b6\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3059\u308b\r\nvar oauth_client_authenticate_password = '*************';\r\n\r\n\/\/ Salesforce \u30ab\u30b9\u30bf\u30e0\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u5bfe\u3057\u3066\u5b9f\u884c\u3059\u308bSOQL\u3092\u8a2d\u5b9a\u3059\u308b\r\nvar sobject_name = 'QuickStart__c';\r\nvar soql = 'SELECT user_name__c, user_email__c, create_date__c FROM ' + sobject_name;\r\n\r\n\/\/ Salesforce REST API\u3078\u63a5\u7d9a\u3059\u308b\u6642\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u9375\u300d(OAuth\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u30ad\u30fc\u7b49)\u3092\u30bb\u30c3\u30c8\u3059\u308b\r\nvar conn = new jsforce.Connection({\r\n  oauth2 : {\r\n    loginUrl : oauth_login_url,\r\n    clientId : oauth_client_id,\r\n    clientSecret : oauth_client_secret\r\n  }\r\n});\r\n\r\nconsole.log(\"Salesforce REST API Test SELECT SOQL [\" + soql + \"]\");\r\n\r\n\/\/ Salesforce REST API\u3078\u63a5\u7d9a\u3059\u308b\r\nconn.login( oauth_client_username, oauth_client_authenticate_password, function(err, res) {\r\n  if (err) { return console.error(err); }\r\n\r\n  \/\/ Salesforce REST API\u3092\u5b9f\u884c\u3057\u3066\u30ab\u30b9\u30bf\u30e0\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3078\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3059\u308b\r\n  conn.query( soql, function(err, res) {\r\n    if (err) { return console.error(err); }\r\n    console.log(res);\r\n  });\r\n});\r\n<\/code><\/pre>\n
\u5f53\u8fd0\u884cNode.js\u7a0b\u5e8f\u65f6\uff0c\u53ef\u4ee5\u663e\u793a\u5728Force.com\u81ea\u5b9a\u4e49\u5bf9\u8c61\u4e2d\u6ce8\u518c\u7684\u8bb0\u5f55\u3002<\/p>\n
[ec2-user@example-salesforce-api-test-nodejs select_salesforce_api_test]$ node \/home\/ec2-user\/select_salesforce_api_test\/index.js\r\nSalesForce REST API Test SELECT SOQL [SELECT user_name__c, user_email__c, create_date__c FROM QuickStart__c]\r\n{ totalSize: 29,\r\n  done: true,\r\n  records:\r\n   [ { attributes: [Object],\r\n       user_name__c: '\u30c6\u30b9\u30c8\u592a\u90ce',\r\n       user_email__c: 'test.tarou@example.com',\r\n       create_date__c: null },\r\n     { attributes: [Object],\r\n       user_name__c: '\u30c6\u30b9\u30c8\u6b21\u90ce',\r\n       user_email__c: 'test.jirou@example.com',\r\n       create_date__c: null },\r\n\r\n\u3000(\u4e2d\u7565)\r\n\r\n     { attributes: [Object],\r\n       user_name__c: 'testname_Node_20160912_020629',\r\n       user_email__c: 'testname_Node_20160912_020629@hoge.example.com',\r\n       create_date__c: '2016-09-12' },\r\n     { attributes: [Object],\r\n       user_name__c: 'testname_Node_20160912_015615',\r\n       user_email__c: 'testname_Node_20160912_015615@hoge.example.com',\r\n       create_date__c: '2016-09-12' },\r\n     { attributes: [Object],\r\n       user_name__c: 'SalesForce API\u30c6\u30b9\u30c8',\r\n       user_email__c: 'example@hoge.example.com',\r\n       create_date__c: '2016-09-07' } ] }\r\n[ec2-user@example-salesforce-api-test-nodejs select_salesforce_api_test]$\r\n<\/code><\/pre>\n
\u901a\u8fc7Node.js\u6267\u884cSalesforce REST API\u5e76\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\uff08\u83b7\u53d6Salesforce REST API\u51ed\u636e\u7684\u793a\u4f8b\u65b9\u6cd5\u662f\u4ece.bashrc\u73af\u5883\u53d8\u91cf\u4e2d\u83b7\u53d6\uff09\u3002<\/h1>\n
\u5728.bashrc\u7684\u73af\u5883\u53d8\u91cf\u4e2d\u6dfb\u52a0Salesforce REST API\u8fde\u63a5\u7684\u8bbe\u7f6e(API\u51ed\u8bc1)\uff0c\u53ef\u4ee5\u5728\u4f7f\u7528Node.js\u6267\u884cSalesforce REST API\u65f6\uff0c\u4ece\u73af\u5883\u53d8\u91cf\u4e2d\u83b7\u53d6API\u51ed\u8bc1\u5e76\u6267\u884cSalesforce REST API\u3002<\/p>\n
\u9996\u5148\uff0c\u5728.bashrc\u6587\u4ef6\u4e2d\u6dfb\u52a0Salesforce REST API\u8fde\u63a5\u7684\u8bbe\u7f6e\u3002<\/p>\n
[<\/span>ec2-user@salesforce-api-test ~]$ <\/span>vi \/home\/ec2-user\/.bashrc\r\n\u3000(<\/span>\u672b\u5c3e\u306b\u4ee5\u4e0b\u3092\u8ffd\u52a0\u3059\u308b)<\/span>\r\n\r\n### Sandbox\u74b0\u5883\u3078\u63a5\u7d9a\u3059\u308b\u5834\u5408\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8<\/span>\r\n##export DATABASEDOTCOM_HOST=\"test.salesforce.com\"<\/span>\r\n### \u672c\u756a\u74b0\u5883\u3078\u63a5\u7d9a\u3059\u308b\u5834\u5408\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8<\/span>\r\nexport <\/span>DATABASEDOTCOM_HOST<\/span>=<\/span>\"login.salesforce.com\"<\/span>\r\n\r\nexport <\/span>DATABASEDOTCOM_CLIENT_ID<\/span>=<\/span>\"\u524d\u8ff0\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u9375\u300d(OAuth\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u30ad\u30fc)\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002\"<\/span>\r\nexport <\/span>DATABASEDOTCOM_CLIENT_SECRET<\/span>=<\/span>\"\u524d\u8ff0\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u306e\u79d8\u5bc6\u300d(OAuth\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u30b7\u30fc\u30af\u30ec\u30c3\u30c8)\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002\"<\/span>\r\nexport <\/span>DATABASEDOTCOM_CLIENT_USERNAME<\/span>=<\/span>\"API\u3092\u6709\u52b9\u5316\u3057\u3066\u3044\u308bSalesforce\u30e6\u30fc\u30b6\u30a2\u30ab\u30a6\u30f3\u30c8\u540d\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002\"<\/span>\r\nexport <\/span>DATABASEDOTCOM_CLIENT_AUTHENTICATE_PASSWORD<\/span>=<\/span>\"API\u3092\u6709\u52b9\u5316\u3057\u3066\u3044\u308bSalesforce\u30e6\u30fc\u30b6\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002\"<\/span>\r\n<\/code><\/pre>\n
\u8bfb\u53d6\u5df2\u6dfb\u52a0\u5230.bashrc\u6587\u4ef6\u4e2d\u7684\u73af\u5883\u53d8\u91cf\u3002<\/p>\n
[ec2-user@example-salesforce-api-test-nodejs ~]$ source \/home\/ec2-user\/.bashrc\r\n[ec2-user@example-salesforce-api-test-nodejs ~]$ \r\n<\/code><\/pre>\n
\u5982\u679c\u8981\u4f7f\u7528Node.js\u4ece.bashrc\u83b7\u53d6\u73af\u5883\u53d8\u91cf\u4e2d\u7684API\u51ed\u636e\uff0c\u8bf7\u5c06\u4ee5\u4e0b\u7a0b\u5e8f\u66f4\u6539\u4e3a\uff1a<\/p>\n
ec2-user@example-salesforce-api-test-nodejs ~]$ cd insert_salesforce_api_test\/\r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ pwd\r\n\/home\/ec2-user\/insert_salesforce_api_test\r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$\r\n\r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ vi \/home\/ec2-user\/insert_salesforce_api_test\/index.js\r\nrequire('date-utils');\r\n<\/code><\/pre>\n
var<\/span> jsforce<\/span> =<\/span> require<\/span>(<\/span>'<\/span>jsforce<\/span>'<\/span>);<\/span>\r\n\r\n\/\/ Salesforce REST API\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8<\/span>\r\nvar<\/span> oauth_login_url<\/span> =<\/span> '<\/span>https:\/\/<\/span>'<\/span> +<\/span> process<\/span>.<\/span>env<\/span>.<\/span>DATABASEDOTCOM_HOST<\/span>;<\/span>\r\n\r\n\/\/ Salesforce REST API\u3067\u63a5\u7d9a\u3059\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u9375\u300d\u3092\u8a2d\u5b9a\u3059\u308b<\/span>\r\nvar<\/span> oauth_client_id<\/span> =<\/span> process<\/span>.<\/span>env<\/span>.<\/span>DATABASEDOTCOM_CLIENT_ID<\/span>;<\/span>\r\n\r\n\/\/ Salesforce REST API\u63a5\u7d9a\u7528\u306eSalesforce\u30e6\u30fc\u30b6\u540d\u3092\u8a2d\u5b9a\u3059\u308b<\/span>\r\nvar<\/span> oauth_client_username<\/span> =<\/span> process<\/span>.<\/span>env<\/span>.<\/span>DATABASEDOTCOM_CLIENT_USERNAME<\/span>;<\/span>\r\n\r\n\/\/  Salesforce REST API\u3067\u63a5\u7d9a\u3059\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u306e\u79d8\u5bc6\u300d\u3092\u8a2d\u5b9a\u3059\u308b<\/span>\r\nvar<\/span> oauth_client_secret<\/span> =<\/span> process<\/span>.<\/span>env<\/span>.<\/span>DATABASEDOTCOM_CLIENT_SECRET<\/span>;<\/span>\r\n\r\n\/\/ Salesforce REST API\u63a5\u7d9a\u7528\u306eSalesforce\u30e6\u30fc\u30b6\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3059\u308b<\/span>\r\nvar<\/span> oauth_client_authenticate_password<\/span> =<\/span> process<\/span>.<\/span>env<\/span>.<\/span>DATABASEDOTCOM_CLIENT_AUTHENTICATE_PASSWORD<\/span>;<\/span>\r\n\r\nvar<\/span> sobject_name<\/span> =<\/span> '<\/span>QuickStart__c<\/span>'<\/span>;<\/span>\r\n\r\n\/\/ Salesforce REST API\u3078\u63a5\u7d9a\u3059\u308b\u6642\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u9375\u300d(OAuth\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u30ad\u30fc\u7b49)\u3092\u30bb\u30c3\u30c8\u3059\u308b<\/span>\r\nvar<\/span> conn<\/span> =<\/span> new<\/span> jsforce<\/span>.<\/span>Connection<\/span>({<\/span>\r\n  oauth2<\/span> :<\/span> {<\/span>\r\n    loginUrl<\/span> :<\/span> oauth_login_url<\/span>,<\/span>\r\n    clientId<\/span> :<\/span> oauth_client_id<\/span>,<\/span>\r\n    clientSecret<\/span> :<\/span> oauth_client_secret<\/span>\r\n  }<\/span>\r\n});<\/span>\r\n\r\n\/\/ \u30ab\u30b9\u30bf\u30e0\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3078\u8ffd\u52a0\u3059\u308b\u30c7\u30fc\u30bf\u3092\u30bb\u30c3\u30c8<\/span>\r\nvar<\/span> date<\/span> =<\/span> new<\/span> Date<\/span>();<\/span>\r\nvar<\/span> insert_time<\/span> =<\/span> date<\/span>.<\/span>toFormat<\/span>(<\/span>\"<\/span>YYYYMMDD_HH24MISS<\/span>\"<\/span>);<\/span>\r\nvar<\/span> insert_name<\/span> =<\/span> \"<\/span>testname_Node_<\/span>\"<\/span> +<\/span> insert_time<\/span>;<\/span>\r\nvar<\/span> insert_email<\/span> =<\/span> insert_name<\/span> +<\/span> \"<\/span>@hoge.example.com<\/span>\"<\/span>;<\/span>\r\nvar<\/span> create_date<\/span> =<\/span> date<\/span>.<\/span>toFormat<\/span>(<\/span>\"<\/span>YYYY-MM-DD<\/span>\"<\/span>);<\/span>\r\n\r\nvar<\/span> insert_record<\/span> =<\/span> {<\/span>\r\n  user_name__c<\/span>:<\/span> insert_name<\/span>,<\/span>\r\n  user_email__c<\/span>:<\/span> insert_email<\/span>,<\/span>\r\n  create_date__c<\/span>:<\/span> create_date<\/span>\r\n};<\/span>\r\n\r\nconsole<\/span>.<\/span>log<\/span>(<\/span>\"<\/span>Salesforce REST API Insert Record<\/span>\"<\/span>);<\/span>\r\nconsole<\/span>.<\/span>log<\/span>(<\/span>insert_record<\/span>);<\/span>\r\n\r\n\/\/ Salesforce REST API\u3078\u63a5\u7d9a\u3059\u308b<\/span>\r\nconn<\/span>.<\/span>login<\/span>(<\/span> oauth_client_username<\/span>,<\/span> oauth_client_authenticate_password<\/span>,<\/span> function<\/span>(<\/span>err<\/span>,<\/span> res<\/span>)<\/span> {<\/span>\r\n  if<\/span> (<\/span>err<\/span>)<\/span> {<\/span> return<\/span> console<\/span>.<\/span>error<\/span>(<\/span>err<\/span>);<\/span> }<\/span>\r\n\r\n  \/\/ Salesforce REST API\u3092\u5b9f\u884c\u3057\u3066\u30ab\u30b9\u30bf\u30e0\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3078\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3059\u308b<\/span>\r\n  conn<\/span>.<\/span>sobject<\/span>(<\/span> sobject_name<\/span> ).<\/span>create<\/span>(<\/span> insert_record<\/span>,<\/span> function<\/span>(<\/span>err<\/span>,<\/span> res<\/span>)<\/span> {<\/span>\r\n    if<\/span> (<\/span>err<\/span>)<\/span> {<\/span> return<\/span> console<\/span>.<\/span>error<\/span>(<\/span>err<\/span>);<\/span> }<\/span>\r\n    console<\/span>.<\/span>log<\/span>(<\/span>res<\/span>);<\/span>\r\n  });<\/span>\r\n});<\/span> \r\n<\/code><\/pre>\n
\u8fd0\u884cNode.js\u7a0b\u5e8f\u540e\uff0c\u53ef\u4ee5\u5c06\u8bb0\u5f55\u6dfb\u52a0\u5230Force.com\u81ea\u5b9a\u4e49\u5bf9\u8c61\u4e2d\u3002<\/p>\n
[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ pwd\r\n\/home\/ec2-user\/insert_salesforce_api_test\r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ \r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ node \/home\/ec2-user\/insert_salesforce_api_test\/index.js\r\nSalesforce REST API Insert Record\r\n{ user_name__c: 'testname_Node_20170311_123050',\r\n  user_email__c: 'testname_Node_20170311_123050@hoge.example.com',\r\n  create_date__c: '2017-03-11' }\r\n{ id: 'a032800000QEaALAA1', success: true, errors: [] }\r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ \r\n<\/code><\/pre>\n
\u4f7f\u7528Node.js\u4eceSalesforce REST API\u4e2d\u6267\u884c\uff0c\u5e76\u663e\u793a\u81ea\u5b9a\u4e49\u5bf9\u8c61\u7684\u8bb0\u5f55\uff08\u4f8b\u5982\uff0c\u4ece.bashrc\u73af\u5883\u53d8\u91cf\u4e2d\u83b7\u53d6Salesforce REST API\u51ed\u8bc1\u7684\u793a\u4f8b\uff09\u3002<\/h1>\n
\u53ef\u4ee5\u901a\u8fc7\u5c06Salesforce REST API\u8fde\u63a5\u7684\u8bbe\u7f6e\uff08API\u51ed\u636e\uff09\u6dfb\u52a0\u5230.bashrc\u73af\u5883\u53d8\u91cf\u4e2d\uff0c\u5728\u4f7f\u7528Node.js\u6267\u884cSalesforce REST API\u65f6\uff0c\u53ef\u4ee5\u4ece\u73af\u5883\u53d8\u91cf\u4e2d\u83b7\u53d6API\u51ed\u636e\uff0c\u5e76\u6267\u884cSalesforce REST API\u3002<\/p>\n
\u9996\u5148\u5728.bashrc\u6587\u4ef6\u4e2d\u6dfb\u52a0Salesforce REST API\u8fde\u63a5\u7684\u914d\u7f6e\u3002<\/p>\n
[<\/span>ec2-user@salesforce-api-test ~]$ <\/span>vi \/home\/ec2-user\/.bashrc\r\n\u3000(<\/span>\u672b\u5c3e\u306b\u4ee5\u4e0b\u3092\u8ffd\u52a0\u3059\u308b)<\/span>\r\n\r\n### Sandbox\u74b0\u5883\u3078\u63a5\u7d9a\u3059\u308b\u5834\u5408\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8<\/span>\r\n##export DATABASEDOTCOM_HOST=\"test.salesforce.com\"<\/span>\r\n### \u672c\u756a\u74b0\u5883\u3078\u63a5\u7d9a\u3059\u308b\u5834\u5408\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8<\/span>\r\nexport <\/span>DATABASEDOTCOM_HOST<\/span>=<\/span>\"login.salesforce.com\"<\/span>\r\n\r\nexport <\/span>DATABASEDOTCOM_CLIENT_ID<\/span>=<\/span>\"\u524d\u8ff0\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u9375\u300d(OAuth\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u30ad\u30fc)\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002\"<\/span>\r\nexport <\/span>DATABASEDOTCOM_CLIENT_SECRET<\/span>=<\/span>\"\u524d\u8ff0\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u306e\u79d8\u5bc6\u300d(OAuth\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u30b7\u30fc\u30af\u30ec\u30c3\u30c8)\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002\"<\/span>\r\nexport <\/span>DATABASEDOTCOM_CLIENT_USERNAME<\/span>=<\/span>\"API\u3092\u6709\u52b9\u5316\u3057\u3066\u3044\u308bSalesforce\u30e6\u30fc\u30b6\u30a2\u30ab\u30a6\u30f3\u30c8\u540d\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002\"<\/span>\r\nexport <\/span>DATABASEDOTCOM_CLIENT_AUTHENTICATE_PASSWORD<\/span>=<\/span>\"API\u3092\u6709\u52b9\u5316\u3057\u3066\u3044\u308bSalesforce\u30e6\u30fc\u30b6\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002\"<\/span>\r\n<\/code><\/pre>\n
\u52a0\u8f7d\u5df2\u7ecf\u6dfb\u52a0\u5230.bashrc\u6587\u4ef6\u4e2d\u7684\u73af\u5883\u53d8\u91cf\u3002<\/p>\n
[ec2-user@example-salesforce-api-test-nodejs ~]$ source \/home\/ec2-user\/.bashrc\r\n[ec2-user@example-salesforce-api-test-nodejs ~]$ \r\n<\/code><\/pre>\n
\u5982\u679c\u9700\u8981\u4ece.bashrc\u73af\u5883\u53d8\u91cf\u4e2d\u83b7\u53d6API\u51ed\u636e\uff0c\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u7a0b\u5e8f\u8fdb\u884c\u66f4\u6539\uff1a<\/p>\n
[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ cd ~\r\n[ec2-user@example-salesforce-api-test-nodejs ~]$ \r\n[ec2-user@example-salesforce-api-test-nodejs ~]$ cd insert_salesforce_api_test\/\r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ pwd\r\n\/home\/ec2-user\/insert_salesforce_api_test\r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ \r\n[ec2-user@example-salesforce-api-test-nodejs insert_salesforce_api_test]$ vi \/home\/ec2-user\/insert_salesforce_api_test\/index.js\r\n<\/code><\/pre>\n
var<\/span> jsforce<\/span> =<\/span> require<\/span>(<\/span>'<\/span>jsforce<\/span>'<\/span>);<\/span>\r\n\r\n\/\/ Salesforce REST API\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8<\/span>\r\nvar<\/span> oauth_login_url<\/span> =<\/span> '<\/span>https:\/\/<\/span>'<\/span> +<\/span> process<\/span>.<\/span>env<\/span>.<\/span>DATABASEDOTCOM_HOST<\/span>;<\/span>\r\n\r\n\/\/ Salesforce REST API\u3067\u63a5\u7d9a\u3059\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u9375\u300d\u3092\u8a2d\u5b9a\u3059\u308b<\/span>\r\nvar<\/span> oauth_client_id<\/span> =<\/span> process<\/span>.<\/span>env<\/span>.<\/span>DATABASEDOTCOM_CLIENT_ID<\/span>;<\/span>\r\n\r\n\/\/ Salesforce REST API\u63a5\u7d9a\u7528\u306eSalesforce\u30e6\u30fc\u30b6\u540d\u3092\u8a2d\u5b9a\u3059\u308b<\/span>\r\nvar<\/span> oauth_client_username<\/span> =<\/span> process<\/span>.<\/span>env<\/span>.<\/span>DATABASEDOTCOM_CLIENT_USERNAME<\/span>;<\/span>\r\n\r\n\/\/  Salesforce REST API\u3067\u63a5\u7d9a\u3059\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u306e\u79d8\u5bc6\u300d\u3092\u8a2d\u5b9a\u3059\u308b<\/span>\r\nvar<\/span> oauth_client_secret<\/span> =<\/span> process<\/span>.<\/span>env<\/span>.<\/span>DATABASEDOTCOM_CLIENT_SECRET<\/span>;<\/span>\r\n\r\n\/\/ Salesforce REST API\u63a5\u7d9a\u7528\u306eSalesforce\u30e6\u30fc\u30b6\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3059\u308b<\/span>\r\nvar<\/span> oauth_client_authenticate_password<\/span> =<\/span> process<\/span>.<\/span>env<\/span>.<\/span>DATABASEDOTCOM_CLIENT_AUTHENTICATE_PASSWORD<\/span>;<\/span>\r\n\r\n\/\/ Salesforce \u30ab\u30b9\u30bf\u30e0\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u5bfe\u3057\u3066\u5b9f\u884c\u3059\u308bSOQL\u3092\u8a2d\u5b9a\u3059\u308b<\/span>\r\nvar<\/span> sobject_name<\/span> =<\/span> '<\/span>QuickStart__c<\/span>'<\/span>;<\/span>\r\nvar<\/span> soql<\/span> =<\/span> '<\/span>SELECT user_name__c, user_email__c, create_date__c FROM <\/span>'<\/span> +<\/span> sobject_name<\/span>;<\/span>\r\n\r\n\/\/ Salesforce REST API\u3078\u63a5\u7d9a\u3059\u308b\u6642\u306e\u300c\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u9375\u300d(OAuth\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u30ad\u30fc\u7b49)\u3092\u30bb\u30c3\u30c8\u3059\u308b<\/span>\r\nvar<\/span> conn<\/span> =<\/span> new<\/span> jsforce<\/span>.<\/span>Connection<\/span>({<\/span>\r\n  oauth2<\/span> :<\/span> {<\/span>\r\n    loginUrl<\/span> :<\/span> oauth_login_url<\/span>,<\/span>\r\n    clientId<\/span> :<\/span> oauth_client_id<\/span>,<\/span>\r\n    clientSecret<\/span> :<\/span> oauth_client_secret<\/span>\r\n  }<\/span>\r\n});<\/span>\r\n\r\nconsole<\/span>.<\/span>log<\/span>(<\/span>\"<\/span>Salesforce REST API Test SELECT SOQL [<\/span>\"<\/span> +<\/span> soql<\/span> +<\/span> \"<\/span>]<\/span>\"<\/span>);<\/span>\r\n\r\n\/\/ Salesforce REST API\u3078\u63a5\u7d9a\u3059\u308b<\/span>\r\nconn<\/span>.<\/span>login<\/span>(<\/span> oauth_client_username<\/span>,<\/span> oauth_client_authenticate_password<\/span>,<\/span> function<\/span>(<\/span>err<\/span>,<\/span> res<\/span>)<\/span> {<\/span>\r\n  if<\/span> (<\/span>err<\/span>)<\/span> {<\/span> return<\/span> console<\/span>.<\/span>error<\/span>(<\/span>err<\/span>);<\/span> }<\/span>\r\n\r\n  \/\/ Salesforce REST API\u3092\u5b9f\u884c\u3057\u3066\u30ab\u30b9\u30bf\u30e0\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3078\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3059\u308b<\/span>\r\n  conn<\/span>.<\/span>query<\/span>(<\/span> soql<\/span>,<\/span> function<\/span>(<\/span>err<\/span>,<\/span> res<\/span>)<\/span> {<\/span>\r\n    if<\/span> (<\/span>err<\/span>)<\/span> {<\/span> return<\/span> console<\/span>.<\/span>error<\/span>(<\/span>err<\/span>);<\/span> }<\/span>\r\n    console<\/span>.<\/span>log<\/span>(<\/span>res<\/span>);<\/span>\r\n  });<\/span>\r\n});<\/span>\r\n<\/code><\/pre>\n
\u5f53\u6267\u884cNode.js\u7a0b\u5e8f\u65f6\uff0c\u53ef\u4ee5\u663e\u793a\u5728Force.com\u81ea\u5b9a\u4e49\u5bf9\u8c61\u4e2d\u6ce8\u518c\u7684\u8bb0\u5f55\u3002<\/p>\n
[ec2-user@example-salesforce-api-test-nodejs select_salesforce_api_test]$ pwd\r\n\/home\/ec2-user\/select_salesforce_api_test\r\n[ec2-user@example-salesforce-api-test-nodejs select_salesforce_api_test]$ node \/home\/ec2-user\/select_salesforce_api_test\/index.js\r\nSalesForce REST API Test SELECT SOQL [SELECT user_name__c, user_email__c, create_date__c FROM QuickStart__c]\r\n{ totalSize: 62,\r\n  done: true,\r\n  records: \r\n   [ { attributes: [Object],\r\n       user_name__c: '\u30c6\u30b9\u30c8\u592a\u90ce',\r\n       user_email__c: 'test.tarou@example.com',\r\n       create_date__c: null },\r\n     { attributes: [Object],\r\n       user_name__c: '\u30c6\u30b9\u30c8\u6b21\u90ce',\r\n       user_email__c: 'test.jirou@example.com',\r\n       create_date__c: null },\r\n\r\n\u3000(\u51fa\u529b\u7d50\u679c\u9577\u3044\u306e\u3067\u4e2d\u7565)\r\n\r\n       user_name__c: 'testname_Node_20170311_114546',\r\n       user_email__c: 'testname_Node_20170311_114546@hoge.example.com',\r\n       create_date__c: '2017-03-11' },\r\n     { attributes: [Object],\r\n       user_name__c: 'testname_Node_20170311_122616',\r\n       user_email__c: 'testname_Node_20170311_122616@hoge.example.com',\r\n       create_date__c: '2017-03-11' } ] }\r\n[ec2-user@example-salesforce-api-test-nodejs select_salesforce_api_test]$ \r\n<\/code><\/pre>\n
\n
\u8fd9\u5c31\u662f\u4ee5\u4e0a\u7684\u5185\u5bb9\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u9996\u5148 \u5728Salesforce\u4e2d\uff0c\u6709\u4e00\u4e2a\u540d\u4e3aSalesforce REST API\u7684\u5de5\u5177\uff0c\u53ef\u4ee5\u5bf9\u5176\u8fdb\u884c\u5404\u79cd\u64cd\u4f5c\u3002 […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-32126","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\u4f7f\u7528Node.js\u8c03\u7528Salesforce REST API\u6267\u884c\u64cd\u4f5c\uff08\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\uff09 - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528node-js\u8c03\u7528salesforce-rest-api\u6267\u884c\u64cd\u4f5c\uff08\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528Node.js\u8c03\u7528Salesforce REST API\u6267\u884c\u64cd\u4f5c\uff08\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\uff09\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u5728Salesforce\u4e2d\uff0c\u6709\u4e00\u4e2a\u540d\u4e3aSalesforce REST API\u7684\u5de5\u5177\uff0c\u53ef\u4ee5\u5bf9\u5176\u8fdb\u884c\u5404\u79cd\u64cd\u4f5c\u3002 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528node-js\u8c03\u7528salesforce-rest-api\u6267\u884c\u64cd\u4f5c\uff08\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-09T03:17:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T19:14:26+00:00\" \/>\n<meta name=\"author\" content=\"\u6587, \u7fd4\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6587, \u7fd4\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/\",\"name\":\"\u4f7f\u7528Node.js\u8c03\u7528Salesforce REST API\u6267\u884c\u64cd\u4f5c\uff08\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\uff09 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-12-09T03:17:13+00:00\",\"dateModified\":\"2024-04-29T19:14:26+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528Node.js\u8c03\u7528Salesforce REST API\u6267\u884c\u64cd\u4f5c\uff08\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\uff09\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\",\"name\":\"\u6587, \u7fd4\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"caption\":\"\u6587, \u7fd4\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528Node.js\u8c03\u7528Salesforce REST API\u6267\u884c\u64cd\u4f5c\uff08\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\uff09 - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528node-js\u8c03\u7528salesforce-rest-api\u6267\u884c\u64cd\u4f5c\uff08\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528Node.js\u8c03\u7528Salesforce REST API\u6267\u884c\u64cd\u4f5c\uff08\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\uff09","og_description":"\u9996\u5148 \u5728Salesforce\u4e2d\uff0c\u6709\u4e00\u4e2a\u540d\u4e3aSalesforce REST API\u7684\u5de5\u5177\uff0c\u53ef\u4ee5\u5bf9\u5176\u8fdb\u884c\u5404\u79cd\u64cd\u4f5c\u3002 […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528node-js\u8c03\u7528salesforce-rest-api\u6267\u884c\u64cd\u4f5c\uff08\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-12-09T03:17:13+00:00","article_modified_time":"2024-04-29T19:14:26+00:00","author":"\u6587, \u7fd4","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6587, \u7fd4","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"9 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/","name":"\u4f7f\u7528Node.js\u8c03\u7528Salesforce REST API\u6267\u884c\u64cd\u4f5c\uff08\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\uff09 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-12-09T03:17:13+00:00","dateModified":"2024-04-29T19:14:26+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528Node.js\u8c03\u7528Salesforce REST API\u6267\u884c\u64cd\u4f5c\uff08\u5411\u81ea\u5b9a\u4e49\u5bf9\u8c61\u6dfb\u52a0\u8bb0\u5f55\uff09"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c","name":"\u6587, \u7fd4","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","caption":"\u6587, \u7fd4"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8node-js%e8%b0%83%e7%94%a8salesforce-rest-api%e6%89%a7%e8%a1%8c%e6%93%8d%e4%bd%9c%ef%bc%88%e5%90%91%e8%87%aa%e5%ae%9a%e4%b9%89%e5%af%b9%e8%b1%a1%e6%b7%bb%e5%8a%a0%e8%ae%b0%e5%bd%95\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/32126","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=32126"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/32126\/revisions"}],"predecessor-version":[{"id":89344,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/32126\/revisions\/89344"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=32126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=32126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=32126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}