Skip to main content
hardik_mota
Helper ⭐️
September 24, 2021

Support Max, Min, Count functions in API query

Hi Team,

One of my customer was looking to get support of Support Max, Min, Count functions in API query using Gainsight API’s.

Best,

Hardik

3 replies

Contributor ⭐️⭐️⭐️⭐️⭐️
September 24, 2021

Our use case:

Obtain the number of records and maximum values of a timestamp field from a Gainsight object through READ API.

The SQL equivalent of our requirement is as follows:-

 

select count(*) from CustomGainsightObject where Runid = ‘any specific value for Runid’

select max(CustomDateField) from CustomGainsightObject

Translate
Cornelia
Contributor ⭐️⭐️⭐️⭐️⭐️
September 27, 2021

Hello @hardik_mota and @vmoore thank you for your posts. Looping in our Product Manager to look into this and get back to you. 

Translate
skalle
Gainsight Employee ⭐️
Gainsight Employee ⭐️
September 28, 2021

@vmoore  Thanks for the post, we will look at the request and add it to our roadmap plans for prioritization.

Translate