Px-WebDataLoader-StatistiskacentralbyrnSCB.pptVIP

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/DATABASE-ID/LEVELS/TABLE-ID .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 .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,text:Year,type:t},{code:Instat1,text:W