Trouble putting together a SoQL query with Socrata

Question

I have this query that I put together in MySQL in my test db and am trying to figure out how to port it over to the SoQL SODA API. Pretty much just trying to get a list of the unique business and associated details.

SELECT DISTINCT
    (CAMIS), dba, boro, building, street
FROM
    nyc_stuff.restauraunt_inspections
WHERE
    BORO = 'BRONX';

This is the base url I'm using:

https://data.cityofnewyork.us/resource/xx67-kt59.json

I'm aware of how to use the clauses, but can't figure out how to add Distinct into the query.

I tired this:

https://data.cityofnewyork.us/resource/xx67-kt59.json?$select=DISTINCT%20(CAMIS)

But no luck...

score 5 · Accepted Answer · edited Jan 23 '18 at 23:45

5

You can accomplish this by using the $query parameter in SoQL. I would suggest:

https://data.cityofnewyork.us/resource/xx67-kt59.json?$query=SELECT%20distinct%20camis,%20dba,%20boro,%20building,%20street%20WHERE%20boro%20=%20%22BRONX%22

Thanks, Socrata Support

edited Jan 23 '18 at 23:45

chrismetcalf

1,556
1
8
7

answered Jan 23 '18 at 18:59

Data and Insights Support

66
2

Thanks! So this essentially allows you to pass in a regular query? looks like it worked! – Zeratas Jan 23 '18 at 20:25

Trouble putting together a SoQL query with Socrata

1 Answers1