MySQL and Number Data Type in JSON

[harendra]

I am trying to add two datapills which is decimal in MySQL and Number in my JSON Format input schema in My recipe while making API Calls

, but somehow its not able to add, i even tried formula mode, how to resolve this?

[deepak23shastri]

It looks like you’re trying to add these values in the totalBalance field. One of them is null and you can’t add null and a number. You would have to write the formula
(totalBalance.present? ? totalBalance : 0) + (deposit amount.present? ? Deposit amount : 0)

[deepak23shastri]

That should fix it

[harendra]

Thank you, Problem Solved.

[roland-daane]

It looks like you’re updating with a NULL value which isn’t allowed.

If you accumulate the data to a table, then you can check that table to find out.

[harendra]

Okay Roland, My issue is resolved but I will try that too. Thank You.