Transcript Building an API to our statistical database

PX-Web 2014
Maria Gunnarsson, Statistics Sweden
Petros Likidis, Statistics Sweden
We use PX-Web ourselves
We use PX-Web ourselves
Migration tool
PX-Web_xxx.zip
New customized
PX-Web
Tool
Customized PX-Web
Merge tool
Coming in December
•
•
•
•
•
Saved queries
Sort order for PX databases
Forms authentication
API settings query
Improvements and bug fixes
Saved queries
Save query
 Set time
 Latest
period
Result as
 Table on screen
 PX
 CSV
 etc
OK
Save query
You can get back to the same withdrawal via this URL
http://www.statistikdatabasen.scb.se/sq/HKLmp88303DF
Bookmark
OK
Sort order for PX databases
• Suggestion to add a file in each folder called
Menu.sort or Menu.<LANG>.sort that contain a
string that is used to determine the sort order of
the folder. If the file is missing the name of the
folder should be the sort string.
Forms authentication
• Create a login form that can be used to
authenticate users so that they will be able to
access protected databases.
• You will have to implement your own
authentication algorithm.
API settings query
• Comes from a suggestion from R developers
• You will be able to query the API for some if its
settings.
• Max values returned
• Max number of queries
• Size of time window
Improvement and bug fixes
•
•
•
•
•
Logging IP address of users
Better title description on the different pages
Better PX file output
API helper bug
JSON-STAT bug