timezone:
If you have not defined a time zone for this property, America/Los Angeles is the default.
https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/time/task/t_SetASystemTimeZone.html#:~:text=By%20default%2C%20the%20field%20is,Los%20Angeles%20is%20the%20default.&text=Add%20a%20time%20zone%20in,values%2C%20see%20Time%20zone%20representation.
define time zone:
system property -> system
https://www.servicenow.com/community/itsm-forum/how-to-know-the-instance-time-zone/td-p/793187
recordGR.getValue('sys_created_on') -> returns UTC time
recordGR.sys_created_on.getDisplayValue() -> returns user's time
https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/time/task/t_SetASystemTimeZone.html#:~:text=By%20default%2C%20the%20field%20is,Los%20Angeles%20is%20the%20default.&text=Add%20a%20time%20zone%20in,values%2C%20see%20Time%20zone%20representation.
getDisplayValue() will either use user timezone if set or system default time zone in system properties
---------------------------
Servicenow table API:
query by dates:
https://www.servicenow.com/community/developer-forum/rest-api-get-using-greater-than-for-dates/m-p/1676011
https://www.servicenow.com/community/developer-forum/how-to-query-table-with-utc-timestamp/m-p/1639984/page/2
instance time zone :
https://developer.servicenow.com/dev.do#!/reference/api/washingtondc/server_legacy/c_GlideSystemAPI#r_GS-dateGenerate_S_S
dateGenerate
Generates a date and time for the specified date in GMT.
curl "https://fortinetdev.servicenowservices.com/api/now/table/syslog_transaction?sysparm_query=sys_created_on>javascript:gs.dateGenerate('2024-06-13','10:53:00')&sysparm_display_value=true&sysparm_limit=5" \
--request GET \
--header "Accept:application/json" \
--user 'user':'pwd'
# system default timezone of the user -> empty -> system propreties -> system -> PST
https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/time/task/t_SetASystemTimeZone.html#:~:text=By%20default%2C%20the%20field%20is,Los%20Angeles%20is%20the%20default.&text=Add%20a%20time%20zone%20in,values%2C%20see%20Time%20zone%20representation.
query:
https://docs.servicenow.com/bundle/washingtondc-api-reference/page/integrate/inbound-rest/concept/c_TableAPI.html
dates:
https://www.servicenow.com/community/developer-forum/is-there-any-way-to-query-the-rest-api-using-utc-dates/m-p/1431782
display value to true to show request time (PST)
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0789000
created <new_role> role assign to syslog_transcation
add syslog_transaction to allow API call :
https://www.servicenow.com/community/now-platform-forum/why-can-i-not-see-the-syslog-transaction-table-in-the-rest-api/td-p/1057679
glide.ui.permitted_tables
No comments:
Post a Comment