cancel
Showing results for 
Search instead for 
Did you mean: 

How to use distinct function or group columns in C4C ODATA?

shenu
Participant
0 Kudos
478

Hi SAP experts,

I am trying to group a column in the C4C ODATA by using $apply=Group by ((Column name)). However, I am getting an error that says "'$apply' is not a valid system query option" Any suggestions on how I can group by column?

Thank you

Accepted Solutions (1)

Accepted Solutions (1)

former_member226
Employee
Employee
0 Kudos

Hi,

To my knowledge, $apply donot work with C4C Odata(s). Supported OData parameters/functions are listed in the KBA, an unfortunately, $apply is not there.

I am not sure what the business use case is, but did you try utilizing data source(or report) which are exposed by OData and there you can try to aggregate the desired column...But it will not be a straight forward way to work with

shenu
Participant
0 Kudos

Thanks, Saurabh, I will try to look into the report exposed by ODATA

Answers (0)