Data types

The following table describes the supported QuickBooks Online data types and their mapping to the Python data types. The type codes returned in the description cursor attribute can be used in the addtypecast() cursor method.

QuickBooks Online data type	Type code	Python data type
Boolean	3004	bool
Date	3006	datetime.date
DateTime	3007	datetime.datetime
Decimal	3008	float
Integer	3012	int
String	3017	str
Enum	3017	str
Array	3017	str

Request Support

Python Connectors Forum

Provide Feedback