TimeZone in REST API

Status: Reported

Description
From: Eivind Fasting

When using DatabaseTableAgent to set consent (and possibly other things), the timezone specified in the object is ignored (?). 
Steps to reproduce:

Request1:

POST {{webapi_url}}v1/Agents/DatabaseTable/Upsert
body: 

{   "Tablename": "consentperson",   "Columns": [     "person_id",     "consentPurpose_id",     "legalBase_id",     "consentSource_id",     "updated",     "registered"   ],   "Keys": [     "person_id",     "consentPurpose_id"   ],   "Data": [     [       1,       "2",       7,       7,       "2023-10-24T14:40:40Z",       "2023-10-24T14:38:40Z"     ]   ] }

Notice that the update and registered date is specified to Zulu time, which is the military designation for UTC. 

Request2: 
POST {{webapi_url}}v1/Agents/Person/GetConsentInfos 
Header: SO-TimeZone: UTC, includeTZOffset
body: 
{    "PersonId""1"}

Response:

{
  "ConsentPersonId": 24,
  "Comment": "",
  "Registered": "2023-10-24T16:38:40Z",
  "RegisteredAssociateId": 18,
  "Updated": "2023-10-24T16:40:40Z",
  "UpdatedAssociateId": 0,
  "LegalBaseId": 7,
  "LegalBaseKey": "WITHDRAWN",
  "LegalBaseName": "NO:\"Trukket tilbake\";IT:\"Ritirato\";PL:\"Wycofana\";JP:\"  \";CN:\"  \";FR:\"Annul \";CZ:\"Zruaeno\";SP:\"Retirado\";SW:\" terkallat\";NL:\"Ingetrokken\";DA:\"Trukket tilbage\";FI:\"Poistettu\";GE:\"Widerrufen\";US:\"Withdrawn\";RU:\"B>720=>\"",
  "ConsentPurposeId": 2,
  "ConsentPurposeKey": "EMARKETING",
  "ConsentPurposeName": "US:\"E-marketing\";GE:\"E-Marketing\"",
  "ConsentSourceId": 7,
  "ConsentSourceKey": "IMPORT",
  "ConsentSourceName": "NO:\"Import\";IT:\"Importazione\";PL:\"Import\";JP:\"r   p \";CN:\" e\";FR:\"Importation\";CZ:\"Import\";SP:\"Importaci n\";SW:\"Import\";NL:\"Import\";DA:\"Import\";FI:\"Tuonti\";GE:\"Import\";US:\"Import\";RU:\"@B\"",
  "TableRight": null,
  "FieldProperties": {}
}




Based on testing it looks like the initial POST ignores the timezone specified in the body, and it converts it 'to base timezone' before archive. Inside SuperOffice the updated-date looks to be way off: 

There is no Timezone configured on this tenant, and that might be the root issue, but it is also not possible to actually activate timezone as the dropdown is empty:

Comments
Details
Issue id 48726
Registered 31 Oct 2023
Last modified 17 Nov 2023
Severity Medium
Area Sales
Status Reported
Target release
Type Bug
Related Bugs