Hi community,
We're building an automated report generator that creates Confluence pages via the REST API using ADF (Atlassian Document Format). One section of the page embeds a Jira filter as a table of issues ("INICIATIVAS"), and we're trying to control which columns appear — but nothing we've tried respects our configuration.
Our goal: embed a Jira filter as a table showing only these columns, in this order: Type · Key · Summary · Status · Due Date · Updated · Parent
What we've tried:
Attempt 1 — embedCard
Result: renders correctly as a table, but uses the Jira filter's own saved columns. No way to override via ADF.
Attempt 2 — Confluence Jira macro with columns param
Result: columns parameter is completely ignored — Confluence renders with its own default columns regardless.
Attempt 3 — blockCard with datasource
Result: "We ran into an issue trying to fetch results" — the datasource fails to load entirely.
Questions:
datasource approach require the Jira filter to have specific sharing settings (e.g., shared with "Any logged-in Atlassian user")? Could that be causing the fetch error in Attempt 3?Any help appreciated. We're on Confluence Cloud, using the v2 REST API.
Community moderators have prevented the ability to post new answers.
Hi @Rodrigo Xavier ,
Interesting initiative. 👀
Regarding Jira work items, I did manage to dig out this:
To control which columns appear and their specific order, you must use the
extensiontype with thecolumnsparameter. The values must be comma-separated internal field IDs (e.g.,issuetype,key,summary).Ensure the following:
Parameter Name: Use
columnswithin themacroParamsobjectField Keys: Use the exact internal keys. For your request, the string should be:
issuetype,key,summary,status,duedate,updated,parentServer ID: A valid
serverIdis mandatory for the macro to render correctly. You can find this by manually creating a page with a Jira macro and inspecting the storage format viaGET /wiki/api/v2/pages/{id}?body-format=storage.
Now, note that this is what I managed to find, but I haven't tested this myself (at least not in a while). I could try playing around with Postman to see if I can send those requests and if that call will actually end up with the desired outcome 🤔
As for the blockCard - I did see this question in the Dev community (see here) but I'm not sure if they resolved it or not.
Generally speaking, Developer Community could be a good place to also ask this, as folks there are working more with APIs and these, let's say, custom things. 👈
If I do find time next week, I could play around with it more to see how you could actually build this.
Cheers,
Tobi
Hi @Tomislav Tobijas ,
Hope you're well!
Thank you so much for taking the time to reply — your tip about inspecting the page via GET /wiki/api/v2/pages/{id}?body-format=atlas_doc_format was exactly what we needed.
It worked! The problem was the id field inside the datasource object. We were using the string "datasource-jira-issues" as a placeholder, but Atlassian requires the actual UUID of the Jira Issues Datasource provider.
The fix:
// ❌ Wrong
"datasource": { "id": "datasource-jira-issues", ... }
// ✅ Correct
"datasource": {
"id": "d8b75300-...",
"parameters": {
"jql": "filter=12345",
"cloudId": "your-cloud-id"
},
"views": [{
"type": "table",
"properties": {
"columns": [
{"key": "issuetype"}, {"key": "key"}, {"key": "summary"},
{"key": "status"}, {"key": "duedate"}, {"key": "updated"}, {"key": "parent"}
]
}
}]
}We discovered the correct UUID by fetching the ADF of a manually-configured page — d8b75300-... is the fixed provider identifier for the Jira Issues Datasource in Atlassian Cloud.
(Attaching a diagram of how our AI agent generates Confluence pages — in case it helps for context.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Awesome explanation and reply @Rodrigo Xavier ! Thanks for this 🙌 (glad you got it resolved as well :) )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.