Problem facing parsing JSON Data

[chandan988]

Can anyone help in data parsing via Http Node which contain array format i tried JSON , Raw but data is not going ( hitting server )

How shall i pass this data

{
“admissiondate”: “2023-08-11”,
“branchId”: “64777b5e0cd642b28f5594fe”,
“studentname”: “Khushank Sagwan”,
“mobileno”: “xxxxxx”,
“emailid”: “yyyyyyyyy”,
“counsellorId”: “64787b75d71caf313a147060”,
“courseId”: “64788bfdd71caf313a148af9”,
“coursefee”: 57218,
“discount”: 30,
“discountAmount”: 17218,
“taxAmount”: 6102,
“totalAmount”: 40000,
“firstinstallmentamount”: 8000,
“secondinstallmentamount”: 10000,
“thirdinstallmentamount”: 20000,
“firstinstallmentdate”: “2023-11-08”,
“secondinstallmentdate”: “2023-08-11”,
“thirdinstallmentdate”: “2023-08-11”,
“taxId”: “64ca412b3c2e1812705c5b86”,
“createdBy”: “64787f8fd71caf313a147406”,
“orgNumber”: “0001”,
“paymentReceivedArray”: [
{
“paymentAmount”: 2000,
“paymentDate”: “2023-11-08”,
“modeofpayment”: “UPI”
},
{
“paymentAmount”: 8000,
“paymentDate”: “2023-08-11”,
“modeofpayment”: “UPI”
},
{
“paymentAmount”: 10000,
“paymentDate”: “2023-08-11”,
“modeofpayment”: “UPI”
},
{
“paymentAmount”: 10000,
“paymentDate”: “2023-08-11”,
“modeofpayment”: “UPI”
}
]
}

[Jon]

Hey @chandan988,

It looks like you have removed the template, can you complete the below so we know which version you are using which could be important if there is an issue we have fixed and also share the workflow you are trying so we can see what is going on.

    n8n version:
    Database (default: SQLite):
    n8n EXECUTIONS_PROCESS setting (default: own, main):
    Running n8n via (Docker, npm, n8n cloud, desktop app):
    Operating system:

[chandan988]

Basically I got data from Google Sheet ( Read all rows ) and i have to send these data to mongoDB where below are in Array Format & rest are normal,
“paymentReceivedArray”: [
{
“paymentAmount”: 2000,
“paymentDate”: “2023-11-08”,
“modeofpayment”: “UPI”
},
{
“paymentAmount”: 8000,
“paymentDate”: “2023-08-11”,
“modeofpayment”: “UPI”
},
{
“paymentAmount”: 10000,
“paymentDate”: “2023-08-11”,
“modeofpayment”: “UPI”
}

[Jon]

Hey @chandan988,

Can you share the workflow you have created so far so we can check what you are doing? It would also be nice to know what error you are seeing and what version of n8n are you using.

I can put together an example that writes to MongoDB but it may not be of any use, If you are able to provide the information that has been request that would be a massive help and it will allow us to solve this quickly.

[chandan988]

Basically I have pulled data from Google Sheet, and in REceived Payment data are in Arrary format which will go to MongoDb

[Jon]

Hey @chandan988,

That looks ok to me, Are you seeing an error message at all?