Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Genesis SOAP request fails #4

Open
quinten-goens opened this issue Jan 27, 2020 · 5 comments
Open

Genesis SOAP request fails #4

quinten-goens opened this issue Jan 27, 2020 · 5 comments

Comments

@quinten-goens
Copy link

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
Copy link

SrikanthAmudala commented Mar 1, 2020

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

@quinten-goens
Copy link
Author

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.

@SrikanthAmudala
Copy link

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!

@jonasfaehrmann
Copy link

Made the necessary adjustments. Please Review and merge #5

@quinten-goens
Copy link
Author

@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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants