Hi @jalusu,

Welcome to the community!

Just as a head’s up - I am moving your post from the feature requests to the questions category so it gets to the right queue.

What subelements are you trying to query?

Best,

Rachel

Hey @rachelatmonday,

thanks! 🙂

I would like to query all columns of a subitem.

Thanks for your help!

Best

Jann

Hello there @jalusu,

Regarding the GraphQL query generally speaking, can use something like this:

{

  items(ids: SUBITEMIDHERE) {

    name

    id

    column_values {

      text

      value

      column {

        id

        title

      }

    }

  }

}

Take into account that specific column types might require specific syntax’s. You can check them out here 😀

You can also get it all together from the main item like this:

{

  items(ids: MAINITEMIDHERE) {

    subitems {

      id

      name

      column_values {

        text

        value

        column {

          id

          title

        }

      }

    }

  }

}

I do not have experience with PowerBI particularly but this is how the query can look like GraphQL-wise.

I hope that helps!

Cheers,

Matias