Skip to main content
December 31, 2014
Question

importToList Leads not updating

  • December 31, 2014
  • 5 replies
  • 1266 views
I am using importToList to import a list of leads from a csv file. The process is successful and any new leads are added to the list. However, new information on existing leads is not updated. I have selected UPSERTLEADS as my importListMode.

Is there another way to get the leads to update?

Thanks,
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

5 replies

Josh_Hill13
Level 10
December 31, 2014
Are the fields blocked that you were trying to update? It might be that command uses the new leads only. Check developer.marketo.com.
December 31, 2014
Thanks for the reply. Those are good suggestions but I don't think they are the my current issue.

I checked the blocked field status on the fields I'm uploading yesterday. According to the field manager there are no sources that updated are being blocked from.

The UPSERTLEADS is the importListMode to pass when updating existing leads and adding new leads in one list. The LISTONLY mode only adds new leads. This is probably the most confusing point because the example code uses UPSERTLEADS mode and seems to work fine when changing data to update a lead.

Do you have any other suggestions? I appreciate the help.

 
December 31, 2014
I tried running getImportToListStatus and saw that the rows in my test file were failing import which would explain why the changes to data were not reflected in the list. I sent test strings through (bi-passing the csv reader) which imported successfully. I deleted the test strings and ran the program again. This time the rows from the csv reader were imported successfully. I made no other changes to my main class than removing the test rows.

Is there way to return more detail in the output from getImportToListStatus on failed rows?

Thanks,
January 2, 2015
@Dean, have you tried the Get Import Failure File API?

http://developers.marketo.com/documentation/rest/get-import-failure-file/
January 2, 2015
I have not. According to the documentation that returns the failure file of an Import Lead call. Will that also return a failure file for the importToList call?

Thanks,