Query API call problem
I try to use a query API call that looks as follows:
select Id from Account where InstitutionType__c = <value>
The problem (Malformed query error) occurs when value = Doctor's Office because it contains a single quote.
InstitutionType__c is a custom field that we added to Account entity.
How can I fix this query?
Optimal data size for batch operations
What is the recommended batch size for insert / update operations in order to avoid EXCEEDED_RATE_LIMIT error?
What is the the maximum batch size for such operations?
I am interested in inserting/updating accounts, contacts, and opportunities.
FieldsToNull Array and specified custom fields
When I use fieldsToNull array to update custom fields (for Account, Contact, or Opportunity entities) using sforce API 6.0, what should I set <field>Specified boolean fields to (true or false)?