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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.