RubyからSalesforce REST APIを実行する (restforceを使用してSalesforceカスタムオブジェクトへレコードを追加する) ref: http://qiita.com/na0AaooQ/items/bf9a33d76b7120522389

file0.txt

[ec2-user@example-ruby-sinatra-server ~]$ cp -p /home/ec2-user/.bashrc /home/ec2-user/.bashrc.ORG
[ec2-user@example-ruby-sinatra-server ~]$ diff /home/ec2-user/.bashrc /home/ec2-user/.bashrc.ORG
[ec2-user@example-ruby-sinatra-server ~]$ 

file1.txt

[ec2-user@example-ruby-sinatra-server ~]$ vi /home/ec2-user/.bashrc
　(末尾に以下を追加する)

### Sandbox環境へ接続する場合のAPIエンドポイント
##export DATABASEDOTCOM_HOST="test.salesforce.com"
### 本番環境へ接続する場合のAPIエンドポイント
export DATABASEDOTCOM_HOST="login.salesforce.com"

export DATABASEDOTCOM_CLIENT_ID="前述の「コンシューマ鍵」(OAuthコンシューマキー)を記載します。"
export DATABASEDOTCOM_CLIENT_SECRET="前述の「コンシューマの秘密」(OAuthコンシューマシークレット)を記載します。"
export DATABASEDOTCOM_CLIENT_USERNAME="salesforce_api_testuser@**********.salesforce.example.com"
export DATABASEDOTCOM_CLIENT_AUTHENTICATE_PASSWORD="APIを有効化しているSalesforceユーザアカウントのパスワードを記載します。"

file10.txt

