GroupBy APIs [May 13]

Discord-Discussions
1

:raising_hand_man: farhanNoco asked

Hello, in the 0.90 API I see that the /tableName/groupby/:columnName endpoint was removed. I depend on it currently so wanted to ask if it is coming back? I do not see it mentioned in the list of breaking changes. Thanks.

2

:person_tipping_hand: o1lab replied

hey, yes, it will be coming back… sorry it got missed out… cool that you were using it - we had not advertise it that much… what was your usecase for groupby apis… we’d initially written it for group by view

3

:raising_hand_man: farhanNoco replied

We use the Noco API from our backend to serve a couple of frontend applications

4

:person_tipping_hand: o1lab replied

okok

5

:person_tipping_hand: o1lab replied

we will bring it in next to next release

6

:raising_hand_man: farhanNoco replied

I also depend on the query parameters such as bt, bfields, hm, hfields which seems to be missing

7

:person_tipping_hand: o1lab replied

please refer to apis.nocodb.com

8

:person_tipping_hand: o1lab replied

these have changed

9

:raising_hand_man: farhanNoco replied

Sorry to bother you again but I do not see a way. There are only fields, where and sort parameters for Table row list endpoint. Should I pass bt, hm, bfields, hfields inside these somehow?

10

:person_tipping_hand: o1lab replied

my bad - easier to check swagger generated (right top menu)

11

:person_tipping_hand: o1lab replied

semantics for bt, hm has changed

12

:raising_hand_man: farhanNoco replied

Thanks! I tried to filter nested columns like this: http://localhost:8081/api/v1/db/data/noco/TEST/subscriptions?fields=cars&nested[cars][fields]=ConfigId

But I still get all columns for cars instead of only ConfigId. Any idea why that could be?

13

:man_technologist: pranavxc replied

<@973475031101349918> May I know which version of Nocodb are you using ?

14

:raising_hand_man: farhanNoco replied

0.90.10

15

:person_tipping_hand: o1lab replied

relation is subscriptions has many cars ?

16

:raising_hand_man: farhanNoco replied

no one car

17

:person_tipping_hand: o1lab replied

ya makes sense… read it wrongly

18

:man_technologist: pranavxc replied

Everything looks good… can you try with encoded URL

http://localhost:8081/api/v1/db/data/noco/TEST/subscriptions?fields=cars&nested%5Bcars%5D%5Bfields%5D=ConfigId

19

:raising_hand_man: farhanNoco replied

Thanks trying it now. Related question, is it expected that in 0.9.11 the query parameters are in PascalCase instead of snake_case? I see that the fields returned in JSON response are also in PascalCase in 0.9.11 (used to be snake_case in 0.9.10)

20

:man_technologist: pranavxc replied

returned object keys will be column alias