Getting tabular data from a web page

One Star

Getting tabular data from a web page

Hi Talend users,

I am wondering if you can help me.

Is there any way how to get a tabular data from a web page via Talend, like you can do it with Excel (Web query)?

Thanks for getting involved.
Community Manager

Re: Getting tabular data from a web page

Hello
Please try the tHTTPTableInput shared by mlange.

Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Getting tabular data from a web page

shong wrote:
Hello
Please try the tHTTPTableInput shared by mlange.

Best regards

shong

Thanks for your advice! This is what I was looking for. However, is there any chance to do it when authentification required is?

I got this error:

Starting job bla2 at 14:14 02/03/2010.

[statistics] connecting to socket on port 4071
[statistics] connected
Exception in component tHTTPTableInput_1
com.meterware.httpunit.AuthorizationRequiredException: Basic authentication required: realm="CGI Lawson"
at com.meterware.httpunit.WebClient.validateHeaders(WebClient.java:571)
at com.meterware.httpunit.WebClient.updateClient(WebClient.java:464)
at com.meterware.httpunit.WebWindow.updateWindow(WebWindow.java:139)
at com.meterware.httpunit.WebWindow.getSubframeResponse(WebWindow.java:130)
at com.meterware.httpunit.WebWindow.getResponse(WebWindow.java:121)
at com.meterware.httpunit.WebClient.getResponse(WebClient.java:113)
[statistics] disconnected
at wequry.bla2_0_1.bla2.tHTTPTableInput_1Process(bla2.java:198)
at wequry.bla2_0_1.bla2.runJobInTOS(bla2.java:386)
at wequry.bla2_0_1.bla2.main(bla2.java:281)
Job bla2 ended at 14:14 02/03/2010. [exit code=1]

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog