Hi Team,
I was trying to extract data from sandbox but on sandbox only “ Checking ” account type transactions data are present .
Could you let me know how can i get test transaction data or metadata for different account type(mostly loan_data , Mortgage , line of credit and creditcard )
Thank you,
Smruti
Hi! @demoprod
Yo can pull all the accounts from a credential via GET /accounts’s endpoint from a credential:
List accounts for a specific user via GET
{
"rid": "6f004535-a5d5-4be5-a669-f548f0911aab",
"code": 200,
"errors": null,
"status": true,
"message": null,
"response": [
{
"id_account": "5703f88223428348328b45db",
"id_account_type": "520d3aa93b8e778e0d000000",
"id_currency": "523a25953b8e77910e8b456c",
"id_user": "5dde750d8c91e77a123e7013",
"id_external": "",
"id_credential": "5e727097db79ef1a0b3193a2",
"id_site": "56cf5728784806f72b8b4568",
"id_site_organization": "56cf4ff5784806152c8b4567",
"id_site_organization_type": "56cf4f5b784806cf028b4568",
"is_disable": 0,
"name": "ACME Checking",
"number": "00000001",
"balance": 1099,
"currency": "MXN",
"account_type": "Checking",
"site": {
"id_site": "56cf5728784806f72b8b4568",
"id_site_organization": "56cf4ff5784806152c8b4567",
"id_site_organization_type": "56cf4f5b784806cf028b4568",
"name": "Normal",
"organization": "Acme Bank",
"avatar": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJuYnp6NUhjNG9nc1A4MlJXTENxVUlEdElaMVoreTlyNjlTSDFXaXBuckpqUGpFUytmcHU4dnhIQkt0QW81RHBKdz09",
"cover": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJxYXZVeEhjWWcxNTR0a25OMy9TV3dTMnE0VENlTmFzemVEYnZ2elhqWTVXa2JXU0lrclFtT3VteG8xN2sxeHN6QT09",
"small_cover": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJxYXZVeEhjWWcxNTR0a25OMy9TV3dTMnE0VENlTmFzemVEYnZ2elhqWTVXUTNZclN2TWF4YUJZNU9ib2crMWJpUUNyQ0NYRXVQWURpNmduU1JHTlRJZz0",
"time_zone": "America/Mexico_City"
},
"extra": null,
"keywords": null,
"dt_refresh": 1552530148
},
{
"id_account": "5703f88323428348328b45eb",
"id_account_type": "520d3aa93b8e778e0d000002",
"id_currency": "523a25953b8e77910e8b456c",
"id_user": "5dde750d8c91e77a123e7013",
"id_external": "",
"id_credential": "5e727097db79ef1a0b3193a2",
"id_site": "56cf5728784806f72b8b4568",
"id_site_organization": "56cf4ff5784806152c8b4567",
"id_site_organization_type": "56cf4f5b784806cf028b4568",
"is_disable": 0,
"name": "ACME Credit",
"number": "00000011",
"balance": -535,
"currency": "MXN",
"account_type": "Credit Card",
"site": {
"id_site": "56cf5728784806f72b8b4568",
"id_site_organization": "56cf4ff5784806152c8b4567",
"id_site_organization_type": "56cf4f5b784806cf028b4568",
"name": "Normal",
"organization": "Acme Bank",
"avatar": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJuYnp6NUhjNG9nc1A4MlJXTENxVUlEdElaMVoreTlyNjlTSDFXaXBuckpqUGpFUytmcHU4dnhIQkt0QW81RHBKdz09",
"cover": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJxYXZVeEhjWWcxNTR0a25OMy9TV3dTMnE0VENlTmFzemVEYnZ2elhqWTVXa2JXU0lrclFtT3VteG8xN2sxeHN6QT09",
"small_cover": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJxYXZVeEhjWWcxNTR0a25OMy9TV3dTMnE0VENlTmFzemVEYnZ2elhqWTVXUTNZclN2TWF4YUJZNU9ib2crMWJpUUNyQ0NYRXVQWURpNmduU1JHTlRJZz0",
"time_zone": "America/Mexico_City"
},
"extra": {
"owner": "Homer Simpson",
"owner_address": "742 Evergreen Terrace",
"available": 1000
},
"keywords": null,
"dt_refresh": 1552530148
},
{
"id_account": "5703f88323428348328b45f0",
"id_account_type": "520d3aa93b8e778e0d000004",
"id_currency": "523a25953b8e77910e8b456c",
"id_user": "5dde750d8c91e77a123e7013",
"id_external": "",
"id_credential": "5e727097db79ef1a0b3193a2",
"id_site": "56cf5728784806f72b8b4568",
"id_site_organization": "56cf4ff5784806152c8b4567",
"id_site_organization_type": "56cf4f5b784806cf028b4568",
"is_disable": 0,
"name": "ACME Investment",
"number": "00000021",
"balance": 499,
"currency": "MXN",
"account_type": "Investment",
"site": {
"id_site": "56cf5728784806f72b8b4568",
"id_site_organization": "56cf4ff5784806152c8b4567",
"id_site_organization_type": "56cf4f5b784806cf028b4568",
"name": "Normal",
"organization": "Acme Bank",
"avatar": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJuYnp6NUhjNG9nc1A4MlJXTENxVUlEdElaMVoreTlyNjlTSDFXaXBuckpqUGpFUytmcHU4dnhIQkt0QW81RHBKdz09",
"cover": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJxYXZVeEhjWWcxNTR0a25OMy9TV3dTMnE0VENlTmFzemVEYnZ2elhqWTVXa2JXU0lrclFtT3VteG8xN2sxeHN6QT09",
"small_cover": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJxYXZVeEhjWWcxNTR0a25OMy9TV3dTMnE0VENlTmFzemVEYnZ2elhqWTVXUTNZclN2TWF4YUJZNU9ib2crMWJpUUNyQ0NYRXVQWURpNmduU1JHTlRJZz0",
"time_zone": "America/Mexico_City"
},
"extra": null,
"keywords": null,
"dt_refresh": 1552530148
},
{
"id_account": "57317925234283f1078b6837",
"id_account_type": "520d3aa93b8e778e0d000002",
"id_currency": "523a25953b8e77910e8b456c",
"id_user": "5dde750d8c91e77a123e7013",
"id_external": "",
"id_credential": "5e727097db79ef1a0b3193a2",
"id_site": "56cf5728784806f72b8b4568",
"id_site_organization": "56cf4ff5784806152c8b4567",
"id_site_organization_type": "56cf4f5b784806cf028b4568",
"is_disable": 1,
"name": "ACME Credit",
"number": "00000011",
"balance": 535,
"currency": "MXN",
"account_type": "Credit Card",
"site": {
"id_site": "56cf5728784806f72b8b4568",
"id_site_organization": "56cf4ff5784806152c8b4567",
"id_site_organization_type": "56cf4f5b784806cf028b4568",
"name": "Normal",
"organization": "Acme Bank",
"avatar": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJuYnp6NUhjNG9nc1A4MlJXTENxVUlEdElaMVoreTlyNjlTSDFXaXBuckpqUGpFUytmcHU4dnhIQkt0QW81RHBKdz09",
"cover": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJxYXZVeEhjWWcxNTR0a25OMy9TV3dTMnE0VENlTmFzemVEYnZ2elhqWTVXa2JXU0lrclFtT3VteG8xN2sxeHN6QT09",
"small_cover": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJxYXZVeEhjWWcxNTR0a25OMy9TV3dTMnE0VENlTmFzemVEYnZ2elhqWTVXUTNZclN2TWF4YUJZNU9ib2crMWJpUUNyQ0NYRXVQWURpNmduU1JHTlRJZz0",
"time_zone": "America/Mexico_City"
},
"extra": null,
"keywords": null,
"dt_refresh": 1494867506
},
{
"id_account": "57317925234283f1078b6841",
"id_account_type": "520d3aa93b8e778e0d000004",
"id_currency": "523a25953b8e77910e8b456c",
"id_user": "5dde750d8c91e77a123e7013",
"id_external": "",
"id_credential": "5e727097db79ef1a0b3193a2",
"id_site": "56cf5728784806f72b8b4568",
"id_site_organization": "56cf4ff5784806152c8b4567",
"id_site_organization_type": "56cf4f5b784806cf028b4568",
"is_disable": 1,
"name": "ACME Investment",
"number": "00000021",
"balance": 499,
"currency": "MXN",
"account_type": "Investment",
"site": {
"id_site": "56cf5728784806f72b8b4568",
"id_site_organization": "56cf4ff5784806152c8b4567",
"id_site_organization_type": "56cf4f5b784806cf028b4568",
"name": "Normal",
"organization": "Acme Bank",
"avatar": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJuYnp6NUhjNG9nc1A4MlJXTENxVUlEdElaMVoreTlyNjlTSDFXaXBuckpqUGpFUytmcHU4dnhIQkt0QW81RHBKdz09",
"cover": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJxYXZVeEhjWWcxNTR0a25OMy9TV3dTMnE0VENlTmFzemVEYnZ2elhqWTVXa2JXU0lrclFtT3VteG8xN2sxeHN6QT09",
"small_cover": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJxYXZVeEhjWWcxNTR0a25OMy9TV3dTMnE0VENlTmFzemVEYnZ2elhqWTVXUTNZclN2TWF4YUJZNU9ib2crMWJpUUNyQ0NYRXVQWURpNmduU1JHTlRJZz0",
"time_zone": "America/Mexico_City"
},
"extra": null,
"keywords": null,
"dt_refresh": 1494867506
},
{
"id_account": "57317925234283f1078b6843",
"id_account_type": "520d3aa93b8e778e0d000000",
"id_currency": "523a25953b8e77910e8b456c",
"id_user": "5dde750d8c91e77a123e7013",
"id_external": "",
"id_credential": "5e727097db79ef1a0b3193a2",
"id_site": "56cf5728784806f72b8b4568",
"id_site_organization": "56cf4ff5784806152c8b4567",
"id_site_organization_type": "56cf4f5b784806cf028b4568",
"is_disable": 1,
"name": "ACME Checking",
"number": "00000001",
"balance": 1099,
"currency": "MXN",
"account_type": "Checking",
"site": {
"id_site": "56cf5728784806f72b8b4568",
"id_site_organization": "56cf4ff5784806152c8b4567",
"id_site_organization_type": "56cf4f5b784806cf028b4568",
"name": "Normal",
"organization": "Acme Bank",
"avatar": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJuYnp6NUhjNG9nc1A4MlJXTENxVUlEdElaMVoreTlyNjlTSDFXaXBuckpqUGpFUytmcHU4dnhIQkt0QW81RHBKdz09",
"cover": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJxYXZVeEhjWWcxNTR0a25OMy9TV3dTMnE0VENlTmFzemVEYnZ2elhqWTVXa2JXU0lrclFtT3VteG8xN2sxeHN6QT09",
"small_cover": "/assets/Z1JLMk5FTTFTcVE4ZW81NWVEZU9sbFI3bEhOT0JEd2wyd2VsbjcrTWZYRzAxbzZEeUJqNGJxYXZVeEhjWWcxNTR0a25OMy9TV3dTMnE0VENlTmFzemVEYnZ2elhqWTVXUTNZclN2TWF4YUJZNU9ib2crMWJpUUNyQ0NYRXVQWURpNmduU1JHTlRJZz0",
"time_zone": "America/Mexico_City"
},
"extra": null,
"keywords": null,
"dt_refresh": 1494867506
}
]
}
And then identifie the type by the id_account_type field in response using GET /catalogues/account_types’s endpoint from catalogues:
{
"rid": "09090caf-8aa5-4de6-bcc6-2b85a22a5ed6",
"code": 200,
"errors": null,
"status": true,
"message": null,
"response": [
{
"id_account_type": "520d3aa93b8e778e0d000002",
"name": "Credit Card"
},
{
"id_account_type": "520d3aa93b8e778e0d000000",
"name": "Checking"
},
{
"id_account_type": "520d3aa93b8e778e0d000001",
"name": "Savings"
},
{
"id_account_type": "520d3aa93b8e778e0d000004",
"name": "Investment"
},
{
"id_account_type": "546d4904df527d1844a2e18d",
"name": "IRS"
},
{
"id_account_type": "546d4904df527d1844a2e18e",
"name": "Utility"
},
{
"id_account_type": "589e638e056f290ac1280941",
"name": "Rewards"
},
{
"id_account_type": "5286609bc6901663398b4567",
"name": "Digital Wallet"
},
{
"id_account_type": "5286609bc6901663398b4568",
"name": "Other"
},
{
"id_account_type": "5b21a816056f291e260c0730",
"name": "Blockchain"
},
{
"id_account_type": "520d3aa93b8e778e0d000003",
"name": "Line of Credit"
},
{
"id_account_type": "520d3aa93b8e778e0d000006",
"name": "Loan"
},
{
"id_account_type": "520d3aa93b8e778e0d000005",
"name": "Mortgage"
}
]
}