JDBC Driver for Instagram

Build 24.0.9062

MediaInsightsPostAlbum

Allows you to get insights for an individual media object for carousel album POSTs. Requires the instagram_basic and instagram_manage_insights scopes.

Select

You can query the following metrics using server-side processing:

  • TotalInteractions
The 本製品 will use the Instagram APIs to process filters by a MediaId and will process filters on other columns client-side within itself.

  • Return results for the following metrics, saved for all the POSTs carousel album objects: TotalInteractions.
         SELECT * FROM MediaInsightsPostAlbum WHERE MediaId = 17945732813652602"
    
         SELECT TotalInteractions FROM MediaInsightsPostAlbum WHERE MediaId = 17945732813652602 
    
        

Columns

Name Type Description
MediaId String The unique identifier of the insight.
TotalInteractions Integer The number of likes, saves, comments and shares on your post minus the number of unlikes, unsaves and deleted comments.

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