I am using an external service (Forms on Fire) to pull a list of Boards with their Groups into a table. I can pull a list of Boards and a separate list of Groups, but I need to have a field or column that links each board to its groups. Using GraphQL to query, then JSON path selector and response mapping to push the data into a table.

The JSON response (when using the API playground or PostMan, etc.) returns each Board, with the groups and their properties underneath each board. However, once I parse this out into tables, I cannot access the Board Id in the Groups table.

Has anyone tried something like this before?

Thanks.

JSON row Path Selector

data.boards[].groups[]

Query Below

{

“query”:“query {boards(limit:100) {

name

state

id

permissions

groups {

id

title

position

color

}

}}”

}