Pages
Get details of Pages. Requires 'pages_read_engagement' permission or the 'Page Public Content Access' feature or the 'Page Public Metadata Access' feature.
Table Specific Information
Select
The adapter will use the Instagram API to process WHERE clause conditions built with the following column and operator. The SearchTerms is required to make a request and the rest of the filter is executed client side within the adapter.
- SearchTerms supports the '=' comparison.
For example:
SELECT * FROM Pages WHERE SearchTerms='facebook'
Columns
| Name | Type | Description |
| Id [KEY] | String | The ID of the Facebook Page. |
| EligibleForBrandedContent | Boolean | Display whether the Facebook Page is eligible to post branded content. |
| IsUnclaimed | Boolean | Display whether a Facebook Page that was automatically generated has been claimed by the business it represents. |
| Link | String | The link to the Facebook Page. |
| City | String | The city where the business represented by the Facebook Page is located. |
| Country | String | The country where the business represented by the Facebook Page is located. |
| Latitude | Double | The latitude of the business represented by the Facebook Page. |
| Longitude | Double | The longitude of the business represented by the Facebook Page. |
| State | String | The state where the business represented by the Facebook Page is located. |
| Street | String | The street on which the business represented by the Facebook Page is located. |
| Zip | Integer | The postal code of the business represented by the Facebook Page. |
| Name | String | The name of the Facebook Page. |
| VerificationStatus | String | The verification status of the Facebook Page that represents a business. |
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.
| Name | Type | Description |
| SearchTerms | String | The term that is to be searched. |