DAB - Column type DateTimeOffset not yet supported

[Aniruddh25]

Discussed in #1356

^{Originally posted by nihasalangaden March 24, 2023}
Hi All,

I was trying this with an existing table , but getting the below error: any thoughts?

dbug: Azure.DataApiBuilder.Service.Services.ISqlMetadataProvider[0]
Logging primary key information for entity: test.
dbug: Azure.DataApiBuilder.Service.Services.ISqlMetadataProvider[0]
Primary key column name: application_id
Primary key mapped name: application_id
Type: Byte
IsNullable: False
IsAutoGenerated: False
fail: Azure.DataApiBuilder.Service.Startup[0]
Unable to complete runtime initialization operations due to:
System.ArgumentException: Column type DateTimeOffset not yet supported.
at Azure.DataApiBuilder.Service.Parsers.EdmModelBuilder.BuildEntityTypes(ISqlMetadataProvider sqlMetadataProvider)
at Azure.DataApiBuilder.Service.Parsers.EdmModelBuilder.BuildModel(ISqlMetadataProvider sqlMetadataProvider)
at Azure.DataApiBuilder.Service.Parsers.ODataParser.BuildModel(ISqlMetadataProvider sqlMetadataProvider)
at Azure.DataApiBuilder.Service.Services.SqlMetadataProvider3.InitODataParser() at Azure.DataApiBuilder.Service.Services.SqlMetadataProvider3.InitializeAsync()
at Azure.DataApiBuilder.Service.Startup.PerformOnConfigChangeAsync(IApplicationBuilder app)
info: Azure.DataApiBuilder.Service.Startup[0]
Loading config file: dab-config.json
fail: Azure.DataApiBuilder.Service.Startup[0]
Exiting the runtime engine...
Table structure is as below:
application_id tinyint
application_cd varchar
application_nm varchar
create_ts datetimeoffset
update_ts datetimeoffset

Config file added like below:
"test": {
"source": {
"type": "table",
"object": "dbo.application_ref",
"key-fields":["application_id"]
},
"rest": {
"methods": [ "get" ]
},
"graphql": {
"operation": "query"
},
"permissions": [{
"role": "anonymous",
"actions": [ "*" ]
}]
}