> ## Documentation Index
> Fetch the complete documentation index at: https://developer.moneyone.in/llms.txt
> Use this file to discover all available pages before exploring further.

# Analytics Excel

> Compute analytics from raw FI data (in AA format) and return a downloadable Excel report.

Runs the analytics journey over raw FI data (in AA format) you supply in the request and
returns a pre-signed S3 URL to a generated Excel report.

The request is identical to [Analytics JSON](./analytics-json) — only the `journey_id`
changes to the Excel variant, and the response returns a report URL instead of inline
insights.

### Headers

| Header          | Description                               |
| --------------- | ----------------------------------------- |
| `Content-Type`  | `application/json`                        |
| `Authorization` | `Basic <base64(client_id:client_secret)>` |

<Note>
  The `Authorization` value, `journey_id`, and `exchange_application_id` are provided by
  Moneyone during onboarding.
</Note>

### Sample request

Set `journey_id` to the value provided by Moneyone for this variant, and pass the raw FI data (in AA format)
under `input_data.aa_data`.

<CodeGroup>
  ```bash cURL theme={null}
  curl --location --request POST 'https://equal-gms-uat.moneyone.in/ie/transaction/journey/execute' \
    --header 'Content-Type: application/json' \
    --header 'Authorization: Basic <base64(client_id:client_secret)>' \
    --data-raw '{
      "journey_id": "<journey_id>",
      "exchange_application_id": "<exchange_application_id>",
      "input_data": {
        "aa_data": [
          {
            "json_data": {
              "ver": "1.21.0",
              "status": "success",
              "data": [
                {
                  "linkReferenceNumber": "44e41c34-d8ea-42eb-bdfe-822696de735b",
                  "maskedAccountNumber": "XXXXXXXXX5035",
                  "fiType": "DEPOSIT",
                  "bank": "FinShareBankServer",
                  "Profile": { "Holders": { "type": "SINGLE", "Holder": [ { "name": "Suryakumar Choudary", "pan": "PFHAE6063H" } ] } },
                  "Summary": { "currentBalance": "721.29", "currency": "INR", "type": "SAVINGS", "ifscCode": "FNSB0000496" },
                  "Transactions": {
                    "startDate": "2024-11-26T10:14:03.000Z",
                    "endDate": "2025-11-26T09:41:33.000Z",
                    "Transaction": [
                      { "type": "DEBIT", "mode": "OTHERS", "amount": "100000.00", "currentBalance": "987.02", "transactionTimestamp": "2024-11-27T05:29:53.000Z", "narration": "EMI", "reference": "RFN00162658" }
                    ]
                  }
                }
              ]
            },
            "id": "9d48d427-aa5d-47dd-a7da-01f30708df8b"
          }
        ]
      }
    }'
  ```
</CodeGroup>

### Response

```json theme={null}
{
  "status": "SUCCESS",
  "message": "Success",
  "status_code": "success",
  "transaction_id": "80107cd7-e077-4d8d-a4d7-02f3ede2f9fd",
  "journey_transaction_id": "EQ.GT.533b16b6-0a95-4d86-8585-09f51d1d9773#<journey_id>#98df5278c6e1467684c3ca67b93b796d",
  "journey_id": "<journey_id>",
  "data": {
    "insights": {
      "analytics_excel_report": [
        {
          "report_s3_url": "<s3_url_link>"
        }
      ]
    }
  }
}
```

### Response fields

| Field                                                  | Description                                               |
| ------------------------------------------------------ | --------------------------------------------------------- |
| `status`                                               | Overall status, e.g. `SUCCESS`.                           |
| `message`                                              | Human-readable status message.                            |
| `status_code`                                          | Machine-readable status code, e.g. `success`.             |
| `transaction_id`                                       | Unique ID for this analytics transaction.                 |
| `journey_transaction_id`                               | Fully-qualified journey transaction reference.            |
| `journey_id`                                           | The `journey_id` provided by Moneyone for this variant.   |
| `data.insights.analytics_excel_report[].report_s3_url` | Pre-signed S3 URL to download the generated Excel report. |

<Note>
  The `report_s3_url` is a time-limited pre-signed link — download the report promptly before
  it expires.
</Note>
