tXML not looping on element for insert to database

Seven 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


Accepted Solutions
Seven Stars

Re: tXML not looping on element for insert to database

Found the answer loop needs to be on date


All Replies
Seven Stars

Re: tXML not looping on element for insert to database

Found the answer loop needs to be on date

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.