nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to programmatically add several customers with assigned email and password

Amedeo Farello

Hello, I need to migrate hundreds of customers from another help desk system. I would prefer to avoid telling them to re-register on the new Jira Service Desk portal.

I have learned that I can create a new customer without sending the invitation mail and then set his password, but I'm dealing with hundreds of them, is there a way to do this by using a CSV file?

Accepted answers

All comments

Tom Lister_fo1j4e

Hi @Amedeo Farello

My approach is to use the rest api for this

https://docs.atlassian.com/software/jira/docs/api/REST/7.6.1/#api/2/user-createUser

I use excel to load the csv. Then I use formulas i.e. concatenate to stitch together data and fixed snippets into a ‘curl’ command to call the REST API for each row of data.

the results are just pasted into a command window.

Amedeo Farello

Thank you @Tom Lister,

I am totally new to REST and curl. Should this be the shape of the resulting command?

curl --request POST \
  --url 'https://my-domain.atlassian.net/rest/api/2/user' \
  --header 'Accept: application/json' \
  --header 'Content-Type: application/json' \
  --data '"{\"name\":\"Fred\",\"email\":\"fred@example.com\",\"displayName\":\"Fred F. User\",\"password\":\"1234\"}"'

But then, how could I create multiple customers at once?

Tom Lister_fo1j4e

Hi @Amedeo Farello

what format do you have your user data in?

i’ve used SQL in some cases e.g. for adding a user to a group

SELECT *,
concat(
'curl -insecure -u admin:password -X POST --data "{\\"name\\": \\”',newval,'\\"}" -H "Content-Type: application/json" https://localhost:8080/rest/api/2/group/user?groupname=', parent_name
) as curl
FROM jiradb.groupmap
where user_name != newval

I’ve used excel by putting the fixed parts of the curl statement in static cells and creating a formula to turn each line of a sheet into a runnable command. Do you need more detail on that?

Amedeo Farello

It would be nice, thank you!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-desk

jira-service-desk-cloud