Skip to content

Get table record

Overview

Retrieves a specific record by sys_id from the specified table.

Path parameters

Name Description
baseurl The absolute base URI for the request (this is the same for all requests) including: the schema, the domain, and a path fragment.
table The table name of for the operation.
sysId The sys id of the table record.

Optional query parameters

Name Type Possible values Description
DisplayValue tableapi.DisplayValue2 DisplayValue2True, DisplayValue2False, or DisplayValue2All 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.View2 View2Desktop, View2Mobile, or View2Both UI view for which to render the data.

Required query parameters

N/A

Examples

package main


import (
    "context"
    "fmt"
    "log"

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

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.TableItemRequestBuilder2GetRequestConfiguration{
        QueryParameters: &tableapi.TableItemRequestBuilder2GetQueryParameters{
            // Optional configurations
        },
    }

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

}
package main


import (
    "context"
    "fmt"
    "log"

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

func main() {
    // Step 1: Create credentials

    cred := credentials.NewBasicProvider("{username}", "{password}")


    // Step 3: Define raw URL
    rawURL := "https://https://{instance}.service-now.com/api/now/v1/table/{TableName}"

    // Step 4: Build request
    requestBuilder = tableapi.NewDefaultTableItemRequestBuilder2(rawURL, client.RequestAdapter)


    // Step 5: Configure request
    getStdConfig := &tableapi.TableItemRequestBuilder2GetRequestConfiguration{
        QueryParameters: &tableapi.TableItemRequestBuilder2GetQueryParameters{
            // Optional configurations
        },
    }

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

}