JSON cast a text value to a number

Issue Summary

When using the JSON data source and querying an API can you can’t cast a text value to a number. I have tried using a Query data source to query the results and casting the text value to a number but it fails and returns only zeros. The same happens for most SQL functions.

Technical details:

  • Redash Version: 8.0.0+b32245 (a16f551e)
  • Browser/OS: Chrome
  • How did you install Redash: Docker

Can you please provide an example that we can investigate / debug?

I was able solve the issue by cleaning the text value of none numeric characters then casting it. The values included $ and ,. Once removed casting worked as expected.