To upsert the records csv file, external id(I our case I am using the ID field) and SObjectType are the required arguments.

Let’s execute the command to load the Account Data. I have the csv file with all the required fields to load the data.

Execute this command: sfdx force:data:bulk:upsert -s Account -f data/Account1.csv -i Id -w 2

When you are in doubt please check for help be appending the command with –help

At this moment in my org I have 11 Accounts.

Once the command execute you can see the results as below.

To know the status please execute the command that was showing in the above picture i.e.

You can see the count updated in the Account List View. Please check the bulk data loads job also to verify the same.

Lets use another command to delete all the Accounts created just now. First fetch all the ids.

Execute the command sfdx force:data:bulk:delete –help to know the arguments required to run this command. The Required files are a csv file contains all the ids and the Object of Interest.

Execute the command : sfdx force:data:bulk:delete -s Account -f data/Account_delete.csv

We can check the same from Bulk data load section.

You can alternatively can query the Account Object/ check in the list view section to confirm the same.

• Execute the command to create Contact: sfdx force:data:record:create -s Contact -v “LastName=Acme”
• Execute the command to update Contact: sfdx force:data:record:update  -s Contact -i 0030K00002IDJOW -v “LastName=Acme Update”
• Execute the command to view Contact: sfdx force:data:record:get -s Contact -i 0030K00002IDJOW
• Execute the command to delete Contact: sfdx force:data:record:delete -s Contact -i 0030K00002IDJOW

Note: 0030K00002IDJOW  is the contact id created during the first step. I have pasted the output of all the commands below.

Please be noted that these are very basic operations that you can perform on the force:data:record. To check the full capabilities please check the command by appending with –help.

sfdx force:data:soql:query –help , You can see query is the required parameter.

Run this command to know the Count of Ids in Contact

sfdx force:data:soql:query -q “SELECT Count(Id) FROM Contact”

force:data:tree

Execute the command: sfdx force:data:tree:export -q “SELECT Id, Name FROM Contact” -d exportdata

It will generate the Contact.json file in exportdata folder.

 

There is so much you can do with the tree commands, where you can plan the data loads in the sequence using plan file. But for now we settle with these simple commands and use cases. We will see the complete understanding of tree commands in another blog post.

I hope you enjoyed reading this blog post. Feel free post your questions/suggestions.