Little helper to get transactions from Viseca One and print them in CSV format.
While the "auth w/o browser" method is a very comfortable way to get the transactions, it has a higher risk to error due to changes to the auth flow of Viseca One. If it fails, try the "auth w/ browser" method.
This method processes the auth flow in the CLI and will trigger a 2FA request like the login in a browser would.
-
Log in to one.viseca.ch
-
Go to "Transaktionen" on one.viseca.ch
-
Save the card ID from the path (between
/v1/card/and/transactions) -
export VISECA_CLI_USERNAME=<email> export VISECA_CLI_PASSWORD=<password> go run cmd/viseca-cli/main.go transactions <cardID>
This method requires a valid session cookie obtained from an authenticated browser session.
-
Log in to one.viseca.ch
-
Open the developer tools of your browser and navigate to the network tab
-
Go to "Transaktionen" on one.viseca.ch
-
Filter the URLs in the network tab of the developer tools for
transactions -
Save the card ID from the path (between
/v1/card/and/transactions) to an env file (see examples) -
Save the session cookie (
AL_SESS-S=AAAAAA...) to an env file (see examples) -
source .env go run main.go "$CARDID" "$COOKIE" > data/export.csv
"TransactionID","Date","Merchant","Amount","PFMCategoryID","PFMCategoryName"
"AUTH8c919db2-1c23-43f1-8862-61c31336d9b6","2021-10-20T17:05:44","ALDI","50.550000","cv_groceries","Groceries"
The API returns 500 Internal Server Error without any additional information when a request doesn't meet the API requirements.
Large page sizes (e.g. 1000) lead to an error.
{
"totalCount": 1,
"list": [
{
"transactionId": "AUTH8c919db2-1c23-43f1-8862-61c31336d9b6",
"cardId": "0000000AAAAA0000",
"maskedCardNumber": "XXXXXXXXXXXX0000",
"cardName": "Mastercard",
"date": "2021-10-20T17:05:44",
"showTimestamp": true,
"amount": 50.55,
"currency": "CHF",
"originalAmount": 50.55,
"originalCurrency": "CHF",
"merchantName": "Aldi Suisse 00",
"prettyName": "ALDI",
"merchantPlace": "",
"isOnline": false,
"pfmCategory": {
"id": "cv_groceries",
"name": "Lebensmittel",
"lightColor": "#E2FDD3",
"mediumColor": "#A5D58B",
"color": "#51A127",
"imageUrl": "https://api.one.viseca.ch/v1/media/categories/icon_with_background/ic_cat_tile_groceries_v2.png",
"transparentImageUrl": "https://api.one.viseca.ch/v1/media/categories/icon_without_background/ic_cat_tile_groceries_v2.png"
},
"stateType": "authorized",
"details": "Aldi Suisse 00",
"type": "merchant",
"isBilled": false,
"links": {
"transactiondetails": "/v1/card/0000000AAAAA0000/transaction/AUTH8c919db2-1c23-43f1-8862-61c31336d9b6"
}
}
]
}
![renovate[bot] avatar](https://avatars.githubusercontent.com/in/2740?v=4 "renovate[bot]")
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent