This package uses omniphx/forrest to provide an Eloquent-style way of querying sObjects from Salesforce.
Follow the instructions provided at omniphx/forrest to connect to your Salesforce environment.
Once done, you can then use the SynergiTech\Salesforce\Facades\Salesforce facade to perform queries against a particular table like so:
use SynergiTech\Salesforce\Facades\Salesforce;
// Get an individual record by Id
Salesforce::table('MyTable')->find('YourIdHere');Allows you to directly pull an individual record as an array by Id. You can also specify another field name as the second parameter. If you specify a non-unique column and multiple records are returned then the first record is always returned.
Salesforce::table('MyTable')->find('YourIdHere');Allows you to directly pull multiple records as a Laravel Collection by provide an array of their respective Id fields. You can also specify another field name as the second parameter.
Salesforce::table('MyTable')->findMany(['YourId1Here', 'YourId2Here']);Allows you to create a new record on the specified table using an array of fields.
$response = Salesforce::table('MyTable')->create([
'Name' => 'John Doe',
]);[
'id' => '', // Salesforce Id
'success' => true,
'errors' => [],
'data' => [
// Full record data
],
]Allows you to update a record using it's Salesforce Id with an array of fields.
$response = Salesforce::table('MyTable')->update('Id', [
'Name' => 'John Doe',
]);See 'create' above
Allows you to upsert a record using an Id field and the associated value.
$response = Salesforce::table('MyTable')->createOrUpdate('My_External_Id__c', 'ExternalId', [
'Name' => 'John Doe',
]);[
'id' => '', // Salesforce Id
'success' => true,
'errors' => [],
'created' => true, // True/False depending on whether the record was created or updated
'data' => [
// Full record data
],
]Allows you to delete a record by it's Id, returning true if successful.
Salesforce::table('MyTable')->delete('Id');This package allows you to scope your get calls using query builder methods.
Query builders cannot currently be used in conjunction with the update or delete methods (sorry 🙏).
You can also scope your queries with where clauses.
// Basic where clause
Salesforce::table('MyTable')->where('Name', 'John Doe')->get();
// You can also use any of the following operators
// Equals and Not Equals
Salesforce::table('MyTable')->where('Name', '=', 'John Doe')->get();
Salesforce::table('MyTable')->where('Name', '!=', 'John Doe')->get();
// Comparisons
Salesforce::table('MyTable')->where('Age', '<', 30)->get();
Salesforce::table('MyTable')->where('Age', '<=', 30)->get();
Salesforce::table('MyTable')->where('Age', '>', 30)->get();
Salesforce::table('MyTable')->where('Age', '>=', 30)->get();
// Like
Salesforce::table('MyTable')->where('Name', 'LIKE', 'John %')->get();
Salesforce::table('MyTable')->where('Name', 'LIKE', '% Middlename %')->get();
Salesforce::table('MyTable')->where('Name', 'LIKE', '% Doe')->get();You can provide an array of possible values to the whereIn method to select any records that match any of the values.
Salesforce::table('MyTable')->whereIn('Country', ['United Kingdom', 'United States'])->get();You can order by a particular field in either ascending or descending order.
// Ascending (default)
Salesforce::table('MyTable')->orderBy('Age')->get();
// Descending
Salesforce::table('MyTable')->orderBy('Age', 'DESC')->get();By default when chaining an orderBy null values are returned first.
You can chain on ->nullsLast() to return null values last.
Salesforce::table('MyTable')->orderBy('LastLoginDate')->nullsLast()->get();You can limit the amount of records returned.
Salesforce::table('MyTable')->where('Name', 'LIKE', 'John%')->limit(20)->get();By default omniphx/forrest typically throws a single exception with more detail contained within a JSON encoded string. We've wrapped some with our own exceptions to help with debugging.