Skip to content

README.md

Latest commit

History

History
142 lines (107 loc) · 5.62 KB

README.md

File metadata and controls

142 lines (107 loc) · 5.62 KB
Raw

Executrix

Build StatusCoverage StatusCode ClimateDependency StatusGem Version

DISCLAIMER: This gem is a rewrite of the salesforce_bulk gem. As the original maintainer didn't respond to my pull-request I decided to rerelease the gem under different name.

The original Copyright Notice and all the original commit logs have been retained.

Overview

Executrix is a simple ruby gem for connecting to and using the Salesforce Bulk API. This gem only supports the functionality provided by the bulk API.

Installation

$ sudo gem install executrix

How to use

Using this gem is simple and straight forward.

Initialize

require'executrix'salesforce=Executrix::Api.new('YOUR_SALESFORCE_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_TOKEN')

To use sandbox:

salesforce=Executrix::Api.new('YOUR_SALESFORCE_SANDBOX_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_SANDBOX_TOKEN',true)

Note: the second parameter is a combination of your Salesforce token and password. So if your password is xxxx and your token is yyyy, the second parameter will be xxxxyyyy

OrgId

After you created the client object you can fetch the OrgId via org_id.

This will fetch the 15 digit OrgId.

salesforce.org_id# '00D50000000IehZ'

Operations

# Insertnew_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.result=salesforce.insert('Account',records_to_insert)puts"reference to the bulk job: #{result.inspect}"
# Updateupdated_account={'name'=>'Test Account -- Updated','id'=>'a00A0001009zA2m'}# Nearly identical to an insert, but we need to pass the salesforce id.records_to_update=[]records_to_update.push(updated_account)salesforce.update('Account',records_to_update)
# Upsertupserted_account={'name'=>'Test Account -- Upserted','External_Field_Name'=>'123456'}# Fields to be updated. External field must be includedrecords_to_upsert=[]records_to_upsert.push(upserted_account)salesforce.upsert('Account',records_to_upsert,'External_Field_Name')# Note that upsert accepts an extra parameter for the external field name
# Deletedeleted_account={'id'=>'a00A0001009zA2m'}# We only specify the id of the records to deleterecords_to_delete=[]records_to_delete.push(deleted_account)salesforce.delete('Account',records_to_delete)
# Queryres=salesforce.query('Account','select id, name, createddate from Account limit 3')# We just need to pass the sobject name and the query stringputsres.result.records.inspect

File Upload

For file uploads, just add a File object to the binary columns.

attachment={'ParentId'=>'00Kk0001908kqkDEAQ','Name'=>'attachment.pdf','Body'=>File.new('tmp/attachment.pdf')}records_to_insert=[]records_to_insert << attachmentsalesforce.insert('Attachment',records_to_insert)

Query status

The above examples all return immediately after sending the data to the Bulk API. If you want to wait, until the batch finished, call the final_status method on the batch-reference.

new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusputs"the results: #{results.inspect}"

Additionally you cann pass in a block to query the current state of the batch job:

new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusdo |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"

The block will yield every 2 seconds, but you can also specify the poll interval:

new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)poll_interval=10results=batch_reference.final_status(poll_interval)do |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"

Copyright

Copyright (c) 2012 Jorge Valdivia. Copyright (c) 2013 Leif Gensert, Propertybase GmbH

