When you pull the entire document, you get only lower case "id" for both values:
"id": "Entity|12365",
"Id": "Entity|12365",
"Details
When you should see
"id": "Entity|12365",
"Id": 123456
I suspect it's a result of treating known system attributes specially, going to sift through and try and find the issue but thought I would log it in case I can't resolve it.
If I have a document with
"Id": 123455 "id": "Entity|12345"
SELECT a.Id FROM AuditLog AS a
You get:
[ { "Id": null },
When you pull the entire document, you get only lower case "id" for both values: "id": "Entity|12365", "Id": "Entity|12365", "Details
When you should see "id": "Entity|12365", "Id": 123456
I suspect it's a result of treating known system attributes specially, going to sift through and try and find the issue but thought I would log it in case I can't resolve it.