Skip to Content
avatar image
Former Member

How to pull data from a website..

Hi all,

My scenario is to

1>Pull a bank statement from its website and store the corresponding data in r3.

the point is,there is no particular file name or location..

we should be able to get the bank statement within a specified period(given by user)..

My interface will accept username password, from and to date for the bank statement.

with this is it possible to pull the data out form the bank...

Can we crack this..!!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Mar 29, 2007 at 11:00 AM

    Hi,

    sure it;s possible

    you can use java proxy to connect to WWW and get whatever you need

    from it

    but as said no standard adapter supports this so you will need to write

    a few lines of code (java proxy)

    Regards,

    michal

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 29, 2007 at 10:59 AM

    Does it accept Webservices? if yes SOAP adapters can be used.

    Else, you might need to use a Javas Proxy and use a "HTTP Get " oi the Java proxy to get the message from the Website.

    There point here is, how will the interfacing be done with the website? What are the options that the website provide?

    regards

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bhavesh..

      the bank website can accept the from and to date, and display the bank statement.

      it even has an option to save the file on to dish (excel or csv)..

      but i need to take the from and to date from my user and be able to retreive the corresponding data..

  • avatar image
    Former Member
    Mar 29, 2007 at 11:00 AM

    Harish,

    For your requirement, your bank must prvide you with a webservice WSDL. The webservice should take in the user Id/pwd and date range and give the response as bank statement. If your bank already has a webservice that is hosted in internet, then you can very well do this.

    Regards,

    Jai Shankar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Oops.. I was unaware of the option of using Java proxy to extract data from a webpage..... Thanks for the information. Will try to work on this.

      Regards,

      Jai Shankar