Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData SSIS Components for Instagram Views
| Name | Description |
| AccountContactButtonType | It returns the number of taps on the DIRECTION, CALLs and EMAILs button during the selected time period. For this view, the Metric Type is total_value and Breakdown(dimension) is contact_button_type. Requires the instagram_basic and instagram_manage_insights scopes. |
| AccountFollowType | The number of accounts that followed and the number of accounts that unfollowed or stopped using Instagram during the selected time period. For this view, the Metric Type is total_value and Breakdown(dimension) is follow_type. Requires the instagram_basic and instagram_manage_insights scopes. |
| AccountInsights | Allows you to get insights for an Instagram business account. Requires the instagram_basic and instagram_manage_insights scopes. |
| AccountMediaProductType | It returns the number of POSTs and IGTVs during the selected time period. For this view, the Metric Type is total_value and Breakdown(dimension) is media_product_type. Requires the instagram_basic and instagram_manage_insights scopes. |
| AccountTimeSeriesFollowType | It returns the metric endtime and the value. For this view, the Metric type is time_series and breakdown is follow_type. Requires the instagram_basic and instagram_manage_insights scopes. |
| AccountTimeSeriesMediaProductType | It returns the metric endtime and the value. For this view, the Metric type is time_series and breakdown is media_product_type. Requires the instagram_basic and instagram_manage_insights scopes. |
| AccountTimeSeriesWithoutBreakdown | It returns the metric endtime and the value. For this view, the Metric type is time_series. Requires the instagram_basic and instagram_manage_insights scopes. |
| AccountWithoutBreakdown | It returns the total values of the metric type in Instagram. For eg, if the metric type is impressions, it will return the number of times your posts, stories, reels, videos and live videos were on screen, including in ads. For this view, the Metric Type is total_value. Requires the instagram_basic and instagram_manage_insights scopes. |
| AudienceInsights | Retrieve follower insights for an Instagram business account. |
| IGMedia | This View Represents an Instagram Photo, Video, Story, Album, or IGTV media. |
| InstagramBusinessProfile | Get information about the Instagram Business account. Requires the instagram_basic scope, business_management, manage_pages . |
| InstagramPages | Query information about pages connected to the Facebook account. Requires the instagram_basic scope. |
| Media | Query media objects. Requires the instagram_basic and instagram_content_publish scopes. |
| MediaInsightReels | Allows you to get insights for reel media object. Requires the instagram_basic and instagram_manage_insights scopes. |
| MediaInsights | Allows you to get insights for an individual media object. Requires the instagram_basic and instagram_manage_insights scopes. |
| MediaInsightsPost | Allows you to get insights for an individual media object for image and video POSTs. Requires the instagram_basic and instagram_manage_insights scopes. |
| MediaInsightsPostAlbum | Allows you to get insights for an individual media object for carousel album POSTs. Requires the instagram_basic and instagram_manage_insights scopes. |
| MediaInsightsStory | Allows you to get insights for an individual media object for Story. Requires the instagram_basic and instagram_manage_insights scopes. |
| OnlineFollowers | Query Online Followers insights as hourly totals. Requires the instagram_basic and instagram_manage_insights scopes. |
| 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. |
| Permissions | Query the Permissions the User has granted the current application. |
| Stories | Query Stories. Requires the instagram_basic and instagram_manage_insights scopes. |
| Tags | Query tags. Requires the instagram_basic and instagram_manage_comments scopes. |