Hi - I’d like to Update an Entity in Affinity after creating a new opportunity but getting an issue with the ID to feed from Step 2 to Step 3
The zap goes as follows:
Any help would be greatly appreciated :)
+6Hey
What exact issue are you getting? Can you post the screenshots of Data in and Data out as well as any errors?
+14Hi
For us to have more info, post screenshots showing:
Thank you for your replies
+14
Help links for understanding expected values in dropdown lists: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps
TIP: Click field labels ( i ) to see tooltips with more info that may provide guidance.
The error appears to be related to the mapped variable value for the List Entry field.
Post screenshots showing the DATA OUT from Zap Step 2 related to the different IDs returned.
The step is Update an Entity (Affinity) and it’s asking for a List Entry (the row in a specific Affinity List).
In your mapping you’ve put “2. List Entries – Entity Id: 99566176.” That is the Entity ID (person/org/opportunity record), not the List Entry ID for the row in Deal Pipeline.
Because the action can’t resolve a valid list_entry for the selected list, Affinity throws the generic error:
“Failed to create a person or organization field value… Please select a valid list entry.”
Pass the List Entry Id for the record in the Deal Pipeline list.
If you don’t have it yet, add a search step like “Find List Entry in a List” (or “Find/Create List Entry”), then map List Entry Id from that step into List Entry here.
Also make sure the found list entry actually belongs to Deal Pipeline (IDs are list-scoped).
This is what we’re seeing:
It doesn't seem to be finding the list entry ID:
In Step #2 - I create the opportunity. You can see that the entity exists in the Deal Pipeline and it shows the List Entry ID
In Step #3 - I search for the list entry ID and it doesn't find it
Of the possible List Entry IDs, I'm assuming it should be the List Entries ID? 217677408
The List Entries Entity ID is the ID for the organization
The List Entries List ID is the Deaflow Pipeline list ID
Creator ID - I'm assuming is me
+14
Give this a try for dropdown fields where you are trying to map a dynamic variable.
Switch to Static mode and try to locate the desired option from the dropdown list.
There you will be able to see the underlying option ID to help you make sense of which variable you should map when configuring as Custom mode.
Help links for understanding expected values in dropdown lists: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps
+6Hey
I see how it can get a bit complex with so many IDs floating around.
But coming to the Update an Entity action in Zapier, it can either update the global or list fields of a person, organization, or opportunity.
I was looking into affinity API to understand the Zapier integration a bit better. You can see here- https://api-docs.affinity.co/#get-a-specific-list-entry
I also saw more about organization id from the API which is the List Entries ID in your case- https://api-docs.affinity.co/#update-an-organization
Can you skip the Find the List Entry action for now and just put List Entries ID in Update an Entity action as I didn’t see in the screenshots if you have already tried it? Hope it helps!
PS: If you need more active assistance, I’m happy to connect through my Zapier Solution Partner page if you’d like to reach out here- https://zapier.com/partnerdirectory/automation-jinn
Thank you
When I go to the static option to see what type of ID they're looking for, it looks like they're looking for the composite ID:
When I choose a specific entity from the list or when I choose the choose the Composite entity ID from the step above, I get the following error message:
I also tried to use the List Entry ID from the search step above and when I use that ID (or any of the other available IDs), I get this error message:
Here's the overview of the different IDs that are available when I search for a list entry
Thank you!!
+6Hey
Couldn’t see the screenshots with the error message. Can you post them again?
In static option, you can also just type the id for now to test it. See more about it here- https://help.zapier.com/hc/en-us/articles/31709122224653-Enter-data-in-Zap-fields
When I go to the static option to see what type of ID they're looking for, it looks like they're looking for the composite ID:
When I choose a specific entity from the list or when I choose the choose the Composite entity ID from the step above, I get the following error message:
I also tried to use the List Entry ID from the search step above and when I use that ID (or any of the other available IDs), I get this error message:
Here's the overview of the different IDs that are available when I search for a list entry
+6Hey
Thanks for the quick reply. I am talking about these particular screenshots. Somehow they are not visible-
When I choose a specific entity from the list or when I choose the choose the Composite entity ID from the step above, I get the following error message:
I also tried to use the List Entry ID from the search step above and when I use that ID (or any of the other available IDs), I get this error message:
+6Hey
Can you see the dropdown of the List Entry in configure and select a field there?
Did you also click on retest step as I think it’s still taking the previous value?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
