Get Vendors

Use this service to get active vendors from Spectrum.

Connection Information

URL = https://<SPECTRUM-SERVER>:8482/vendors/Company_Code

Authentication: Basic Authentication, Enhanced Authentication

Supported methods: GET

Underlying File Maintenance

Accounts Payable > Vendor File Maintenance
Accounts Payable > Vendor Locations

Assumptions and Dependencies

Only active vendors are returned.

Parameter Fields

If you want to filter by items such as state or city, pCostCenter is a required parameter.

Important: If you're using Postman, send the filter parameters as part of the query parameters.


Element Name	Description	Req	Type	Max	Format	Validation
Authorization_ID	Authorization ID to access the server	YES	Text	20		Data Exchange Installation Screen
GUID	Unique reference number created by programming		Text	36
pCompany_Code	Company Code	YES	Text	3	Valid Company in Spectrum	Defaults from the Authorization ID if not populated
pType	Vendor Type		Text	6
pCity	Vendor City		Text	25
pState	Vendor State		Text	2
pName	Vendor Name		Text	30
pCostCenter	Cost Centers		Text	3		Specific cost center or 'ALL'

Return Fields


Element Name	Description	Type	Max	Format	Validation
Company_Code	Company Code	Text	3		Valid Spectrum Company
Vendor_Code	Vendor Code	Text	10		Vendor File Maintenance
Name	Vendor Name	Text	30		Vendor File Maintenance or Vendor Location Maintenance
Address_1	Address 1	Text	30		Vendor File Maintenance or Vendor Location Maintenance
Address_2	Address 2	Text	30		Vendor File Maintenance or Vendor Location Maintenance
City	City	Text	30		Vendor File Maintenance or Vendor Location Maintenance
State	State / Province	Text	2		Vendor File Maintenance or Vendor Location Maintenance
Zip_Code	Postal Code	Text	10		Vendor File Maintenance or Vendor Location Maintenance
First_Name	Primary Contact First Name	Text	20		Contact Master
Last_Name	Primary Contact Last Name	Text	30		Contact Master
Phone_Number	Primary Contact Phone	Text	14		Primary phone defined for Contact Master
Email	Primary Contact Email	Text	80		Email defined for Contact Master
Account_Reference	Account Reference	Text	25		Vendor File Maintenance
Payment_Terms	Payment Due Terms	Text	1	When A = Invoice Date. When B = Prox Terms
Payment_Term_Days	Payment Number of Days	Numeric	12
Discount_Terms	Discount Terms	Text	1	When A = Invoice Date. When B = Prox Terms
Discount_Term_Days	Discount Number of Days	Numeric	12
Discount_Percent	Discount Percent	Numeric	3.2
Purchase_Location_Name	Purchase Location	Text	30		Locations
Purchase_Address_1		Text	30		Locations
Purchase_Address_2		Text	30		Locations
Purchase_City		Text	30		Locations
Purchase_State		Text	2		Locations
Purchase_Zip		Numeric	10		Locations
Payment_Location_Name	Payment Location	Text	30		Locations
Payment_Address_1		Text	30		Locations
Payment_Address_2		Text	30		Locations
Purchase_City		Text	30		Locations
Purchase_State		Text	2		Locations
Purchase_Zip		Numeric	10		Locations