Re-Sync Connection With a Non-Admin API Key

Question

How can I re-sync my Apple App Store connection using an API key without admin permissions?

Environment

Connector: Apple App Store

Answer

If you are using an Apple App Store API key without admin permissions, you need to perform the following actions before starting a connection re-sync:

1. Check how old are your ONE_TIME_SNAPSHOT analytics reports for each of the apps you want to re-sync. You can only re-create new ONE_TIME_SNAPSHOT reports once they are 31-days old or older.
2. Delete all existing ONE_TIME_SNAPSHOT analytics reports for each of the apps you want to re-sync, making sure they are 31-days old or older.
3. Create new, up-to-date ONE_TIME_SNAPSHOT analytics reports to replace the ones you deleted. It usually takes 2 days for the App Store to generate new reports.

NOTE: Fivetran recommends granting admin permissions to the Apple App Store API key. With admin permissions, Fivetran automatically deletes all ONE_TIME_SNAPSHOT analytics reports that are 31-days old or older and sends new report requests to App Store Analytics.

Once you have completed the above-mentioned steps, run a historical re-sync for your connection:

1. Log in to your Fivetran dashboard.
2. Select Connectors in the top left corner of the page.
3. Select your Apple App Store connection to open the Connection details page.
4. Go to the Setup tab.
5. Click Resync all historical data to start the re-sync.