Hi @Jeff Thorns
I'm going to flag this post for the Zapier Community Team. They should have more insight on this and can escalate to the support team if needed.
Sit tight, and someone will contact you soon.
Hi @Jeff Thorns
I'm going to flag this post for the Zapier Community Team. They should have more insight on this and can escalate to the support team if needed.
Sit tight, and someone will contact you soon.
Hi I’m also in contact with support. But I expect that I have to make due with the current limitations. So i'm hoping someone has a better workaround then my hardcoded js lookup table, since it is a issue that others also have.
@Jeff Thorns, dealing with IDs is a pain but it’s real easy to find the values. Simply visit the Pipedrive API Reference page to find it.
Here are the steps:
- Enter your API token. You can find your API key in Pipedrive by Personal Preference
- Select from the list of Endpoints that you’re looking to locate the value or ID
- Find the Get all and then Click “Run endpoint” to find all the values and IDs.
I hope this helps!
@Nate
Yes, I'm aware of that but doing this for alot of values isn't as easy. I can get an array of all the values and all the numeric id’s for all the fieldsbbut because there are fields without options they are left as null and sadly zapier romves nulls in the incoming array, and no way to fix this without using a external method.
Leaving me with the options to
1 create a huge zap that does a api call for every field.
2 make a hard-coded lookup table.
Hey @Jeff Thorns!
Did you ever manage to find a solution to your issue? If so, we’d love to hear about how how you tackled it!
Hey @Jeff Thorns!
Did you ever manage to find a solution to your issue? If so, we’d love to hear about how how you tackled it!
Hi, i haven't found a dynamic solution for it yet sadly
my solution until then is a hardcoded js filter that loops through all the custom field id’s and spits out an hard coded value,
I'll probably gonna use a other tool like n8n to do the job since it doesnt touch raw data. until then I'll be waiting for a zapier solution….
Hey @Jeff Thorns!
Did you ever manage to find a solution to your issue? If so, we’d love to hear about how how you tackled it!
Hi, i haven't found a dynamic solution for it yet sadly
my solution until then is a hardcoded js filter that loops through all the custom field id’s and spits out an hard coded value,
I'll probably gonna use a other tool like n8n to do the job since it doesnt touch raw data. until then I'll be waiting for a zapier solution….
I might found something that maybe works, the new loop action has a option for trim whitespace, and it seems from my first test when i input the option id and option label with trim whitespace set to false it might work!