Forum Discussion

Sudip's avatar
Sudip
Frequent Visitor
2 years ago

graphql error message. "message": "Decimal cannot parse the given value of type `System.Single`."

I have created a table in warehouse which have data types String,Int,datetime,Real,decimal.   I am now trying to do a mutation create and insert some records but I have the mentioned error . {  ...
API for GraphQL
data engineering
Sudip's avatar
Sudip
Frequent Visitor
2 years ago

could you provide a example?? like what values need to pass for single or decimal datatype. as i see every positive system.single is like decimal data type. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Sudip 

 

I haven't tested a mutation in GraphQL. I tested with SQL queries to insert some data into a warehouse table. The result is below. 

If I don't define a precision number and scale number for DECIMAL type column when creating a table, the default scale is 0. When inserting decimal numbers to the table, it will round the numbers. If I define a precision number and scale number, it will round numbers to the defined precision and scale. decimal and numeric (Transact-SQL) - SQL Server | Microsoft Learn

May I know which data type is defined for "amount" column in your warehouse table? 

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!