Apex Code Development You need to sign in to do that
Don't have an account?
Philip Zimmerman SOQL on External Object With Set<Id> in WHERE clause - URL too long
I am running a simple soql query to gather a list of external objects are that related to a set of ids of internal records.
SELECT ExternalId, Type__c, Location__c, Payer__c, PayerDescription__c, DateofService__c, PostedDate__c, Amount__c, EncounterID_SDB__c FROM Transaction_External__x WHERE EncounterID_SDB__c in: esdbids
This query generates an insanely long GET request URL to our external system. The Request is 9,000 characters when esdbids contains 248 ids. I dont want to open up our maxquerylength that much. Has anyone found a way around this issue in the past?
SELECT ExternalId, Type__c, Location__c, Payer__c, PayerDescription__c, DateofService__c, PostedDate__c, Amount__c, EncounterID_SDB__c FROM Transaction_External__x WHERE EncounterID_SDB__c in: esdbids
This query generates an insanely long GET request URL to our external system. The Request is 9,000 characters when esdbids contains 248 ids. I dont want to open up our maxquerylength that much. Has anyone found a way around this issue in the past?
You can always chunk it to 15 records at a time and do your processing.