Extract all custom field with associated issue screen

[joanna_natial]

Hello Admin,

Currently using Jira Cloud Product, I want to extract all custom fields with associated screen issue so I can evaluate all customs fields that are frequently use in our project.

Seems like Jira Cloud has no settings for this, could help me if there is any other way how to extract those custom fields.

[Prachi Bolar]

Hello,

Welcome to the community :) 

Please find details below

To get information about a custom field and the screens it is associated with in Jira, you can use the following Jira REST API endpoint:

1. First, you may want to list all custom fields to find the field ID:

GET /rest/api/3/field More details here : https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-fields/

2. Get the screens associated with the custom field 

GET /rest/api/3/field/customfield_10000/screens

The custom field is id 10000 is from the first step

More details here : https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-screens/#api-rest-api-3-field-fieldid-screens-get

GET https://your-domain.atlassian.net/rest/api/3/field/customfield_10000/screens

In case you want to Export all custom field with it's ID for Jira please check this article : 

https://support.atlassian.com/jira/kb/how-to-export-all-custom-field-with-its-id-for-jira/

Thank You,

Prachi

[David Nickell]

good morning.  @Prachi Bolar  -- I see you are listed as being on the Atlassian Team.  Did you even try my spreadsheet?  (I am just curious).  Your answer is correct (ish) but how many steps would an admin have to take?  (A rhetorical question). 

My spreadsheet executes the ATLASSIAN REST CALLS using MICROSOFT POWER QUERY code. Sure, I add a little logic here or there.  But is essentially me making use of same parts of your product you discuss. 

My solution is very reusable and this process is repeatable for all of the ATLASSIAN GET Apis.  My way is basically a simplification of yours.

Final point... here is my way executed against 3 sites I have access to Including jira.atlassian.com.   It took me less than 5 minutes and all I had to do is change URLS

[David Nickell]

@joanna_natial   Good evening.  I have a utility that helps.   This Excel Spreadsheet pulls back all your custom fields. 

1. It is Free
2. There is no VBA code; Just Power Query
3. There is nothing to "Plugin".   Simply replace my Email, URL, and API Token with your own.

• Follow this link to my Extract Page in my website:  SplitDimeData Excel Extracts 
• The first version returns the list of fields.  It can be executed by any user
• The second version with Screens requires Admin Permissions to run

Anyone interested may download and use either extract.

FYI:  many parts of the Altassian configuration (like screens) are tied to Projects using SCHEMES.   So its not quite as simple sometimes as saying "this screen has this field".  I will explain more later.  In the diagram below you can see that projects have Issue Type Screen Schemes.  (the square box - IT represents an Issue Type key)

[David Nickell]

Note -- anyone who reads my response is welcome to go to my website and download the Utilities.  They are free this week;   Next week I'll have multiple utilities zipped and sold as an "Admin utilities" Bundle.  Pricing to be determined.  But since it is NOT a plugin, there will be no "Per User" license costs.

https://splitdimedata.com/extracts

[Trudy Claspill]

Hello @joanna_natial 

Welcome to the Atlassian community.

You might find this discussion useful.

https://community.developer.atlassian.com/t/how-using-an-api-can-i-get-the-list-of-screens-associated-to-a-custom-field/61809/5

Are you open to considering a third party app? If so you might find this one helpful.

https://marketplace.atlassian.com/apps/1217194/optimizer-for-jira?hosting=cloud&tab=overview

[David Nickell]

@Trudy Claspill  good evening ... I glanced at your plugin (the marketplace detail) and I like the range of features.  Pricing also seems very reasonable.  

If I get a chance I will try to get a copy to do some testing later today.