---
title: "Building a Simple Table from Rest API Data"
canonical: "https://support.appfire.com/space/TBL/74814217/Building%20a%20Simple%20Table%20from%20Rest%20API%20Data"
format: markdown
---
> Macro (div)
> 
> ### On this page
> 
> > Macro (toc)

# Overview

This page shows how you bring Rest API data from a JIRA query directly into a Confluence table using the [JSON Table macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74815257), which is part of the [Advanced Tables for Confluence](https://appfire.atlassian.net/wiki/spaces/TBL/overview) add-on.

# Macro Browser Input

### Select this Macro

|  |  |
| --- | --- |
| *Macro Name* | JSON Table |
| *Macro Syntax* | {json-table} |

### Define these Parameters/Values

|  |  |
| --- | --- |
| *Paths to fields* | issues |
| *Paths to fields to be included* | key,fields.summary,fields.issuetype.name,fields.issuetype.id,fields.fixVersions[*].name |
| *URL to JSON data* | [https://bobswift.atlassian.net/rest/api/latest/search?jql=key%20in%20(TBL-174%2C%20TBL-300)%20order%20by%20key](https://bobswift.atlassian.net/rest/api/latest/search?jql=key%20in%20(TBL-174%2C%20TBL-300)%20order%20by%20key) |
| *Auto number on each row* | selected |

> ✅ **JSON data**
> ✅ 
> ✅ Click on the URL link above to view the live JSON data.

### Screenshot

![image](media://73fe852d-21b4-4132-b219-65bd54765ec9)

# Wiki Markup Input

```plaintext
{json-table:
paths=issues|
fieldPaths=key,fields.summary,fields.issuetype.name,fields.issuetype.id,fields.fixVersions[*].name|
url=https://bobswift.atlassian.net/rest/api/latest/search?jql=key%20in%20(TBL-174%2C%20TBL-300)%20order%20by%20key|
autoNumber=true}
{json-table}
```

# Example Result

![image](media://e40869ee-cd64-4c6b-a949-e05ccfcd136c)

# Other Examples

Visit our [full list of product examples](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74815984) for additional inspiration!