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.
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.