Six Stars

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:

talenttxmlmap.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

1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: tXML not looping on element for insert to database

Found the answer loop needs to be on date

3 REPLIES
Six Stars

Re: tXML not looping on element for insert to database

Found the answer loop needs to be on date

Six Stars

Re: tXML not looping on element for insert to database

Did not work after compile....
Moderator

Re: tXML not looping on element for insert to database

Hello,

Could you please post your current setting screenshots on forum?

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.