• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Formula Mode Questions

Gabriel Burgener

started a topic about 6 years ago

Exception: SQL Statement error: TinyTds::Error: Arithmetic overflow error converting numeric to data type numeric

Hello everyone,


Sourcing my financial data via JSON, I need to convert it into a number format before feeding it into a SQL Server row.

Would anybody know the best formula to convert a string into a number?

When using to_f, I get the following message.

Exception: SQL Statement error: TinyTds::Error: Arithmetic overflow error converting numeric to data type numeric.

However, the data is limited to decimals from 0.01 to 99.99.

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count