topic Re: Extracting data from a HTML / XML web page in Application Development and Automation Discussions

Extracting data from a HTML / XML web page

former_member221770 — Thu, 25 Aug 2005 06:10:19 GMT

Hi guys,

We are trying to extract data from a html (or xml) web page into SAP. Has anyone had any experience doing this? I know you can call a HTML webpage from SAP via the object CL_GUI_HTML_VIEWER, but is there a way to extract data from a page, be it from looking at the source code or other means?

Thanks,

Pat.

Re: Extracting data from a HTML / XML web page

Former Member — Thu, 25 Aug 2005 06:21:55 GMT

Hi Pat,

You need to look at CALL TRANSFORMATION syntax to do this.


CALL TRANSFORMATION trans|(name) 
                    [PARAMETERS ...] 
                    [OBJECTS ...] 
                    SOURCE ... 
                    RESULT ...

How's the weather at Lavender Bay?

Re: Extracting data from a HTML / XML web page

athavanraja — Thu, 25 Aug 2005 06:26:35 GMT

Hi Pat,

if you are on WAS6.10 > you can use CL_HTTP_CLIENT else

you can use HTTP_GET or HTTP_POST

let me know if you need code sample.

Regards

Raja

Re: Extracting data from a HTML / XML web page

eddy_declercq — Thu, 25 Aug 2005 06:26:37 GMT

Hi, Have a look at this article https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/webas/abap/just browsing around.article

and Craig's weblog /people/sap.user72/blog/2005/05/03/sdn-meets-labs-integrated-web-content

Eddy

Re: Extracting data from a HTML / XML web page

former_member221770 — Thu, 25 Aug 2005 22:34:56 GMT

Hi guys,

Thanks for your quick responses. Will try out each of your suggestions and I'll let you know how I go.

By the way, Syd Oz, Lavender Bay is great!

Cheers,

Pat.

Re: Extracting data from a HTML / XML web page

athavanraja — Sat, 27 Aug 2005 06:50:34 GMT

if your qestion is answered, please reward the helpful answers and close the thread.

Regards

Raja

Re: Extracting data from a HTML / XML web page

athavanraja — Sun, 28 Aug 2005 10:27:57 GMT

online help

http://help.sap.com/saphelp_nw04/helpdata/en/1f/93163f9959a808e10000000a114084/frameset.htm

Regards

Raja

Re: Extracting data from a HTML / XML web page

former_member221770 — Sun, 28 Aug 2005 22:23:26 GMT

Hi Raja,

I have been busy attending to another issue that has come up but I am planning to follow up on your suggestions sometime today. Once I have done this I will award the points accordingly.

Thanks to everyone for your help so far.

Cheers,

Pat.

Re: Extracting data from a HTML / XML web page

former_member221770 — Mon, 29 Aug 2005 01:00:11 GMT

Durairaj,

Someone from the BSP forum sent me a link to your SDN Community Contribution (RFC_READ_TABLE for SAP Web AS) which is exactly what I was looking for!

Big thanks to all who replied with suggestions.

Cheers,

Pat.

Re: Extracting data from a HTML / XML web page

athavanraja — Mon, 29 Aug 2005 04:22:39 GMT

this is exactly the issue with code samples. Unlike weblogs, you dont know what code samples are there, unless you search. Something needs to done about organizing the code samples.

Regards

Raja