Is it possible to export the Organizations as CSV

We have option to " Import from a CSV " in Organisations under JSM project but is there any way to export these details as well.

2 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

3 votes

Answer accepted

Hi @Ruchi ,

As far as I know the only option is using rest api and it returns JSON not CSV.

https://developer.atlassian.com/cloud/jira/service-desk/rest/api-group-organization/#api-rest-servicedeskapi-organization-get

The rest api has pagination, it takes 50 organization on each page. You need to modify the start parameter if you have more than 50 organizations.

/rest/servicedeskapi/organization?start=1

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thank you @Mehmet A _Bloompeak_ I tried the above suggestion but why is it giving random organisations , I was expecting to see the 1st 50 organisations.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I guess it returns the organizations ordered by their ids. The ids are generated by the organization creation date. It is not possible to get organizations ordered by name. You need to get all the organization page by page and then combine them into a single json array. Then you can sort it using javascript coding.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thank you:)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hi @Ruchi , Welcome to the community! There is no option available from UI to export the organization member in csv in JSM. Here is the link to the rest api for extracting the same data to csv using th erest api.

Hope this will be helpful to your query, in case of any query let me know. Thanks

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Shib @shib saha Thank you:)

Could you please share the link , I dont see this in your answer.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Apology i forgot the share the link: https://developer.atlassian.com/cloud/customer-service-management/rest/v1/api-group-organization/#api-api-v1-organization-organizationid-get

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Ruchi likes this

Was this helpful?

Thanks!

Jira Service Management

DEPLOYMENT TYPE

CLOUD

PRODUCT PLAN

STANDARD

PERMISSIONS LEVEL

Product Admin

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Is it possible to export the Organizations as CSV

2 answers

1 accepted

Comments for this post are closed

Was this helpful?

Thanks!

DEPLOYMENT TYPE

PRODUCT PLAN

PERMISSIONS LEVEL

TAGS

Atlassian Community Events