要約

Currently, we can get the Custom fields and the corresponding field ID using the Get Fields API. This article talks about fetching the Custom field ID in Excel using the JSON output from the above API results via POSTMAN.

It is worth noting that this API returns system and custom issue fields according to the following rules:

• Fields that cannot be added to the issue navigator are always returned.
• Fields that cannot be placed on an issue screen are always returned.
• Fields that depend on global Jira settings are only returned if the setting is enabled. That is, timetracking fields, subtasks, votes, and watches.
• For all other fields, this operation only returns the fields that the user has permission to view (that is, the field is used in at least one project that the user has Browse Projects project permission for.)

環境

• Jira Cloud

ソリューション

You get the Custom fields and the corresponding field ID using the Get Fields API, run this query in Postman and save the output in JSON format by clicking on "Save Response to file" as shown in below screenshot.

Once you have the JSON file ready to use, you can follow the steps mentioned in the below article which talks about converting a JSON file to Excel.

• How to Convert a JSON File to Microsoft Excel

After converting the JSON file to Excel, select the column named as ID and perform below steps while the column is selected.

• Click on "Data" >> Click on Text to Columns
• Select Delimited and click on Next.
• Under Delimiters Check the Box "Other" and enter "_" as a separator, then click on Next and Finish
• Now you will have all the Custom field names and their corresponding IDs in separate columns.