DAB - Column type DateTimeOffset not yet supported

[nihasalangaden]

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": [ "*" ]
}]
}

[Aniruddh25]

Thanks for reporting this issue @nihasalangaden!

It does look like this case was not supported yet - here as per the stack trace:

data-api-builder/src/Service/Parsers/EdmModelBuilder.cs

Line 112 in 2107b7d

case "DateTime":

While a new release with the fix would be out soon, we encourage you to contribute as well following: https://github.com/Azure/data-api-builder/blob/main/CONTRIBUTING.md

[Aniruddh25]

Created issue: #1358 to track this.