How to group using Bubble Data API

These are the fields in Student Table:

First Name
Last Name
Class
Address

I want to make a query using Bubble Data API. I want to see the list of students whose first name is same as other student(s) and total number of students with a specific first name.

If there are 3 students with first name “Sam” and 2 with first name “Ana”, how would I query that result using bubble Data API ?

I’d prefer to use the Workflow API for this. Pass the name to it, and the actions in the backend workflow can return the list/count of students with the same name as the one provided to it in the parameter.

1 Like