--- title: "Data Source - App Store Connect API" slug: "data-source-app-store-connect-api" updated: 2024-10-07T05:27:29Z published: 2024-10-07T05:27:29Z canonical: "documents.trocco.io/data-source-app-store-connect-api" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Data Source - App Store Connect API ## summary Help Page for ETL Configuration of Report Data Setting from the App Store. ## Obtainable data Data is retrieved using the [App Store Connect API](https://developer.apple.com/documentation/appstoreconnectapi). Financial Reporting" and "Sales and Trends" are available. Each of these reports can be linked to the same reports that can be downloaded from "Payments and Financial Reporting" and "Sales and Trends" in [App Store Connect](https://itunesconnect.apple.com/login?targetPrefix=/WebObjects/iTunesConnect.woa&targetUrl=/wa/jumpTo?page=paymentsAndFinancialReports&authResult=FAILED). [*Here is the](https://help.apple.com/app-store-connect/#/dev061699fdb) help page for Sales and Trends [.](https://help.apple.com/app-store-connect/#/dev061699fdb) [*Here is the](https://help.apple.com/app-store-connect/#/devfa880063b) help page for financial reporting [.](https://help.apple.com/app-store-connect/#/devfa880063b) ## Setting items ### STEP1 Basic settings | item name | indispensable | default value | Contents | | --- | --- | --- | --- | | App Store Connect API Connection Configuration | Yes | - | Select the previously registered Connection Configuration that has the necessary permissions for this ETL Configuration. | | API Endpoint | Yes | - | Specify the URL to connect to the API. | | Input file format | Yes | CSV/TSV | Specify the format of the input file. For more information, see [About input file format settings](/docs/configuration-of-input-files). | | query parameter | No | - | You can specify query parameters to be included in requests to the API. See Query Parameter Types below for more information on parameter types. Parameter values can also be determined dynamically during TROCCO's Data Setting by using [Custom Variables](/docs/custom-variables). | ### Query Parameter Types The parameters that can be specified vary depending on the type of report (API Endpoint URL) to be retrieved. Please refer to the [official documentation for](https://developer.apple.com/documentation/appstoreconnectapi/sales_and_finance_reports) more information. ### Financial Reports | Parameter name | Contents | | --- | --- | | filter[regionCode] | You can specify the unit of currency. See [official documentation](https://help.apple.com/app-store-connect/?lang=en#/dev63d64d955) for code. | | filter[reportDate] | You can specify the date of the report to be retrieved based on the Apple Fiscal Calendar. Specify in YYYYY-MM format. | | filter[reportType] | You can specify **FINANCIAL** or **FINANCE_DETAIL** as the report type. | | filter[vendorNumber] | Vendor number can be specified. For more information, please see the [official documentation](https://help.apple.com/app-store-connect/#/dev3a16f3fe0). | ### Sales and Trends Reports | Parameter name | Contents | | --- | --- | | filter[frequency] | You can specify the interval at which reports are retrieved. **DAILY**, **WEEKLY**, **MONTHLY**, and **YEARLY** can be specified. | | filter[reportDate] | You can specify the date of the report to be retrieved. Specify in YYYYY-MM-DD format. For more information, please see the [official documentation](https://help.apple.com/app-store-connect/#/dev8a5831138). | | filter[reportSubType] | **SUMMARY**, **DETAILED**, and **OPT_IN** can be specified as report subtypes. | | filter[reportType] | **SALES**, **PRE_ORDER**, **NEWSSTAND**, **SUBSCRIPTION**, **SUBSCRIPTION_EVENT**, and **SUBSCRIBER** can be specified as report types. | | filter[vendorNumber] | Vendor number can be specified. For more information, please see the [official documentation](https://help.apple.com/app-store-connect/#/dev3a16f3fe0). | | filter[version] | You can specify the version of the report. For more information, please see the [official documentation](https://developer.apple.com/documentation/appstoreconnectapi/download_sales_and_trends_reports). |