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/unspsc_reference
Status:
200 OK
Content-Type:
application/json
{
   "rows": "https://api-v2.onetcenter.org/database/rows/unspsc_reference",
   "table_id": "unspsc_reference",
   "title": "UNSPSC Reference",
   "description": "Provide relevant aspects of the UNSPSC taxonomy.",
   "data_dictionary": "https://www.onetcenter.org/dictionary/29.0/excel/unspsc_reference.html",
   "download": {
      "excel": "https://www.onetcenter.org/dl_files/database/db_29_0_excel/UNSPSC%20Reference.xlsx",
      "text": "https://www.onetcenter.org/dl_files/database/db_29_0_text/UNSPSC%20Reference.txt",
      "mysql": "https://www.onetcenter.org/dl_files/database/db_29_0_mysql/28_unspsc_reference.sql",
      "sql_server": "https://www.onetcenter.org/dl_files/database/db_29_0_mssql/28_unspsc_reference.sql",
      "oracle": "https://www.onetcenter.org/dl_files/database/db_29_0_oracle/28_unspsc_reference.sql"
   },
   "column": [
      {
         "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)"
      },
      {
         "column_id": "class_code",
         "optional": false,
         "title": "Class Code",
         "description": "UNSPSC class code",
         "type": "Number",
         "format": "Integer(8)"
      },
      {
         "column_id": "class_title",
         "optional": false,
         "title": "Class Title",
         "description": "UNSPSC class title",
         "type": "Text",
         "format": "Character Varying(150)"
      },
      {
         "column_id": "family_code",
         "optional": false,
         "title": "Family Code",
         "description": "UNSPSC family code",
         "type": "Number",
         "format": "Integer(8)"
      },
      {
         "column_id": "family_title",
         "optional": false,
         "title": "Family Title",
         "description": "UNSPSC family title",
         "type": "Text",
         "format": "Character Varying(150)"
      },
      {
         "column_id": "segment_code",
         "optional": false,
         "title": "Segment Code",
         "description": "UNSPSC segment code",
         "type": "Number",
         "format": "Integer(8)"
      },
      {
         "column_id": "segment_title",
         "optional": false,
         "title": "Segment Title",
         "description": "UNSPSC segment title",
         "type": "Text",
         "format": "Character Varying(150)"
      }
   ]
}