Forum Discussion

Ganeshu108's avatar
Ganeshu108
New Contributor II
2 years ago

Mongo DB Account Configuration

Hello All,               I am trying to configure mongodb account But while configuring mongodb account getting following error  please help me to resolve this.
maahutch's avatar
maahutch
New Contributor
3 years ago
Copy LinkReport

Thanks Aleksandar. Is there a resource to learn this notation and how to use it in Snaplogic?

If my JSON were formatted like this, how would I adapt that expression?

{
    "id": "1",
    "subjects":
                 [
                    {
                        "subject_id":"a"
    
                    },
                    {
                        "subject_id":"b"
    
                    }
                ]
}
Aleksandar_A's avatar
Aleksandar_A
Contributor III
3 years ago
Copy LinkReport

For more resources and helpful insights please refer to the official SnapLogic documentation SnapLogic Documentation.

In order to format the new json you can use the following expression in a Mapper Snap:

$subjects.map(x => x.extend({"id":$id}))

Then use a JSON Splitter to split the subjects array.

You can also refer to the sample pipeline attached below:

–sl-comm-array-denormalized-table_2023_06_23.slp (9.0 KB)

Regards,
Aleksandar.

Related Content