api and px web

[borodu...@gmail.com]

Dear all

i have a file based px web instalation 

-- http://pxweb.monstat.org/pxweb   - version for serbian language

- http://pxweb.monstat.org/PXWebEng   - version for english language

Our goverment open data portal https://data.gov.me/ is trying to colect data from my PX web database via API.

I have approved API via px web administration

When I tupe pxweb.monstat.org/PXWeb/api/v1/sr I get list of databases but no data

Can I work with API and file base px web?

Do I need to change something in my px files?

Any help is welcomed and appriciated

Regards

Boro

[Jan Bruusgaard]

Yes, you traverse the structure down to the table metadata.

eg. http://pxweb.monstat.org/PXWeb/api/v1/sr/Demografija/Migracije/tabela%201.px

Http GET only gives the metadata for the table as JSON.

To get the data you use http POST.

You post your api query as JSON towards the URL. 

I can come back with an example, if needed. 

Kind regards,

Jan Bruusgaard

Statistics Norway

[borodu...@gmail.com]

Hi Jan, 

thanks for explanation.

And yes an example would be very helpufull and appiciated

Tnanks

Boro

[Jan Bruusgaard]

Hello Boro,

To test if your API works, you can post a query like [ ]. That gives all values for variables where elimation is false and the eleminated value (Total)  when elimination is set to true.

{
  "query": [
  ],
  "response": {
    "format": "xlsx"
  }
}

See enclosed response in Excel. I also got response by changing format "xlsx" to px, json-stat2 or xlsx.

A good way to test the API is using Postman https://www.postman.com/downloads/

You can also find also some general hints in our API-user guide in English. 

Kind regards

Jan 

[borodu...@gmail.com]

Hello Jan

Yes!!!

Thank very much
Boro