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
Rathna DeshmukhRathna Deshmukh 

How to Query all the fields in Salesforce Object using Enterprise WSDL

Hi,

How to Query all the fields in your Salesforce Object using Enterprise WSDL?

I need to retrieve all fields in Account object using Query operation\method in enterprise wsdl.I tired the query "select * from Account",this query with "select *" is not working.it throws error Saying "malformed query and unexpected *" in query.

Please let me know what should be the query to seelct all fields from salesforce account object for enterprise wsdl.

also pl help me in understanding what is the difference between Query and QueryAll method in enterprise wsdl?

Thanks in Advance!!
Pramod_SFDCPramod_SFDC
Hi,

Please look into the below link, I hope it answers your query and also provide moreinformation.

>>https://developer.salesforce.com/page/Enterprise_Query_All

Regards
Pramod
Rathna DeshmukhRathna Deshmukh
Hi,

How to Query all the fields in your Salesforce Object using Enterprise WSDL?

I need to retrieve all fields in Account object using Query operation\method in enterprise wsdl.I tired the query "select * from Account",this query with "select *" is not working.it throws error Saying "malformed query and unexpected *" in query.

Please let me know what should be the query to seelct all fields from salesforce account object for enterprise wsdl.
Henry AkpalaHenry Akpala
You cannot use wildcards in salesforce querys.  You will need to extract the field names and generate a SOQL that includes all the fields.  Alternatively, you can use the developer console to generate the query and it will give you all the fields and use that.
Henry AkpalaHenry Akpala
Correction, I meant SOQL Explorer application not Developer Console.
sweetzsweetz
Hi,

QueryAll() - Retrieves data from specified objects, whether or not they have been deleted.
Query() - Executes a query against the specified object and returns data that matches the specified criteria

To retrieve all the fields for a particular object, you have to mention all the field names in the soql for that object. You can use workbench,cloudingo,force.com ide for that. It will easily fetch all the field names for you.
Workbench link: https://workbench.developerforce.com/login.php
Cloudingo Link : http://www.cloudingo.com/studio
Force.com IDE : https://developer.salesforce.com/page/Force.com_IDE_Installation