Schedule Updates via URL, API Keys (4 February 2019)

Schedule Dataset Updates

Do you regularly update a dataset that is already published somewhere else on the web? Or even import a filtered dataset from another Socrata site into yours every month or quarter?

If you have imported a dataset from a public URL endpoint, such as this Census dataset for Washington State, you can now schedule automated updates for that data right from your Socrata dataset. After you've specified the URL, configured your data so it looks accurate, and published your dataset, you can set up scheduling with the desired frequency and time of day you would like this dataset updated at. And then Socrata will take it from there!

Today, this feature supports full replace updates, and the frequency is set in days, from 1-90. 

Read this Knowledge Base article for more details on how scheduling data updates works. 

API Keys

Users of Socrata APIs now have more flexibility and can authenticate using API Keys. API Keys are personal authentication credentials that you can create and then pass in place of a username and password when using HTTP Basic Auth to perform API calls. Keys are owned by a single user and have identical rights, roles, and permissions to that user. Users can create API Keys via API following the instructions in the documentation. API Key creation through the UI is forthcoming.

Why Use API Keys?

  • Access Socrata APIs without the risk of embedding your username and password in scripts or code

  • Users on domains that require SSO (and thus without passwords) can access Socrata APIs

  • Create individual keys for different apps or jobs so that if any one needs to be revoked or rotated, other apps are unaffected

  • Change your account password without disrupting apps or rotate API keys without disrupting logins

Read this Knowledge Base article for more details on how to use API Keys. 

Visualization Updates: Bubble Charts and Single Select Filters

Recently, the ability to create scatter plots was added to the visualization suite, adding an exciting new exploratory option for datasets on Socrata. Today, we've released a major update to scatter plots: bubble charts! 


With this update, the points on a scatter plot can be resized and colored based on categories or factors within your data, giving a more robust and complete analytical view. Along with this change, we've also released a significant improvement to visualization filter bar: the ability to make a filter "single select." With this change, a filter can be configured to always select only one value, instead of selecting a range or group of values.


For more details on building visualizations in Socrata, check out our Knowledge Base.

Small Updates & Bug Fixes 

  • Released a significant update to the look and feel of the Notifications panel, making product updates more prominent and improving the mobile experience.
  • Fixed an issue where the notifications bell still showed an orange indicator even where there are 0 unread notifications,
  • Data importing and editing
    • With the new data import experience, we no longer accept money data types in datasets. This means when a money datatype is uploaded, it will be read as a Text column. During the upload process, you can change the column type to Number and format it as Money.
  • Visualization updates
    • Fixed an issue causing Scatter Plots to be listed as Data Lenses in the catalogs instead of charts.
    • Now, when a layer of a multi-layer map is hidden, the legend associated with that layer will also be hidden.
    • Added the ability to sort the interior elements of a group for a grouped chart.
    • Now, the "based on" information in the header of a multi-layer map will reflect all of the underlying layers, not just the base layer.
  •  Financial Insights Updates
    • Open Expenditures: Fixed an issue where in some cases the ledger list under the chart would continue loading and prevent users from accessing the View Data button.
    • Open Finance: When applications are linked with an Open Finance page, the favicon for the Open Finance page will now appear on all child applications.
    • Small updates and bug fixes.


Check out our other Product News, and give us a shout at with questions or ideas. 

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



Article is closed for comments.