How Do I Get the API Name of a Custom Salesforce Sync Object

[kshoemake]

Hello,

I'm syncing an object over from salesforce (AccountContactRelation) into Marketo. I was able to get the object to sync from the contact record and the records seem to have flowed through. 

I was reading that the smart list options were limited for custom objects in the sense that you cannot pull a smart list on it itself, you can only add the 'Has Custom Object' filter and add constraints, which is fine. We can make do with that for segmentation. 

However, my understanding from How to Obtain Marketo Custom Object Data is that I can use the marketo API to pull this information. 

I'm using a call like 

{{base_url}}/rest/v1/customobjects/AccountContactRelationships.json?filterType=ContactId&filterValues=003Rj000005Dsz2IAC&fields=Id,ContactId,AccountId

to attempt tot retrieve the information, but it's returning an error that AccountContactRelationships cannot be found. Normally this means I have the wrong API name. I've tried a few different iterations, but cannot find the actual API name. 

So that leads me to two questions:
1. Are Custom Salesforce Objects Synced considered custom objects?
2. If so, how do I get its API name?

[SanfordWhiteman · Accepted solution]

You can’t access SFDC Custom Objects via the Marketo API. Only Marketo Custom Objects.

[kshoemake]

Thanks. I was suspicious of that but couldn't confirm it in the documentation. 

Do you know why the row count between salesforce & marketo would be different? How would you troubleshoot that in Marketo? 

[SanfordWhiteman]

Start by getting an extract from SFDC of all the people with at least one CO record. Compare that to the Marketo people with at least one SFDC CO, and hopefully you'll see low-hanging fruit of people who should have a CO but don't. Then see what those people have in common in SFDC: permissions, record type, etc.

There are also situations where more Marketo rows exist than SFDC due to ill-timed deletions. Nothing you can do about those unless you unsync and start over.

[kshoemake]

So that's where it gets weird. The CO page reports these numbers: 301,007 for salesforce and 301,298 for marketo. 

This is for the Account Contact Relation table in salesforce, so by enabling it, all contacts in salesforce automatically gain 1 record for the relation. I expect that records that exist in marketo would not gain an ACR record. In salesforce, if I pull a count of all account contact relations where our sync filter allows the record to be synced to Marketo, this number is 243,903. If I include all records, this number is 301,296, which is close enough to be considered a match for what the CO page reports (what's odd is this matches the marketo rows and not the salesforce rows). 

When the sync for this object as a custom sync object in marketo was enabled, I would have expected there to roughly about the same number of leads in marketo (258,304). We have 301,263 contacts in salesforce with 243,878 enabled for sync). The difference between the two just means we have records that were disabled and haven't been purged. 

So what I'm seeing then, is even though we have a sync filter - the sync filter is pulling in all records from salesforce regardless if its parent lead exists in marketo. 

I'll see if support can add another filter there - otherwise I'm going to have to push our ops team to use salesforce sharing to limit records going to marketo instead of using a traditional marketo sync filter. 

[SanfordWhiteman]

That isn’t so surprising. See also https://nation.marketo.com/t5/product-blogs/sfdc-campaign-members-can-still-sync-to-marketo-even-if-...

[kshoemake]

 I remember at a previous org we had configure sharing rules on a variety of objects. I believe that was before marketo had the option of a custom sync filter, so I wasn't sure how well that worked with one. Seems like it's about the same, but I'm going to bet that support cannot filter on the related objects.