CData Python Connector for Instagram

Build 23.0.8868

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8868