Extracting data from a HTML / XML web page

[former_member221770]

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.

[Former Member]

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?

[eddy_declercq]

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

[former_member221770]

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.

[athavanraja]

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

Regards

Raja

[athavanraja]

online help

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

Regards

Raja

[former_member221770]

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.

[athavanraja]

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

[former_member221770]

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.

[athavanraja]

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