[New Connector] - Apple and Android App Data

[JoseAnaya28]

@apentori

Request from Comms and Founders to get data from the apple app store and the google play store for downloads over time of the Status App.

I tried using the api key you generated for me but it seems the airbyte connector builder won't be sufficient for this request

[apentori]

Could you add more context please ?
Like documentation links, limitation of the connector builder for this, ...

[JoseAnaya28]

@apentori, yeah sorry. Created the issue without a lot of information but here's the summary:

1. For apple connector, the main issue is the authentication. It needs to authenticate using a JWT token and currently the builder does not support it. Other than that, it seems pretty straightforward by requesting a report, read a report and then download the data. Ideally we would be able to get each report subtype.

2. For google, they don't have an API for the app statistics we need. They only have an API for app metrics for backend and system data, so it's not useful for our case. So we need a different way to get the statistics reports.

[jakubgs]

I believe the work on this is continuing, but I see no updates.

[apentori]

For iOS store, the report can only be asked by admin : https://developer.apple.com/documentation/appstoreconnectapi/analytics/downloading_analytics_reports#4333771.
If request is made in the config ONGOING, it should generate on periodicly, that an API key made with the role Sales should be abble to access.