+ Start a Discussion
Kevin GlinskiKevin Glinski 

Platform Connect Illegal datetime format

I'm using the new Platform Connect (I also heard it refered to as Lightning Connect at dreamforce) and I have an external sql view that is exposed via a WCF web service to expose it in OData format.  I have a couple tables working, but this one returns a datetime in the Id and I'm getting the error. 

We encountered an unexpected error. Try again later, or contact your administrator, who can verify the external data source settings and server availability. Error received: Illegal datetime format 2014-09-17T09%3A00%3A00

Should Salesforce be able to handle the url having %3A instead of a : in the ID, or is there a way for that to not be encoded in the ID?

Here is an example ID returned by the service
<id>https://myserver/CicDataService.svc/IWrkgrpQueueStats(cHKey3='%2A',cHKey4='%2A',cName='407ETR',ConfigurationSet=-2147483648,cReportGroup='%2A',cType='W',DimensionSet=-2147477149,dIntervalStart=datetime'2014-10-06T15%3A30%3A00',I3TimeStampGMT=datetime'2014-10-06T20%3A00%3A00',nDuration=1800,nServiceLevel=0,SchemaMajorVersion=4,SchemaMinorVersion=0,SiteId=1,StatisticsSet=-2139396932,SubSiteId=0)</id>

 
ShashankShashank (Salesforce Developers) 
It seems like an odata related issue: http://tridion.stackexchange.com/questions/5658/how-to-modify-attribute-types-for-the-content-delivery-web-service