May 9, 2016

How to Query External Object in Salesforce?

Sample Query:

SELECT Id, Name__c, AirDate__c FROM Advertisements__x WHERE Name__c LIKE '%Early%'

here Advertisements__x is an External object.

Check the below link for additional information

Note:
1. In SOQL queries of external objects, IN clauses with more than approximately 15 IDs return the error "This operation is too complicated for Secure Agent." The exact IN clause limit varies based on SharePoint ID length.

2. A subquery that involves external objects can fetch up to 1,000 rows of data.

2 comments:

  1. can we use in operator and are there any limitations on it

    ReplyDelete
    Replies
    1. In SOQLueries of external objects, IN clauses with more than approximately 15 IDs return the error “This operation is too complicated for Secure Agent.” The exact IN clause limit varies based on SharePoint ID length.

      Delete