How to connect to a web site with xml file contains many adress ?

Seven Stars

How to connect to a web site with xml file contains many adress ?

Hello, I have an XML file wich have many adress (uri) , how can connect to the web site ?

For exemple my xml file is like

<?xml version="1.0" encoding="ISO-8859-15"?>
<root>
<row>
<ows_Title>1st URI</ows_Title>
</row>
<row>
<ows_Title> 2nd URI</ows_Title>
</row>
<row>
<ows_Title>3rd URI</ows_Title>
</row>
</root>

my xml file was auto generating, i can't edit.

 

 

I want to connect to the 1st URI and getting his element with output, after, connect to 2nd URI etc....

I'v already used tHttpRequest but in the URI I was "www.my_web_site/" and her, i need to connect with URI in the XML file like this "www.my_web_site"."/1st" doest it can be working ?


Accepted Solutions
Seven Stars

Re: How to connect to a web site with xml file contains many adress ?

Hello, yes its well formed, is solved my problem, I needed to set the variable into the out var going to my tHttprequest set_var_xmlmap.PNG


All Replies
Seven Stars

Re: How to connect to a web site with xml file contains many adress ?

up please Cat Frustrated

Highlighted
Moderator

Re: How to connect to a web site with xml file contains many adress ?

Hello,

Is your XML file well formed? Have you tried to use tfileinputxml or tExtractXMLField component to extract your address firstly?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: How to connect to a web site with xml file contains many adress ?

Hello, yes its well formed, is solved my problem, I needed to set the variable into the out var going to my tHttprequest set_var_xmlmap.PNG

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads