write a simple program for testing

This is actually part of a big project. This is some kind of a test if you can write a simple program and connect to a database on a server using API. The API is not well documented but this job is very easy. You have to give me the simple program (you can write that in any language) and give the details or explanations on how you were able to connect (the program must be well commented and well explained so that I won't ask so many questions from you). Also give your recommendations for security and other advice it is appreciated. Once you have done all this simple task you will be paid. If you have any question or you need other details please contact me I'm here to help. Here are some info that might help you: web api, soap, xml. Once you are done with this job please do not share the information, please make everything private because this is online banking we might hire you in the future and if you share all the information both of us will surely get headache in the near future. You need to follow all the instructions here if you are able to connect to the server and get the information explained on the documentation please help me replicate it so that I can check your work.

Project ID: 19430002