function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Mel LisauMel Lisau 

How can i incorporate the Salesforce SOQL Query builder in my Visual Studio project

I have a Salesforce project. I use SOAP API to login and that is successful. 
When our clients need to construct a query to a sObject they dont know all the field names, relationships etc . So they construct a very minimal query for lets say update / upsert .
What i am hoping to do is give them something like Query Builder Tool. 
So is there a way that I can add this to my Visual Studio project and display the UI to the user ?

Thanks
ShivankurShivankur (Salesforce Developers) 
Hi Mel,

You can refer to this Extension (https://marketplace.visualstudio.com/items?itemName=salesforce.salesforcedx-vscode-soql) in VS Code for building SOQL easily.

SOQL Builder is a VS Code extension that eliminates the guesswork when building SOQL queries. With SOQL Query Builder, anyone can visually build, run, and explore results from queries. Build queries using clicks in a visual editor, then save and extend the queries using a text editor. You can instantly view query results, and then save the results to a .csv or .json file.

Note: SOQL Builder is currently in beta.

Also, refer to below links to get more insight on how it can be used as well its features.

Helper Links:
https://developer.salesforce.com/blogs/2020/11/introducing-the-soql-query-builder-now-in-beta.html
https://developer.salesforce.com/tools/vscode/en/soql/soql-builder/

Hope above information helps, Please mark as Best Answer so that it can help others in the future.

Thanks.
Mel LisauMel Lisau
Thanks for the reply . Those links just obviously explain how to use the builder. So there is no real way to incorporate it into Visual Studio lets say as a where i can pass in the binding object to my org and the sobject and all required fields will be pulled down ?