Display table of issues of current authenticated users?

[Lisa Singh]

Hi All

I'm a bit new to APIs and JSON but okay with CQL/JQL.

I'm trying to create a Confluence page that shows a table of the current authenticated user's reported issues. My Jira and Confluence spaces are linked.

In JQL I can just user currentUser() - how can I do it in any of the Confluence macros that will pull JSON or use JQL?

Until recently I worked with Remedy/Helix and for a current user query from another application etc, you had to escape the $USER variable and BAM it ran the query as the current logged in user.

But I can't work out how to do that with any of the Confluence macros that pull Jira issues.

Thanks for any help.