How to display Epoch time as a human-readable date using the JSON table macro in the Advanced Tables for Confluence app
When you are using the JSON Table macro in the Data Center version of the Advanced Tables for Confluence app, the standard macro formatting like MX~DD.MM.YYYY works for 10-digit (seconds) values.
Sample JSON data:
{
"data": [
{
"id": 1,
"name": "Item A",
"timestamp": 1678886400
},
{
"id": 2,
"name": "Item B",
"timestamp": 1679059200
},
{
"id": 3,
"name": "Item C",
"timestamp": 1750140000
}
]
}Follow these steps to display the Epoch time in a human-readable date format:
Create a new Confluence page
Insert the JSON Table macro into the page.
Within the macro editor, configure the following settings:
Go to Column settings and add these settings: MX~DD.MM.YYYY
Click Publish.
