Set up a row identifier (ID column)

A row identifier can be established for any Socrata dataset. A row identifier is a specific column of a dataset that contains values that uniquely identify each row in the dataset. In other words, the value in this column cannot be the same for any two rows in the dataset, it must be different for each row. A common column to use is an ID column with some kind of number or code that identifies that row of data. Row identifiers are required for using the Upsert function within DataSync.

An example of a Row Identifier is the 'Reference Number' column on Edmonton's 311 dataset: https://data.edmonton.ca/Indicators/311-Explorer/ukww-xkmj

How to set a row identifier from a working copy

Step 1: The row identifier is set through the "Edit Metadata" page, which can be accessed from the data table page. Select "Edit Metadata" next to the dataset name. 

Step 2: Once on the edit metadata page, Scroll to the subheader called “API Endpoint”, in this section you can select the row identifier from the drop-down menu that contains all the columns within the dataset.

Step 3: After selecting the appropriate column. Click “Save” at the bottom.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.