Px-Web API Albania
Px-Web API use in INSTAT
Table of Contents
About PX-Web API
PX-Web API use in INSTAT
About Data Visualization Project
Future plans
About PX-Web API
PxWeb API
A
programmatic way to access px-web database
GET
Request: metadata about databases, levels, tables,
contents and variables of a table
Returns a json format of the metadata
POST
Request: post a query for retrieving data from a table
Returns a specified format of the filtered table (json, xml, px, csv.)
About PX-Web API
GET Request: API/LANGUAGE/DATABASEID/<LEVELS>/TABLE-ID
http://instat.gov.al:8080/api/al/DST/LSMS/LSMS01
JSON
metadata response
POST Request: Posting a json formatted request to the
above url will return a response with the data filtered
according to the posted query.
User
specified format response
PX-Web API GET request
Example resoponse of the GET request “/api/en”
[{"dbid":"DST","text":"Statistical database"}]
Example response of the GET request “/api/en/DST/ND”
[{"id":"ND0001","type":"t","text":"Constructions by their type- Riconstructions 2004-1 - 2012-4"},
{"id":"ND0002","type":"t","text":"Dwelling by prefecture by prefectures according to construction permits
2005 - 2011"},
{"id":"ND0003","type":"t","text":"Number and square meter of building permits issue for new buildings
2004-1 - 2012-4"},
{"id":"ND0004","type":"t","text":"Dwelling by district according to construction permits 2005 - 2011"},
{"id":"ND0005","type":"t","text":"Value of building permits issued by clients for buildings and civil
engineering works 1999 - 2011"},
{"id":"ND0006","type":"t","text":"Approximate value- New constructions 2004-1 - 2012-4"}]
PxWeb API POST request
Example of POST request into the url
"http://instat.gov.al:8080/api/en/DST/OS/DVS/DVS0008/"
{"query": [{"code": "NivArsim", "selection": {"filter": "all","values":
["*"]}},{"code": "urban_rural", "selection": {"filter": "all","values":
["*"]}},{"code": "Vit", "selection": {"filter": "all", "values": ["*"] }}],"response":
{ "format": "json" }}:
response
{"columns":[{"code":"NivArsim","text":"Level of Education
","type":"d"},{"code":"urban_rural","text":"urban_rural","type":"d"},{"code":"Vit","t
ext":"Year","type":"t"},{"code":"Instat1","text":"Women
Percentage","type":"c"}],"comments":[],"data":[{"key":["1","1","2013"],"values":["3.
0"]},{"key":["1","2","2013"],"values":["5.9"]},{"key":["2","1","2013"],"values":["26.
9"]},{"key":["2","2","2013"],"values":["55.0"]},{"key":["3","1","2013"],"values":["46
.9"]},{"key":["3","2","2013"],"values":["33.9"]},{"key":["4","1","2013"],"values":["2
3.2"]},{"key":["4","2","2013"],"values":["5.2"]}]}
1/12/2017
PX-Web API use in INSTAT
Programmatic access to our pxweb database
Internal
use for our Data Visualization Project
Charts
and table data are provided from px web database
using pxweb api queries
Users
can programmatically access our database for
automatic update of figures in their reports
1/12/2017
PX-Web API use in INSTAT
Visualization of INSTAT publications
About Data Visualization Project
Visual Studio 2013
SQL Server 2012
ASP.net
.Net Framework 4.5
Entity Framework (Database First Model)
LINQ
JQuery
JQPlot
Pivot js
About Data Visualization Project
Visualization of INSTAT publications (Tables)
Pivot.js
About Data Visualization Project
Visualization of INSTAT publications (Charts)
Jqplot
Future plans
Visualize main INSTAT publication
Create a loading application to populate the
database
Extend the use of the API for other purposes
External
users as well
Thank You For Your
Attention!
© Copyright 2024