Get table record

Overview

Retrieves a specific record by sys_id from the specified table.

Path parameters

Name	Description
table	The table name for the operation.
sysId	The sys id of the table record.

Optional query parameters

Name	Type	Possible values	Description
DisplayValue	tableapi.DisplayValue	DisplayValueTrue, DisplayValueFalse, or DisplayValueAll	Determines the type of data returned, either the actual values from the database or the display values of the fields.
ExcludeReferenceLink	bool	N/A	Flag that indicates whether to exclude Table API links for reference fields.
Fields	[]string	N/A	List of fields to include in the response.
QueryNoDomain	bool	N/A	Flag that indicates whether to restrict the record search to only the domains configured for the logged in user.
View	tableapi.View	ViewDesktop, ViewMobile, or ViewBoth	UI view for which to render the data.

Required query parameters

N/A

Examples

Fluent

package main

import (
	"context"
	"fmt"
	"log"

	servicenowsdkgo "github.com/michaeldcanady/servicenow-sdk-go/v2"
	tableapi "github.com/michaeldcanady/servicenow-sdk-go/v2/tableapi"
)

func main() {
  // Step 1: Create credentials
  cred := credentials.NewBasicProvider("{username}", "{password}")
  // Step 2: Initialize client
  client, err := servicenowsdkgo.NewServiceNowServiceClient(
  	servicenowsdkgo.WithAuthenticationProvider(cred),
  	servicenowsdkgo.WithURL("https://{instance}.service-now.com"),
  )
  if err != nil {
  	log.Fatal(err)
  }
  // Step 3: Configure request
  getConfig := &tableapi.TableItemRequestBuilderGetRequestConfiguration{
  	QueryParameters: &tableapi.TableItemRequestBuilderGetQueryParameters{
  		// Optional configurations
  	},
  }

  // Step 4: Execute request
  getResponse, err := client.Now().Table("{TableName}").ByID("{SysID}").Get(context.Background(), getConfig)
  if err != nil {
  	log.Fatal(err)
  }
}

Standard

package main

import (
	"context"
	"fmt"
	"log"

	servicenowsdkgo "github.com/michaeldcanady/servicenow-sdk-go/v2"
	tableapi "github.com/michaeldcanady/servicenow-sdk-go/v2/tableapi"
)

func main() {
  // Step 1: Create credentials
  cred := credentials.NewBasicProvider("{username}", "{password}")
  // Step 2: Initialize client
  client, err := servicenowsdkgo.NewServiceNowServiceClient(
  	servicenowsdkgo.WithAuthenticationProvider(cred),
  	servicenowsdkgo.WithURL("https://{instance}.service-now.com"),
  )
  if err != nil {
  	log.Fatal(err)
  }
  // Step 3: Define raw URL
  rawURL := "https://{instance}.service-now.com/api/now/v1/table/{TableName}"

  // Step 4: Build request
  requestBuilder = tableapi.NewDefaultTableItemRequestBuilder(rawURL, client.GetRequestAdapter())
  // Step 5: Configure request
  getStdConfig := &tableapi.TableItemRequestBuilderGetRequestConfiguration{
  	QueryParameters: &tableapi.TableItemRequestBuilderGetQueryParameters{
  		// Optional configurations
  	},
  }

  // Step 6: Execute request
  getStdRecord, err := requestBuilder.Get(context.Background(), getStdConfig)
  if err != nil {
  	log.Fatal(err)
  }
}