Is it possible to use Smart Values in Confluence Cloud to retrieve user entity properties?

Question

In Jira it is possible to store properties for users following this endpoint, which then it is possible as well to retrieve using Automation Rules with smart values with the syntax {{user.properties.propertyname}} as shared here.

I was able to use an external tool to store a user property in Confluence, using this endpoint, but it seems it is not possible to retrieve user entity properties using Smart Values, even though trying with the same syntax.

Would anyone be able to confirm or deny this?

Thanks a lot in advance.

Alfonso Leiva · Answer

I tried that before, and got that error, which is odd, since this is calling Confluence from Confluence Automation rules.

Anyhow, adding the Authorization header with the Basic email:token encoded on base64 worked.

Alfonso Leiva · Answer

Hi Bill!

I tried to do that, but I got the weird error Current user not permitted to use Confluence. statusCode four hundred o three

Would you happen to know why?

Bill Sheboy · Answer

Hi @Alfonso Leiva

I just replicated your result: user entity properties cannot be returned for a user in a Confluence automation rule.

The user properties are not listed in the documentation as available: https://support.atlassian.com/cloud-automation/docs/smart-values-in-confluence-automation/#User-properties

A workaround is calling the REST API endpoint to get the property using the Send Web Request action with the user's accountId:

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-user-properties/#api-rest-api-3-user-properties-propertykey-get

Kind regards,
Bill