Match users in CSV import to user type attribute of Assets objects

Summary

Learn how to import users as attribute values in Assets Cloud using Atlassian Account IDs.

Solution

Find the Atlassian Account ID for users

To obtain the Atlassian Account IDs in your site, you can export all users into a CSV file. To do so, navigate to yoursitename.atlassian.com/admin/users > Export users. Once you have the account IDs, update the objects with the corresponding Jira users in your file.

Use automation to update the user attribute based on email addresses

Let's say you have an object type called "Person" that has the attributes:

• "Jira User" of type "User" - this attribute needs to be updated with the corresponding Jira user for that object.

• "Manager" of type "Object" - this attribute is self-referenced and stores the manager object of the user.

• "Jira Manager" of type "User" - this attribute needs to be updated with the corresponding Jira user of the manager for that object.

• "mail" of type Text - stores the email address of the user.

These steps will help you update the "Jira User" attribute with the corresponding user by fetching the user details using the email address stored in the "mail" attribute:

1. Create a global automation rule that triggers when an object is created. (You can also use the scheduled trigger followed by a Branch on AQL).

2. Create a Branch on AQL. Choose the desired schema and specify the AQL:

3. Add two Create variable actions and create these variables:

   1. Variable 1:

      1. name: EMAIL

      2. Smart value: {{object.email}}

   2. Variable 2:

      1. Name: emailManager

      2. Smart value: {{object.Manager.mail}}

4. Add a Send web request action to get the User account ID using the search user API:

   1. Web request URL: https://<Cloud site URL>/rest/api/3/user/search?query={{EMAIL.urlEncode}}

   2. Configure three Headers:

      1. Content-Type: application/json

      2. Accept: application/json

      3. Authorization: In the Authorization header make sure that you add the keyword Basic followed by the base64 of your emailaddress:APItoken. So if the base64 of the emailaddress:APItoken is AB12XY45 then to the Authorization header add the value Basic AB12XY45.

   3. HTTP method: GET

   4. Web request body: Empty

   5. Check the option "Delay execution of subsequent rule actions until we've received a response for this web request", as the response contains the user's Atlassian account ID.

      

5. Create variable in the rule to store the account ID of the user:

   1. Variable name: AAIDUser

   2. Smart value: {{webResponse.body.accountID}}

6. Next, send a web request using Send web request action again. Use the same content from step 4 except for the Web request URL field which should be:

   https://<Cloud site URL>/rest/api/3/user/search?query={{emailManager.urlEncode}}

   ⚠️ Make sure you check the option "Delay execution of subsequent rule actions until we've received a response for this web request"

7. Add another Create variable to store account id of the manager:

   1. Variable name: AAIDManager

   2. Smart value: {{webResponse.body.accountID}}

8. Add an action to Edit object and set the attributes using the variables you just created:

   1. Jira Manager: {{AAIDManager}}

   2. Jira user: {{AAIDUser}}

9. Publish the rule.

You can edit the rule according to your requirements, for example, by removing those actions in case you do not have the manager attribute.

Update more than 50 objects

Automation has a limit where it can only update 50 objects at once. So, depending on the number of users you would like to update, it can happen that no new objects are picked by the branch as the "Jira user" remains empty for these objects.

In that case, you can add an attribute in the "Person" object type, say "Last Sync date" of type date, and use this to go through the objects that have not been synced since the last update. This value will help us iterate over all the objects using an automation rule, and the update will be performed only on those objects that have not been updated on that day.

After you have added the above attribute, you need to make changes to the above rule as below:

1. Update the AQL in branch as:

   objecttype = "Person" and mail is not empty and "Jira User" is empty AND ("Last Sync date" < startOfDay() OR "Last Sync date" IS EMPTY)

   This will only check those objects which have not been picked up by the automation rule on the same day.

2. In the Edit object action, add attribute "Last Sync date" and provide the value:

   {{now.format("dd/MMM/yy")}}

   This will update the attribute to store the date when the automation rule picked this object to check for the corresponding Jira user.

Another option is to make use of Dynamic Looping.

We have a feature request to expand the number of objects that can be updated per rule: JSDCLOUD-10643 - Ability to update more than 50 objects in a single Assets automation run.

For more examples refer to the article Update Asset object attribute values using automation