Zapier error creating a lead - provided dataset is not valid

API
, , ,
1

I am trying to set up a Zapier connection from Facebook Lead forms to a Pipedrive lead, 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 a text value of the selection, but it seems like Pipedrive is looking for a number ID. But, I don’t see how to change the ID on either platform so that they would match up. Is there a way to see which IDs Pipedrive is looking for in those custom fields?

Any help you could provide would be much appreciated!

2

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.