Visual Studio SOQL Builder is a VS code extension from Salesforce which we can use to create and run SOQL inside VS code. Using Visual Studio SOQL Builder we can see actual results without doing any guesswork. And we can do export records in JSON or CSV format. So if we need to take data backup or data migration we can easily do that using this new extensions.
So today we will check how we can install this and use it.
1. Install the SOQL extension
Firstly go to Extensions (ctrl +shift + x) and Search for SOQL. Install the extension and it will take few minutes. After that restart the VS code so it can take effect.
2. Now create SOQL file
Firstly we need to make sure that our Project is authorize and default org is setup. We will get a sample file in
<project-folder>/scripts/soql directory. However we can create and store file in any directory.
We can also create a new file with .soql extension. Now right click on soql file and select Open With… In next screen select the SOQL builder and it will open the file.
3. Test your Query and Export Data
Finally we have completed all the prerequisite steps with the Visual Studio SOQL Builder and we can make our own query and quickly preview the result. As this is still in beta so this has some limitations which you can quickly check here.
But we can still make some simple queries and export their results. So we don’t need to open workbench or developer console or any other third party tool.
Check how you can use Bulk API in Apex with Flow to quickly import bulk data here.
Did you like this post or wants to add anything, let me know in comments. Happy Programming 🙂