topic Re: Unable to populate Date picker value using the API "Error Bad request" in APIs & Integrations

Unable to populate Date picker value using the API "Error Bad request"

johnjohn123123 — Thu, 31 Oct 2019 13:47:43 GMT

We have created a property for our compnay named "TPS Update Date" of type DatePicker as follow:-

but when i try to populate this property using the API i will get this error:-

The remote server returned an error: (400) Bad Request

here is a sample of the passed JSON which will raise the error:-

"[{\"objectId\":****,\"properties\":[{\"name\":\"email_gateway\",\"value\":\"******\"},{\"name\":\"website_gateway\",\"value\":\"****.\"},{\"name\":\"mse_scan\",\"value\":\"No\"},{\"name\":\"mse_status\",\"value\":\"****.\"},{\"name\":\"tps_update_date\",\"value\":\"1572525038454\"},{\"name\":\"tps\",\"value\":\"Allowed\"}]}]"

while if i remove the

{\"name\":\"tps_update_date\",\"value\":\"1572525038454\"}

property from the JSON i will be able to update the record. and i am converting the date inside our c# application to unix based ..so the value i am passing will be 1572525038454 (as shown in the above json)..

so i am not sure why this is not working for me?

Re: Unable to populate Date picker value using the API "Error Bad request"

IsaacTakushi — Mon, 04 Nov 2019 21:34:02 GMT

Hi, @johnjohn123123.

Apologies for the delayed response.

I do not see a company property with the internal name tps_update_date in your account with the Hub ID ending in 0966. Am I looking in the correct account or did you delete the property?

Also, could you share a request URL you were testing with? (For example: https://api.hubapi.com/companies/v2/companies/1234567.) Please remove any hapikey values.

Re: Unable to populate Date picker value using the API "Error Bad request"

johnjohn123123 — Tue, 05 Nov 2019 10:51:11 GMT

Thanks for the reply. i am developing an console application for 3rd party compnay.. so do you need their ID? and can i send it in a confidentail way?

here is the c# code to intigrate with the API:-

using (WebClient wc = new WebClient())
         {
               string url = "https://api.hubapi.com/companies/v1/batch-async/update?hapikey=******";
               Uri uri = new Uri(url);
               wc.Encoding = System.Text.Encoding.UTF8;
               wc.Headers.Add(HttpRequestHeader.ContentType, "application/json");
               var apiupdateresults = wc.UploadString(uri, data);
               Console.WriteLine("Api update results= " + apiupdateresults);
         }

Re: Unable to populate Date picker value using the API "Error Bad request"

IsaacTakushi — Tue, 05 Nov 2019 12:57:27 GMT

Sure, could you direct message it to me? Also, do you have an object ID you've been testing with that I could also use?

Re: Unable to populate Date picker value using the API "Error Bad request"

johnjohn123123 — Tue, 05 Nov 2019 13:47:50 GMT

Hi @IsaacTakushi

I just send you a message with all the info you asked for.

Thanks for your help

Re: Unable to populate Date picker value using the API "Error Bad request"

johnjohn123123 — Wed, 06 Nov 2019 11:50:06 GMT

Hi @IsaacTakushi , did you have the chance to check the above ?

Thanks

Re: Unable to populate Date picker value using the API "Error Bad request"

IsaacTakushi — Wed, 06 Nov 2019 20:08:30 GMT

Apologies for the delayed response, @johnjohn123123.

Thank you for sending that information along!

It looks like the tps_update_date property in that account has the type: "date" instead of datetime.

As mentioned in this article, properties with a type of date only accept UNIX millisecond timestamps at midnight UTC: "If you try to set a value that is not midnight UTC, you will receive an error."

In your first post, you shared the timestamp value 1572525038454, which is not at UTC midnight. If you send 1572480000000 instead, the date field should accept it.

Alternatively, you can change the tps_update_date property to be the type: "datetime" with this endpoint. See the example below:

PUT

https://api.hubapi.com/properties/v1/companies/groups/named/tps_update_date?hapikey=key

{
  type: "datetime"
}

If tps_update_date property is datetime, then it will accept 1572525038454.

Re: Unable to populate Date picker value using the API "Error Bad request"

johnjohn123123 — Thu, 07 Nov 2019 14:04:01 GMT

Hi Isaac,

thanks for the helpful reply. i fix this by converting the Date instead of the DateTime inside my code, and now i am able to populate the date picker value through the API.

Re: Unable to populate Date picker value using the API "Error Bad request"

tkoseoglu — Thu, 24 Oct 2024 01:17:51 GMT

Thank you. Following your advice, I was able to POST to the HS API by converting my C# DateTime to a UNIX long. (17533348999)

But now, when reading that exact same property FROM the HS API (instead of POSTing to it) the data in the property is now "2024-10-01". Needless to say, I am not able to parse it into my original custom data type with has a property of type long?. How are we supposed to handle that?