Skip to Main Content

Breadcrumb

Category

page_parts

Pagila

Actor
Output similar to the actor table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
Example output: 
{
"actor":[
{
"ACTOR_ID":34
,"FIRST_NAME":"Samantha"
,"LAST_NAME":"Perez"
,"LAST_UPDATE":"2022-08-17T20:30:44.363000000Z"
}
,{
"ACTOR_ID":35
,"FIRST_NAME":"Blake"
,"LAST_NAME":"Miller"
,"LAST_UPDATE":"2022-07-19T23:49:01.304000000Z"
}
]
}
Address
Output similar to the address table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
DIST_CITY_ID VARCHAR2 Y
Example output: 
{
"address":[
{
"ADDRESS_ID":262
,"ADDRESS":"255 Tubpo Pass"
,"ADDRESS2":"Flat 285"
,"DISTRICT":"Washington"
,"CITY_ID":1
,"POSTAL_CODE":"31704"
,"PHONE":"641 318 6272"
,"LAST_UPDATE":"2023-01-08T09:06:17.751000000Z"
}
,{
"ADDRESS_ID":264
,"ADDRESS":"231 Jo Path"
,"ADDRESS2":"Hammond Condo 491"
,"DISTRICT":"Delaware"
,"CITY_ID":2
,"POSTAL_CODE":"48911"
,"PHONE":"962 835 7342"
,"LAST_UPDATE":"2022-07-13T17:08:39.667000000Z"
}
]
}
Category
Output similar to the category table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
Example output: 
{
"category":[
{
"CATEGORY_ID":14
,"NAME":"War"
,"LAST_UPDATE":"2023-03-28T15:48:54.255000000Z"
}
,{
"CATEGORY_ID":15
,"NAME":"Family"
,"LAST_UPDATE":"2023-05-02T04:30:48.985000000Z"
}
]
}
City
Output similar to the city table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
DIST_COUNTRY_ID VARCHAR2 Y
Example output: 
{
"city":[
{
"CITY_ID":1
,"CITY":"Dover"
,"COUNTRY_ID":58
,"LAST_UPDATE":"2023-05-17T13:44:14.700000000Z"
}
,{
"CITY_ID":2
,"CITY":"Waterbury"
,"COUNTRY_ID":58
,"LAST_UPDATE":"2023-02-17T09:09:58.120000000Z"
}
]
}
Country
Output similar to the country table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
Example output: 
{
"country":[
{
"COUNTRY_ID":58
,"COUNTRY":"Canada"
,"LAST_UPDATE":"2023-05-29T08:00:15.200000000Z"
}
,{
"COUNTRY_ID":59
,"COUNTRY":"Switzerland"
,"LAST_UPDATE":"2022-11-05T17:42:09.793000000Z"
}
]
}
Customer
Output similar to the customer table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
DIST_STORE_ID VARCHAR2 Y
DIST_ADDRESS_ID VARCHAR2 Y
Example output: 
{
"customer":[
{
"CUSTOMER_ID":322
,"STORE_ID":1
,"FIRST_NAME":"Mariah"
,"LAST_NAME":"Nelson"
,"EMAIL":"Mariah.Nelson@cajfe.int"
,"ADDRESS_ID":262
,"ACTIVEBOOL":false
,"CREATE_DATE":"2023-02-22T14:31:14Z"
,"LAST_UPDATE":"2022-10-06T13:55:03.325000000Z"
,"ACTIVE":1
}
,{
"CUSTOMER_ID":323
,"STORE_ID":1
,"FIRST_NAME":"William"
,"LAST_NAME":"White"
,"EMAIL":"William.White@lehku.net"
,"ADDRESS_ID":264
,"ACTIVEBOOL":false
,"CREATE_DATE":"2023-02-06T15:50:54Z"
,"LAST_UPDATE":"2022-11-15T18:55:57.230000000Z"
,"ACTIVE":1
}
]
}
Film
Output similar to the film table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
DIST_LANGUAGE_ID VARCHAR2 Y
DIST_ORIGINAL_LANGUA VARCHAR2 Y
Example output: 
{
"film":[
{
"FILM_ID":81
,"TITLE":"Happens never Best Heat"
,"DESCRIPTION":"It not lead him to meditate upon his frailty as a."
,"RELEASE_YEAR":1991
,"LANGUAGE_ID":4
,"ORIGINAL_LANGUAGE_ID":4
,"RENTAL_DURATION":6
,"RENTAL_RATE":4.32
,"LENGTH":109
,"REPLACEMENT_COST":20.45
,"RATING":"PG"
,"LAST_UPDATE":"2023-04-17T04:46:07.724000000Z"
,"SPECIAL_FEATURES":"Hijge hexagon (White)"
,"FULLTEXT":"{\"user_list_filter\":\"Random filter\",\"users\":[{\"person_num_pk\":1,\"person_char_pk\":\"FBB5ED920B24F791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Julian Wood\",\"email\":\"sobfis@rupme.mil\",\"address\":\"422 Sohjip Boulevard\",\"zipcode\":\"40588\",\"state\":\"Oklahoma\"},{\"person_num_pk\":2,\"person_char_pk\":\"FBB5ED920B25F791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Kayla Perry\",\"email\":\"libcibsof@gipde.mil\",\"address\":\"319 Remiwvu Loop\",\"zipcode\":\"20878\",\"state\":\"North Dakota\"},{\"person_num_pk\":3,\"person_char_pk\":\"FBB5ED920B26F791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Jaxon Carter\",\"email\":\"rusmi@met.gov\",\"address\":\"167 Rapgisne Extension\",\"zipcode\":\"84606\",\"state\":\"Utah\"},{\"person_num_pk\":4,\"person_char_pk\":\"FBB5ED920B27F791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Jacob Moore\",\"email\":\"mutdesha@leduze.com\",\"address\":\"131 Lavi Plaza\",\"zipcode\":\"72762\",\"state\":\"Iowa\"},{\"person_num_pk\":5,\"person_char_pk\":\"FBB5ED920B28F791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Michael Long\",\"email\":\"zoklacwim@jiri.com\",\"address\":\"454 Ton Way\",\"zipcode\":\"78261\",\"state\":\"Louisiana\"}]}"
}
,{
"FILM_ID":83
,"TITLE":"The Act Married jumping River Carlo"
,"DESCRIPTION":"Chechaquo this was his first winter the trouble with him was that."
,"RELEASE_YEAR":2009
,"LANGUAGE_ID":4
,"ORIGINAL_LANGUAGE_ID":4
,"RENTAL_DURATION":5
,"RENTAL_RATE":3.72
,"LENGTH":124
,"REPLACEMENT_COST":14.7
,"RATING":"G"
,"LAST_UPDATE":"2023-01-21T14:08:49.671000000Z"
,"SPECIAL_FEATURES":"Virtual pako"
,"FULLTEXT":"{\"user_list_filter\":\"Random filter\",\"users\":[{\"person_num_pk\":1,\"person_char_pk\":\"FBB5ED920B29F791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Lydia Ramirez\",\"email\":\"fervi@jog.mil\",\"address\":\"224 Buh Park\",\"zipcode\":\"97810\",\"state\":\"Rhode Island\"},{\"person_num_pk\":2,\"person_char_pk\":\"FBB5ED920B2AF791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Ariana Torres\",\"email\":\"pegi@ne.net\",\"address\":\"381 Lo Park\",\"zipcode\":\"58801\",\"state\":\"Nebraska\"},{\"person_num_pk\":3,\"person_char_pk\":\"FBB5ED920B2BF791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Jack Jenkins\",\"email\":\"biw@vacvizhop.gov\",\"address\":\"496 Luwe Drive\",\"zipcode\":\"72705\",\"state\":\"Ohio\"},{\"person_num_pk\":4,\"person_char_pk\":\"FBB5ED920B2CF791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Levi Cox\",\"email\":\"godpep@sihzul.mil\",\"address\":\"153 Rat Drive\",\"zipcode\":\"42301\",\"state\":\"Vermont\"},{\"person_num_pk\":5,\"person_char_pk\":\"FBB5ED920B2DF791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Jason Wright\",\"email\":\"totti@girhas.net\",\"address\":\"395 Jenfagle Court\",\"zipcode\":\"68005\",\"state\":\"Massachusetts\"},{\"person_num_pk\":6,\"person_char_pk\":\"FBB5ED920B2EF791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Luis Martin\",\"email\":\"memor@dez.com\",\"address\":\"150 Ka Place\",\"zipcode\":\"02911\",\"state\":\"Rhode Island\"},{\"person_num_pk\":7,\"person_char_pk\":\"FBB5ED920B2FF791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Bailey Torres\",\"email\":\"tegimjew@dobi.org\",\"address\":\"185 Hep Parkway\",\"zipcode\":\"10704\",\"state\":\"South Dakota\"},{\"person_num_pk\":8,\"person_char_pk\":\"FBB5ED920B30F791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Zoe Carter\",\"email\":\"winliwkuj@nekna.com\",\"address\":\"123 Negod Trail\",\"zipcode\":\"27478\",\"state\":\"North Dakota\"},{\"person_num_pk\":9,\"person_char_pk\":\"FBB5ED920B31F791E0531910000A691B\",\"person_cdate\":\"2023-05-15T14:22:00\",\"name\":\"Madelyn Alexander\",\"email\":\"cob@sokimpum.mil\",\"address\":\"318 Nifub Road\",\"zipcode\":\"96782\",\"state\":\"Oklahoma\"}]}"
}
]
}
Film_Actor
Output similar to the film_actor table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
DIST_ACTOR_ID VARCHAR2 Y
DIST_FILM_ID VARCHAR2 Y
Example output: 
{
"film_actor":[
{
"ACTOR_ID":34
,"FILM_ID":81
,"LAST_UPDATE":"2023-02-25T08:44:48.637000000Z"
}
,{
"ACTOR_ID":34
,"FILM_ID":81
,"LAST_UPDATE":"2022-08-24T20:51:37.575000000Z"
}
]
}
Film_Category
Output similar to the film_category table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
DIST_FILM_ID VARCHAR2 Y
DIST_CATEGORY_ID VARCHAR2 Y
Example output: 
{
"film_category":[
{
"FILM_ID":81
,"CATEGORY_ID":15
,"LAST_UPDATE":"2023-01-03T21:35:38.707000000Z"
}
,{
"FILM_ID":86
,"CATEGORY_ID":15
,"LAST_UPDATE":"2023-03-22T01:23:30.394000000Z"
}
]
}
Inventory
Output similar to the inventory table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
DIST_FILM_ID VARCHAR2 Y
DIST_STORE_ID VARCHAR2 Y
Example output: 
{
"inventory":[
{
"INVENTORY_ID":1
,"FILM_ID":81
,"STORE_ID":1
,"LAST_UPDATE":"2023-02-27T01:06:55.336000000Z"
}
,{
"INVENTORY_ID":2
,"FILM_ID":81
,"STORE_ID":2
,"LAST_UPDATE":"2022-08-23T12:30:32.136000000Z"
}
]
}
Language
Output similar to the language table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
Example output: 
{
"language":[
{
"LANGUAGE_ID":3
,"NAME":"Thai"
,"LAST_UPDATE":"2022-08-28T08:37:06.569000000Z"
}
,{
"LANGUAGE_ID":4
,"NAME":"Fula"
,"LAST_UPDATE":"2023-04-29T05:42:02.190000000Z"
}
]
}
Payment
Output similar to the payment table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
DIST_CUSTOMER_ID VARCHAR2 Y
DIST_STAFF_ID VARCHAR2 Y
DIST_RENTAL_ID VARCHAR2 Y
Example output: 
{
"payment":[
{
"PAYMENT_ID":5088
,"CUSTOMER_ID":324
,"STAFF_ID":1
,"RENTAL_ID":5091
,"AMOUNT":7.41
,"PAYMENT_DATE":"2022-10-04T22:06:06.000000000Z"
}
,{
"PAYMENT_ID":5089
,"CUSTOMER_ID":324
,"STAFF_ID":1
,"RENTAL_ID":5091
,"AMOUNT":10.2
,"PAYMENT_DATE":"2022-10-20T04:36:53.000000000Z"
}
]
}
Rental
Output similar to the rental table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
DIST_INVENTORY_ID VARCHAR2 Y
DIST_CUSTOMER_ID VARCHAR2 Y
DIST_STAFF_ID VARCHAR2 Y
Example output: 
{
"rental":[
{
"RENTAL_ID":5088
,"RENTAL_DATE":"2023-05-15T14:22:15Z"
,"INVENTORY_ID":2
,"CUSTOMER_ID":322
,"RETURN_DATE":"2024-04-26T16:40:41Z"
,"STAFF_ID":1
,"LAST_UPDATE":"2022-08-30T02:17:11.555000000Z"
}
,{
"RENTAL_ID":5092
,"RENTAL_DATE":"2023-05-15T14:41:15Z"
,"INVENTORY_ID":2
,"CUSTOMER_ID":322
,"RETURN_DATE":"2023-08-20T19:53:37Z"
,"STAFF_ID":1
,"LAST_UPDATE":"2023-03-18T07:26:53.268000000Z"
}
]
}
Staff
Output similar to the staff table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
DIST_ADDRESS_ID VARCHAR2 Y
DIST_STORE_ID VARCHAR2 Y
Example output: 
{
"staff":[
{
"STAFF_ID":1
,"FIRST_NAME":"Bailey"
,"LAST_NAME":"Edwards"
,"ADDRESS_ID":262
,"EMAIL":"BEdwards@kise.mil"
,"STORE_ID":2
,"ACTIVE":true
,"USERNAME":"bailey.edwards"
,"PASSWORD":"f7e88d11c44c78d8e996925be2aeb5b483ba5482"
,"LAST_UPDATE":"2022-09-11T03:52:07.926000000Z"
,"PICTURE":"06b11b7e9"
}
,{
"STAFF_ID":2
,"FIRST_NAME":"Aubrey"
,"LAST_NAME":"Collins"
,"ADDRESS_ID":262
,"EMAIL":"Aubrey.Collins@kosra.org"
,"STORE_ID":2
,"ACTIVE":true
,"USERNAME":"acollins"
,"PASSWORD":"7340e770c1322d3f81d898cea89535584e7d1182"
,"LAST_UPDATE":"2022-12-15T11:18:09.401000000Z"
,"PICTURE":"c439bb72c"
}
]
}
Store
Output similar to the store table from the Pagila sample database.
API Endpoint (click to try):
Parameters:
Name Type Default Default Value
DIST_ADDRESS_ID VARCHAR2 Y
Example output: 
{
"store":[
{
"STORE_ID":1
,"MANAGER_STAFF_ID":1
,"ADDRESS_ID":262
,"LAST_UPDATE":"2023-04-05T15:54:15.560000000Z"
}
,{
"STORE_ID":2
,"MANAGER_STAFF_ID":2
,"ADDRESS_ID":262
,"LAST_UPDATE":"2023-02-06T03:34:04.792000000Z"
}
]
}

Anchor Points

On this page

07.03.2023