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/
? =
& =
& =
& =
& =
& =
& =
& =
& =
& =
  • My Next Move
  • O*NET OnLine

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/dwa_reference
Status:
200 OK
Content-Type:
application/json
{
   "rows": "https://api-v2.onetcenter.org/database/rows/dwa_reference",
   "table_id": "dwa_reference",
   "title": "DWA Reference",
   "description": "Provide each Detailed Work Activity.",
   "data_dictionary": "https://www.onetcenter.org/dictionary/29.0/excel/dwa_reference.html",
   "download": {
      "excel": "https://www.onetcenter.org/dl_files/database/db_29_0_excel/DWA%20Reference.xlsx",
      "text": "https://www.onetcenter.org/dl_files/database/db_29_0_text/DWA%20Reference.txt",
      "mysql": "https://www.onetcenter.org/dl_files/database/db_29_0_mysql/24_dwa_reference.sql",
      "sql_server": "https://www.onetcenter.org/dl_files/database/db_29_0_mssql/24_dwa_reference.sql",
      "oracle": "https://www.onetcenter.org/dl_files/database/db_29_0_oracle/24_dwa_reference.sql"
   },
   "column": [
      {
         "column_id": "element_id",
         "optional": false,
         "title": "Element ID",
         "description": "Content Model Outline Position",
         "type": "Text",
         "format": "Character Varying(20)"
      },
      {
         "column_id": "element_name",
         "optional": false,
         "title": "Element Name",
         "description": "Content Model Element Name",
         "type": "Text",
         "format": "Character Varying(150)"
      },
      {
         "column_id": "iwa_id",
         "optional": false,
         "title": "IWA ID",
         "description": "Identifies each Intermediate Work Activity",
         "type": "Text",
         "format": "Character Varying(20)"
      },
      {
         "column_id": "iwa_title",
         "optional": false,
         "title": "IWA Title",
         "description": "Intermediate Work Activity statement",
         "type": "Text",
         "format": "Character Varying(150)"
      },
      {
         "column_id": "dwa_id",
         "optional": false,
         "title": "DWA ID",
         "description": "Identifies each Detailed Work Activity",
         "type": "Text",
         "format": "Character Varying(20)"
      },
      {
         "column_id": "dwa_title",
         "optional": false,
         "title": "DWA Title",
         "description": "Detailed Work Activity statement",
         "type": "Text",
         "format": "Character Varying(150)"
      }
   ]
}