topic MySQL and Number Data Type in JSON in Workato Pros Discussion Board

MySQL and Number Data Type in JSON

harendra — Thu, 06 Jan 2022 17:42:07 GMT

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?

Re: MySQL and Number Data Type in JSON

pluitel — Thu, 06 Jan 2022 18:34:20 GMT

Looks like an issue with the formula you're using. Can you share it in the thread?

Re: MySQL and Number Data Type in JSON

deepak23shastri — Thu, 06 Jan 2022 20:49:24 GMT

It looks like the pill you’ve mapped has empty string. You could use null safe expression “&” to resolve it. What formula are you using can you post a picture of your input data mapping and the formula?

Re: MySQL and Number Data Type in JSON

harendra — Thu, 06 Jan 2022 21:04:11 GMT

Here

Re: MySQL and Number Data Type in JSON

harendra — Thu, 06 Jan 2022 21:04:24 GMT

Here

Re: MySQL and Number Data Type in JSON

deepak23shastri — Thu, 06 Jan 2022 21:09:29 GMT

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)

Re: MySQL and Number Data Type in JSON

deepak23shastri — Thu, 06 Jan 2022 21:09:36 GMT

That should fix it

Re: MySQL and Number Data Type in JSON

roland-daane — Fri, 07 Jan 2022 00:12:04 GMT

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.

Re: MySQL and Number Data Type in JSON

harendra — Fri, 07 Jan 2022 15:11:28 GMT

Thank you, Problem Solved.

Re: MySQL and Number Data Type in JSON

harendra — Fri, 07 Jan 2022 15:30:32 GMT

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