How to generate General Manager report for over a year?

Steps to Generate a Report in Apaleo
Step 1: Create a Custom App in Apaleo
Step 2: Create a Free Postman Account
Step 3: Authenticate the App and Generate the Report
Step 4: Convert the Report to Excel (Optional)

Steps to Generate a Report in Apaleo

Using this option, you will receive the report in JSON format. You can use a free JSON to Excel converter to make the data more readable.

Step 1: Create a Custom App in Apaleo

1. Log in to your Apaleo account.
2. Navigate to Account > Apps > Connected Apps.
3. Click Add a new app and select Add a custom app.
4. Fill in the following details:
   • Client Code: GM report
   • Client Name: GM report
   • Secrets: GM report
   • Scopes: reports.read
5. Click Save.
6. Once completed, copy and save the credentials generated for the app.

Step 2: Create a Free Postman Account

1. Go to Postman.
2. Create a free account.

Step 3: Authenticate the App and Generate the Report

1. After creating the Postman account, select the option to make a new HTTP call.
2. Change the HTTP method to POST.
3. Enter the URL: https://identity.apaleo.com/connect/token.
4. Go to the Authorization tab and select Basic Auth.
5. Enter the credentials saved from your app.
6. Go to the Body tab and select x-www-form-urlencoded.
7. Enter the following key-value pairs:
   • grant_type: client_credentials
8. Click Send to generate an access token.
9. Copy and save the token.
10. To use your credentials:
    • Click New and select HTTP.
    • Keep the method as GET and enter the API call URL:
    • https://api.apaleo.com/reports/v1/reports/property-performance?propertyId={propertyID}&from=2024-01-01&to=2024-08-13&timeSliceDefinitionIds={propertyID}-NIGHT&expand=businessDays
    • Replace {propertyID} with your property's ID from Apaleo.
    • Go to the Authorization tab, select Bearer Token, and enter the token you saved.
    • Click Send to execute the call.

Step 4: Convert the Report to Excel (Optional)

If you want the report in Excel format, you can use online JSON to Excel converters.

Here is one option: https://www.convertcsv.com/json-to-csv.htm.