I'm trying to use the JSON table macro to extract issues from JIRA using a JQL query. The query needs to be able to search based on a custom field object, and I can't seem to find the right syntax. The field structure of one desired record is as follows:
"customfield_11501":"self":"https://jira.gw.montereycoe.org/rest/api/2/customFieldOption/11947","value":"Monterey County Office of Education","id":"11947","child":"self":"https://jira.gw.montereycoe.org/rest/api/2/customFieldOption/15700","value":"Alisal Elementary","id":"15700"}}
Both inside JIRA search and from my browser, I can can query for the child property using the parent field ID. The follwing works in my browser:
I cannot, however, find any syntax that works inside the JSON macro. I've tried every variant I can think of, using customfield_11501, cf, dot notation . . . nothing works. I consistently get the "Error rendering macro 'json-table' : URL is invalid or not allowed" error.
How can I make this work?
Confluence server 5.10.3