Updating Marketo Static Leads via API Header field not found

[Ben_SYD]

Hello There, 

I'm currently undertaking some automation for our Marketing Team. I'm looking to automate the upload of leads from our CRM to a static leads list within Marketo. 

I have a CSV with some dummy data I'm trying to upload to a static list.  However, I'm getting a 1006 response saying the fields don't exist. 

However, I can see the fields do exist within the static list.  I can manually update the static list via the GUI without issues. 

Any help would be appreciated, as I'm banging my head against the wall this point. 

[SanfordWhiteman]

Please attach a CSV reproducing this behavior in this thread (as an attachment, not inline). It’s not possible to troubleshoot without that.

By the way, since you won’t be using Postman to send the data in reality, using its shortcut to attach the file (as opposed to building the raw MIME payload in Postman) isn’t a great test. You still need to be able to duplicate the right payload in your app.

[Ben_SYD]

Hi Sandord, 

Thanks for the reply. However, I'm unable to find the ability to upload attachments? Would you be able to advise. 

Noted for Postman. Ta. 

[SanfordWhiteman]

Do you not have the Attach Files option at the bottom of the reply pane?

[Ben_SYD]

It seems I don't have that functionality? 

[SanfordWhiteman]

Hmm, guess you don’t. Perks of being the Community Moderator!

I’ll send you my email via PM and then you can email it to me.

[SanfordWhiteman]

For anyone lurking, the problem was that @Ben_SYD was using the UI names of fields like First and Last, which are allowed when you do the mapping in the UI.

An API import expects API names like FirstName and LastName.