Skip to Main Content

page_parts

Northwind

Categories
Output similar to the CATEGORIES table from the Northwind sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"categories":[
{
"CATEGORY_ID":4
,"CATEGORY_NAME":"Fruits"
,"DESCRIPTION":"The teensy cylinder ve"
,"PICTURE":"sne"
}
,{
"CATEGORY_ID":5
,"CATEGORY_NAME":"Vegetables"
,"DESCRIPTION":"The colossal cube wajizleh"
,"PICTURE":"qht"
}
]
}
Customer_Customer_Demo
Output similar to the customer_customer_demo table from the Northwind sample database.
Parameters:
Name Type Default Default Value
DIST_CUSTOMER_ID VARCHAR2 Y
DIST_CUSTOMER_TYPE_I VARCHAR2 Y
Example output:
{
"customer_customer_demo":[
{
"CUSTOMER_ID":"JAHGK"
,"CUSTOMER_TYPE_ID":"G"
}
,{
"CUSTOMER_ID":"JAHGK"
,"CUSTOMER_TYPE_ID":"G"
}
]
}
Customer_Demographics
Output similar to the customer_demographics table from the Northwind sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"customer_demographics":[
{
"CUSTOMER_TYPE_ID":"G"
,"CUSTOMER_DESC":"Q"
}
,{
"CUSTOMER_TYPE_ID":"G"
,"CUSTOMER_DESC":"Q"
}
]
}
Customers
Output similar to the customers table from the Northwind sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"customers":[
{
"CUSTOMER_ID":"IPGTB"
,"COMPANY_NAME":"Grayson Chemicals"
,"CONTACT_NAME":"Lucas Allen"
,"CONTACT_TITLE":"Electrician"
,"ADDRESS":"72 Loti Mill"
,"CITY":"Savannah"
,"REGION":"GA"
,"POSTAL_CODE":"53186"
,"COUNTRY":"VG"
,"PHONE":"4537 1382"
,"FAX":"87 7237"
}
,{
"CUSTOMER_ID":"PRQIW"
,"COMPANY_NAME":"Camila Bank"
,"CONTACT_NAME":"Christian Bell"
,"CONTACT_TITLE":"Billing"
,"ADDRESS":"264 Tila Heights"
,"CITY":"Durkee"
,"REGION":"OR"
,"POSTAL_CODE":"98666"
,"COUNTRY":"PR"
,"PHONE":"75 15323"
,"FAX":"05 9144 7247"
}
]
}
Employee_Territories
Output similar to the employee_territories table from the Northwind sample database.
Parameters:
Name Type Default Default Value
DIST_EMPLOYEE_ID VARCHAR2 Y
DIST_TERRITORY_ID VARCHAR2 Y
Example output:
{
"employee_territories":[
{
"EMPLOYEE_ID":3
,"TERRITORY_ID":"56451"
}
,{
"EMPLOYEE_ID":3
,"TERRITORY_ID":"84696"
}
]
}
Employees
Output similar to the employees table from the Northwind sample database.
Parameters:
Name Type Default Default Value
DIST_REPORTS_TO VARCHAR2 Y
Example output:
{
"employees":[
{
"EMPLOYEE_ID":2
,"LAST_NAME":"Evans"
,"FIRST_NAME":"Mason"
,"TITLE":"Analyst"
,"TITLE_OF_COURTESY":"Mr."
,"BIRTH_DATE":"1952-02-19T02:58:39Z"
,"HIRE_DATE":"2009-05-09T05:51:49Z"
,"ADDRESS":"192 Tej Pass"
,"CITY":"West Jordan"
,"REGION":"UT"
,"POSTAL_CODE":"04073"
,"COUNTRY":"GP"
,"HOME_PHONE":"423 3687"
,"EXTENSION":"vesy"
,"PHOTO":"o"
,"NOTES":"Was to the chilcoot pass dyea and."
,"PHOTO_PATH":"https:\/\/www.me.net\/rumjehviz.html"
}
,{
"EMPLOYEE_ID":3
,"LAST_NAME":"Campbell"
,"FIRST_NAME":"Carson"
,"TITLE":"Sales Assistant"
,"TITLE_OF_COURTESY":"Mrs."
,"BIRTH_DATE":"1952-02-19T08:48:54Z"
,"HIRE_DATE":"1993-03-23T00:12:09Z"
,"ADDRESS":"440 Saf Plaza"
,"CITY":"Fairmont"
,"REGION":"WV"
,"POSTAL_CODE":"71205"
,"COUNTRY":"SK"
,"HOME_PHONE":"36 7147 6376"
,"EXTENSION":"jxl"
,"PHOTO":"o"
,"NOTES":"Was than fifty below--how much colder he."
,"REPORTS_TO":2
,"PHOTO_PATH":"http:\/\/www.niwdokom.mil\/konev.html"
}
]
}
Order_Details
Output similar to the order_details table from the Northwind sample database.
Parameters:
Name Type Default Default Value
DIST_ORDER_ID VARCHAR2 Y
DIST_PRODUCT_ID VARCHAR2 Y
Example output:
{
"order_details":[
{
"ORDER_ID":11057.1
,"PRODUCT_ID":12
,"UNIT_PRICE":26.32
,"QUANTITY":13
,"DISCOUNT":0
}
,{
"ORDER_ID":11067.53
,"PRODUCT_ID":12
,"UNIT_PRICE":93.5
,"QUANTITY":10
,"DISCOUNT":0
}
]
}
Orders
Output similar to the orders table from the Northwind sample database.
Parameters:
Name Type Default Default Value
DIST_CUSTOMER_ID VARCHAR2 Y
DIST_EMPLOYEE_ID VARCHAR2 Y
DIST_SHIP_VIA VARCHAR2 Y
Example output:
{
"orders":[
{
"ORDER_ID":11059.1
,"CUSTOMER_ID":"WDNUB"
,"EMPLOYEE_ID":3
,"ORDER_DATE":"2023-01-25T21:35:17Z"
,"REQUIRED_DATE":"2022-05-24T06:44:31Z"
,"SHIPPED_DATE":"2023-02-03T11:24:33Z"
,"SHIP_VIA":2
,"FREIGHT":345.22
,"SHIP_NAME":"Harper Corp."
,"SHIP_ADDRESS":"16 Tatwode Court"
,"SHIP_CITY":"Fairmont"
,"SHIP_REGION":"WV"
,"SHIP_POSTAL_CODE":"89801"
,"SHIP_COUNTRY":"TL"
}
,{
"ORDER_ID":11065.54
,"CUSTOMER_ID":"WDNUB"
,"EMPLOYEE_ID":3
,"ORDER_DATE":"2022-07-13T13:03:01Z"
,"REQUIRED_DATE":"2023-02-25T11:24:03Z"
,"SHIPPED_DATE":"2022-11-04T07:43:37Z"
,"SHIP_VIA":2
,"FREIGHT":94.32
,"SHIP_NAME":"The Great Enterprise"
,"SHIP_ADDRESS":"420 Vakpe Pass"
,"SHIP_CITY":"Gilbert"
,"SHIP_REGION":"AZ"
,"SHIP_POSTAL_CODE":"80916"
,"SHIP_COUNTRY":"MN"
}
]
}
Products
Output similar to the products table from the Northwind sample database.
Parameters:
Name Type Default Default Value
DIST_SUPPLIER_ID VARCHAR2 Y
DIST_CATEGORY_ID VARCHAR2 Y
Example output:
{
"products":[
{
"PRODUCT_ID":11
,"PRODUCT_NAME":"Licorice Made With Organic Sugar Twists"
,"SUPPLIER_ID":1
,"CATEGORY_ID":5
,"QUANTITY_PER_UNIT":8
,"UNIT_PRICE":21.08
,"UNITS_IN_STOCK":111
,"UNITS_ON_ORDER":0
,"REORDER_LEVEL":25
,"DISCONTINUED":1
}
,{
"PRODUCT_ID":12
,"PRODUCT_NAME":"Scottish Style Sliced Salmon"
,"SUPPLIER_ID":2
,"CATEGORY_ID":5
,"QUANTITY_PER_UNIT":22
,"UNIT_PRICE":4.86
,"UNITS_IN_STOCK":105
,"UNITS_ON_ORDER":0
,"REORDER_LEVEL":0
,"DISCONTINUED":1
}
]
}
Region
Output similar to the region table from the Northwind sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"region":[
{
"REGION_ID":2
,"REGION_DESCRIPTION":"Oceania"
}
,{
"REGION_ID":3
,"REGION_DESCRIPTION":"Asia Pacific"
}
]
}
Shippers
Output similar to the shippers table from the Northwind sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"shippers":[
{
"SHIPPER_ID":2
,"COMPANY_NAME":"GLS"
,"PHONE":"388 693 4478"
}
,{
"SHIPPER_ID":3
,"COMPANY_NAME":"SingPost"
,"PHONE":"357 252 6296"
}
]
}
Suppliers
Output similar to the suppliers table from the Northwind sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"suppliers":[
{
"SUPPLIER_ID":1
,"COMPANY_NAME":"Savannah Bank"
,"CONTACT_NAME":"Juan Wright"
,"CONTACT_TITLE":"Professor"
,"ADDRESS":"215 Gonoref Center"
,"CITY":"Iowa City"
,"REGION":"Maine"
,"POSTAL_CODE":"70168"
,"COUNTRY":"CH"
,"PHONE":"61 898 238"
,"FAX":"319 32 54 5"
,"HOMEPAGE":"http:\/\/www.cowbam.org\/gifgus.html"
}
,{
"SUPPLIER_ID":2
,"COMPANY_NAME":"Beyond Agency"
,"CONTACT_NAME":"Angel Wood"
,"CONTACT_TITLE":"Cashier"
,"ADDRESS":"279 Sodmifho Park"
,"CITY":"Augusta"
,"REGION":"North Dakota"
,"POSTAL_CODE":"84097"
,"COUNTRY":"CC"
,"PHONE":"73 65 44 54"
,"FAX":"684 327 2231"
,"HOMEPAGE":"https:\/\/www.kepoh.com\/lozo.html"
}
]
}
Territories
Output similar to the territories table from the Northwind sample database.
Parameters:
Name Type Default Default Value
DIST_REGION_ID VARCHAR2 Y
Example output:
{
"territories":[
{
"TERRITORY_ID":"33245"
,"TERRITORY_DESCRIPTION":"Durham"
,"REGION_ID":2
}
,{
"TERRITORY_ID":"41396"
,"TERRITORY_DESCRIPTION":"Evansville"
,"REGION_ID":2
}
]
}
Us_States
Output similar to the us_states table from the Northwind sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"us_states":[
{
"STATE_ID":29
,"STATE_NAME":"Rhode Island"
,"STATE_ABBR":"AR"
,"STATE_REGION":"south"
}
,{
"STATE_ID":30
,"STATE_NAME":"North Dakota"
,"STATE_ABBR":"AR"
,"STATE_REGION":"west"
}
]
}

Anchor Points

On this page