APIs & Integrations

eibach-cv
Contributor

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

SOLVE

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"
        },

 

 

0 Upvotes
1 Accepted solution
eibach-cv
Solution
Contributor

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

SOLVE

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.

View solution in original post

2 Replies 2
dennisedson
HubSpot Product Team
HubSpot Product Team

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

SOLVE

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

0 Upvotes
eibach-cv
Solution
Contributor

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

SOLVE

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.