Interactive Demo
This demonstration page allows you to test out the Web Services API by sending a request and viewing the JSON data returned. See the Reference Manual for a complete guide to the available services.
Request
Response
Send a request to see the response.
Loading...
The request could not be completed (). Please try again.
URL:
https://api-v2.onetcenter.org/database/info/job_zone_reference
Status:
200 OK
Content-Type:
application/json
{
"rows": "https://api-v2.onetcenter.org/database/rows/job_zone_reference",
"table_id": "job_zone_reference",
"title": "Job Zone Reference",
"description": "Provide Job Zone data (developed to help transition DOT’s measures of Specific Vocational Preparation (SVP) to O*NET’s measure of experience, education, and job training).",
"data_dictionary": "https://www.onetcenter.org/dictionary/29.0/excel/job_zone_reference.html",
"download": {
"excel": "https://www.onetcenter.org/dl_files/database/db_29_0_excel/Job%20Zone%20Reference.xlsx",
"text": "https://www.onetcenter.org/dl_files/database/db_29_0_text/Job%20Zone%20Reference.txt",
"mysql": "https://www.onetcenter.org/dl_files/database/db_29_0_mysql/2_job_zone_reference.sql",
"sql_server": "https://www.onetcenter.org/dl_files/database/db_29_0_mssql/2_job_zone_reference.sql",
"oracle": "https://www.onetcenter.org/dl_files/database/db_29_0_oracle/2_job_zone_reference.sql"
},
"column": [
{
"column_id": "job_zone",
"optional": false
,
"title": "Job Zone",
"description": "Job Zone number",
"type": "Number",
"format": "Integer(1)"
},
{
"column_id": "name",
"optional": false
,
"title": "Name",
"description": "Job Zone name/zone",
"type": "Text",
"format": "Character Varying(50)"
},
{
"column_id": "experience",
"optional": false
,
"title": "Experience",
"description": "Job Zone experience requirements",
"type": "Text",
"format": "Character Varying(300)"
},
{
"column_id": "education",
"optional": false
,
"title": "Education",
"description": "Job Zone educational requirements",
"type": "Text",
"format": "Character Varying(500)"
},
{
"column_id": "job_training",
"optional": false
,
"title": "Job Training",
"description": "Job Zone training requirements",
"type": "Text",
"format": "Character Varying(300)"
},
{
"column_id": "examples",
"optional": false
,
"title": "Examples",
"description": "Job Zone examples",
"type": "Text",
"format": "Character Varying(500)"
},
{
"column_id": "svp_range",
"optional": false
,
"title": "SVP Range",
"description": "Specific vocational preparation range",
"type": "Text",
"format": "Character Varying(25)"
}
]
}