Update Table Row

description updates a specific row in a servicenow table using sys id, with options for display value settings endpoint url api/now/v2/table/{{tablename}}/{{sys id}} method patch inputs path parameters (object) – required tablename (string) – required table name sys id (string) – required sys id of the record to be updated parameters (object) sysparm display value (boolean) – required determines the type of data returned, either the actual values from the database or the display values of the fields sysparm input display value (boolean) – required flag that indicates whether to set field values using the display value or the actual value json body (object) – required comments (string) output example \[ { "status code" 200, "response headers" { "server timing" "sem wait;dur=0, sesh wait;dur=0", "content encoding" "gzip", "x is logged in" "true", "x transaction id" "c2e8b1909703", "x content type options" "nosniff", "pragma" "no store,no cache", "cache control" "no cache,no store,must revalidate,max age= 1", "expires" "0", "content type" "application/json;charset=utf 8", "transfer encoding" "chunked", "date" "fri, 04 nov 2022 22 29 20 gmt", "keep alive" "timeout=20", "connection" "keep alive", "server" "servicenow", "set cookie" "glide user=; max age=0; expires=thu, 01 jan 1970 00 00 10 gmt; path=/; httponly; samesite=none; secure, glide user session=; max age=0; expires=thu, 01 jan 1970 00 00 10 gmt; path=/; httponly; samesite=none; secure, glide user route=glide f6d1c4085a807931391acf9b7192b09e; max age=2147483647; expires=thu, 23 nov 2090 01 43 27 gmt; path=/; httponly; samesite=none; secure, glide session store=8ee8b5509703111084d57e121153af4b; max age=1800; expires=fri, 04 nov 2022 22 59 20 gmt; path=/; httponly; samesite=none; secure", "strict transport security" "max age=63072000; includesubdomains" }, "reason" "ok", "json body" { "result" { "parent" "", "made sla" "true", "caused by" "", "watch list" "", "upon reject" "cancel all future tasks", "sys updated on" "2022 11 04 15 29 20", "child incidents" "0", "hold reason" "", "origin table" "", "task effective number" "inc0000060", "approval history" "", "number" "inc0000060", "resolved by" { "display value" "david loo", "link" "https //dev130168 service now\ com/api/now/v2/table/sys user/5137153cc611227c000bbd1bd8cd2007" }, "sys updated by" "admin", "opened by" { "display value" "joe employee", "link" "https //dev130168 service now\ com/api/now/v2/table/sys user/681ccaf9c0a8016400b98a06818d57c7" }, "user input" "", "sys created on" "2016 12 12 07 19 57", "sys domain" { "display value" "global", "link" "https //dev130168 service now\ com/api/now/v2/table/sys user group/global" }, "state" "closed", "route reason" "", "sys created by" "employee", "knowledge" "false", "order" "", "calendar stc" "102,197", "closed at" "2016 12 13 18 46 44", "cmdb ci" { "display value" "storage area network 001", "link" "https //dev130168 service now\ com/api/now/v2/table/cmdb ci/109562a3c611227500a7b7ff98cc0dc7" }, "delivery plan" "", "contract" "", "impact" "2 medium", "active" "false", "work notes list" "", "business service" { "display value" "email", "link" "https //dev130168 service now\ com/api/now/v2/table/cmdb ci service/27d32778c0a8000b00db970eeaa60f16" }, "business impact" "", "priority" "3 moderate", "sys domain path" "/", "rfc" "", "time worked" "", "expected start" "", "opened at" "2016 12 12 07 19 57", "business duration" "8 hours", "group list" "", "work end" "", "caller id" { "display value" "joe employee", "link" "https //dev130168 service now\ com/api/now/v2/table/sys user/681ccaf9c0a8016400b98a06818d57c7" }, "reopened time" "", "resolved at" "2016 12 13 13 43 14", "approval set" "", "subcategory" "email", "work notes" "2016 12 12 16 56 57 beth anglin (work notes)\nupdating priority as workaround for incident has been provided \n\n2016 12 12 09 57 00 beth anglin (work notes)\nincreasing priority as this incident is affecting more number of users\n\n2016 12 12 09 01 24 beth anglin (work notes)\nupdating incident with correct configuration item\n\n", "universal request" "", "short description" "unable to connect to email", "close code" "solved (permanently)", "correlation display" "", "delivery task" "", "work start" "", "assignment group" { "display value" "network", "link" "https //dev130168 service now\ com/api/now/v2/table/sys user group/287ebd7da9fe198100f92cc8d1d2154e" }, "additional assignee list" "", "business stc" "28,800", "cause" "", "description" "i am unable to connect to the email server it appears to be down ", "origin id" "", "calendar duration" "1 day 4 hours 23 minutes", "close notes" "this incident is resolved ", "notify" "do not notify", "service offering" "", "sys class name" "incident", "closed by" { "display value" "joe employee", "link" "https //dev130168 service now\ com/api/now/v2/table/sys user/681ccaf9c0a8016400b98a06818d57c7" }, "follow up" "", "parent incident" "", "sys id" "1c741bd70b2322007518478d83673af3", "contact type" "self service", "reopened by" "", "incident state" "closed", "urgency" "2 medium", "problem id" "", "company" { "display value" "acme north america", "link" "https //dev130168 service now\ com/api/now/v2/table/core company/31bea3d53790200044e0bfc8bcbe5dec" }, "reassignment count" "2", "activity due" "2016 12 12 17 26 36", "assigned to" { "display value" "david loo", "link" "https //dev130168 service now\ com/api/now/v2/table/sys user/5137153cc611227c000bbd1bd8cd2007" }, "severity" "3 low", "comments" "2022 11 04 15 29 20 system administrator (additional comments)\ntest\n\n2022 11 04 15 28 12 system administrator (additional comments)\ntest\n\n2022 11 04 15 21 53 system administrator (additional comments)\ntest\n\n2022 11 04 15 21 03 system administrator (additional comments)\ntest\n\n2016 12 13 12 30 14 joe employee (additional comments)\nhi david, \nthat must be it i was on phone calls at all three of those times and must not have had any activity on my computer please close this incident \n\n2016 12 13 10 42 25 david loo (additional comments)\nhi joe,\ni've checked in network logs and you were timed out from the vpn at 9 25am, 10 42am and 2 28pm these three times coincide with entries in the exchange server logs showing you lost connection at those same times the vpn policy is to time out a connection if it hasn't been active in 30 minutes please ensure the next time you lose connectivity you are still\u00a0connected to the vpn \n\ni'm going to update this incident to resolved please let me know if you need any more assistance \n\n2016 12 13 07 53 01 joe employee (additional comments)\nhi david,\nthank you! i use the corporate vpn and was also unable to connect to the email server at 9 30am and 10 45am \n\n2016 12 13 06 43 17 david loo (additional comments)\nhi joe,\nmy name is david \u00a0i'll be assisting you with this incident can you confirm which vpn you have been using today?\u00a0i also see you were having this issue at 2 30pm were there any other times you can recall you had issues connecting to the email?\n\n2016 12 12 16 56 57 beth anglin (additional comments)\nhi joe, \nas per discussion on call, workaround has been provided and it has worked for you i have verified with the exchange team we haven't had an issue with the email server today i'm going to assign this issue to the network team for further investigation \n\n2016 12 12 12 43 50 joe employee (additional comments)\nhi beth,\nyes, i'm connected to the vpn, although i've had to reconnect to it a couple of times the last time i was unable to connect was 2 30pm \n\n2016 12 12 10 52 42 beth anglin (additional comments)\nhi joe, \nare you connected to the vpn when you're having this issue? can you identify a specific time you were unable to connect to email?\n\n2016 12 12 08 30 49 beth anglin (additional comments)\nhi joe, \nmy name is beth and i'll be assisting you with your issue \n\n2016 12 12 07 19 57 joe employee (additional comments)\ni am unable to connect to the email server it appears to be down \n\n", "approval" "not yet requested", "sla due" "unknown", "comments and work notes" "2022 11 04 15 29 20 system administrator (additional comments)\ntest\n\n2022 11 04 15 28 12 system administrator (additional comments)\ntest\n\n2022 11 04 15 21 53 system administrator (additional comments)\ntest\n\n2022 11 04 15 21 03 system administrator (additional comments)\ntest\n\n2016 12 13 12 30 14 joe employee (additional comments)\nhi david, \nthat must be it i was on phone calls at all three of those times and must not have had any activity on my computer please close this incident \n\n2016 12 13 10 42 25 david loo (additional comments)\nhi joe,\ni've checked in network logs and you were timed out from the vpn at 9 25am, 10 42am and 2 28pm these three times coincide with entries in the exchange server logs showing you lost connection at those same times the vpn policy is to time out a connection if it hasn't been active in 30 minutes please ensure the next time you lose connectivity you are still\u00a0connected to the vpn \n\ni'm going to update this incident to resolved please let me know if you need any more assistance \n\n2016 12 13 07 53 01 joe employee (additional comments)\nhi david,\nthank you! i use the corporate vpn and was also unable to connect to the email server at 9 30am and 10 45am \n\n2016 12 13 06 43 17 david loo (additional comments)\nhi joe,\nmy name is david \u00a0i'll be assisting you with this incident can you confirm which vpn you have been using today?\u00a0i also see you were having this issue at 2 30pm were there any other times you can recall you had issues connecting to the email?\n\n2016 12 12 16 56 57 beth anglin (additional comments)\nhi joe, \nas per discussion on call, workaround has been provided and it has worked for you i have verified with the exchange team we haven't had an issue with the email server today i'm going to assign this issue to the network team for further investigation \n\n2016 12 12 16 56 57 beth anglin (work notes)\nupdating priority as workaround for incident has been provided \n\n2016 12 12 12 43 50 joe employee (additional comments)\nhi beth,\nyes, i'm connected to the vpn, although i've had to reconnect to it a couple of times the last time i was unable to connect was 2 30pm \n\n2016 12 12 10 52 42 beth anglin (additional comments)\nhi joe, \nare you connected to the vpn when you're having this issue? can you identify a specific time you were unable to connect to email?\n\n2016 12 12 09 57 00 beth anglin (work notes)\nincreasing priority as this incident is affecting more number of users\n\n2016 12 12 09 01 24 beth anglin (work notes)\nupdating incident with correct configuration item\n\n2016 12 12 08 30 49 beth anglin (additional comments)\nhi joe, \nmy name is beth and i'll be assisting you with your issue \n\n2016 12 12 07 19 57 joe employee (additional comments)\ni am unable to connect to the email server it appears to be down \n\n", "due date" "", "sys mod count" "19", "reopen count" "0", "sys tags" "", "escalation" "normal", "upon approval" "proceed to next task", "correlation id" "", "location" "", "category" "inquiry / help" } } } ] output parameters status code (number) reason (string) json body (object) result (object) parent (string) made sla (string) caused by (string) watch list (string) upon reject (string) sys updated on (string) child incidents (string) hold reason (string) origin table (string) task effective number (string) approval history (string) number (string) resolved by (object) display value (string) link (string) sys updated by (string) opened by (object) display value (string) link (string) user input (string) sys created on (string) sys domain (object) display value (string) link (string) state (string) route reason (string) sys created by (string) knowledge (string) order (string) calendar stc (string) closed at (string) cmdb ci (object) display value (string) link (string) delivery plan (string) contract (string) impact (string) active (string) work notes list (string) business service (object) display value (string) link (string) business impact (string) priority (string) sys domain path (string) rfc (string) time worked (string) expected start (string) opened at (string) business duration (string) group list (string) work end (string) caller id (object) display value (string) link (string) reopened time (string) resolved at (string) approval set (string) subcategory (string) work notes (string) universal request (string) short description (string) close code (string) correlation display (string) delivery task (string) work start (string) assignment group (object) display value (string) link (string) additional assignee list (string) business stc (string) cause (string) description (string) origin id (string) calendar duration (string) close notes (string) notify (string) service offering (string) sys class name (string) closed by (object) display value (string) link (string) follow up (string) parent incident (string) sys id (string) contact type (string) reopened by (string) incident state (string) urgency (string) problem id (string) company (object) display value (string) link (string) reassignment count (string) activity due (string) assigned to (object) display value (string) link (string) severity (string) comments (string) approval (string) sla due (string) comments and work notes (string) due date (string) sys mod count (string) reopen count (string) sys tags (string) escalation (string) upon approval (string) correlation id (string) location (string) category (string) response headers header type server timing string content encoding string x is logged in string x transaction id string x content type options string pragma string cache control string expires string content type string transfer encoding string date string keep alive string connection string server string set cookie string strict transport security string