[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ pwd
/home/ec2-user/select_salesforce_restforce_api_test
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ bundle list | grep restforce
  * restforce (2.5.0)
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ bundle list
Gems included by the bundle:
  * bundler (1.13.2)
  * faraday (0.9.2)
  * faraday_middleware (0.11.0.1)
  * hashie (3.5.5)
  * json (2.0.3)
  * multipart-post (2.0.0)
  * restforce (2.5.0)
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 

file11.txt

[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ ls -lrta /home/ec2-user/select_salesforce_restforce_api_test/
合計 28
drwx------ 8 ec2-user ec2-user 4096  3月 11 13:02 ..
-rw-r--r-- 1 ec2-user ec2-user   75  3月 11 13:03 Gemfile.ORG
-rw-r--r-- 1 ec2-user ec2-user   91  3月 11 13:06 Gemfile
drwxrwxr-x 2 ec2-user ec2-user 4096  3月 11 13:08 .bundle
drwxrwxr-x 3 ec2-user ec2-user 4096  3月 11 13:08 vendor
-rw-rw-r-- 1 ec2-user ec2-user  433  3月 11 13:08 Gemfile.lock
drwxrwxr-x 4 ec2-user ec2-user 4096  3月 11 13:08 .
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 

file12.txt

[ec2-user@example-ruby-sinatra-server ~]$ hostname
example-ruby-sinatra-server
[ec2-user@example-ruby-sinatra-server ~]$ mkdir /home/ec2-user/insert_salesforce_restforce_api_test
[ec2-user@example-ruby-sinatra-server ~]$ cd /home/ec2-user/insert_salesforce_restforce_api_test
[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ pwd
/home/ec2-user/insert_salesforce_restforce_api_test
[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ ls -lrta /home/ec2-user/insert_salesforce_restforce_api_test
合計 8
drwx------ 9 ec2-user ec2-user 4096  3月 11 13:13 ..
drwxrwxr-x 2 ec2-user ec2-user 4096  3月 11 13:13 .
[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ 

file13.txt

[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ ls -lrta /home/ec2-user/insert_salesforce_restforce_api_test
合計 28
drwx------ 9 ec2-user ec2-user 4096  3月 11 13:13 ..
-rw-r--r-- 1 ec2-user ec2-user   75  3月 11 13:14 Gemfile.ORG
-rw-r--r-- 1 ec2-user ec2-user   91  3月 11 13:15 Gemfile
drwxrwxr-x 2 ec2-user ec2-user 4096  3月 11 13:15 .bundle
drwxrwxr-x 3 ec2-user ec2-user 4096  3月 11 13:15 vendor
-rw-rw-r-- 1 ec2-user ec2-user  433  3月 11 13:15 Gemfile.lock
drwxrwxr-x 4 ec2-user ec2-user 4096  3月 11 13:15 .
[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ 
[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ bundle list | grep restforce
  * restforce (2.5.0)
[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ 
[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ bundle list
Gems included by the bundle:
  * bundler (1.13.2)
  * faraday (0.9.2)
  * faraday_middleware (0.11.0.1)
  * hashie (3.5.5)
  * json (2.0.3)
  * multipart-post (2.0.0)
  * restforce (2.5.0)
[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ 

file14.txt

[ec2-user@example-ruby-sinatra-server ~]$ cd /home/ec2-user/select_salesforce_restforce_api_test/
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ pwd
/home/ec2-user/select_salesforce_restforce_api_test
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ ls -lrta /home/ec2-user/select_salesforce_restforce_api_test/
合計 32
-rw-r--r-- 1 ec2-user ec2-user   75  3月 11 13:03 Gemfile.ORG
-rw-r--r-- 1 ec2-user ec2-user   91  3月 11 13:06 Gemfile
drwxrwxr-x 2 ec2-user ec2-user 4096  3月 11 13:08 .bundle
drwxrwxr-x 3 ec2-user ec2-user 4096  3月 11 13:08 vendor
-rw-rw-r-- 1 ec2-user ec2-user  433  3月 11 13:08 Gemfile.lock
drwx------ 9 ec2-user ec2-user 4096  3月 11 13:24 ..
drwxrwxr-x 4 ec2-user ec2-user 4096  3月 11 13:24 .
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 

file15.txt

[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ vi /home/ec2-user/select_salesforce_restforce_api_test/select_salesforce_api_test.rb

file17.txt

[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ pwd
/home/ec2-user/select_salesforce_restforce_api_test
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ ruby /home/ec2-user/select_salesforce_restforce_api_test/select_salesforce_api_test.rb
"testname_Ruby_20170311_133426 : testname_Ruby_20170311_133426@hoge.example.com 2017-03-11"
"testname_Ruby_20170311_134741 : testname_Ruby_20170311_134741@hoge.example.com 2017-03-11"
"testname_Node_20170311_114548 : testname_Node_20170311_114548@hoge.example.com 2017-03-11"
"testname_Node_20170311_122544 : testname_Node_20170311_122544@hoge.example.com 2017-03-11"
"testname_Ruby_20170311_114515 : testname_Ruby_20170311_114515@hoge.example.com 2017-03-11"
"testname_Node_20170311_122603 : testname_Node_20170311_122603@hoge.example.com 2017-03-11"
"testname_Ruby_20170311_114654 : testname_Ruby_20170311_114654@hoge.example.com 2017-03-11"
"testname_Node_20170311_121201 : testname_Node_20170311_121201@hoge.example.com 2017-03-11"
"testname_Ruby_20170311_134744 : testname_Ruby_20170311_134744@hoge.example.com 2017-03-11"
"testname_Node_20170311_123050 : testname_Node_20170311_123050@hoge.example.com 2017-03-11"
"testname_Ruby_20170311_114637 : testname_Ruby_20170311_114637@hoge.example.com 2017-03-11"
"testname_Ruby120170311_134632 : testname_Ruby120170311_134632@hoge.example.com 2017-03-11"
"testname_Ruby1_20170311_134643 : testname_Ruby1_20170311_134643@hoge.example.com 2017-03-11"
"testname_Node_20170311_114546 : testname_Node_20170311_114546@hoge.example.com 2017-03-11"
"testname_Node_20170311_122616 : testname_Node_20170311_122616@hoge.example.com 2017-03-11"
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 

file18.txt

[ec2-user@example-ruby-sinatra-server ~]$ cd /home/ec2-user/insert_salesforce_restforce_api_test
[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ 

[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ vi /home/ec2-user/insert_salesforce_restforce_api_test/insert_salesforce_api_test.rb

file2.txt

[ec2-user@example-ruby-sinatra-server ~]$ source /home/ec2-user/.bashrc
[ec2-user@example-ruby-sinatra-server ~]$ 

file20.txt

[ec2-user@example-ruby-sinatra-server ~]$ cd /home/ec2-user/insert_salesforce_restforce_api_test/
[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ pwd
/home/ec2-user/insert_salesforce_restforce_api_test
[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ 
[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ ruby /home/ec2-user/insert_salesforce_restforce_api_test/insert_salesforce_api_test.rb
"testname_Ruby_20170311_133426 : testname_Ruby_20170311_133426@hoge.example.com 2017-03-11"
"testname_Ruby_20170311_134741 : testname_Ruby_20170311_134741@hoge.example.com 2017-03-11"
"testname_Ruby_20170311_114515 : testname_Ruby_20170311_114515@hoge.example.com 2017-03-11"
"testname_Ruby_20170311_114654 : testname_Ruby_20170311_114654@hoge.example.com 2017-03-11"
"testname_Ruby_20170311_134744 : testname_Ruby_20170311_134744@hoge.example.com 2017-03-11"
"testname_Ruby_20170311_114637 : testname_Ruby_20170311_114637@hoge.example.com 2017-03-11"
"testname_Ruby120170311_134632 : testname_Ruby120170311_134632@hoge.example.com 2017-03-11"
"testname_Ruby1_20170311_134643 : testname_Ruby1_20170311_134643@hoge.example.com 2017-03-11"
"testname_Ruby_20170311_135450 : testname_Ruby_20170311_135450@hoge.example.com 2017-03-11"
[ec2-user@example-ruby-sinatra-server insert_salesforce_restforce_api_test]$ 

file3.txt

[ec2-user@example-ruby-sinatra-server ~]$ hostname
example-ruby-sinatra-server
[ec2-user@example-ruby-sinatra-server ~]$ id
uid=500(ec2-user) gid=500(ec2-user) groups=500(ec2-user),10(wheel)
[ec2-user@example-ruby-sinatra-server ~]$ mkdir /home/ec2-user/select_salesforce_restforce_api_test
[ec2-user@example-ruby-sinatra-server ~]$ cd /home/ec2-user/select_salesforce_restforce_api_test
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ ls -lrta /home/ec2-user/select_salesforce_restforce_api_test/
合計 8
drwx------ 8 ec2-user ec2-user 4096  3月 11 13:02 ..
drwxrwxr-x 2 ec2-user ec2-user 4096  3月 11 13:02 .
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 

file4.txt

[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ pwd
/home/ec2-user/select_salesforce_restforce_api_test
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ bundle init
Writing new Gemfile to /home/ec2-user/select_salesforce_restforce_api_test/Gemfile
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ ls -lrta /home/ec2-user/select_salesforce_restforce_api_test/
合計 12
drwx------ 8 ec2-user ec2-user 4096  3月 11 13:02 ..
-rw-r--r-- 1 ec2-user ec2-user   75  3月 11 13:03 Gemfile
drwxrwxr-x 2 ec2-user ec2-user 4096  3月 11 13:03 .
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 

file5.txt

[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ cp -p /home/ec2-user/select_salesforce_restforce_api_test/Gemfile /home/ec2-user/select_salesforce_restforce_api_test/Gemfile.ORG
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ diff /home/ec2-user/select_salesforce_restforce_api_test/Gemfile /home/ec2-user/select_salesforce_restforce_api_test/Gemfile.ORG
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 

[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ cat /home/ec2-user/select_salesforce_restforce_api_test/Gemfile
# frozen_string_literal: true
source "https://rubygems.org"

# gem "rails"
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 

file6.txt

[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ echo 'gem "restforce"' >> /home/ec2-user/select_salesforce_restforce_api_test/Gemfile
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ cat /home/ec2-user/select_salesforce_restforce_api_test/Gemfile
# frozen_string_literal: true
source "https://rubygems.org"

# gem "rails"
gem "restforce"
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 

file7.txt

[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ diff /home/ec2-user/select_salesforce_restforce_api_test/Gemfile /home/ec2-user/select_salesforce_restforce_api_test/Gemfile.ORG
5d4
< gem "restforce"
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 

file8.txt

[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ pwd
/home/ec2-user/select_salesforce_restforce_api_test
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ bundle list
Could not find gem 'restforce' in any of the gem sources listed in your Gemfile or available on this machine.
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 

file9.txt

2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ pwd
/home/ec2-user/select_salesforce_restforce_api_test
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ ls -lrta /home/ec2-user/select_salesforce_restforce_api_test/
合計 16
drwx------ 8 ec2-user ec2-user 4096  3月 11 13:02 ..
-rw-r--r-- 1 ec2-user ec2-user   75  3月 11 13:03 Gemfile.ORG
drwxrwxr-x 2 ec2-user ec2-user 4096  3月 11 13:06 .
-rw-r--r-- 1 ec2-user ec2-user   91  3月 11 13:06 Gemfile
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ bundle install --path vendor/bundle
Fetching gem metadata from https://rubygems.org/.........
Fetching version metadata from https://rubygems.org/..
Fetching dependency metadata from https://rubygems.org/.
Resolving dependencies...
Installing multipart-post 2.0.0
Installing hashie 3.5.5
Installing json 2.0.3 with native extensions
Using bundler 1.13.2
Installing faraday 0.9.2
Installing faraday_middleware 0.11.0.1
Installing restforce 2.5.0
Bundle complete! 1 Gemfile dependency, 7 gems now installed.
Bundled gems are installed into ./vendor/bundle.
[ec2-user@example-ruby-sinatra-server select_salesforce_restforce_api_test]$ 

insert_salesforce_api_test.rb

#!/bin/env ruby
#
require 'bundler/setup'
require 'restforce'
require 'date'

# Salesforce接続用インスタンス作成とSalesforce API認証
client = Restforce.new(
     host: ENV['DATABASEDOTCOM_HOST'],
     username: ENV['DATABASEDOTCOM_CLIENT_USERNAME'],
     password: ENV['DATABASEDOTCOM_CLIENT_AUTHENTICATE_PASSWORD'],
     client_id: ENV['DATABASEDOTCOM_CLIENT_ID'],
     client_secret: ENV['DATABASEDOTCOM_CLIENT_SECRET']
)

now = Time.now
create_date = now.strftime("%Y-%m-%d")
insert_time = now.strftime("%Y%m%d_%H%M%S")
insert_name = "testname_Ruby_" + insert_time
insert_email = insert_name + "@hoge.example.com"

# Salesforceカスタムオブジェクトにレコードを登録する
client.create(
  'QuickStart__c',
  user_name__c: insert_name,
  user_email__c: insert_email,
  create_date__c: create_date
)

# Salesforceカスタムオブジェクトに登録されているレコード一覧を表示
client.query("SELECT user_name__c, user_email__c, create_date__c FROM QuickStart__c WHERE user_email__c LIKE '%Ruby%' AND create_date__c >= TODAY").each do|record|
  p "#{record.user_name__c} : #{record.user_email__c} #{record.create_date__c}"
end

select_salesforce_api_test.rb

#!/bin/env ruby
#
require 'bundler/setup'
require 'restforce'

# Salesforce接続用インスタンス作成とSalesforce API認証
client = Restforce.new(
     host: ENV['DATABASEDOTCOM_HOST'],
     username: ENV['DATABASEDOTCOM_CLIENT_USERNAME'],
     password: ENV['DATABASEDOTCOM_CLIENT_AUTHENTICATE_PASSWORD'],
     client_id: ENV['DATABASEDOTCOM_CLIENT_ID'],
     client_secret: ENV['DATABASEDOTCOM_CLIENT_SECRET']
)

# Salesforceカスタムオブジェクトに登録されているレコード一覧を表示
client.query("SELECT user_name__c, user_email__c, create_date__c FROM QuickStart__c WHERE create_date__c >= TODAY").each do|record|
  p "#{record.user_name__c} : #{record.user_email__c} #{record.create_date__c}"
end