SOLVED

INVALID_FIELD_FOR_INSERT_UPDATE: cannot specify Id in an insert call

Go to solution
Amith_Nayanar
Level 1

INVALID_FIELD_FOR_INSERT_UPDATE: cannot specify Id in an insert call

Hi fellow marketers,

Iam facing this issue and unable to sync a particular lead from Marketo to SFDC. Have you guys faced this issue before? Any idea why this is happening?

Thanks

Amith

1 ACCEPTED SOLUTION

Accepted Solutions
Grégoire_Miche2
Level 10

Re: INVALID_FIELD_FOR_INSERT_UPDATE: cannot specify Id in an insert call

It seems to me that Marketo is not aware of the fact that the lead was converted and did not automatically resync with the contact instead. This might be because the sync broke just before the conversion or because Marketo cannot access the contact that should be replacing the lead. Can be linked to specific sharing rules set in SFDC for the Marketo user or because of a sync filter that is deactivated for this record.

-Greg

View solution in original post

3 REPLIES 3
SanfordWhiteman
Level 10 - Community Moderator

Re: INVALID_FIELD_FOR_INSERT_UPDATE: cannot specify Id in an insert call

Have you read the notes at SFDC Read Only Fields Deep Dive ?

Amith_Nayanar
Level 1

Re: INVALID_FIELD_FOR_INSERT_UPDATE: cannot specify Id in an insert call

Hi Sanford,

Thanks for sharing this. But this is what i found out.

The lead is existing in Marketo since 2014, it had synced to SFDC earlier. I verified the synch which happened in 2014 and found the SFDC ID to which the lead had synched. When i try to search the lead in SFDC, based on that ID, i get the message, saying that the lead was converted. When i open the converted contact, the email ID and name is totally different. Any idea, why this happened?

I suspect the email ID/name was changed in SFDC, but it didnt reflect in Marketo. Right now, Marketo is trying to sync the lead to SFDC, but since the email ID, is different, it is trying to create a new recoprd in SFDC. But the SFDC ID already exists in SFDC. So, the error is coming up.

Did i confuse you?

Grégoire_Miche2
Level 10

Re: INVALID_FIELD_FOR_INSERT_UPDATE: cannot specify Id in an insert call

It seems to me that Marketo is not aware of the fact that the lead was converted and did not automatically resync with the contact instead. This might be because the sync broke just before the conversion or because Marketo cannot access the contact that should be replacing the lead. Can be linked to specific sharing rules set in SFDC for the Marketo user or because of a sync filter that is deactivated for this record.

-Greg