Schedule 70 API

An API for getting data on GSA Schedule 70 vendors that are authorized to work with state and local governments.

• Rationale
• Design
• Usage
• Endpoints
• Sample response
• Field listing

Rationale

State and local governments can purchase IT services off of the GSA Schedule 70, but locating a contractor that meets specific requirements is not easy using the existing GSA eLibrary website. This API makes it easy to search for contractors by state or city; more clearly lists contractor socio-economic indicators, and; supports the development of a range of different client applications that can be used by state and local officials to quickly identify Schedule 70 contractors authorized to work with state and local governments.

Design

This API is built to conform to as many of the API standards articulate here as possible. It is built with Node.js and uses the Express framework for the API layer, and MySQL for the back-end data store.

Usage

• Clone this repo, and install dependencies: npm install
• Scrape the data
• Create a database user:

mysql> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT SELECT ON schedule70 . * TO 'user'@'localhost';

• Start the app: DBHOST=localhost DBUSER=user DBPASS=password DATABASE=schedule70 npm start

API Methods

Get contractors list

• URL: https://{host}/?limit=1&0ffset=5
• Optional limit & offset & format parameters

Get contractors list by State

• URL: https://{host}/state/NY?limit=1&0ffset=5
• Optional limit & offset & format parameters

Get contractors list by City

• URL: https://{host}/city/Syracuse?limit=2
• Optional limit & offset & format parameters

Get contractors list by Category

• URL: https://{host}/category/132%2050?limit=5&offset=2&format=csv
• Optional limit & offset & format parameters

Download all contractors data

• https://{host}/download
• Downloads all data as a csv file

Sample response

{
	"result": "success",
	"count": 2,
	"data": [
		{
		"Category": "132 51",
		"Contractor_Name": "GOVSPHERE, INC.",
		"Contractor_Details_URL": "http://www.gsaelibrary.gsa.gov/ElibMain/contractorInfo.do;jsessionid=45223235A079C3DB237FB375FB880575.prd2pweb?contractNumber=GS-35F-0593X&contractorName=GOVSPHERE%2C+INC.&executeQuery=YES",
		"Contract_Number": "GS-35F-0593X",
		"Phone": "315-897-7100",
		"Contractor_TC_Price_List": "https://www.gsaadvantage.gov/ref_text/GS35F0593X/GS35F0593X_online.htm",
		"View_Catalog": "http://www.gsaelibrary.gsa.gov/ElibMain/advRedirect.do?contract=GS-35F-0593X&sin=132+51&src=elib&app=cat",
		"State_Local": 1,
		"Small_Business": 1,
		"Other_Than_Small_Business": 0,
		"Women_Owned_Small_Business": 0,
		"Economically_Disadvantaged_Women_Owned_Small_Business": 0,
		"Woman_Owned_Business": 0,
		"Service_Disabled_Veteran_Owned_Small_Business": 0,
		"Veteran_Owned_Small_Business": 0,
		"SBA_Certified_Small_Disadvantaged_Business": 0,
		"SBA_Certified_8a_Firm": 0,
		"SBA_Certified_HUBZone_Firm": 1,
		"State": "NY",
		"City": "SYRACUSE"
	},
	{
		"Category": "132 51",
		"Contractor_Name": "PROGRESSIVE EXPERT CONSULTING, INC.",
		"Contractor_Details_URL": "http://www.gsaelibrary.gsa.gov/ElibMain/contractorInfo.do;jsessionid=45223235A079C3DB237FB375FB880575.prd2pweb?contractNumber=GS-35F-0375V&contractorName=PROGRESSIVE+EXPERT+CONSULTING%2C+INC.&executeQuery=YES",
		"Contract_Number": "GS-35F-0375V",
		"Phone": "315-446-6160",
		"Contractor_TC_Price_List": "https://www.gsaadvantage.gov/ref_text/GS35F0375V/GS35F0375V_online.htm",
		"View_Catalog": "http://www.gsaelibrary.gsa.gov/ElibMain/advRedirect.do?contract=GS-35F-0375V&sin=132+51&src=elib&app=cat",
		"State_Local": 1,
		"Small_Business": 1,
		"Other_Than_Small_Business": 0,
		"Women_Owned_Small_Business": 0,
		"Economically_Disadvantaged_Women_Owned_Small_Business": 0,
		"Woman_Owned_Business": 0,
		"Service_Disabled_Veteran_Owned_Small_Business": 0,
		"Veteran_Owned_Small_Business": 0,
		"SBA_Certified_Small_Disadvantaged_Business": 1,
		"SBA_Certified_8a_Firm": 0,
		"SBA_Certified_HUBZone_Firm": 0,
		"State": "NY",
		"City": "SYRACUSE"
	}
]
}

Field listing

Name	Type	Description
Category	String	The category number for the service provided by the contractor
Contractor_Name	String	The name of the contractor
Contractor_Details_URL	String	URL to the contractor profile on GSA eLibrary
Contract_Number	String	The number of the contract through which the contractor provides service
Phone	String	The contact phone number of the contractor
Contractor_TC_Price_List	String	URL to the contractor's price listing
View_Catalog	String	URL to GSA Advantage catalog
State_Local	Number	Indicates whether contractor is authorized to work with state and local governments
Small_Business	Number	Indicates whether contractor is classified as a small business
Other_Than_Small_Business	Number	Indicates whether contractor is classified as other than a small business
Women_Owned_Small_Business	Number	Indicates whether contractor is classified as a Women Owned Small business (WOSB)
Economically_Disadvantaged_Women_Owned_Small_Business	Number	Indicates whether contractor is classified as an Economically Disadvantaged Women Owned Small business (EDWOSB)
Woman_Owned_Business	Number	Indicates whether contractor is classified as a Woman Owned business
Service_Disabled_Veteran_Owned_Small_Business	Number	Indicates whether contractor is classified as a Service Disabled Veteran Owned Small business
Veteran_Owned_Small_Business	Number	Indicates whether contractor is classified as a Veteran Owned Small business
SBA_Certified_Small_Disadvantaged_Business	Number	Indicates whether contractor is classified as a SBA Certified Small Disadvantaged business
SBA_Certified_8a_Firm	Number	Indicates whether contractor is classified as a SBA Certified 8(a) Firm
SBA_Certified_HUBZone_Firm	Number	Indicates whether contractor is classified as a SBA Certified HUBZone Firm
State	String	The state the contractor is located in
City	String	The city the contractor is located in