Zapier error failed to create a lead in Pipedrive provided dataset is not valid

jhollender

Hi, I am trying to set up a Zapier connection from Facebook Lead forms to Pipedrive, and I am running into an error when trying to map custom fields. These are just single dropdown options that exist in the Facebook lead form and also in Pipedrive. The error is:

Failed to create a lead in Pipedrive

provided dataset is not valid Custom field validation failed. Error: Expected 'number' as value of singleOption field. ApiKey: 3b871eba3523fd9f75eb8bfc50b5ba2abbf40c15

For example, one field is:
Do they have land?
The options are Yes, No, Looking. Those exist in Pipedrive as well.

Facebook is sending the text value of the selection, but it seems like Pipedrive is looking for a matching number ID. But, I don't see how to change the ID on either platform so that they would match up. Any ideas?

Any help you could provide would be much appreciated!

—

EDIT:

Zapier support was kind enough to help. We had to create a lookup table action and convert the Facebook selection value to the ID that Pipedrive was looking for. Seems like an oversight on Pipedrive’s API to not do text matching for these integrations.

andres

You are probably not setting up a field correctly.

Happy to help you on a Zoom call. Book a time with me here https://connex.digital/book/andres

jhollender

Zapier support was kind enough to help. We had to create a lookup table action and convert the Facebook selection value to the ID that Pipedrive was looking for. Seems like an oversight on Pipedrive’s API to not do text matching for these integrations.