Issue when using Lead API for syncLeadRequest | Community
Skip to main content
K
kiruthika_s
New Participant
January 31, 2024
Solved

Issue when using Lead API for syncLeadRequest

  • January 31, 2024
  • 1 reply
  • 2295 views

Hi,

 

I am trying to POST using Lead API syncLeadRequest (/rest/v1/leads.json). The record I am sending is only in the Global partition. When I send the below payload, I am expecting it to NOT get updated and get error as Lead not found( since I have mentioned the partitionName in which to look for based on the lookupfield). But the data is getting updated in the Global partition record. Why is that ? 

{

    "action": "updateOnly",
    "partitionName": "02. Partition B",
    "lookupField": "email",
    "input": [
        {
            "email": "testemail@gmail.com",
            "Col A": "Value A",
            "Col B": "Value B",
        }
    ]
}
 
Appreciate your help!
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Darshil_Shah1

@kiruthika_s, the partitionName field isn't considered a co-lookup key in the POST request with the Email Address field. AFAICT, the Marketo REST API sees the entire lead database as one unit while making updates, not the virtual partitions created by creating the person partitions via Marketo > Admin. Also, with the default settings, duplicates aren't allowed in the person partitions. However, if you have intentional duplicates with partitions and workspaces, it is required to have the secondary dedupe field as leadPartitionID. Once you have that setup, you can use the leadPartitionID as the lookupField similar to email and Person ID (see the JSON payload below).

 

{ "action": "updateOnly", "lookupField": "leadPartitionID", "input": [ { "email": "a@example.com", "leadPartitionID": "1", "firstName": "Luke" } ] }

 

Check out this article on Marketing Nation: https://nation.marketo.com/t5/employee-blogs/duplicates-with-partitions-and-workspaces-via-rest-api/ba-p/325790

1 reply

Darshil_Shah1
Darshil_Shah1Accepted solution
Community Manager
February 1, 2024

@kiruthika_s, the partitionName field isn't considered a co-lookup key in the POST request with the Email Address field. AFAICT, the Marketo REST API sees the entire lead database as one unit while making updates, not the virtual partitions created by creating the person partitions via Marketo > Admin. Also, with the default settings, duplicates aren't allowed in the person partitions. However, if you have intentional duplicates with partitions and workspaces, it is required to have the secondary dedupe field as leadPartitionID. Once you have that setup, you can use the leadPartitionID as the lookupField similar to email and Person ID (see the JSON payload below).

 

{ "action": "updateOnly", "lookupField": "leadPartitionID", "input": [ { "email": "a@example.com", "leadPartitionID": "1", "firstName": "Luke" } ] }

 

Check out this article on Marketing Nation: https://nation.marketo.com/t5/employee-blogs/duplicates-with-partitions-and-workspaces-via-rest-api/ba-p/325790

K
kiruthika_sAuthor
New Participant
February 1, 2024

Thanks for the clarification @darshil_shah1 . 

We are building a pipeline to bring in data for custom fields. There might be duplicate records within the partitions in Marketo and same email in different partitions. We also do not have a unique Id other than the email in the source data. But we do have a BU id which corresponds to the person partition in our Marketo instances.

So came up with a solution, to match the record to the correct partition based on the BU id and then look up based on email id.

 

As per your input, would setting up leadPartitionID as secondary Dedupe field and using it as lookupField without mentioning email as lookup will work for our usecase ?

Setting up as below, would not lookup for all records in that partition Id and give "Multiple lead match lookup criteria" ?

"lookupField": "leadPartitionID",

I am just learning on how this Dedupe field works 🙂 

Darshil_Shah1
Darshil_Shah1
Community Manager
February 1, 2024

@kiruthika_s, Yes, you'd first need to request the Marketo support team to add a secondary dedupe key (BU ID or partition ID), and using the resultant composite key (which would be a unique key), you can update the exact person record you want to update amongst the duplicate (people with the same email address) records in your database.

Terms & ConditionsAccessibility statement

Loading footer...