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/tasks_to_dwas
Status:
200 OK
Content-Type:
application/json
{
"rows": "https://api-v2.onetcenter.org/database/rows/tasks_to_dwas",
"table_id": "tasks_to_dwas",
"title": "Tasks to DWAs",
"description": "Provide a mapping of task statements to Detailed Work Activities.",
"data_dictionary": "https://www.onetcenter.org/dictionary/29.0/excel/tasks_to_dwas.html",
"download": {
"excel": "https://www.onetcenter.org/dl_files/database/db_29_0_excel/Tasks%20to%20DWAs.xlsx",
"text": "https://www.onetcenter.org/dl_files/database/db_29_0_text/Tasks%20to%20DWAs.txt",
"mysql": "https://www.onetcenter.org/dl_files/database/db_29_0_mysql/25_tasks_to_dwas.sql",
"sql_server": "https://www.onetcenter.org/dl_files/database/db_29_0_mssql/25_tasks_to_dwas.sql",
"oracle": "https://www.onetcenter.org/dl_files/database/db_29_0_oracle/25_tasks_to_dwas.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": "task_id",
"optional": false
,
"title": "Task ID",
"description": "Identifies each task",
"type": "Number",
"format": "Integer(8)"
},
{
"column_id": "task",
"optional": false
,
"title": "Task",
"description": "Task statement associated with an occupation",
"type": "Text",
"format": "Character Varying(1000)"
},
{
"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)"
},
{
"column_id": "date_updated",
"optional": false
,
"title": "Date",
"description": "Date when data was updated",
"type": "Date",
"format": "Date"
},
{
"column_id": "domain_source",
"optional": false
,
"title": "Domain Source",
"description": "Source of the data",
"type": "Text",
"format": "Character Varying(30)"
}
]
}