Here i am selecting top 500 rows from the list using below rest api method, I want to select only distinct values for (ESI_ProjectSeqNoLookupId ) column .Please explain in below code where to insert distinct keyword or someother way to select column in ESI_ProjectSeqNoLookupId.
query.RestQuery = "getbytitle('RFA')/Items?$select=ID,ESI_AFENo,ESI_ProjectSeqNoLookupId&$top=500";