I have requirement to read object ( ccrz__E_OrderItems__c ) which is having items ( ccrz__E_OrderItems__c ) and items contain another Object as ( ccrz__E_Product__c ) and I have to read also product details. When I am using wizard I am able to select fields at Ordrer item levels only. I do not see any option to read Product details but as per Sales Force team Order and Product are related and should be read as single SOQL query.
Any idea Why I am not able to see this relation ( Order -> Item -> Product ) ? Any limitation on Hierarchy of information accessible via SalesForce connector ? Any workaround ? I would like to avoid second look up.
Please let me know if more information required.