PX Win connection via API

[Igor Stefelin]

Hello.

We have changed our production server and installed new version of PxWeb (not the latest, 2020v1) and everything works ok. But the problem is with PxWin connection to PxWeb API. New API does not work with PxWin application. API works with web browser and with Postman application but not with PxWin.
Our configuration for PxWin is

<database id="sistat_api" type="PXAPI" name="SiStat">
<params>
<baseUrl>https://pxweb.stat.si:443/SiStatData/api/v1/{0}/Data</baseUrl>
<supportedLanguages>sl,en</supportedLanguages>
</params>
</database>

Our entire database is stored inside one directory (all px files).
Is PxWin using special Ports? Application does not have any logs so we can't determine where is the problem.

We would appreciate any help with this matter.

Regards

Andraž Pencelj and Igor Štefelin

Statistics Office of Republic Slovenia

[Hans Baumgartner]

Hi,

 

I just tested our new PxWeb 2020v2 against PxWin and it works.

 

I also tested yours and it did not work

<database id="sistat_api" type="PXAPI" name="SiStat">
<params>
<baseUrl>https://pxweb.stat.si:443/SiStatData/api/v1/{0}/Data</baseUrl>
<supportedLanguages>sl,en</supportedLanguages>
</params>
</database>

 

This is ours:

   <database id="fi_api_statfin_test" type="PXAPI" name="TK StatFin API Test">

      <params>

         <baseUrl>http://pxweb2.stat.fi/PXWeb/api/v1/{0}/StatFin</baseUrl>

         <supportedLanguages>fi,sv,en</supportedLanguages>

      </params>

   </database>

 

I think the problem is that all the files are in the root of the database ex.\database\StatFin (in the StatFin directory)

Or might there be a problem with the HTTPS

 

There is also a bug in PxWin when you are trying to access the all databases under \database\ it does not work!

Many statistical offices have not understood that that you have to make a directory under \database\  for every

database they have done subject areas under database and thereby split one database into many databases.

That’s where the API access to all databases under database would be nice.

All databases under \database\ <baseUrl>http://pxweb2.stat.fi/PXWeb/api/v1/{0}/</baseUrl>

 

 

Hans Baumgartner

 

Lähettäjä: pca...@googlegroups.com <pca...@googlegroups.com> Puolesta Igor Stefelin
Lähetetty: perjantai 12. helmikuuta 2021 12.00
Vastaanottaja: pca...@googlegroups.com
Aihe: PX Win connection via API

--
You received this message because you are subscribed to the Google Groups "pcaxis" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pcaxis+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pcaxis/CALiK1hHYHfjj7uNb9oY3UXR_Lr4RJrsb9frncoYNM-goGmM1mA%40mail.gmail.com.

[Petros Likidis]

Hi,

I just want to confirm that Hans is right about a bug in PxWin that does not display tables in the root of the database folder. 

Please add an issue for it at https://github.com/statisticssweden/PxWeb/issues/new/choose 

Kind regards

Petros

To view this discussion on the web visit https://groups.google.com/d/msgid/pcaxis/AM7PR10MB3510BE978009C79FCA43CF31918B9%40AM7PR10MB3510.EURPRD10.PROD.OUTLOOK.COM.