Mongo Collection double values coming to SendGrid template weirdly

[Lukas_deConantseszn1 (Lukas De Conantsesznak)]

This is how a double value from an array of nested documents gets printed out in SendGrid. I was wondering if anyone has had a similar experience? I am sending the array in my request to SendGrid. Then in the template, I am looping through the array and accessing properties.

I have seen similar strange things happen with MongoDB collection values when they get sent over http.

Anyone had similar experiences? Know a remedy?

[Pavel_Duchovny]

Hi @Lukas_deConantseszn1,

This looks like a response from a realm webhook? Correct me if I am wrong.

If so this is sent as extended json standard where types are represented this way.

You can parse them into plain json before you return them :

JSON.parse(JSON.stringify(doc))

Thanks
Pavel

[Lukas_deConantseszn1 (Lukas De Conantsesznak)]

This data is happening in a realm function that is querying the collection with its atlas service.

[Pavel_Duchovny]

But how is the client access the data? Is it a web sdk or a webhook url?

[Lukas_deConantseszn1 (Lukas De Conantsesznak)]

Realm function runs once a day, queries data, then sends it in an API request to SendGrid. SendGrid email template then reads the data like this.

[Pavel_Duchovny]

You use http service to send data? Have you used the encodeBodyAsJson flag,?

Have you tried to parse it to json before ?

Thanks
Pavel

[Lukas_deConantseszn1 (Lukas De Conantsesznak)]

I use context.http.post and I use encodeBodyAsJson set to true.

I tried the JSON.Stringify JSON.Parse thing and it sadly didn’t work. I’m going to try to parseFloat on the value itself next.

[Lukas_deConantseszn1 (Lukas De Conantsesznak)]

I switched to using axios in my realm function. context.http just has problems