Using the inbound REST API, is it possible to specify date values in GMT time?

kevingoerlitz
Kilo Explorer

‎07-08-2015 03:12 PM

Using the inbound REST API, is it possible to specify date values in GMT time (preferably using ISO 8601 format)?   Or do I have to use the javascript:gs.dateGenerate() function which apparently requires the date/time to be specified in the timezone specified in the user's profile?

Labels:
0 Helpfuls
  • 1,607 Views
2 REPLIES 2

pankaj_puniani
ServiceNow Employee
ServiceNow Employee

‎01-29-2016 02:36 PM

For inbound REST Table API, if query parameter 'sysparm_input_display_value' is set to false (I think it's default), date value will be inserted into database as it's specified in request body. Date values are stored in GMT, so yes if you specify date values in GMT, it will be inserted as GMT if above mentioned parameter is false. However if parameter 'sysparm_input_display_value' is true, API will assume that date value is in user time zone and convert it into GMT before storing it.


Chris Swetnam
Tera Contributor

‎01-27-2020 10:18 AM

Thank you @pankaj_puniani !

Adding api/now/table/table_name?sysparm_input_display_value=true to the end of your POST will use the sys_user's time zone. 

0 Helpfuls