square brackets not appearing in json array with one record

ahsin — Thu, 08 Dec 2016 19:54:24 GMT

Hi, I am using tWriteJsonField and have an array that has only one record. The output from talend does not put square brackets around the array, please see below example:
Required output:
{ "employees" :}

Talend output:
{ "employees" :
{ "firstName" : "John" , "lastName" : "Doe" }}

Would request help on this.

Re: square brackets not appearing in json array with one record

Anonymous — Thu, 08 Dec 2016 20:42:55 GMT

The problem here is Talend does not handle JSON internally.They do everything with XML.
Take a look in the documentation. There is a way to get an array by adding an @array attribute in the mapping configuration.
The other solution could be you use components which are dedicated to JSON without the workaround XML.
https://exchange.talend.com/#marketplaceproductoverview:gallery=marketplace%252F1&pi=marketplace%252F1%252Fproducts%252F1438%252Fitems%252F2571

topic Re: square brackets not appearing in json array with one record in Talend Studio

square brackets not appearing in json array with one record

Re: square brackets not appearing in json array with one record