Skip to content

Instantly share code, notes, and snippets.

@arbass22

arbass22/transactions.json

Created November 23, 2019 19:35
Show Gist options
  • Save arbass22/b0db6d572bbfba9bc652515f31af6fb9 to your computer and use it in GitHub Desktop.
Save arbass22/b0db6d572bbfba9bc652515f31af6fb9 to your computer and use it in GitHub Desktop.
Download ZIP
Sample Plaid Transactions
Raw
transactions.json
{
"accounts": [
{
"account_id": "8XzqjPnBgDFV1EgzyKxqHNRXo55gqKiwX1pxk",
"balances": {
"available": 100,
"current": 110,
"iso_currency_code": "USD",
"limit": null,
"unofficial_currency_code": null
},
"mask": "0000",
"name": "Plaid Checking",
"official_name": "Plaid Gold Standard 0% Interest Checking",
"subtype": "checking",
"type": "depository"
},
{
"account_id": "EXZvBWqMJwFg1vXrwDW9hQKjzvv4xgHXBRejW",
"balances": {
"available": 200,
"current": 210,
"iso_currency_code": "USD",
"limit": null,
"unofficial_currency_code": null
},
"mask": "1111",
"name": "Plaid Saving",
"official_name": "Plaid Silver Standard 0.1% Interest Saving",
"subtype": "savings",
"type": "depository"
},
{
"account_id": "WnrzyA163LFzV7PwKojNHepXqzzJMwFlb9yWL",
"balances": {
"available": null,
"current": 1000,
"iso_currency_code": "USD",
"limit": null,
"unofficial_currency_code": null
},
"mask": "2222",
"name": "Plaid CD",
"official_name": "Plaid Bronze Standard 0.2% Interest CD",
"subtype": "cd",
"type": "depository"
},
{
"account_id": "AXjpkWD7JxFwkbGjQNo9Ud1gpbbxNaF1pjJ1g",
"balances": {
"available": null,
"current": 410,
"iso_currency_code": "USD",
"limit": 2000,
"unofficial_currency_code": null
},
"mask": "3333",
"name": "Plaid Credit Card",
"official_name": "Plaid Diamond 12.5% APR Interest Credit Card",
"subtype": "credit card",
"type": "credit"
},
{
"account_id": "GX1ox6rLJyF64wg3RLDqhkNXpWWn5yF1pBx1m",
"balances": {
"available": 43200,
"current": 43200,
"iso_currency_code": "USD",
"limit": null,
"unofficial_currency_code": null
},
"mask": "4444",
"name": "Plaid Money Market",
"official_name": "Plaid Platinum Standard 1.85% Interest Money Market",
"subtype": "money market",
"type": "depository"
},
{
"account_id": "ndWwQ9qLvMu1aEMwrlnZHQa9nWWzK7H65eV6v",
"balances": {
"available": null,
"current": 320.76,
"iso_currency_code": "USD",
"limit": null,
"unofficial_currency_code": null
},
"mask": "5555",
"name": "Plaid IRA",
"official_name": null,
"subtype": "ira",
"type": "brokerage"
},
{
"account_id": "bn7gzobdZ6FoNzLD7KwpTMqWwGGmN9FVkxKVd",
"balances": {
"available": null,
"current": 23631.9805,
"iso_currency_code": "USD",
"limit": null,
"unofficial_currency_code": null
},
"mask": "6666",
"name": "Plaid 401k",
"official_name": null,
"subtype": "401k",
"type": "brokerage"
},
{
"account_id": "mxEbXwl1vgCLJ7egKRP8TJd8PyywMKuLompLn",
"balances": {
"available": null,
"current": 65262,
"iso_currency_code": "USD",
"limit": null,
"unofficial_currency_code": null
},
"mask": "7777",
"name": "Plaid Student Loan",
"official_name": null,
"subtype": "student",
"type": "loan"
}
],
"item": {
"available_products": [
"assets",
"balance",
"credit_details",
"identity",
"income",
"investments",
"liabilities"
],
"billed_products": ["auth", "transactions"],
"error": null,
"institution_id": "ins_3",
"item_id": "RnboyA7mqQFVjDyMP1gxHGXbGWPDZ7HRq9D59",
"webhook": ""
},
"total_transactions": 17,
"transactions": [
{
"account_id": "8XzqjPnBgDFV1EgzyKxqHNRXo55gqKiwX1pxk",
"account_owner": null,
"amount": 6.33,
"category": ["Travel", "Car Service", "Ride Share"],
"category_id": "22006001",
"date": "2019-10-31",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "Uber 072515 SF**POOL**",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "gq1ka6RjoPTq7mWJD5XZUQlzamRRPPSg6VRgM",
"transaction_type": "special",
"unofficial_currency_code": null
},
{
"account_id": "AXjpkWD7JxFwkbGjQNo9Ud1gpbbxNaF1pjJ1g",
"account_owner": null,
"amount": 500,
"category": ["Food and Drink", "Restaurants"],
"category_id": "13005000",
"date": "2019-10-28",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "Tectra Inc",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "ndWwQ9qLvMu1aEMwrlnZHQag5pJJEES65eV6m",
"transaction_type": "place",
"unofficial_currency_code": null
},
{
"account_id": "AXjpkWD7JxFwkbGjQNo9Ud1gpbbxNaF1pjJ1g",
"account_owner": null,
"amount": 2078.5,
"category": ["Payment"],
"category_id": "16000000",
"date": "2019-10-27",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "AUTOMATIC PAYMENT - THANK",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "y1B5WRPmwMU6e5JozNldhjyq4KrrddCya3ny7",
"transaction_type": "special",
"unofficial_currency_code": null
},
{
"account_id": "AXjpkWD7JxFwkbGjQNo9Ud1gpbbxNaF1pjJ1g",
"account_owner": null,
"amount": 500,
"category": ["Food and Drink", "Restaurants"],
"category_id": "13005000",
"date": "2019-10-27",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "KFC",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "mxEbXwl1vgCLJ7egKRP8TJdxrWjjNNcLompLG",
"transaction_type": "place",
"unofficial_currency_code": null
},
{
"account_id": "AXjpkWD7JxFwkbGjQNo9Ud1gpbbxNaF1pjJ1g",
"account_owner": null,
"amount": 500,
"category": ["Shops", "Sporting Goods"],
"category_id": "19046000",
"date": "2019-10-27",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "Madison Bicycle Shop",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "bn7gzobdZ6FoNzLD7KwpTMqJaz33KKhVkxKVy",
"transaction_type": "place",
"unofficial_currency_code": null
},
{
"account_id": "EXZvBWqMJwFg1vXrwDW9hQKjzvv4xgHXBRejW",
"account_owner": null,
"amount": 25,
"category": ["Payment", "Credit Card"],
"category_id": "16001000",
"date": "2019-10-18",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "CREDIT CARD 3333 PAYMENT *//",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "6DKdb4ArpecJE47KZoNxHQpjqAa8jLsgl9KvR",
"transaction_type": "special",
"unofficial_currency_code": null
},
{
"account_id": "8XzqjPnBgDFV1EgzyKxqHNRXo55gqKiwX1pxk",
"account_owner": null,
"amount": 5.4,
"category": ["Travel", "Car Service", "Ride Share"],
"category_id": "22006001",
"date": "2019-10-18",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "Uber 063015 SF**POOL**",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "9XBKMjb3JdF8bDXB1rdLFXWozwblojFRvGyXx",
"transaction_type": "special",
"unofficial_currency_code": null
},
{
"account_id": "GX1ox6rLJyF64wg3RLDqhkNXpWWn5yF1pBx1m",
"account_owner": null,
"amount": 5850,
"category": ["Transfer", "Debit"],
"category_id": "21006000",
"date": "2019-10-17",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "ACH Electronic CreditGUSTO PAY 123456",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": "ACH",
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "ZR3eyAola8ty6gLqxdjeH1NyGXb5yMigERq4n",
"transaction_type": "special",
"unofficial_currency_code": null
},
{
"account_id": "WnrzyA163LFzV7PwKojNHepXqzzJMwFlb9yWL",
"account_owner": null,
"amount": 1000,
"category": ["Transfer", "Deposit"],
"category_id": "21007000",
"date": "2019-10-17",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "CD DEPOSIT .INITIAL.",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "QynmGAjblXtQRkzpPLw3H4KQmbdlQGFpgM6b4",
"transaction_type": "special",
"unofficial_currency_code": null
},
{
"account_id": "AXjpkWD7JxFwkbGjQNo9Ud1gpbbxNaF1pjJ1g",
"account_owner": null,
"amount": 78.5,
"category": ["Recreation", "Gyms and Fitness Centers"],
"category_id": "17018000",
"date": "2019-10-16",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "Touchstone Climbing",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "XJkBVRLXxguQDw51EgyrHKnd3NmBdeHdX6KGG",
"transaction_type": "place",
"unofficial_currency_code": null
},
{
"account_id": "8XzqjPnBgDFV1EgzyKxqHNRXo55gqKiwX1pxk",
"account_owner": null,
"amount": -500,
"category": ["Travel", "Airlines and Aviation Services"],
"category_id": "22001000",
"date": "2019-10-16",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "United Airlines",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "y1B5WRPmwMU6e5JozNldhjyXaQElXZFya3n7n",
"transaction_type": "special",
"unofficial_currency_code": null
},
{
"account_id": "8XzqjPnBgDFV1EgzyKxqHNRXo55gqKiwX1pxk",
"account_owner": null,
"amount": 12,
"category": ["Food and Drink", "Restaurants"],
"category_id": "13005000",
"date": "2019-10-15",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": "3322",
"zip": null
},
"name": "McDonald's",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "bn7gzobdZ6FoNzLD7KwpTMqG6D8nG7cVkxKM6",
"transaction_type": "place",
"unofficial_currency_code": null
},
{
"account_id": "8XzqjPnBgDFV1EgzyKxqHNRXo55gqKiwX1pxk",
"account_owner": null,
"amount": 4.33,
"category": ["Food and Drink", "Restaurants", "Coffee Shop"],
"category_id": "13005043",
"date": "2019-10-15",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "Starbucks",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "mxEbXwl1vgCLJ7egKRP8TJdyR5b9yEtLompVe",
"transaction_type": "place",
"unofficial_currency_code": null
},
{
"account_id": "8XzqjPnBgDFV1EgzyKxqHNRXo55gqKiwX1pxk",
"account_owner": null,
"amount": 89.4,
"category": ["Food and Drink", "Restaurants"],
"category_id": "13005000",
"date": "2019-10-14",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "SparkFun",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "ndWwQ9qLvMu1aEMwrlnZHQaWvBymWbs65eVLQ",
"transaction_type": "place",
"unofficial_currency_code": null
},
{
"account_id": "EXZvBWqMJwFg1vXrwDW9hQKjzvv4xgHXBRejW",
"account_owner": null,
"amount": -4.22,
"category": ["Transfer", "Credit"],
"category_id": "21005000",
"date": "2019-10-13",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "INTRST PYMNT",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "RnboyA7mqQFVjDyMP1gxHGXVZWyJVpSRqlkeg",
"transaction_type": "special",
"unofficial_currency_code": null
},
{
"account_id": "AXjpkWD7JxFwkbGjQNo9Ud1gpbbxNaF1pjJ1g",
"account_owner": null,
"amount": 500,
"category": ["Travel", "Airlines and Aviation Services"],
"category_id": "22001000",
"date": "2019-10-03",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "United Airlines",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "6DKdb4ArpecJE47KZoNxHQpjqAa8jLsgl9D4N",
"transaction_type": "special",
"unofficial_currency_code": null
},
{
"account_id": "8XzqjPnBgDFV1EgzyKxqHNRXo55gqKiwX1pxk",
"account_owner": null,
"amount": 6.33,
"category": ["Travel", "Car Service", "Ride Share"],
"category_id": "22006001",
"date": "2019-10-01",
"iso_currency_code": "USD",
"location": {
"address": null,
"city": null,
"lat": null,
"lon": null,
"state": null,
"store_number": null,
"zip": null
},
"name": "Uber 072515 SF**POOL**",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"pending": false,
"pending_transaction_id": null,
"transaction_id": "GX1ox6rLJyF64wg3RLDqhkNW6VmgW7T1pBxz3",
"transaction_type": "special",
"unofficial_currency_code": null
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment