How to update Insight custom fields based on the value change for a Insight custom field?

Question

Hello,

We need to read/ update the Insight custom fields (like name) based on the selection of unique identifier, namely id field. All these fields are attributes of the Insight object.

While creating automation in JSM cloud, the "Edit Issue" action throws the below error.

An error occurred while requesting remote information

Bad Request

No fields or field values to edit for issues (could be due to some field values not existing in a given project):

Any suggestion on how this can be achieved?

Thanks

Gaurav

Semih Tolga Yazici_f29rg0 · Answer

Hi Razvan,

Your solution completely works. I just understand how to avoid Bad request error and want to add a few things in your solution.

If an object is already specified in a customfield, and it is wanted to add attributes of it in other customfields. We don't need to use lookupObjects for that case which will work but take more resource cost.

It works to only use the smartvalue below while editing asset object in Automation.
Name = "{{issue.fields.customfield_xxxx.Attribute Name.Name}}"

For an information: It is an object that's why unfortunately only providing the smart value below not working and causes Bad request error.

Chad Jackson · Answer

@Gaurav Gupta  wondering if you were able to get this working. I am running into the same issue trying to use automation to populate a custom field with

an attribute value based on the selection in another field similar to what you have described.

Thank you, Chad

Razvan Nechifor · Answer

You can try to use Lookup object action and after that Edit issue action and use smart values to populate the Insight custom field.

e.g.

User selects in customfield_xxxxx the value for Employee Id.

Automation configuration:

* Trigger: Issue created or Field value changed (Employee Id) - the 2nd option will cover all possible events and can help you test the automation
* Action Lookup objects:* select Schema in which the Employee Id and Name are stored.
* use the syntax: Key = {{customfield_xxxxx}}

* Optional Action: Log action* Employee Name = "{{lookupObjects.Employee.Name}}"

this action can help you identify the values that will be placed in the Insight customfield and troubleshoot erros (in case the values are not the ones you are expecting).

* Action Edit issue fields:* choose Employee name custom field.
* operation Set query: syntax: Name = "{{lookupObjects.Employee.Name}}" (Employee is name is of the object where all attributes described above are stored, Name = attribute of the Employee).

I hope this will help you.