Context: I'm trying to find a way to easily present email/phone info for a customer based on their email as it populates in the reporter field (reporter.emailAddress).
Current state:
- What I'm doing is creating "Contact" objects in Insight, then a "Contact" Insight Object field that filters those objects. These objects contain customer email and phone numbers.
- With automation, I have it set so that editing the reporter field triggers an "Edit Issue" action with the IQL query being "Email = {{issue.reporter.emailAddress}}". This successfully allows me to populate the contact object automatically.
Problem: When I move to a contact that doesn't have an object created in Insight, the automation fails.
What I attempted to do was set an If Block IQL condition that had the same "Email = {{issue.reporter.emailAddress}}" query. The thought was that if the query found any matching object, it would be TRUE and move the automation forward to the Edit Issue action listed above, while FALSE would pass to an Edit Issue action with a blank query.
The results of this are that everything processes as FALSE, regardless of whether it has an existing object or not, so clearly I'm incorrect about how that IQL conditional works.
After a couple of hours of playing around and searching the KB, I'm stuck. Looking for some suggestions if anyone has any. Thanks in advance!
