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

Highlighted
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
Highlighted
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

View solution in original post


All Replies
Highlighted
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.
Highlighted
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

View solution in original post

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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog