How to Create a Service Account for JSON Export
I need to create a service account to export JSON, what steps should I follow?
I need to create a service account to export JSON, what steps should I follow?
Hi Bradley A., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To create a service account in Mixpanel for exporting JSON data, follow these steps: 1. Go to Organization or Project Settings - Navigate to the Service Accounts tab in your Organization settings or Project settings. - You will be prompted to select the role and assign the service account to specific projects. - Note: Service accounts created from the project settings page are automatically assigned an admin role for that project. Deleting a service account from the organization revokes access to all projects, while deleting from a project only revokes access to that project.2. Create the Service Account - Provide a descriptive username. - Optionally, set the role (owner, admin, analyst, consumer), expiration date, and assign it to one or more projects. - When you create the service account, you will receive a secret. Store this secret securely—you will not be able to access it again after creation.3. Use the Service Account Credentials for Export - Use the service account’s username and secret for authentication when making API requests to export JSON data. - Authentication is done via HTTP Basic Auth, and Mixpanel accepts both base64-encoded and plain-text credentials. - Example (cURL):
--user "<serviceaccount_username> :<serviceaccount_secret> "
```LBKS - Example (Python):
```LBKS import requests
requests.get(
'[https://mixpanel.com/api/app/me](https://mixpanel.com/api/app/me)',
auth=('<serviceaccount_username> ', '<serviceaccount_secret> '),
)
```LBKS - When exporting data (e.g., via the Raw Export API), include your service account credentials in the request.
```LBKS curl --request GET \
--url '[https://data.mixpanel.com/api/2.0/export?project_id=<YOUR_PROJECT_ID](https://data.mixpanel.com/api/2.0/export?project_id=<YOUR_PROJECT_ID) &from_date=<FROM_DATE> &to_date=<TO_DATE> >' \
--header 'accept: text/plain' \
--header 'authorization: Basic <base64-encoded-credentials> '
```LBKS - For more details on exporting JSON, see the [Raw Export API documentation](https://developer.mixpanel.com/reference/raw-event-export).LBKS**Important:**
- Only users with Owner or Admin permissions can manage service accounts.
- By default, service accounts do not expire, but you can set an expiration for added security.
- Immediately store your credentials in a safe place after creation, as you cannot retrieve the secret again later.LBKSFor more details, see the Mixpanel documentation on [Service Accounts](https://github.com/mixpanel/docs/blob/main/reference/Mixpanel%20APIs/authentication/service-accounts.md) and [Exporting Data](https://docs.mixpanel.com/guides/playbooks/project-migration#step-3-export-existing-data).
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.