JDBC Driver for Instagram

Build 24.0.9062

ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

CData JDBC Driver for Instagram ビュー

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.

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