Pages
Get details of Pages. Requires a custom OAuth app with 'pages_read_engagement' permission or the 'Page Public Content Access' feature or the 'Page Public Metadata Access' feature.
Table Specific Information
Select
For information on how to create a custom OAuth app, please see Creating a Custom OAuth App. Please refer to Instagram's latest documentation for information on how to get this view's requisite permissions for a custom OAuth app.
The connector 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 connector.
- 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. |