Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tXML not looping on element for insert to database

Hi -

 

My Talend job is not looping thru the xml element data even thou the SOAPUI does

SOAPUI response 

{
   "data":    [
           {
         "client_ip": "196.14.29.39",
         "day_id": 1500501600,
         "in_bytes": 38662088078,
         "out_bytes": 56837609153,
         "site": "cpt",
         "tot_bytes": 95499697231
      },
                {
         "client_ip": "196.14.29.39",
         "day_id": 1500588000,
         "in_bytes": 80098234483,
         "out_bytes": 76864778167,
         "site": "cpt",
         "tot_bytes": 156963012650
      }
      
   ],
   "status": "SUCCESS"
}

The tXMLMap is configured as below:

0683p000009Lrbk.png

The problem is that only the first row gets inserted to the database and not the complete loop data as per the date

 

Thanks

Labels (5)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Found the answer loop needs to be on date

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Found the answer loop needs to be on date

Anonymous
Not applicable
Author

Did not work after compile....
Anonymous
Not applicable
Author

Hello,

Could you please post your current setting screenshots on forum?

Best regards

Sabrina