Public/table/Get-SNOWSCItem.ps1

function Get-SNOWSCItem {
    <#
    .SYNOPSIS
        Retrieves a sc_cat_item record from SNOW
    .DESCRIPTION
        Gets a record from the sc_cat_item table
    .NOTES
        Uses Get-SNOWObject as a template function.
    .OUTPUTS
        PSCustomObject. The full table record/s.
    .LINK
        https://github.com/insomniacc/PSSnow/blob/main/docs/functions/Get-SNOWSCItem.md
    .LINK
        https://docs.servicenow.com/csh?topicname=c_TableAPI.html&version=latest
    .EXAMPLE
        Get-SNOWSCItem -limit 1 -verbose
        Returns a single record from sc_cat_item
    #>
   

    [CmdletBinding()]
    param (
        [Parameter()]
        [string]
        $access_type,
        [Parameter()]
        [boolean]
        $active,
        [Parameter()]
        [string]
        $availability,
        [Parameter()]
        [boolean]
        $billable,
        [Parameter()]
        [string]
        $category,
        [Parameter()]
        [string]
        $checked_out,
        [Parameter()]
        [string]
        $cost,
        [Parameter()]
        [alias('cart')]
        [string]
        $custom_cart,
        [Parameter()]
        [alias('execution_plan')]
        [string]
        $delivery_plan,
        [Parameter()]
        [string]
        $delivery_plan_script,
        [Parameter()]
        [string]
        $delivery_time,
        [Parameter()]
        [string]
        $description,
        [Parameter()]
        [string]
        $display_price_property,
        [Parameter()]
        [string]
        $entitlement_script,
        [Parameter()]
        [alias('flow')]
        [string]
        $flow_designer_flow,
        [Parameter()]
        [string]
        $fulfillment_automation_level,
        [Parameter()]
        [alias('fulfillment_group')]
        [string]
        $group,
        [Parameter()]
        [alias('hide_on_service_portal')]
        [boolean]
        $hide_sp,
        [Parameter()]
        [string]
        $icon,
        [Parameter()]
        [boolean]
        $ignore_price,
        [Parameter()]
        [string]
        $image,
        [Parameter()]
        [string]
        $list_price,
        [Parameter()]
        [string]
        $location,
        [Parameter()]
        [boolean]
        $mandatory_attachment,
        [Parameter()]
        [string]
        $meta,
        [Parameter()]
        [alias('hide_price__mobile_listings_')]
        [boolean]
        $mobile_hide_price,
        [Parameter()]
        [alias('classic_mobile_picture')]
        [string]
        $mobile_picture,
        [Parameter()]
        [alias('classic_mobile_picture_type')]
        [string]
        $mobile_picture_type,
        [Parameter()]
        [string]
        $model,
        [Parameter()]
        [string]
        $name,
        [Parameter()]
        [alias('hide_attachment')]
        [boolean]
        $no_attachment_v2,
        [Parameter()]
        [boolean]
        $no_cart,
        [Parameter()]
        [alias('hide__add_to_cart_')]
        [boolean]
        $no_cart_v2,
        [Parameter()]
        [alias('hide_delivery_time')]
        [boolean]
        $no_delivery_time_v2,
        [Parameter()]
        [boolean]
        $no_order,
        [Parameter()]
        [boolean]
        $no_order_now,
        [Parameter()]
        [boolean]
        $no_proceed_checkout,
        [Parameter()]
        [boolean]
        $no_quantity,
        [Parameter()]
        [alias('hide_quantity')]
        [boolean]
        $no_quantity_v2,
        [Parameter()]
        [boolean]
        $no_search,
        [Parameter()]
        [alias('hide__add_to_wish_list_')]
        [boolean]
        $no_wishlist_v2,
        [Parameter()]
        [alias('omit_price_in_cart')]
        [boolean]
        $omit_price,
        [Parameter()]
        [string]
        $order,
        [Parameter()]
        [string]
        $ordered_item_link,
        [Parameter()]
        [string]
        $owner,
        [Parameter()]
        [string]
        $picture,
        [Parameter()]
        [alias('preview_link')]
        [string]
        $preview,
        [Parameter()]
        [string]
        $price,
        [Parameter()]
        [alias('published_item')]
        [string]
        $published_ref,
        [Parameter()]
        [alias('recurring_price_frequency')]
        [string]
        $recurring_frequency,
        [Parameter()]
        [string]
        $recurring_price,
        [Parameter()]
        [string]
        $request_method,
        [Parameter()]
        [string]
        $roles,
        [Parameter()]
        [alias('catalogs')]
        [string]
        $sc_catalogs,
        [Parameter()]
        [alias('created_from_item_design')]
        [string]
        $sc_ic_item_staging,
        [Parameter()]
        [alias('published_version')]
        [string]
        $sc_ic_version,
        [Parameter()]
        [alias('associated_template')]
        [string]
        $sc_template,
        [Parameter()]
        [string]
        $short_description,
        [Parameter()]
        [alias('expand_help_for_all_questions')]
        [boolean]
        $show_variable_help_on_load,
        [Parameter()]
        [boolean]
        $start_closed,
        [Parameter()]
        [string]
        $state,
        [Parameter()]
        [string]
        $taxonomy_topic,
        [Parameter()]
        [string]
        $template,
        [Parameter()]
        [string]
        $template_manager_roles,
        [Parameter()]
        [string]
        $type,
        [Parameter()]
        [alias('use_cart_layout')]
        [boolean]
        $use_sc_layout,
        [Parameter()]
        [string]
        $vendor,
        [Parameter()]
        [alias('visible_on_bundles')]
        [boolean]
        $visible_bundle,
        [Parameter()]
        [alias('visible_on_guides')]
        [boolean]
        $visible_guide,
        [Parameter()]
        [alias('visible_elsewhere')]
        [boolean]
        $visible_standalone,
        [Parameter()]
        [string]
        $workflow
    )
    DynamicParam { Import-DefaultParamSet -TemplateFunction "Get-SNOWObject" }

    Begin {
        $table = "sc_cat_item"
    }
    Process {
        Invoke-SNOWTableREAD -table $table -Parameters $PSBoundParameters
    }
}