+ Start a Discussion
CRMfusion - GWCRMfusion - GW 

SOQL size for BULK API

With version 28 of the API the length of SOQL queries was raised from 10,000 characters to 20,000 characters.  Was the limit on SOQL in Bulk API queries also raised?

 

We seem to have failures when the SOQL is above 10,000 characters

Ashish_SFDCAshish_SFDC
Hi,


According to this page at the bottom, it throws an error. Being that is an API, it's up to them.

http://www.salesforce.com/us/developer/docs/soql_sosl/Content/sforce_api_calls_soql_select.htm

SOQL statements can't exceed 10,000 characters. For SOQL statements that exceed this maximum length, the API returns a MALFORMED_QUERY exception code ; no result rows are returned.

http://www.salesforce.com/us/developer/docs/dbcom_apex/Content/apex_gov_limits.htm


Regards,
Ashish