topic Re: tXML not looping on element for insert to database in Talend Studio

tXML not looping on element for insert to database

Anonymous — Sat, 16 Nov 2024 09:08:32 GMT

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:

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

Thanks

Re: tXML not looping on element for insert to database

Anonymous — Wed, 25 Oct 2017 17:38:50 GMT

Found the answer loop needs to be on date

Re: tXML not looping on element for insert to database

Anonymous — Wed, 25 Oct 2017 19:12:57 GMT

Did not work after compile....

Re: tXML not looping on element for insert to database

Anonymous — Thu, 26 Oct 2017 07:43:54 GMT

Hello,

Could you please post your current setting screenshots on forum?

Best regards

Sabrina