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

https://api-v2.onetcenter.org/
GET parameters
? =
& =
& =
& =
& =
& =
& =
& =
& =
& =

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)"
      }
   ]
}