I have connected to a public dataset using Socrata. As this dataset is very large, I would like to use a where statement in the .get statement to filter out certain records.
I only want to import records for which I have matching records in my SQL database. I have created a Python list of these Id's.
I would like to run something like below, but this syntax is invalid.
result = client.get(socrata_dataset_id , where ='id in id_list') Is it possible to use a python list to as a filter in the client.get statement or is there a better way to do this?
Please, don't post about your other queries here.