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?
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.