External Object that has indirect lookup field "Id__c will" return null value when queried
Last updated 2022-02-10 ·Reference W-3583549 ·Reported By 1 users
When an External Object has an indirect lookup field "Id__c", and you attempt to query that object by adding a field to a report, etc. an error will be returned:
error: Unsupported Operation
bad id null
1. Create an external object from SFDC connector. e.g., "ExternalAccount"
2. Create indirect lookup between local standard object "Account" and external object "ExternalAccount".
3. Create a report type with primary object "Account", "ExternalAccount" as a child object.
4. Run the report, add any field from "ExternalAccount" to the report.
Change the Field Name so that the API Name is not "Id__c"
Remove the indirect lookup
Reported By (1)
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.