Skip to main content

Support Max, Min, Count functions in API query

  • September 24, 2021
  • 3 replies
  • 50 views

hardik_mota
Forum|alt.badge.img+4

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

Forum|alt.badge.img
  • 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


Cornelia
Forum|alt.badge.img+1
  • 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. 


skalle
Forum|alt.badge.img+1
  • 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.