Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for Instagram Views
|AccountInsights||Allows you to get insights for an Instagram business account. Requires the instagram_basic and instagram_manage_insights scopes.|
|AudienceInsights||Retrieve audience 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.|
|OnlineFollowers||Query Online Followers insights as hourly totals. Requires the instagram_basic and instagram_manage_insights scopes.|
|Pages||Get details of Pages. Requires '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.|
|Places||Query location data about a media object.|
|Stories||Query Stories. Requires the instagram_basic and instagram_manage_insights scopes.|
|Tags||Query tags. Requires the instagram_basic and instagram_manage_comments scopes.|