Convert user identifiers to account IDs in JQL queries

Converts one or more JQL queries with user identifiers (username or user key) to equivalent JQL queries with account IDs.

You may wish to use this operation if your system stores JQL queries and you want to make them GDPR-compliant. For more information about GDPR-related changes, see the migration guide.

Permissions required: Permission to access Jira.

curl --location --request POST 'http://jira.local:8080/jira/rest//rest/api/3/jql/pdcleaner' \ --header 'Content-Type: application/json' \ --data-raw '{ "queryStrings": [ "assignee = mia", "issuetype = Bug AND assignee in (mia) AND reporter in (alana) order by lastViewed DESC" ] }'

{"queryStrings":["issuetype = Bug AND assignee in (abcde-12345) AND reporter in (abc551-c4e99) order by lastViewed DESC"],"queriesWithUnknownUsers":[{"originalQuery":"assignee = mia","convertedQuery":"assignee = unknown"}]}

Responses

🟢200Returned if the request is successful. Note that the JQL queries are returned in the same order that they were passed.

application/json

Body

The converted JQL queries.

queriesWithUnknownUsers

array[object (JQLQueryWithUnknownUsers) {2}]

optional

List of queries containing user information that could not be mapped to an existing user

convertedQuery

string

optional

The converted query, with accountIDs instead of user identifiers, or 'unknown' for users that could not be found

originalQuery

string

optional

The original query, for reference

queryStrings

array[string]

optional

The list of converted query strings with account IDs in place of user identifiers.

🟠400Returned if at least one of the queries cannot be converted. For example, the JQL has invalid operators or invalid keywords, or the users in the query cannot be found.

🟠401Returned if the authentication credentials are incorrect or missing.

Convert user identifiers to account IDs in JQL queries

Request

Responses