Create migration as analogs to Salesforce objects read from a connected org. Useful for staging data for import or downloading data for warehousing.
See Laravel Migration Builder as well.
composer require blackbricksoftware/laravel-migration-builder-salesforce --dev
php artisan vendor:publish --tag=laravel-migration-builder-salesforce-config
Add the following lines. See the Salesforce REST API Client for Laravel page for specific configuration details.
SF_AUTH_METHOD=UserPassword
SF_CONSUMER_KEY=123455
SF_CONSUMER_SECRET=ABCDEF
SF_CALLBACK_URI=https://test.app/callback
SF_LOGIN_URL=https://login.salesforce.com
#SF_LOGIN_URL=https://test.salesforce.com
[email protected]
SF_PASSWORD=password123
SF_AUTH_METHOD=UserPassword will likely be the easiest method for a CLI application.
SF_LOGIN_URL will generally be https://login.salesforce.com for a live org or https://test.salesforce.com for a sandbox org.
SF_PASSWORD will be the user's login password with the user's token concatenated on the end.
Run php artisan make:migration-builder:salesforce:object ObjectName to create a migration based on the description of ObjectName from the Salesforce REST API.
Run php artisan make:migration-builder:salesforce:object:debug ObjectName to create a 3 files in the (a ObjectName.var_dump.txt, Objectname.print_r.txt, and pretty printed ObjectName.json) in the Storage::disk('local') directory (usually storage/app/migration-builder/salesforce/) showing the response from the Salesforce REST API.
- This Salesforce Developer document I guess.