Get list of all projects, project name and category name

Chamdarig Dall

Hi Team, 

how to get list of all projects, project name and project category name in Jira Data Center

or at least omit pagination on All project types - All categories page

Kawan Diogo_ykfovu

Hi @Chamdarig Dall 

 

In tests, the category shows in the endpoint:  /api/2/project

 

You can use an test script in postman to retrieve all information in a table, the output looks like this:

 

Here the test script below:

const template = `
<style type="text/css">
    .tftable {font-size:14px;color:#333333;width:100%;border-width: 1px;border-color: #87ceeb;border-collapse: collapse;}
    .tftable th {font-size:18px;background-color:#87ceeb;border-width: 1px;padding: 8px;border-style: solid;border-color: #87ceeb;text-align:left;}
    .tftable tr {background-color:#ffffff;}
    .tftable td {font-size:14px;border-width: 1px;padding: 8px;border-style: solid;border-color: #87ceeb;}
    .tftable tr:hover {background-color:#e0ffff;}
</style>
<table class="tftable">
  <thead>
    <tr>
      <th>Project ID</th>
      <th>Project Name</th>
      <th>Project Category</th>
      <th>Project Type</th>
    </tr>
  </thead>

  <tbody>
    {{#each table}}
    <tr>
      <td>{{this.id}}</td>
      <td>{{this.name}}</td>
      <td>{{this.category}}</td>
      <td>{{this.type}}</td>
    </tr>
    {{/each}}
  </tbody>
</table>
`;
const body = pm.response.json(); // Jira API response
if (!Array.isArray(body)) {
    console.error("Unexpected response format. Expected an array.");
    pm.visualizer.set(`<h3 style="color:red;">Error: Unexpected response format</h3>`);
} else {
    const table = body.map(project => ({
        id: project.id,
        name: project.name,
        category: project.projectCategory ? project.projectCategory.name : "No Category",
        type: project.projectTypeKey || "Unknown"
    }));
    // Set the visualizer with formatted data
    pm.visualizer.set(template, { table });

}