Mark Silverberg

Is there a way to expose the internal row id of a @socrata dataset through the API (in the case of publishers not specifying an id)?

@CoryMollet Still looking for help getting @socrata row IDs? Sorry for the holiday season delay, but his may help: https://dev.socrata.com/docs/system-fields.html …

@chrismetcalf @socrata Not anymore, @skram pointed me there as well. Exactly what I needed. Thanks for the help!

@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 …