Hello,
im importing an SQL Tbale to the Commom Data Service.
If the Date Value is NULL ins SQL this results in following values in the flow:
Text
{ "ID": 3,
"DecTest": 3.67,
"Inttest": null,
"Datum": "" }
The date NULL value reults not in an null value, but in an empty string.
This cannot be imported in the CDS:
{ "status": 400, "message":
"Cannot convert the literal '' to the expected type 'Edm.DateTimeOffset'.",
"source": "rts-connector.powerapps.com" }
Would be great if this would be working dirctly without programming workarounds.
{ "status": 400, "message": "Cannot convert the literal '' to the expected type 'Edm.DateTimeOffset'.", "source": "rts-connector.powerapps.com" }
Regards
Dieter
