How to ensure data downloaded from the usage reports is unique?
I am trying to download data from the following reports using the Soap API and load into our Postgres DB.
The reports are scheduled for Daily and Weekly.
How would I know what columns make each row unique? So i don't end up duplicating the data.
[ 'SessionUsage', 'SessionsViewsByUsers', 'SessionsCreatedOrEdited', 'SystemViews' ]
Shows full folder hierarchy. Session Name, Session ID, Presenter, User ID, Email, Start Time, Folder Name, Views, Unique Viewers, Minutes Delivered, Average Minutes Delivered, Session Length, Rating Count, Average Rating, Folder Path.
Username, User ID, Email, Session Name, Session ID, Minutes Delivered, Percentage Completed.