How to get different account type test data on sandbox

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:

200

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:

200 GET Account Types

 {
    "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"
        }
    ]
}