TDV Adapter for Facebook

Build 21.0.8137

Places

Query the Places based on the supplied Id. Places are stored as Pages in Facebook.

Table Specific Information

Places in Facebook are places that can charted on a map and visited. They will typically contain an address, coordinates, and basic information.

Select

If you know the place Id, you may specify the Id to obtain information about the specific place. For example:

SELECT * FROM Places WHERE Id = '407032649344593'

If no Id is specified, no results will come back.

Columns

Name Type Description
ID [KEY] String The Id of the place.
Username String Username for the page of the place if any.
Name String The name of the place.
Category String The category of the place.
Categories String An aggregate of categories associated with the page if multiple categories are available.
Link String A link to the place.
LocationStreet String The street address of the place.
LocationCity String The the city for the place.
LocationState String The the state for the place.
LocationCountry String The the country for the place.
LocationZip String The the ZIP code of the place.
LocationLatitude String The latitude of the place.
LocationLongitude String The longitude of the place.
Phone String The phone number of the place, if available.
Picture String A link to the profile picture of the page for the place.
About String Basic information about the place.
Description String A description of the place, if available.
Website String A link to the website for the place.
Likes Integer Number of people who like the place.
Checkins Integer The total number of users who have checked in to the place.
TalkingAboutCount Integer The number of users talking about the place.
CanPost Boolean Boolean indicating if the authenticated user can post of the page for the place.
IsPublished Boolean A boolean indicating if the page for the place has been published.
IsCommunityPage Boolean Boolean indicating if this is a community Page.
PublicTransit String The public transit available for the place, if any.
ParkingStreet Boolean Boolean indicating if street parking is available.
ParkingLot Boolean Boolean indicating if a parking lot is available.
ParkingValet Boolean Boolean indicating if valet parking is available.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source. For more information, see the WHERE clause section.

Name Type Description
Distance String Optional input that can be specified if searching places. This is the maximum distance from the specified LocationLatitude and LocationLongitude in meters.
offset String Which result to begin returning results from. Used for manual paging of results.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137