🚀Launch Week 04, May 13th - 17th, 2024!🚀

Plugins Mods Docs Home

theapsgroup/freshservice

steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

freshservice_agent freshservice_agent_role freshservice_announcement freshservice_asset freshservice_asset_component freshservice_asset_contract freshservice_asset_type freshservice_business_hour freshservice_change freshservice_change_note freshservice_contract freshservice_contract_type freshservice_department freshservice_location freshservice_problem freshservice_problem_note freshservice_problem_task freshservice_problem_timeentry freshservice_product freshservice_purchase_order freshservice_release freshservice_release_note freshservice_release_task freshservice_release_timeentry freshservice_requester freshservice_service freshservice_sla_policy freshservice_software freshservice_software_installation freshservice_software_user freshservice_solution_article freshservice_solution_category freshservice_solution_folder freshservice_ticket freshservice_ticket_conversation freshservice_ticket_task freshservice_ticket_timeentry freshservice_vendor

Table: freshservice_vendor

Obtain information about Vendors stored in the FreshService instance.

Examples

List all vendors

select
  id,
  name,
  description
from
  freshservice_vendor;

Get a specific vendor

select
  name,
  description,
  line1 as street,
  city,
  state,
  zipcode,
  country
from
  freshservice_vendor
where
  id = 296358410;

Schema for freshservice_vendor

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
city	text		Name of the city.
country	text		Name of the country.
created_at	timestamp with time zone		Timestamp at which the vendor was created.
description	text		Description of the vendor.
id	bigint	=	ID of the vendor.
line1	text		Address line 1.
name	text		Name of the vendor.
primary_contact_id	bigint		User ID of the primary contact.
state	text		Name of the state.
updated_at	timestamp with time zone		Timestamp at which the vendor was last updated.
zipcode	text		Zip (postal) code of the location.