View
 

Tables::Schema

Schema

 

Describes a given Factual table.

 

Requires a table key in the TABLE_KEY position of request url.

 

 

Basic Example

 

http://api.factual.com/v1/YOUR_API_KEY/tables/CIGf9f/schema

 

Feature Details

 

Parameters

none.

 

Result Payload 

Payload Field Description Examples
schema_object An object describing the schema of the table.

{"fields":
  [
    {"name":"Restaurant","is_primary":true,"id":3231768,"datatype":"String"},
    {"name":"Street Address","is_primary":true,"id":3231769,"datatype":"String"},
    {"name":"City","is_primary":false,"id":3231771,"datatype":"String"},
    {"name":"State","is_primary":false,"id":3231772,"datatype":"String"},
  ],
  "key":"CIGf9f",
  "created_at":"2009/10/11 22:47:03 +0000",
  "total_row_count":53914,
  "description":null,
  "updated_at":"2009/10/11 22:50:09 +0000",
  "name":"California Restaurants",
  "source":null,
  "creator":"factualstaff",
  "rating":1.0,
  "is_private":false,
  "created_by_user_id":186
}