camel salesforce component  has issues with dates less than or equal to
"November 18th  1883".

These dates are serialized  to a format unacceptable to SalesForce.

For example

Date 1800-01-01 is serialized by this component as

1800-01-01T00:00:00.000-05:50:36

Salesforce responds with the following error

{message:'{errors:[{"errorCode":"JSON_PARSER_ERROR","message":"Cannot
deserialize instance of date from VALUE_STRING value
1800-01-01T00:00:00.000-05:50:36 ...

The problem has to do with the seconds in the time zone part (:36 in above
example)

The issue arises because camel salesforce component use the Joda DataTime
library which handles date before "November 18th  1883" in this manner

see here for some discussion on this

https://www.kevinhooke.com/2010/07/23/whats-the-significance-of-nov-18th-1883-to-software-development-in-the-us/
<https://www.kevinhooke.com/2010/07/23/whats-the-significance-of-nov-18th-1883-to-software-development-in-the-us/>
  

or

http://stackoverflow.com/questions/14282423/why-when-year-is-less-than-1884-it-remove-few-milliseconds
<http://stackoverflow.com/questions/14282423/why-when-year-is-less-than-1884-it-remove-few-milliseconds>
  

Maybe the salesforce component should convert the date or date time to
milliseconds format rather than the zoned format. Salesforce  seems to
accept this format





--
View this message in context: 
http://camel.465427.n5.nabble.com/camel-salesforce-component-date-time-issue-tp5784399.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Reply via email to