Mark Silverberg

@CoryMollet No problem. Probably worth checking it again, I added some more detail after @skram sent you the link

@chrismetcalf @skram Actually, trying $select :*, * doesn't seem to work. Explicitly including all column names does.

@CoryMollet @chrismetcalf The API docs at https://dev.socrata.com/docs/system-fields.html … were recently updated. Depends on v2.1 vs v2.0. Can you give ex URL?

@skram @chrismetcalf Doesn't work as expected: http://data.cityofchicago.org/resource/7nii-7srd.json?$select= …:*,*

@skram @chrismetcalf Does work as expected: http://data.cityofchicago.org/resource/7nii-7srd.json?%24select=%3Aid%2C+%3Acreated_at%2C+%3Aupdated_at%2C+service_request_type%2C+service_request_number%2C+date_service_request_was_received%2C+location_of_building_on_the_lot_if_garage_change_type_code_to_bgd_%2C+is_the_building_dangerous_or_hazardous_%2C+is_building_open_or_boarded_%2C+if_the_building_is_open_where_is_the_entry_point_%2C+is_the_building_currently_vacant_or_occupied_%2C+is_the_building_vacant_due_to_fire_%2C+any_people_using_property_homeless_childen_gangs_%2C+address_street_number%2C+address_street_direction%2C+address_street_name%2C+address_street_suffix%2C+zip_code%2C+x_coordinate%2C+y_coordinate%2C+ward%2C+police_district%2C+community_area%2C+latitude%2C+longitude%2C+location …

@skram @chrismetcalf Though it looks like the first row is actually metadata?

@CoryMollet @chrismetcalf first row being metadata was City of Chicago’s decision, not a Socrata thing.

@CoryMollet @chrismetcalf http://data.cityofchicago.org/resource/7nii-7srd.json?$select= …:*,* doesn’t work because it is the SODA 2.0 endpoint. 2.1 is http://data.cityofchicago.org/resource/yama-9had.json?$select= …:*,*