topic Re: Array with single element is not getting populated within [] in Talend using MongoDB output in Talend Studio

Array with single element is not getting populated within [] in Talend using MongoDB output

AGadiyar — Fri, 15 Nov 2024 23:57:45 GMT

Hi Team,

I am trying to insert a JSON document with arrays into the target mongoDB and the issue I am facing is array with one element is not getting enclosed within square brackets whereas array with more than one element is working fine.

Single element:

"project" : {

"projectName" : "AAU",

"delay" : "0 days",

"projectBudget" : "315000000"

}

Multiple elements:

"project" : [

{

"projectName" : "AAD",

"delay" : "3 days",

"projectBudget" : "90000000"

{

"projectName" : "AAE",

"delay" : "3 days",

"projectBudget" : "105000000"

}

]

Output expected: Even for single element output to come within square brackets [ ]

"project" :[ {

"projectName" : "AAU",

"delay" : "0 days",

"projectBudget" : "315000000"

}

]

Any help on this is much appreciated.

Thanks!

Re: Array with single element is not getting populated within [] in Talend using MongoDB output

gjeremy1617088143 — Tue, 13 Jul 2021 15:12:28 GMT

Hi, does the json are created with talend or does they come from an other source ?

Project is just a part of tje json or it's the root element ?

Send me Love and Kudos

Re: Array with single element is not getting populated within [] in Talend using MongoDB output

AGadiyar — Tue, 13 Jul 2021 15:23:26 GMT

JSON is created within Talend..we are using mongodb input, reading the data from a collection and trying to convert to the required json structure within talend. Project is part of a json. Attaching the screenshot for reference

Re: Array with single element is not getting populated within [] in Talend using MongoDB output

gjeremy1617088143 — Thu, 15 Jul 2021 07:42:35 GMT

Hi, @AGadivar, if projects array is the last thing on your json it could be esay to rewrite data :

you read your json as a string then you could do something like that :

((your string).replaceAll(""project\\" \\: \\{",'"project" : [

{').replaceAll("(?<! \\}

)\\]$"," }

]")

Send me Love and Kudos