Issues with using Insight Objects in Automation

Question

I was hoping someone could help as I have had zero luck with support.

I have an object in Insight on JSM Premiere called "Client Programs" with an attribute I need to return called "ProgramName"

I am trying to return the value of ProgramName and add it in a comment when the ticket is opened and I have had zero luck so far.

I am adding the Lookup Objects action and adding in key: key = {{ issue.field.customfield_12345 }} (Which is what support told me to do) but that fails unfortunately.

Are there IQL queries you can use for built-in Insight similar to the Insight App that will work?

For my "Add Comment to Issue" I tried this for a test and it doesn't work for obvious reason:

Test: {{lookupObjects}}

Alex van Vucht (GLiNTECH) · Answer

My approach to troubleshooting these is to:

* Do a "Log Action" action just before the LookupObjects action and see if the IQL query got the smartvalue correctly.
* Run that Lookup Objects IQL query in Insight and make sure the IQL query gives the result I expect
* Do a "Log Action" to record the results of the Lookup Objects action.

The issue you're experiencing should emerge after doing the above. If you still can't work it out, let us know which of the above gives an unexpected result.

Also make sure you aren't trying to do any functions on the ProgramName, like {{lookupObject.ProgramName.capitalize()}} as they won't work.