Get Table

description retrieves records from a specified servicenow table using the 'tablename' path parameter endpoint url api/now/v2/table/{{tablename}} method get inputs path parameters (object) – required tablename (string) – required name of the table from which to retrieve the records parameters (object) name value pairs (object) active (string) assigned to (string) state (string) sysparm display value (string) sysparm exclude reference link (boolean) sysparm fields (string) sysparm limit (number) sysparm no count (boolean) sysparm offset (number) sysparm query (string) sysparm query category (string) sysparm query no domain (boolean) sysparm suppress pagination header (boolean) sysparm view (string) output example \[ { "status code" 200, "response headers" {}, "reason" "ok", "json body" { "result" \[ { "parent" "", "made sla" "true", "watch list" "", "upon reject" "cancel", "sys updated on" "2016 01 19 04 52 04", "approval history" "", "number" "prb0000050", "sys updated by" "glide maint", "opened by" { "link" "https //instance servicenow\ com/api/now/table/sys user/glide maint", "value" "glide maint" }, "user input" "", "sys created on" "2016 01 19 04 51 19", "sys domain" { "link" "https //instance servicenow\ com/api/now/table/sys user group/global", "value" "global" }, "state" "4", "sys created by" "glide maint", "knowledge" "false", "order" "", "closed at" "2016 01 19 04 52 04", "cmdb ci" { "link" "https //instance servicenow\ com/api/now/table/cmdb ci/55b35562c0a8010e01cff22378e0aea9", "value" "55b35562c0a8010e01cff22378e0aea9" }, "delivery plan" "", "impact" "3", "active" "false", "work notes list" "", "business service" "", "priority" "4", "sys domain path" "/", "time worked" "", "expected start" "", "rejection goto" "", "opened at" "2016 01 19 04 49 47", "business duration" "1970 01 01 00 00 00", "group list" "", "work end" "", "approval set" "", "wf activity" "", "work notes" "", "short description" "switch occasionally drops connections", "correlation display" "", "delivery task" "", "work start" "", "assignment group" "", "additional assignee list" "", "description" "switch occasionally drops connections", "calendar duration" "1970 01 01 00 02 17", "close notes" "updated firmware", "sys class name" "problem", "closed by" "", "follow up" "", "sys id" "04ce72c9c0a8016600b5b7f75ac67b5b", "contact type" "phone", "urgency" "3", "company" "", "reassignment count" "", "activity due" "", "assigned to" "", "comments" "", "approval" "not requested", "sla due" "", "comments and work notes" "", "due date" "", "sys mod count" "1", "sys tags" "", "escalation" "0", "upon approval" "proceed", "correlation id" "", "location" "" } ] } } ] output parameters status code (number) reason (string) json body (object) result (array) parent (string) made sla (string) watch list (string) upon reject (string) sys updated on (string) approval history (string) number (string) sys updated by (string) opened by (object) link (string) value (string) user input (string) sys created on (string) sys domain (object) link (string) value (string) state (string) sys created by (string) knowledge (string) order (string) closed at (string) cmdb ci (object) link (string) value (string) delivery plan (string) impact (string) active (string) work notes list (string) business service (string) priority (string) sys domain path (string) time worked (string) expected start (string) rejection goto (string) opened at (string) business duration (string) group list (string) work end (string) approval set (string) wf activity (string) work notes (string) short description (string) correlation display (string) delivery task (string) work start (string) assignment group (string) additional assignee list (string) description (string) calendar duration (string) close notes (string) sys class name (string) closed by (string) follow up (string) sys id (string) contact type (string) urgency (string) company (string) reassignment count (string) activity due (string) assigned to (string) comments (string) approval (string) sla due (string) comments and work notes (string) due date (string) sys mod count (string) sys tags (string) escalation (string) upon approval (string) correlation id (string) location (string)