Can I upsert the AccountContactRelation object?

Of course. You can upsert the AccountContactRelation object.

Folowing the example of the minimal configuration to transfer all Accounts and Contacts along with their relations. You need to provide three objects:

{
 "objects": [
 {
      "query": "SELECT Id, Name FROM Contact",
      "operation": "Upsert",
      "externalId": "Name",
      "master": false
 },
 {
      "query": "SELECT id, Name FROM Account",
      "operation": "Upsert",
      "externalId": "Name"
 },
 {
      "query": "SELECT Id, AccountId, ContactId FROM AccountContactRelation",
      "operation": "Upsert",
      "externalId": "AccountId;ContactId",
      "master": false
 }
 ]
}
Last updated on Sa Oct 2022