Data types

The following table describes the supported Dynamics 365 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.

Dynamics 365 data type	Type code	Python data type
Binary	3002	binary
Boolean	3004	bool
Currency	3005	float
Floating Point Number	3009	float
Double	3009	float
Decimal Number	3008	float
Date and Time	3007	datetime.datetime
Whole Number	3012	int
Int	3020	int
Long	3021	int
Lookup	3010	str
Owner	3010	str
Unique Identifier	3010	str
Customer	3010	str
GUID	3010	str
Single Line of Text	3017	str
Multiple Lines of Text	3017	str
Option Set	3017	str
MultiSelect Option Set	3017	str
Two Options	3017	str
Status	3017	str
Status Reason	3017	str
Image	3017	str
String	3017	str

Request Support

Python Connectors Forum

Provide Feedback