+Philip Garrett [Appsheet] +Praveen Seshadri ...

(Levent KULAÇOĞLU) #1

@Philip_Garrett_Appsh @praveen Regarding AppSheet RESTful API connection, which timezone IDs we should be using? It’s by-default “Pacific Standard Time” but if I try to change it to i.e. Europe/Istanbul or GMT+3 or GMT+03:00 or even to UTC+3, I get the similar error like below:

{

“Message”: “An error has occurred.”,

“ExceptionMessage”: “Internal error: ‘TimeZones’ does not contain entry for TimeZoneId ‘Europe/Istanbul’.”,

“ExceptionType”: “Jeenee.DataTypes.SpreadsheetException”,

“StackTrace”: "

at Jeenee.DataTypes.TimeZones.GetTimeZoneInfoByID(String timeZoneId) in q:\git\Jeenee\DataTypes\Locale\TimeZones.cs:line 158\r\n

at Jeenee.DataTypes.TimeZones.GetTzOffset(String timeZoneId) in q:\git\Jeenee\DataTypes\Locale\TimeZones.cs:line 168\r\n

at Nirvana.source.api.BaseAPIController.LogStart(LogOperation logOperation, String appTemplateName, Dictionary`2 properties, String data) in q:\git\Jeenee\Nirvana\Controllers\API\BaseAPIController.cs:line 63\r\n

at Nirvana.source.api.PublicAPIController.RestApi_Invoke(String appId, String tableName, JObject data) in q:\git\Jeenee\Nirvana\Controllers\API\PublicAPIController.cs:line 374\r\n

at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.b__9(Object instance, Object[] methodParameters)\r\n

at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n— End of stack trace from previous location where exception was thrown —\r\n

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n

at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n

at System.Web.Http.Controllers.ApiControllerActionInvoker.d__0.MoveNext()\r\n— End of stack trace from previous location where exception was thrown -\r\n

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n

at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n

at System.Web.Http.Controllers.ActionFilterResult.d__2.MoveNext()\r\n— End of stack trace from previous location where exception was thrown -\r\n

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n

at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n

at System.Web.Http.Dispatcher.HttpControllerDispatcher.d__1.MoveNext()" }

(Aleksi Alkio) #2

I believe you should “Turkey Standard Time”

(Levent KULAÇOĞLU) #3

Thnx @Aleksi_Alkio I will give it a try

(Levent KULAÇOĞLU) #4

@Aleksi_Alkio @Philip_Garrett_Appsh I confirm that " Turkey Standard Time " is working as a valid key pair value with Timezone parameter in the JSON payload