error Bigquery-Appsheet "Value of type System.Int64 cannot be used for a parameter of type Numeric"

[Ruxandra]

Hello!

I have an app in Appsheet based on Bigquery tables; when I save the form in order to write data in my Bq table, I receive this error message: "Unable to add row to table 'bq_pv_santiereinterne'. → Value of type System.Int64 cannot be used for a parameter of type Numeric".

I don't understand which and where is the issue.

Could someone give me some ideas which is the problem?

Thank you!

Regards!

Ruxandra 

[jaia · Accepted solution]

Hello,

You have mixed incompatible types between your AppSheet table columns and the the BigQuery table.  It is unfortunate that the naming conventions amongst systems are not consistent.

To match things up correctly:

AppSheet Type		BigQuery Type
Number	=	INTEGER
Decimal	=	NUMERIC
Price	=	NUMERIC
Date	=	DATE
Time	=	TIME
DateTime	=	DATETIME
Yes/No	=	BOOLEAN
Ref	=	STRING
Enum	=	STRING
EnumList	=	STRING
Text	=	STRING
LongText	=	STRING
*Duration	=	STRING
I believe all others (yet to test)	=	STRING

*I have found Duration to be problematic.  Although there is a DURATION type in BigQuery, AppSheet does not appear to transform correctly to the BiqQuery type.  Additionally, it doesn't seem that a STRING value from BigQuery is converted into Aduration at read time.  I have needed to store/read durations as Text/STRINGS and then use a Virtual Column defined as type Duration to convert the Text column to a Duration.  I have not re-tested in recent months to see if this has been addressed.

[jaia · Accepted solution]

Hello,

You have mixed incompatible types between your AppSheet table columns and the the BigQuery table.  It is unfortunate that the naming conventions amongst systems are not consistent.

To match things up correctly:

AppSheet Type		BigQuery Type
Number	=	INTEGER
Decimal	=	NUMERIC
Price	=	NUMERIC
Date	=	DATE
Time	=	TIME
DateTime	=	DATETIME
Yes/No	=	BOOLEAN
Ref	=	STRING
Enum	=	STRING
EnumList	=	STRING
Text	=	STRING
LongText	=	STRING
*Duration	=	STRING
I believe all others (yet to test)	=	STRING

*I have found Duration to be problematic.  Although there is a DURATION type in BigQuery, AppSheet does not appear to transform correctly to the BiqQuery type.  Additionally, it doesn't seem that a STRING value from BigQuery is converted into Aduration at read time.  I have needed to store/read durations as Text/STRINGS and then use a Virtual Column defined as type Duration to convert the Text column to a Duration.  I have not re-tested in recent months to see if this has been addressed.

[Spitfire]

@jaia Question, Percent=Numeric?

This is great information.  I have been running all my tables with Float for instead of numeric, we will get on changing that.  

[jaia]

Hello,

Thank you for your engagement regarding this issue. We haven’t heard back from you regarding this issue for sometime now. Hence, I'm going to close this issue which will no longer be monitored. However, if you have any new issues, Please don’t hesitate to create a new issue. We will be happy to assist you on the same.

Regards,
Jai Ade

[Ruxandra]

Hello!

I also had a topic on Appsheet where I received the answer. Thank you! It's ok to close the topic.