I have the following document with id in the form namespace.GUID, so for example:
RAMSOFT.AUDIT.STUDYACCESS.00485ff354cd491a9044aa6143608fa5
The document content as shown on the screen when I fetch it via couchbase admin console contains a field accesstime, which is in this format:
"accesstime": "2014-11-28T11:01:18",
When I read the data via the .NET sdk, I see a transformation occurring where the T is changed to a space:
"2014-11-28 11:01:18"
When I read the same data via the Python client (using my n1ql query runner tool), the T has not been transformed to a space:
select studydatetime from `default` where authtag = '783E12AE07ECED7E199490C1CF268799'
and _document_type = 'STUDYACCESS'
{'studydatetime': '2014-11-28T11:30:00'}
So why does the .NET bucket.Get(id).Value (which is a Newtonsoft.Json.Linq.JContainer) get transformed?
What other magic transforms or JSON rewrite rules should I be aware of?
Warren