How to append in automation an array of values into multiple user field

Diogo Rodrigues

Hello,

 

I've approvers field that I want to populate with data from multiple attributes in the linked asset.

I'm able to get the array from one attribute and set it into approvers.

However when I want to append another array I fail to succeed.

 

I'm able to append a single user using the update option using this documentation example:

 

{ "update":

{

"customfield_12345": [{

"add": { "value": "{{issue.customfield_12224}}" }

}]

}

}

 

However using the array it returns success but not appending values:

{ "update" :

{ "customfield_12345" : [ {

"add" : {{MyAssetField.AssetAtribute.flatten.asJsonObjectArray("id")}}

} ]

}

}

Bill Sheboy

Hi @Diogo Rodrigues 

For a question like this, context is important for the community to help.  Please post the following:

• an image of your complete automation rule in a single image for continuity
• images of any relevant actions / conditions / branches
• an image of the audit log details showing the rule execution

Until we see those...

 

In the examples you show, you appear to be adding two completely different values to customfield_12345: a single field value and an asset attribute.

First, have you tested the contents of your asset attribute contain what you expect?

Next, you are attempting to use the function asJsonObjectArray() incorrectly in two ways: with the wrong attribute of "id" versus "value", and trying to add an array within an array.

Finally, if your source information is indeed from an asset value, those are looked up just-in-time, and so there could be timing problems when the value is not provided fast enough to be used in the dynamic JSON expression.

 

Let's assume your asset data {{MyAssetField.AssetAttribute.flatten}} produces a comma-separated values list.  To solve the timing problem, that could be stored with Create Variable.  That variable could then be split() into a list, and iterated to create the dynamic JSON expression in the Edit Issue action (recently renamed to Edit Work Item action).

• action: create variable
  • name: varAssetData
  • smart value: {{MyAssetField.AssetAttribute.flatten.join(",")}}
• action: Edit Issue, with advanced edit and a JSON expression

{
  "update": {
    "customfield_12345": [
      {{#varAssetData.split(",")}}
        { "add": { "value": "{{.}}" } }  {{^last}},{{/}}
      {{/}}
    ]
  }
}

 

Kind regards,
Bill