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/tools_used
Status:
200 OK
Content-Type:
application/json
{
"rows": "https://api-v2.onetcenter.org/database/rows/tools_used",
"table_id": "tools_used",
"title": "Tools Used",
"description": "Provide Tools Used examples.",
"data_dictionary": "https://www.onetcenter.org/dictionary/29.0/excel/tools_used.html",
"download": {
"excel": "https://www.onetcenter.org/dl_files/database/db_29_0_excel/Tools%20Used.xlsx",
"text": "https://www.onetcenter.org/dl_files/database/db_29_0_text/Tools%20Used.txt",
"mysql": "https://www.onetcenter.org/dl_files/database/db_29_0_mysql/32_tools_used.sql",
"sql_server": "https://www.onetcenter.org/dl_files/database/db_29_0_mssql/32_tools_used.sql",
"oracle": "https://www.onetcenter.org/dl_files/database/db_29_0_oracle/32_tools_used.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": "example",
"optional": false
,
"title": "Example",
"description": "Tool example",
"type": "Text",
"format": "Character Varying(150)"
},
{
"column_id": "commodity_code",
"optional": false
,
"title": "Commodity Code",
"description": "UNSPSC commodity code",
"type": "Number",
"format": "Integer(8)"
},
{
"column_id": "commodity_title",
"optional": false
,
"title": "Commodity Title",
"description": "UNSPSC commodity title",
"type": "Text",
"format": "Character Varying(150)"
}
]
}
