genesisclient icon indicating copy to clipboard operation
genesisclient copied to clipboard

Genesis SOAP request fails

Open quinten-goens opened this issue 6 years ago • 5 comments

Dear,

FYI

When initializing a GenesisClient instance and attempting to access the TestService through this instance using the test_service() method I received a 404 for the WSDL file. It seems to be no longer hosted by DESTATIS.

After checking it seems they have a new 2010 version available at the '/services/TestService_2010?wsdl' endpoint. However, when attempting to read in this new version I receive a 500 message with the following error message: WebFault: Server raised fault: 'The AXIS engine could not find a target service to invoke! targetService is '.

I suspect they have a malformed WSDL file in this newer version which makes it unable to do the SOAP request.

Cheers

quinten-goens avatar Jan 27 '20 10:01 quinten-goens

Hi,

I am facing the same issue and somehow my client.service is not able to find the services associated with /services/TestService_2010?wsdl. When I initialize my client with the new 2010 URL I receive a UserWarning for all the services mentioned in the documentation.

Were you able to solve the issue? if so, could you please guide me in downloading a table from the DESTATIS. @

Thank you very much!

Dear,

FYI

When initializing a GenesisClient instance and attempting to access the TestService through this instance using the test_service() method I received a 404 for the WSDL file. It seems to be no longer hosted by DESTATIS.

After checking it seems they have a new 2010 version available at the '/services/TestService_2010?wsdl' endpoint. However, when attempting to read in this new version I receive a 500 message with the following error message: WebFault: Server raised fault: 'The AXIS engine could not find a target service to invoke! targetService is '.

I suspect they have a malformed WSDL file in this newer version which makes it unable to do the SOAP request.

Cheers

SrikanthAmudala avatar Mar 01 '20 03:03 SrikanthAmudala

Hi,

I am facing the same issue and somehow my client.service is not able to find the services associated with /services/TestService_2010?wsdl. When I initialize my client with the new 2010 URL I receive a UserWarning for all the services mentioned in the documentation.

Were you able to solve the issue? if so, could you please guide me in downloading a table from the DESTATIS. @

Thank you very much!

Dear, FYI When initializing a GenesisClient instance and attempting to access the TestService through this instance using the test_service() method I received a 404 for the WSDL file. It seems to be no longer hosted by DESTATIS. After checking it seems they have a new 2010 version available at the '/services/TestService_2010?wsdl' endpoint. However, when attempting to read in this new version I receive a 500 message with the following error message: WebFault: Server raised fault: 'The AXIS engine could not find a target service to invoke! targetService is '. I suspect they have a malformed WSDL file in this newer version which makes it unable to do the SOAP request. Cheers

Hi Srikanth,

I communicated with the people who developed DESTATIS. They have let me know that everything should be working as intended for the SOAP requests. They replied that the technology behind this webservice is old and that potentially the new technologies I am using to access this webservice are incompatible. Since this is not a satisfactory answer to me I examined further and came to the conclusion that their service name in their WDSL file is incorrect causing it to not function.

I proceeded by dropping the SOAP requests and went to use HTTP GET requests which do work. Using python I was then able to use the requests module to successfully requests data from the service. I followed the tutorial in point 4.2 Create a very huge table and export it in their documentation which is available here https://www-genesis.destatis.de/genesis/misc/GENESIS-Webservices_Introduction.pdf.

You can request the data in csv format and then parse it and clean it. This is however a painful process.

In my communication with them they let me know they will release a new API this summer which should be up to date and more accessible. I am looking forward to this. Good luck.

quinten-goens avatar Mar 01 '20 16:03 quinten-goens

Hi, I am facing the same issue and somehow my client.service is not able to find the services associated with /services/TestService_2010?wsdl. When I initialize my client with the new 2010 URL I receive a UserWarning for all the services mentioned in the documentation. Were you able to solve the issue? if so, could you please guide me in downloading a table from the DESTATIS. @ Thank you very much!

Dear, FYI When initializing a GenesisClient instance and attempting to access the TestService through this instance using the test_service() method I received a 404 for the WSDL file. It seems to be no longer hosted by DESTATIS. After checking it seems they have a new 2010 version available at the '/services/TestService_2010?wsdl' endpoint. However, when attempting to read in this new version I receive a 500 message with the following error message: WebFault: Server raised fault: 'The AXIS engine could not find a target service to invoke! targetService is '. I suspect they have a malformed WSDL file in this newer version which makes it unable to do the SOAP request. Cheers

Hi Srikanth,

I communicated with the people who developed DESTATIS. They have let me know that everything should be working as intended for the SOAP requests. They replied that the technology behind this webservice is old and that potentially the new technologies I am using to access this webservice are incompatible. Since this is not a satisfactory answer to me I examined further and came to the conclusion that their service name in their WDSL file is incorrect causing it to not function.

I proceeded by dropping the SOAP requests and went to use HTTP GET requests which do work. Using python I was then able to use the requests module to successfully requests data from the service. I followed the tutorial in point 4.2 Create a very huge table and export it in their documentation which is available here https://www-genesis.destatis.de/genesis/misc/GENESIS-Webservices_Introduction.pdf.

You can request the data in csv format and then parse it and clean it. This is however a painful process.

In my communication with them, they let me know they will release a new API this summer which should be up to date and more accessible. I am looking forward to this. Good luck.

Hi Quinten,

Thank you very much for the quick response. It seems ExportService_2010 is working and I was able to retrieve the tables. I will try your approach as well and see how it works out.

Cheers!

SrikanthAmudala avatar Mar 01 '20 23:03 SrikanthAmudala

Made the necessary adjustments. Please Review and merge https://github.com/marians/genesisclient/pull/5

jonasfaehrmann avatar Apr 28 '20 09:04 jonasfaehrmann

@SrikanthAmudala and @jonasfaehrmann, DESTATIS has contacted me to announce they have released a new RESTful API to access their data. For more information see: https://www-genesis.destatis.de/genesis/misc/GENESIS-Webservices_Introduction.pdf

quinten-goens avatar May 29 '20 08:05 quinten-goens