Petar Savov Posted June 19, 2019 Share Posted June 19, 2019 Hello, all of our integration maps are failing where we upsert in Salesforce child records matching the parent record by using external id on the parent record. The relationship in Salesforce of the two custom objects is Master-Detail. Objects: Master__c, with external text unique id fieldMaster_No__c. Detail__c, with the lookup field Master__c (Master-Detail to Master__c) Test records: Existing Master__c record in SalesforcewithMaster_No__c = TESTID We are using the virtual fieldMaster__c_Master__r_Master_No__c which is available in the Salesforce Target Connectionwhen inserting Detail__c records to match the external id Master_No__c: UPSERT Detail__c record, Master__c_Master__r_Master_No__c = TESTID and Master__c = null. Upserting was working before, but now we get this error:Operation failed. Label: Upsert Detail__c, Error: Required fields are missing: [Master__c] Is something changed in the way we should upsert records in Salesforce The error message means that the id of the Master object is required now, although we use the virtual field to match the master record by using the external id. Link to comment Share on other sites More sharing options...
Albert Baiungo Jr. Posted June 19, 2019 Share Posted June 19, 2019 HI Petar, This is Albert with the Scribe Support team. This issue could be related to a newly updated Salesforce to version Summer 19. If you have not already please open a support case regarding this issue so that the support team can look into this further. Thanks, Albert Link to comment Share on other sites More sharing options...
Petar Savov Posted June 21, 2019 Author Share Posted June 21, 2019 Hi Albert, I was not able to open a support case yet. I was wondering if the Scribe Support team was able to reproduce the issue or to find a solution The Scribe maps that use upsert operation matching the parent record by external id stopped working on 06/16/2019. Thanks, Petar Link to comment Share on other sites More sharing options...
Petar Savov Posted June 21, 2019 Author Share Posted June 21, 2019 This is stil not working and as a workaround I created new maps using csv lookup files, but this solution is not ideal. Link to comment Share on other sites More sharing options...
Petar Savov Posted June 26, 2019 Author Share Posted June 26, 2019 Hi Albert, I ran a small test Scribe solution for this issue that was failing before and it completed successfully today. I seems that the issue is resolved, so I will test reverting the solutions to the maps where match by parent external id is used. Thank you, Petar Link to comment Share on other sites More sharing options...
Recommended Posts