Using API to get Board and Group data combined

monday Apps & Developers
, , ,
1

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
}
}}”
}

3

Thanks, I moved it over.

4

Hello there @msrMiler,

In this case I believe you will need to use a query like this one:

{
  boards(limit: 10) {
    id
    name
    state
    permissions
    groups {
      id
      title
      position
      color
    }
  }
}

And then on your end get boards.id and pair it with the boards.groups.id in it and save it so you can check that link afterwards.

Hope that helps!

Cheers,
Matias