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
have questionshave questions 

Error: query is either selecting too many fields or ...

Hi, I tried to do a data query on my customs object which has more than 160 fields can an error occured as follows:
 
---------------------------
Microsoft Excel
---------------------------
Error Generated by request::Query is either selecting too may fields or the filter conditions are too complicated.
ExceptionCode : 1
 
Could not establish connection to API service

---------------------------
OK  
---------------------------
 
Is there a restriction by the connector on how many fields you can query?
Ron HessRon Hess
This message is coming from the API, not the connector itself, i've not seen this message before.  Can you try with a much smaller set of columns ( just clear some out ), and see if you can get a subset of the fields to come back?

this may identify if it is the number cols or the query itself that is the issue.  
have questionshave questions
Hi, thanks for the reply. I tried to delete some columns and after that, I can get the data from salesforce. So I think it is the # of columns issue?