Available data types in API Connector Framework:
| Name | Type | SQL-type equivalent | Example |
|---|---|---|---|
DT_WSTR
|
string
|
nvarchar
|
"hello world"
|
DT_BOOL
|
boolean
|
bit
|
true
|
DT_I4
|
number
|
int
|
1234567890
|
DT_I8
|
big number
|
bigint
|
12345678901234567890
|
DT_R4
|
real number
|
real
|
1234567890.12345
|
DT_R8
|
big real number
|
float
|
12345678901234567890.12345
|
DT_DECIMAL
|
decimal number
|
decimal
|
1234567890.12345
|
DT_DBTIMESTAMP
|
date and time
|
datetime
|
"2023-01-01T12:00:00"
|
DT_DBDATE
|
date
|
date
|
"2023-01-01"
|
DT_DBTIME
|
time
|
time
|
"12:00:00"
|
DT_DBTIMESTAMPOFFSET
|
date and time with timezone offset
|
datetimeoffset
|
"2023-01-01T12:00:00+00:00"
|
DT_CY
|
currency
|
money
|
1234567890.12345
|
DT_GUID
|
GUID
|
uniqueidentifier
|
"550e8400-e29b-41d4-a716-446655440000"
|
DT_BYTES
|
binary
|
varbinary
|
"0xDEADBEEF"
|