JSON URL for Object Property

Description

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:

https://jira.gw.montereycoe.org/rest/api/2/search?jql=project=hssni+and+issuetype=story+and+cf[11501]=%22Alisal%20Elementary%22

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[11501], 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?

Thanks

Environment

Confluence server 5.10.3

Assignee

Sunita Patro (Bob Swift Atlassian Apps)

Reporter

Dave Paulson

Labels

None

Support Entitlement

None

Components

Affects versions

Priority

Major
Configure