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/alternate_titles
Status:
200 OK
Content-Type:
application/json
{
"rows": "https://api-v2.onetcenter.org/database/rows/alternate_titles",
"table_id": "alternate_titles",
"title": "Alternate Titles",
"description": "Provide alternate occupational titles for O*NET-SOC occupations.",
"data_dictionary": "https://www.onetcenter.org/dictionary/29.0/excel/alternate_titles.html",
"download": {
"excel": "https://www.onetcenter.org/dl_files/database/db_29_0_excel/Alternate%20Titles.xlsx",
"text": "https://www.onetcenter.org/dl_files/database/db_29_0_text/Alternate%20Titles.txt",
"mysql": "https://www.onetcenter.org/dl_files/database/db_29_0_mysql/29_alternate_titles.sql",
"sql_server": "https://www.onetcenter.org/dl_files/database/db_29_0_mssql/29_alternate_titles.sql",
"oracle": "https://www.onetcenter.org/dl_files/database/db_29_0_oracle/29_alternate_titles.sql"
},
"column": [
{
"column_id": "onetsoc_code",
"optional": false
,
"title": "O*NET-SOC Code",
"description": "O*NET-SOC Code",
"type": "Text",
"format": "Character(10)"
},
{
"column_id": "title",
"optional": false
,
"title": "Title",
"description": "O*NET-SOC Title",
"type": "Text",
"format": "Character Varying(150)"
},
{
"column_id": "alternate_title",
"optional": false
,
"title": "Alternate Title",
"description": "Alternate occupational title",
"type": "Text",
"format": "Character Varying(250)"
},
{
"column_id": "short_title",
"optional": true
,
"title": "Short Title",
"description": "Short version of alternate title (if applicable)",
"type": "Text",
"format": "Character Varying(150)"
},
{
"column_id": "sources",
"optional": false
,
"title": "Source(s)",
"description": "List of source codes — see below",
"type": "Text",
"format": "Character Varying(50)"
}
]
}