Mule Salesforce connector Create Juntion Object using External IDs

Question

I have the following Objects and fields.

Object A: External Id (a_ext_id) and other fields Object B: Extrernal Id (b_ext_id) and other fields Custom Junction Object C: External id (c_ext_id) and fields a__c (lookup(a)), b__c (Master-Detail(b)) and Status__c

I would like to upsert records into Junction Object C without having to know the Salesforce Ids of Object A and Object B.

I just got it working with Partner WSDL.

Is there anyway to upsert in Mule without writing Java code?

Answer 1

This can be accomplished using external IDs. I would recommend using dataweave before connecting to Salesforce and submitting the parent objects' external ids as seen below: (assuming the external ID values are present in the payload).

{ c_ext_id: payload.cExt, // Value: C's external ID from payload a__r: { a_ext_id: payload.aExt // value: A's External ID from payload }, b__r:{ b_ext_id: payload.bExt // value: B's External ID from payload }, status__c: payload.status }

Hope this helps!

Check out the Salesforce admin training to learn more about it.