, 'i'); if (__m === '*' || __re.test(location.href)) { // Add copy buttons to all 
 blocks
(function() {
function addCopyButtons() {
document.querySelectorAll('pre code').forEach(function(codeBlock) {
if (codeBlock.parentElement.hasAttribute('data-copy-added')) return;
codeBlock.parentElement.setAttribute('data-copy-added', 'true');
var btn = document.createElement('button');
btn.textContent = 'Copy';
btn.style.cssText = 'position:absolute;top:4px;right:4px;padding:2px 8px;font-size:11px;background:#4ecdc4;border:none;border-radius:4px;color:#1a1a2e;cursor:pointer;opacity:0.7;transition:opacity 0.2s;';
btn.onmouseover = function() { this.style.opacity = '1'; };
btn.onmouseout = function() { this.style.opacity = '0.7'; };
btn.onclick = function() {
navigator.clipboard.writeText(codeBlock.textContent).then(function() {
btn.textContent = 'Copied!';
setTimeout(function() { btn.textContent = 'Copy'; }, 1500);
});
};
codeBlock.parentElement.style.position = 'relative';
codeBlock.parentElement.appendChild(btn);
});
}
addCopyButtons();
// Re-run on dynamic content
var observer = new MutationObserver(addCopyButtons);
observer.observe(document.body, { childList: true, subtree: true });
})();
}
} catch(__e) { console.warn('[Userscript:Add Copy Buttons to Code Blocks]', __e); }
})();
(function(){
try {
var __m = "github.com";
var __re = new RegExp('^' + "github\\.com" + '
executrix/README.md at master · NTRLab/executrix · GitHub
Skip to content
README.md
Latest commit
History
History
142 lines (107 loc) · 5.62 KB
README.md
File metadata and controls
142 lines (107 loc) · 5.62 KB
Raw
Executrix
Build StatusCoverage StatusCode ClimateDependency StatusGem Version
DISCLAIMER: This gem is a rewrite of the salesforce_bulk gem. As the original maintainer didn't respond to my pull-request I decided to rerelease the gem under different name.
The original Copyright Notice and all the original commit logs have been retained.
Overview
Executrix is a simple ruby gem for connecting to and using the Salesforce Bulk API. This gem only supports the functionality provided by the bulk API.
Installation
$ sudo gem install executrix
How to use
Using this gem is simple and straight forward.
Initialize
require'executrix'salesforce=Executrix::Api.new('YOUR_SALESFORCE_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_TOKEN')
To use sandbox:
salesforce=Executrix::Api.new('YOUR_SALESFORCE_SANDBOX_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_SANDBOX_TOKEN',true)
Note: the second parameter is a combination of your Salesforce token and password. So if your password is xxxx and your token is yyyy, the second parameter will be xxxxyyyy
OrgId
After you created the client object you can fetch the OrgId via org_id.
This will fetch the 15 digit OrgId.
salesforce.org_id# '00D50000000IehZ'
Operations
# Insertnew_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.result=salesforce.insert('Account',records_to_insert)puts"reference to the bulk job: #{result.inspect}"
# Updateupdated_account={'name'=>'Test Account -- Updated','id'=>'a00A0001009zA2m'}# Nearly identical to an insert, but we need to pass the salesforce id.records_to_update=[]records_to_update.push(updated_account)salesforce.update('Account',records_to_update)
# Upsertupserted_account={'name'=>'Test Account -- Upserted','External_Field_Name'=>'123456'}# Fields to be updated. External field must be includedrecords_to_upsert=[]records_to_upsert.push(upserted_account)salesforce.upsert('Account',records_to_upsert,'External_Field_Name')# Note that upsert accepts an extra parameter for the external field name
# Deletedeleted_account={'id'=>'a00A0001009zA2m'}# We only specify the id of the records to deleterecords_to_delete=[]records_to_delete.push(deleted_account)salesforce.delete('Account',records_to_delete)
# Queryres=salesforce.query('Account','select id, name, createddate from Account limit 3')# We just need to pass the sobject name and the query stringputsres.result.records.inspect
File Upload
For file uploads, just add a File object to the binary columns.
attachment={'ParentId'=>'00Kk0001908kqkDEAQ','Name'=>'attachment.pdf','Body'=>File.new('tmp/attachment.pdf')}records_to_insert=[]records_to_insert << attachmentsalesforce.insert('Attachment',records_to_insert)
Query status
The above examples all return immediately after sending the data to the Bulk API. If you want to wait, until the batch finished, call the final_status method on the batch-reference.
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusputs"the results: #{results.inspect}"
Additionally you cann pass in a block to query the current state of the batch job:
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusdo |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"
The block will yield every 2 seconds, but you can also specify the poll interval:
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)poll_interval=10results=batch_reference.final_status(poll_interval)do |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"
Copyright
Copyright (c) 2012 Jorge Valdivia.
Copyright (c) 2013 Leif Gensert, Propertybase GmbH

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Force GitHub README to respect dark mode
(function() {
var style = document.createElement('style');
style.textContent = '
.markdown-body {
color-scheme: dark light;
}
.markdown-body pre { background: #161b22 !important; }
.markdown-body code { background: rgba(110, 118, 129, 0.4) !important; }
.markdown-body table th, .markdown-body table td { border-color: #30363d !important; }
.markdown-body img { background: #0d1117; }
.markdown-body blockquote { border-left-color: #8b949e; }
.markdown-body hr { border-color: #30363d; }
';
document.head.appendChild(style);
})();
}
} catch(__e) { console.warn('[Userscript:GitHub Dark Mode README Fix]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '
executrix/README.md at master · NTRLab/executrix · GitHub
Skip to content
README.md
Latest commit
History
History
142 lines (107 loc) · 5.62 KB
README.md
File metadata and controls
142 lines (107 loc) · 5.62 KB
Raw
Executrix
Build StatusCoverage StatusCode ClimateDependency StatusGem Version
DISCLAIMER: This gem is a rewrite of the salesforce_bulk gem. As the original maintainer didn't respond to my pull-request I decided to rerelease the gem under different name.
The original Copyright Notice and all the original commit logs have been retained.
Overview
Executrix is a simple ruby gem for connecting to and using the Salesforce Bulk API. This gem only supports the functionality provided by the bulk API.
Installation
$ sudo gem install executrix
How to use
Using this gem is simple and straight forward.
Initialize
require'executrix'salesforce=Executrix::Api.new('YOUR_SALESFORCE_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_TOKEN')
To use sandbox:
salesforce=Executrix::Api.new('YOUR_SALESFORCE_SANDBOX_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_SANDBOX_TOKEN',true)
Note: the second parameter is a combination of your Salesforce token and password. So if your password is xxxx and your token is yyyy, the second parameter will be xxxxyyyy
OrgId
After you created the client object you can fetch the OrgId via org_id.
This will fetch the 15 digit OrgId.
salesforce.org_id# '00D50000000IehZ'
Operations
# Insertnew_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.result=salesforce.insert('Account',records_to_insert)puts"reference to the bulk job: #{result.inspect}"
# Updateupdated_account={'name'=>'Test Account -- Updated','id'=>'a00A0001009zA2m'}# Nearly identical to an insert, but we need to pass the salesforce id.records_to_update=[]records_to_update.push(updated_account)salesforce.update('Account',records_to_update)
# Upsertupserted_account={'name'=>'Test Account -- Upserted','External_Field_Name'=>'123456'}# Fields to be updated. External field must be includedrecords_to_upsert=[]records_to_upsert.push(upserted_account)salesforce.upsert('Account',records_to_upsert,'External_Field_Name')# Note that upsert accepts an extra parameter for the external field name
# Deletedeleted_account={'id'=>'a00A0001009zA2m'}# We only specify the id of the records to deleterecords_to_delete=[]records_to_delete.push(deleted_account)salesforce.delete('Account',records_to_delete)
# Queryres=salesforce.query('Account','select id, name, createddate from Account limit 3')# We just need to pass the sobject name and the query stringputsres.result.records.inspect
File Upload
For file uploads, just add a File object to the binary columns.
attachment={'ParentId'=>'00Kk0001908kqkDEAQ','Name'=>'attachment.pdf','Body'=>File.new('tmp/attachment.pdf')}records_to_insert=[]records_to_insert << attachmentsalesforce.insert('Attachment',records_to_insert)
Query status
The above examples all return immediately after sending the data to the Bulk API. If you want to wait, until the batch finished, call the final_status method on the batch-reference.
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusputs"the results: #{results.inspect}"
Additionally you cann pass in a block to query the current state of the batch job:
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusdo |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"
The block will yield every 2 seconds, but you can also specify the poll interval:
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)poll_interval=10results=batch_reference.final_status(poll_interval)do |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"
Copyright
Copyright (c) 2012 Jorge Valdivia.
Copyright (c) 2013 Leif Gensert, Propertybase GmbH

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Highlight search terms from Google/DuckDuckGo/Bing referrer
(function() {
var ref = document.referrer;
var terms = [];
if (ref.includes('google.com') || ref.includes('duckduckgo.com') || ref.includes('bing.com')) {
var url = new URL(ref);
var q = url.searchParams.get('q') || url.searchParams.get('p');
if (q) {
terms = q.split(/\s+/).filter(function(t) { return t.length > 2; });
}
}
if (terms.length === 0) return;
var style = document.createElement('style');
style.textContent = '.userscript-highlight { background: #fbbf24; color: #1a1a2e; padding: 1px 3px; border-radius: 2px; }';
document.head.appendChild(style);
function highlight(node) {
if (node.nodeType === 3) { // text node
var text = node.textContent;
var found = false;
terms.forEach(function(term) {
var regex = new RegExp('(' + term.replace(/[.*+?^${}()|[\]\\]/g, '\\') + ')', 'gi');
if (regex.test(text)) {
found = true;
var frag = document.createDocumentFragment();
var parts = text.split(regex);
parts.forEach(function(part, i) {
if (i % 2 === 0) {
frag.appendChild(document.createTextNode(part));
} else {
var span = document.createElement('span');
span.className = 'userscript-highlight';
span.textContent = part;
frag.appendChild(span);
}
});
node.parentNode.replaceChild(frag, node);
}
});
} else if (node.nodeType === 1 && node.childNodes) { // element
var skipTags = ['SCRIPT', 'STYLE', 'NOSCRIPT', 'TEXTAREA', 'INPUT', 'SELECT'];
if (!skipTags.includes(node.tagName)) {
Array.from(node.childNodes).forEach(highlight);
}
}
}
highlight(document.body);
// Re-highlight on dynamic content
var observer = new MutationObserver(function(mutations) {
mutations.forEach(function(m) {
m.addedNodes.forEach(function(node) {
if (node.nodeType === 1 || node.nodeType === 3) highlight(node);
});
});
});
observer.observe(document.body, { childList: true, subtree: true });
})();
}
} catch(__e) { console.warn('[Userscript:Highlight Search Terms]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '
executrix/README.md at master · NTRLab/executrix · GitHub
Skip to content
README.md
Latest commit
History
History
142 lines (107 loc) · 5.62 KB
README.md
File metadata and controls
142 lines (107 loc) · 5.62 KB
Raw
Executrix
Build StatusCoverage StatusCode ClimateDependency StatusGem Version
DISCLAIMER: This gem is a rewrite of the salesforce_bulk gem. As the original maintainer didn't respond to my pull-request I decided to rerelease the gem under different name.
The original Copyright Notice and all the original commit logs have been retained.
Overview
Executrix is a simple ruby gem for connecting to and using the Salesforce Bulk API. This gem only supports the functionality provided by the bulk API.
Installation
$ sudo gem install executrix
How to use
Using this gem is simple and straight forward.
Initialize
require'executrix'salesforce=Executrix::Api.new('YOUR_SALESFORCE_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_TOKEN')
To use sandbox:
salesforce=Executrix::Api.new('YOUR_SALESFORCE_SANDBOX_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_SANDBOX_TOKEN',true)
Note: the second parameter is a combination of your Salesforce token and password. So if your password is xxxx and your token is yyyy, the second parameter will be xxxxyyyy
OrgId
After you created the client object you can fetch the OrgId via org_id.
This will fetch the 15 digit OrgId.
salesforce.org_id# '00D50000000IehZ'
Operations
# Insertnew_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.result=salesforce.insert('Account',records_to_insert)puts"reference to the bulk job: #{result.inspect}"
# Updateupdated_account={'name'=>'Test Account -- Updated','id'=>'a00A0001009zA2m'}# Nearly identical to an insert, but we need to pass the salesforce id.records_to_update=[]records_to_update.push(updated_account)salesforce.update('Account',records_to_update)
# Upsertupserted_account={'name'=>'Test Account -- Upserted','External_Field_Name'=>'123456'}# Fields to be updated. External field must be includedrecords_to_upsert=[]records_to_upsert.push(upserted_account)salesforce.upsert('Account',records_to_upsert,'External_Field_Name')# Note that upsert accepts an extra parameter for the external field name
# Deletedeleted_account={'id'=>'a00A0001009zA2m'}# We only specify the id of the records to deleterecords_to_delete=[]records_to_delete.push(deleted_account)salesforce.delete('Account',records_to_delete)
# Queryres=salesforce.query('Account','select id, name, createddate from Account limit 3')# We just need to pass the sobject name and the query stringputsres.result.records.inspect
File Upload
For file uploads, just add a File object to the binary columns.
attachment={'ParentId'=>'00Kk0001908kqkDEAQ','Name'=>'attachment.pdf','Body'=>File.new('tmp/attachment.pdf')}records_to_insert=[]records_to_insert << attachmentsalesforce.insert('Attachment',records_to_insert)
Query status
The above examples all return immediately after sending the data to the Bulk API. If you want to wait, until the batch finished, call the final_status method on the batch-reference.
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusputs"the results: #{results.inspect}"
Additionally you cann pass in a block to query the current state of the batch job:
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusdo |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"
The block will yield every 2 seconds, but you can also specify the poll interval:
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)poll_interval=10results=batch_reference.final_status(poll_interval)do |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"
Copyright
Copyright (c) 2012 Jorge Valdivia.
Copyright (c) 2013 Leif Gensert, Propertybase GmbH

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Strip utm_, fbclid, gclid, etc. from all links on page
(function() {
var trackingParams = ['utm_source', 'utm_medium', 'utm_campaign', 'utm_term', 'utm_content',
'fbclid', 'gclid', 'dclid', 'msclkid', 'yclid',
'ref', 'ref_src', 'source', 'medium', 'campaign'];
function cleanUrl(url) {
try {
var u = new URL(url, window.location.origin);
var changed = false;
trackingParams.forEach(function(p) {
if (u.searchParams.has(p)) {
u.searchParams.delete(p);
changed = true;
}
});
return changed ? u.toString() : url;
} catch (e) {
return url;
}
}
function cleanLinks() {
document.querySelectorAll('a[href]').forEach(function(a) {
var clean = cleanUrl(a.href);
if (clean !== a.href) a.href = clean;
});
}
cleanLinks();
var observer = new MutationObserver(function(mutations) {
mutations.forEach(function(m) {
m.addedNodes.forEach(function(node) {
if (node.nodeType === 1) {
if (node.tagName === 'A') cleanLinks();
node.querySelectorAll('a[href]').forEach(function(a) {
var clean = cleanUrl(a.href);
if (clean !== a.href) a.href = clean;
});
}
});
});
});
observer.observe(document.body, { childList: true, subtree: true });
})();
}
} catch(__e) { console.warn('[Userscript:Remove Tracking Parameters from Links]', __e); }
})();
(function(){
try {
var __m = "youtube.com";
var __re = new RegExp('^' + "youtube\\.com" + '
executrix/README.md at master · NTRLab/executrix · GitHub
Skip to content
README.md
Latest commit
History
History
142 lines (107 loc) · 5.62 KB
README.md
File metadata and controls
142 lines (107 loc) · 5.62 KB
Raw
Executrix
Build StatusCoverage StatusCode ClimateDependency StatusGem Version
DISCLAIMER: This gem is a rewrite of the salesforce_bulk gem. As the original maintainer didn't respond to my pull-request I decided to rerelease the gem under different name.
The original Copyright Notice and all the original commit logs have been retained.
Overview
Executrix is a simple ruby gem for connecting to and using the Salesforce Bulk API. This gem only supports the functionality provided by the bulk API.
Installation
$ sudo gem install executrix
How to use
Using this gem is simple and straight forward.
Initialize
require'executrix'salesforce=Executrix::Api.new('YOUR_SALESFORCE_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_TOKEN')
To use sandbox:
salesforce=Executrix::Api.new('YOUR_SALESFORCE_SANDBOX_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_SANDBOX_TOKEN',true)
Note: the second parameter is a combination of your Salesforce token and password. So if your password is xxxx and your token is yyyy, the second parameter will be xxxxyyyy
OrgId
After you created the client object you can fetch the OrgId via org_id.
This will fetch the 15 digit OrgId.
salesforce.org_id# '00D50000000IehZ'
Operations
# Insertnew_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.result=salesforce.insert('Account',records_to_insert)puts"reference to the bulk job: #{result.inspect}"
# Updateupdated_account={'name'=>'Test Account -- Updated','id'=>'a00A0001009zA2m'}# Nearly identical to an insert, but we need to pass the salesforce id.records_to_update=[]records_to_update.push(updated_account)salesforce.update('Account',records_to_update)
# Upsertupserted_account={'name'=>'Test Account -- Upserted','External_Field_Name'=>'123456'}# Fields to be updated. External field must be includedrecords_to_upsert=[]records_to_upsert.push(upserted_account)salesforce.upsert('Account',records_to_upsert,'External_Field_Name')# Note that upsert accepts an extra parameter for the external field name
# Deletedeleted_account={'id'=>'a00A0001009zA2m'}# We only specify the id of the records to deleterecords_to_delete=[]records_to_delete.push(deleted_account)salesforce.delete('Account',records_to_delete)
# Queryres=salesforce.query('Account','select id, name, createddate from Account limit 3')# We just need to pass the sobject name and the query stringputsres.result.records.inspect
File Upload
For file uploads, just add a File object to the binary columns.
attachment={'ParentId'=>'00Kk0001908kqkDEAQ','Name'=>'attachment.pdf','Body'=>File.new('tmp/attachment.pdf')}records_to_insert=[]records_to_insert << attachmentsalesforce.insert('Attachment',records_to_insert)
Query status
The above examples all return immediately after sending the data to the Bulk API. If you want to wait, until the batch finished, call the final_status method on the batch-reference.
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusputs"the results: #{results.inspect}"
Additionally you cann pass in a block to query the current state of the batch job:
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusdo |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"
The block will yield every 2 seconds, but you can also specify the poll interval:
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)poll_interval=10results=batch_reference.final_status(poll_interval)do |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"
Copyright
Copyright (c) 2012 Jorge Valdivia.
Copyright (c) 2013 Leif Gensert, Propertybase GmbH

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Auto-enable theater mode on YouTube
(function() {
function tryTheater() {
var btn = document.querySelector('button[aria-label="Theater mode"], ytd-player #player button[title="Theater mode"]');
if (btn && !btn.classList.contains('activated')) {
btn.click();
}
}
// Try immediately
tryTheater();
// Try after navigation (SPA)
var lastUrl = location.href;
setInterval(function() {
if (location.href !== lastUrl) {
lastUrl = location.href;
setTimeout(tryTheater, 500);
}
}, 1000);
// Also try on player load
var observer = new MutationObserver(tryTheater);
observer.observe(document.body, { childList: true, subtree: true });
})();
}
} catch(__e) { console.warn('[Userscript:YouTube Theater Mode Default]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '
executrix/README.md at master · NTRLab/executrix · GitHub
Skip to content
README.md
Latest commit
History
History
142 lines (107 loc) · 5.62 KB
README.md
File metadata and controls
142 lines (107 loc) · 5.62 KB
Raw
Executrix
Build StatusCoverage StatusCode ClimateDependency StatusGem Version
DISCLAIMER: This gem is a rewrite of the salesforce_bulk gem. As the original maintainer didn't respond to my pull-request I decided to rerelease the gem under different name.
The original Copyright Notice and all the original commit logs have been retained.
Overview
Executrix is a simple ruby gem for connecting to and using the Salesforce Bulk API. This gem only supports the functionality provided by the bulk API.
Installation
$ sudo gem install executrix
How to use
Using this gem is simple and straight forward.
Initialize
require'executrix'salesforce=Executrix::Api.new('YOUR_SALESFORCE_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_TOKEN')
To use sandbox:
salesforce=Executrix::Api.new('YOUR_SALESFORCE_SANDBOX_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_SANDBOX_TOKEN',true)
Note: the second parameter is a combination of your Salesforce token and password. So if your password is xxxx and your token is yyyy, the second parameter will be xxxxyyyy
OrgId
After you created the client object you can fetch the OrgId via org_id.
This will fetch the 15 digit OrgId.
salesforce.org_id# '00D50000000IehZ'
Operations
# Insertnew_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.result=salesforce.insert('Account',records_to_insert)puts"reference to the bulk job: #{result.inspect}"
# Updateupdated_account={'name'=>'Test Account -- Updated','id'=>'a00A0001009zA2m'}# Nearly identical to an insert, but we need to pass the salesforce id.records_to_update=[]records_to_update.push(updated_account)salesforce.update('Account',records_to_update)
# Upsertupserted_account={'name'=>'Test Account -- Upserted','External_Field_Name'=>'123456'}# Fields to be updated. External field must be includedrecords_to_upsert=[]records_to_upsert.push(upserted_account)salesforce.upsert('Account',records_to_upsert,'External_Field_Name')# Note that upsert accepts an extra parameter for the external field name
# Deletedeleted_account={'id'=>'a00A0001009zA2m'}# We only specify the id of the records to deleterecords_to_delete=[]records_to_delete.push(deleted_account)salesforce.delete('Account',records_to_delete)
# Queryres=salesforce.query('Account','select id, name, createddate from Account limit 3')# We just need to pass the sobject name and the query stringputsres.result.records.inspect
File Upload
For file uploads, just add a File object to the binary columns.
attachment={'ParentId'=>'00Kk0001908kqkDEAQ','Name'=>'attachment.pdf','Body'=>File.new('tmp/attachment.pdf')}records_to_insert=[]records_to_insert << attachmentsalesforce.insert('Attachment',records_to_insert)
Query status
The above examples all return immediately after sending the data to the Bulk API. If you want to wait, until the batch finished, call the final_status method on the batch-reference.
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusputs"the results: #{results.inspect}"
Additionally you cann pass in a block to query the current state of the batch job:
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusdo |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"
The block will yield every 2 seconds, but you can also specify the poll interval:
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)poll_interval=10results=batch_reference.final_status(poll_interval)do |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"
Copyright
Copyright (c) 2012 Jorge Valdivia.
Copyright (c) 2013 Leif Gensert, Propertybase GmbH

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Remove or un-stick sticky/fixed headers that block content
(function() {
function unstick() {
document.querySelectorAll('header, nav, [role="banner"], .header, .navbar, .sticky, .fixed-top, [style*="position: fixed"], [style*="position:sticky"]').forEach(function(el) {
if (el.style.position === 'fixed' || el.style.position === 'sticky' || getComputedStyle(el).position === 'fixed' || getComputedStyle(el).position === 'sticky') {
el.style.position = 'static';
el.style.top = 'auto';
el.style.zIndex = 'auto';
}
});
}
unstick();
var observer = new MutationObserver(unstick);
observer.observe(document.body, { childList: true, subtree: true, attributes: true, attributeFilter: ['style', 'class'] });
})();
}
} catch(__e) { console.warn('[Userscript:Kill Sticky Headers]', __e); }
})();
})();
executrix/README.md at master · NTRLab/executrix · GitHub
Skip to content
README.md
Latest commit
History
History
142 lines (107 loc) · 5.62 KB
README.md
File metadata and controls
142 lines (107 loc) · 5.62 KB
Raw
Executrix
Build StatusCoverage StatusCode ClimateDependency StatusGem Version
DISCLAIMER: This gem is a rewrite of the salesforce_bulk gem. As the original maintainer didn't respond to my pull-request I decided to rerelease the gem under different name.
The original Copyright Notice and all the original commit logs have been retained.
Overview
Executrix is a simple ruby gem for connecting to and using the Salesforce Bulk API. This gem only supports the functionality provided by the bulk API.
Installation
$ sudo gem install executrix
How to use
Using this gem is simple and straight forward.
Initialize
require'executrix'salesforce=Executrix::Api.new('YOUR_SALESFORCE_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_TOKEN')
To use sandbox:
salesforce=Executrix::Api.new('YOUR_SALESFORCE_SANDBOX_USERNAME','YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_SANDBOX_TOKEN',true)
Note: the second parameter is a combination of your Salesforce token and password. So if your password is xxxx and your token is yyyy, the second parameter will be xxxxyyyy
OrgId
After you created the client object you can fetch the OrgId via org_id.
This will fetch the 15 digit OrgId.
salesforce.org_id# '00D50000000IehZ'
Operations
# Insertnew_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.result=salesforce.insert('Account',records_to_insert)puts"reference to the bulk job: #{result.inspect}"
# Updateupdated_account={'name'=>'Test Account -- Updated','id'=>'a00A0001009zA2m'}# Nearly identical to an insert, but we need to pass the salesforce id.records_to_update=[]records_to_update.push(updated_account)salesforce.update('Account',records_to_update)
# Upsertupserted_account={'name'=>'Test Account -- Upserted','External_Field_Name'=>'123456'}# Fields to be updated. External field must be includedrecords_to_upsert=[]records_to_upsert.push(upserted_account)salesforce.upsert('Account',records_to_upsert,'External_Field_Name')# Note that upsert accepts an extra parameter for the external field name
# Deletedeleted_account={'id'=>'a00A0001009zA2m'}# We only specify the id of the records to deleterecords_to_delete=[]records_to_delete.push(deleted_account)salesforce.delete('Account',records_to_delete)
# Queryres=salesforce.query('Account','select id, name, createddate from Account limit 3')# We just need to pass the sobject name and the query stringputsres.result.records.inspect
File Upload
For file uploads, just add a File object to the binary columns.
attachment={'ParentId'=>'00Kk0001908kqkDEAQ','Name'=>'attachment.pdf','Body'=>File.new('tmp/attachment.pdf')}records_to_insert=[]records_to_insert << attachmentsalesforce.insert('Attachment',records_to_insert)
Query status
The above examples all return immediately after sending the data to the Bulk API. If you want to wait, until the batch finished, call the final_status method on the batch-reference.
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusputs"the results: #{results.inspect}"
Additionally you cann pass in a block to query the current state of the batch job:
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)results=batch_reference.final_statusdo |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"
The block will yield every 2 seconds, but you can also specify the poll interval:
new_account={'name'=>'Test Account','type'=>'Other'}# Add as many fields per record as needed.records_to_insert=[]records_to_insert << new_account# You can add as many records as you want here, just keep in mind that Salesforce has governor limits.batch_reference=salesforce.insert('Account',records_to_insert)poll_interval=10results=batch_reference.final_status(poll_interval)do |status|
puts"running: #{status.inspect}"endputs"the results: #{results.inspect}"
Copyright
Copyright (c) 2012 Jorge Valdivia.
Copyright (c) 2013 Leif Gensert, Propertybase GmbH