Views
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
| Name | Description |
| 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. |