One Star

[resolved] Iterate through a list of URL's for tRSSInput?

Hi, just started with Talend and could do with some help. Have already read through previous topics but couldn't get anything working.
I have a list of RSS URL's in an excel document, and would like to use tRSSInput to aggregate the contents into a second excel document. My problem is how to run through the list of URL's and connect it to the RSS URL parameter.
Any ideas?
2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator

Re: [resolved] Iterate through a list of URL's for tRSSInput?

Hi,
You can use tContextLoad or Implicit tContextLoad to iterate a list of RSS URL's in an excel document and set a Context value in RSS URL parameter.
Please see my screenshots and component reference TalendHelpCenter:tContextLoad.
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.
Community Manager

Re: [resolved] Iterate through a list of URL's for tRSSInput?

Hello,
How can i do to read severals values from my ".txt" file and put it in only one context for the tRSSInput component.
Because it took only the last row of my ".txt" file.
Thank you

Hi
You can use tFlowToIterate to iterate all rowss one by one, for example:
tFileInputDelimited--main(row1)-->tFlowToIterate--iterate--tRSSInput--main--tLogRow
on tRSSInput, set the RSS URL field as: row1.url
Refer to the component manual: tFlowToIterate
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
11 REPLIES
Moderator

Re: [resolved] Iterate through a list of URL's for tRSSInput?

Hi,
You can use tContextLoad or Implicit tContextLoad to iterate a list of RSS URL's in an excel document and set a Context value in RSS URL parameter.
Please see my screenshots and component reference TalendHelpCenter:tContextLoad.
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.
One Star

Re: [resolved] Iterate through a list of URL's for tRSSInput?

Thanks for the help.
Moderator

Re: [resolved] Iterate through a list of URL's for tRSSInput?

Hi,
Is this solution working for you? If your issue is closed, may I ask you to click the "Set this topic as resolved" link which is right underneath your initial post? This way, other users will be informed that this thread has been resolved.
Many thanks
Feel free let me know if there is any further help we can give.
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.
One Star

Re: [resolved] Iterate through a list of URL's for tRSSInput?

Hello,
This solution is working for me but it takes only the last row of my file..
One Star

Re: [resolved] Iterate through a list of URL's for tRSSInput?

Hello,
How can i do to read severals values from my ".txt" file and put it in only one context for the tRSSInput component.
Because it took only the last row of my ".txt" file.
Thank you
Community Manager

Re: [resolved] Iterate through a list of URL's for tRSSInput?

Hello,
How can i do to read severals values from my ".txt" file and put it in only one context for the tRSSInput component.
Because it took only the last row of my ".txt" file.
Thank you

Hi
You can use tFlowToIterate to iterate all rowss one by one, for example:
tFileInputDelimited--main(row1)-->tFlowToIterate--iterate--tRSSInput--main--tLogRow
on tRSSInput, set the RSS URL field as: row1.url
Refer to the component manual: tFlowToIterate
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Iterate through a list of URL's for tRSSInput?

Thank you it works!
One Star

Re: [resolved] Iterate through a list of URL's for tRSSInput?

Hi,
Would like to ask how this  "tFileInputDelimited--main(row1)-->tFlowToIterate--iterate--tRSSInput--main--tLogRow" change if I use tREST instead tRSSinput?
BR,
Dynamo
Moderator

Re: [resolved] Iterate through a list of URL's for tRSSInput?

Hi Dynamo,
Could you please give us more description about your job requirement?
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.
One Star

Re: [resolved] Iterate through a list of URL's for tRSSInput?

hi, I have a query ..it is about how to extract google api data by using which component in talend..
Moderator

Re: [resolved] Iterate through a list of URL's for tRSSInput?

Hi pati.pranati,
What does your query look like? Are you looking for tBigqueryInput component which is used to perform the queries supported by Google BigQuery.
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.