Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,297,389
Community Members
 
Community Events
165
Community Groups

CSV Import of Request Types

When running a CSV import for Service Projects, it’s not possible to import the request type field with its current names, like “Get IT Help“ or “Onboard new employees“.

It’s necessary to use the request type keys, and to get that information, the users need to reach out to Atlassian Support. But there’s a way to retrieve this information using an API endpoint.

Instructions

  1. Pick one ticket on your cloud site from the Issue Type that contains the Request Type you need to run the import
    image.png

  2. Export this ticket to XML (“…“ > Export XML) to get its ID
    image.png

    image.png

  3. Now that you have the ID, access the following endpoint on your web browser (change the {your-instance} and {ticket-ID}):
    https://{your-instance}.atlassian.net/rest/servicedesk/1/servicedesk/request/{ticket-ID}/request-types

  4. And you’ll see a page like below, related to the Request type “Investigate a problem“ and also all other Request Types related to the ticket’s Issue Type:
    image.png
  5. The information on the key field can also have a different format, like on the image below, and you can use it the same way:
    image.png
    For these cases, you need to check the relevant Request Type basing on the field “name“.
  6. And the information you need is: portalKey and key. The format needed for the CSV import is:
    portalkey/key => tf/investigateproblem
                              => bug/f8f3cdb9-8e4d-479c-941b-6976ac7d6da9

  7. And you need to use this value on the request type field when running the CSV import. Remember to also map the Issue Type field to have a correct import
    image.png

1 comment

Hi,

I am trying to run CSV import to create issues for "Jira Service Management - Cloud". I was able to get the Request Type Keys per the instructions above. However, when mapping fields in the CSV import wizard, there is no "Request Type" field to map to.  When I use JQL, Request Type shows up as a custom field but it does not show up in the list of custom or Jira fields to map to.

Like Adam Kassoff likes this

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

98 views 0 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you