[CONNECTORS-1275] ES connector doesn't deal with dates properly

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: ManifoldCF 2.3
• Fix Version/s: ManifoldCF 2.4
• Component/s: Elastic Search connector
• Assignee: Karl Wright
• Reporter: Karl Wright
• Created: 11/Feb/16 00:19
• Updated: 05/Apr/16 05:31
• Resolved: 05/Apr/16 05:31

Description

The ES connector does not fill in JSON dates in the proper format. For example:

{
  "took": 4,
  "timed_out": false,
  "_shards": {
    "total": 6,
    "successful": 6,
    "failed": 0
  },
  "hits": {
    "total": 1,
    "max_score": 0.15342641,
    "hits": [
      {
        "_index": "index",
        "_type": "sharepoint",
        "_id": "http://sample.net/Lists/mylist/DispForm.aspx?ID=1",
        "_score": 0.15342641,
        "_source": {
          "Modified": "2016-02-09 12:35:56", // <--- Wrong type, should be Date
          "App Created By": "",
          "GUID": "{D233EA70-CFA7-42DD-8243-AG5BDA3D475B}",
          "Title": "lorem ipsum bacon",
          "Edit": "",
          "App Modified By": "",
          "Attachments": "0",
          "Item Child Count": "",
          "Created": "2016-02-09 12:35:56",
          "Modified By": "",
          "Folder Child Count": "",
          "Type": "",
          "Version": "",
          "Content Type": "", // <-- Missing
          "Created By": "", // <- Missing
          "ID": "1",
          "allow_token_document": "AD+Authority+Group:",
          "deny_token_document": "AD+Authority+Group:DEAD_AUTHORITY",
          "allow_token_share": "__nosecurity__",
          "deny_token_share": "__nosecurity__",
          "allow_token_parent": "__nosecurity__",
          "deny_token_parent": "__nosecurity__",
          "contentfield": ""
        }
      }
    ]
  }
}

Not sure what the proper format is yet. AndreyL, can you fill this in?