ERROR DECLARING DATEFORMAT IN ZOHO ANALYTICS

ERROR DECLARING DATEFORMAT IN ZOHO ANALYTICS

I am using the Zoho Analytics API (https://www.zoho.com/analytics/api/v2/data-api/add-row.html) and, as mentioned in the documentation, to record date and time data, the data must be formatted if you want to store it in a custom format. By default, the format is "yyyy-MM-dd HH:mm:ss". However, if I try to insert a date in the format "dd-MM-yyyy HH:mm:ss", the following error is displayed:

  1. {
  2.     "result": {
  3.         "summary": "INVALID_DATE_VALUE",
  4.         "data": {
  5.             "errorMessage": "Given date value '03-07-2024 13:40:29' is not in proper date format",
  6.             "errorCode": 7514
  7.         },
  8.         "status": "failure"
  9.     },
  10.     "code": 3000
  11. }
This appears to be correct to me.

But if we send data with the format "yyyy-MM-dd HH:mm" and we have customized the "dateFormat" key parameter to "dd-MM-yyyy HH:mm", it is allowing to store and update the data. This should not happen, as it should show the same error as above.

@analytics