Data Table query to get distinct values

How to get DISTINCT values from a data table column using queries in the API call with data-tables/rows/query?

@Sreyams_Jain1,

Could you provide a link from the docs to the API you’re using?

POST https://api.losant.com/applications/ APPLICATION_ID /data-tables/ DATA_TABLE_ID /rows/query

After some discussion with the engineering team, DISTINCT isn’t currently an operation we support for Data Tables. What I can do is make a feature request for this, and let you know if it gets released!

Depending on your use case, you could access MYSQL ( or any other SQL ) DB in a workflow. It would give you the ability to have more query power but does require you to have/maintain an instance of a SQL database.

Thanks, that will be a good feature to have.
In the meantime, I will get all rows and loop through to get distinct values.