About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

WooCommerce -> Pardot giving a "Failed to Create Prospect" error

sean-the-patrick

Hello! Hoping I can find a resolution. Zapier support couldn’t offer any help.

I’m trying to sync orders from WooCommerce to Pardot. 

My credentials for Pardot are good:

 

 

And I’m only attempting to populate email, first name, and last name:
 

 

But it fails -- I get this error:

 

Failed to create a prospect in Pardot
Pardot ran into an error; Your account is unable to use version 4 of the API.. Error code: 89
 

 

OK, fine. So I tried adding a Pardot account using V5 of the API. And got this error:

Failed to create a prospect in Pardot
Pardot ran into an error: The requested record was not found.. Error code: 109

 

Any insight from other Zapier and Pardot users? I had the same problem when trying to sync LinkedIn leads to Pardot last month, and I’m not sure if it’s an issue with my Pardot account OR a Zapier issue.

Thanks!!

 

11 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @sean-the-patrick 

Good question.

Wondering if this is related.

 

Error: This API user lacks sufficient permissions for the requested operation

Pardot requires that you are an admin to perform certain actions. You can see permissions for your users here: https://pi.pardot.com/user

You’ll need to upgrade your user’s role to Admin, then reconnect the account to Zapier and try again.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
sean-the-patrick

Hey @Troy Tessalone, thanks for weighing in!

I’m already an Administrator. :/

Troy Tessalone
Userlevel 7
Badge +14

@sean-the-patrick 

Are these the only fields you are trying to set?

If there are other fields mapped/configured, then show a screenshot of those.

Also, check deduplication rules in Pardot/Salesforce.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
sean-the-patrick

@Troy Tessalone 

Thanks for the help, I’m trying this again today.

I’m trying to simplify this as much as possible, so I have Zapier checking Pardot to find if the email address that I’m sending exists as a current prospect (Find Prospect in Pardot). The only field required is the email address. And I know this is an email address that’s in Pardot already, so it should have no issue finding it.

Same issue, sadly -- error 109.

Any ideas? 
 

 

Troy Tessalone
Userlevel 7
Badge +14

@sean-the-patrick 

If you have a Zapier paid plan, you can open a ticket with Zapier Support: https://zapier.com/app/get-help

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Troy Tessalone
Userlevel 7
Badge +14

@sean-the-patrick 

A possible work around would be to try to use the Pardot API: https://developer.salesforce.com/docs/marketing/pardot/guide/version5overview.html

Zap action: Pardot - API Request

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
sean-the-patrick

Thanks @Troy Tessalone !

sean-the-patrick

Couldn’t get this to work, so am instead using a Pardot form handler, as per these instructions:

https://sfmc-curated.com/thespotforpardot.com/Watch-the-Data-Flow-into-Pardot-with-Zapier?id=4104

W

We just switched our account over to a team account and are running into this issue. Everything was working great until the switch. 

 

We are doing something different and looking up prospects before adding them to a list in the 4th step. We continue to get error code 109, Failed to find or create a prospect in Pardot. 

 

This is the same record I have used for testing for over a year now, and it is definitely in Pardot. 

 

Any thoughts or help would be greatly appreciated!

Troy Tessalone
Userlevel 7
Badge +14

@workinmamaxoxo 

Salesforce Error Codes: https://developer.salesforce.com/docs/marketing/pardot/guide/error-codes

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
I

@workinmamaxoxo I had a similar issue as well but I found a solution. You can try the same and see if it works.

Instead of trying to match using the email address on the “Add Prospect to List”, use the Prospect ID input from the Find/Create Prospect record step.

 

 

Reply


Terms & Conditions