Unable to Sync closedate - Error: 2020-11-05 08:03:25 was not a valid long

Developer Support APIs & Integrations
1

Trying to send a DEAL sync message with createddate and closedate, but I am getting an error that the date I’m sending is an invalid long, even though the documentaiton in the properties says its supposed to be a datetime.

My sync request looks like this:

 {
 "storeId": "eib-wsm",
 "objectType": "DEAL",
 "messages": [
 {
 "action": "UPSERT",
 "externalObjectId": "831718",
 "properties": {
 "dealstage": "processed",
 "amount": "67.34",
 "dealname": "831718",
 "tax": "4.34",
 "closedate": "2020-11-05 08:03:25",
 "createdate": "2020-11-03 01:04:19"
 },
 "associations": {
 "CONTACT" : [
 "*****@gmail.com"
 ]
 }
 }
 ]
 }

The error message says:

{
 "portalId": 8172849,
 "storeId": "eib-wsm",
 "objectType": "DEAL",
 "externalObjectId": "831718",
 "changedAt": 1605025670878,
 "erroredAt": 1605025680755,
 "type": "UNKNOWN_ERROR",
 "details": "Error performing[UPDATE] DEAL[eib-wsm__831718] for portal 8172849, error was [8172849] update failed - java.util.concurrent.CompletionException: com.hubspot.apicaller.exceptions.ApiErrorResponseException: Api[name=deals, subPath=/deals/v2/deals/batch] Failed to process your request. Error code was '400'. Error message was:\n{\"validationResults\":[{\"isValid\":false,\"message\":\"2020-11-05 08:03:25 was not a valid long. Portal 8172849, object type 0-3\",\"error\":\"INVALID_LONG\",\"name\":\"closedate\"},{\"isValid\":false,\"message\":\"2020-11-03 01:04:19 was not a valid long. Portal 8172849, object type 0-3\",\"err",
 "status": "OPEN"
 },
2

Hey @eibach-cv , are you still having issues here?

If you are updating via the Deals API, you will need to use the ISO time format

3

I am using the ecommerce bridge API.

I was able to solve the issue by converting the datetime format to milliseconds. Was unaware this was the value needed because the API says DATETIME.