GraphQL, Aggregating data

[Adurm]

Hi, Wondering if there is any way to aggregate data using the GraphQL Api?

As an example, I would like to be able to retrieve the number of items contained within a boards group.

query { boards(ids: ####) { groups { item_count } } }

where item count would refer to a way to retrieve the number of items, or way to implement a graph ql function to count the number of items

[AlexSavchuk]

Hey @Adurm

First off, my warmest welcome to the community I’m glad you’re with us here and I hope you enjoy your stay.

To be transparent with you, this is not something that the API currently provides. I would suggest instead to query the group’s item IDs, and then to count the number of IDs returned - this would be your best bet in terms of getting the item count within a group.

What do you think? Would this be a plausible solution?

I’ve also moved the thread to the Feature Requests section, and hopefully this helps other users chime in with their feedback

-Alex

[Adurm]

Thanks for responding.

Yes what you have suggested is what ive already done but was hoping to further reduce the complexity of the query and reduce the number of nests within the response.

The above was a simple use case, but i was hoping, if ‘functions’ were allowed, that they could be used to simplify responses such as those contained within column_values - which result in alot of bloated data.

[AlexSavchuk]

@Adurm

Got it, I’m glad you were able to implement a working solution on your end already. I appreciate your feedback on this and I definitely see how it would help with using our GraphQL API - I’ve passed the request along to our product team, but I’m afraid I can’t promise an ETA on this just yet.

That said, I really appreciate you sticking with us and looking out for opportunities to improve monday.com That’s amazing!

-Alex