Upserting a Nested Array into an Array object in Mongo Document

riptidas — Sat, 16 Nov 2024 01:42:02 GMT

My Collection is something like below:

{

"departmentCode": "1234",

"departmentLocations": [

{

"code": "USNYC",

"name": "New York"

{

"code": "USLOS",

"name": "Los Angels"

}

]

}

My source is an oracle table, which have reference to the location code in the above collection.

I need to read from the oracle table and upsert into the above collection as below.

{

"departmentCode": "1234",

"departmentLocations": [

{

"code": "USNYC",

"name": "New York",

"postings": [

{

"name": "Mark Twain",

"position": "Manager"

{

"name": "Jimmy Bourne",

"position": "Clerk"

}

]

{

"code": "USLOS",

"name": "Los Angels",

"postings": [

{

"name": "Harry Summers",

"position": "Operator"

{

"name": "Tommy Lane",

"position": "Sales Rep"

}

]

}

]

}

I obviously cannot use "departmentLocations.postings" as my Data node in tMongoDBOutput component.

Can anyone please help?

Re: Upserting a Nested Array into an Array object in Mongo Document

angamuthu1 — Fri, 02 Apr 2021 18:09:54 GMT

Hi Riptidas,

I have a similar need, can you please share the resolution if you were able to solve the issue

Re: Upserting a Nested Array into an Array object in Mongo Document

riptidas — Wed, 29 Dec 2021 17:37:02 GMT

Hello mohankanala,

Unfortunately I am yet to find a resolution.

Were you able to find a solution?

topic Upserting a Nested Array into an Array object in Mongo Document in Talend Studio

Upserting a Nested Array into an Array object in Mongo Document

Re: Upserting a Nested Array into an Array object in Mongo Document

Re: Upserting a Nested Array into an Array object in Mongo Document