O'Reilly logo

Facebook Cookbook by Jay Goldman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Listing Table

Problem

What’s the schema for the listing table?

Solution

The listing table stores the listings created in the Facebook Marketplace application. Its fields are listed in Table 8-13. Queries to this table will only return data the current user is allowed to see (i.e., you can’t request listing that the current loggedinuser can’t see). More information about this table, including an up-to-date listing of fields, can be found at http://wiki.developers.facebook.com/index.php/Listings_(FQL).

Table 8-13. listing table fields

Name

Type

Index

Description

listing_id

int

Listing ID of this listing.

url

string

 

URL pointing to this listing on Facebook.

title

string

 

Title of this listing.

description

string

 

Description of this listing.

price

string

 

Price of this item as a string (rather than a float).

poster

int

User ID of the user who posted this item.

update_time

string

 

The last time this item was updated in epoch seconds. For more info about epoch seconds, see Formatting Relative Time.

category

string

 

The top-level categories for listings are JOBS, FORSALE, HOUSING, FREESTUFF, and OTHER.

subcategory

string

 

Subcategories are the level below the category. Each category has about five subs (e.g., “For Sale” breaks down into “Books”, “Furniture”, “Tickets”, “Electronics”, “Cars”, and “Other”).

image_urls

array

 

An array of the images uploaded to this listing. Users can add four images when they create the listing and can add more after it’s been created (which is a really effective user ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required