This is the plaid schema guide.
For MX : https://docs.mx.com/api#core_resources_transactions
For Yodlee: https://developer.yodlee.com/Yodlee_API/docs/v1_1/Data_Model/Resource_Transactions
YODLEE
{
"date": "string",
"sourceId": "string",
"symbol": "string",
"cusipNumber": "string",
"highLevelCategoryId": 0,
"detailCategoryId": 0,
"description": : {
"security": "string",
"original": "string",
"simple": "string",
"consumer": "string"
},
"memo": "string",
"settleDate": "string",
"type": "string",
"baseType": "CREDIT",
"categorySource": "SYSTEM",
"principal": {
"amount": 0,
"currency": "USD"
},
"lastUpdated": "string",
"interest": {
"amount": 0,
"currency": "USD"
},
"price": {
"amount": 0,
"currency": "USD"
},
"commission": {
"amount": 0,
"currency": "USD"
},
"id": 0,
"amount": {
"amount": 0,
"currency": "USD"
},
"checkNumber": "string",
"quantity": 0,
"valoren": "string",
"isManual": true,
"merchant": {
"website": "string",
"address": {
"zip": "string",
"country": "string",
"address3": "string",
"address2": "string",
"city": "string",
"sourceType": "string",
"address1": "string",
"street": "string",
"state": "string",
"type": "HOME"
},
"contact": {
"phone": "string",
"email": "string"
},
"categoryLabel": [
"string"
],
"coordinates": {
"latitude": 0,
"longitude": 0
},
"name": "string",
"id": "string",
"source": "YODLEE"
},
"sedol": "string",
"transactionDate": "string",
"categoryType": "TRANSFER",
"accountId": 0,
"createdDate": "string",
"sourceType": "AGGREGATED",
"CONTAINER": "bank",
"postDate": "string",
"parentCategoryId": 0,
"subType": "AUTH_HOLD",
"category": "string",
"runningBalance": {
"amount": 0,
"currency": "USD"
},
"categoryId": 0,
"holdingDescription": "string",
"isin": "string",
"status": "POSTED"
}
MX
{
"transactions": [
{
"category": "Gas",
"created_at": "2020-09-21T19:43:48Z",
"date": "2020-09-21",
"posted_at": "2020-09-22T12:00:00Z",
"status": "POSTED",
"top_level_category": "Auto & Transport",
"transacted_at": "2020-09-21T12:00:00Z",
"type": "DEBIT",
"updated_at": "2020-09-21T19:43:51Z",
"account_guid": "ACT-8e6f92c8-1491-42ce-8bf6-c309e9531530",
"amount": 7.29,
"check_number_string": null,
"currency_code": "USD",
"description": "ExxonMobil",
"guid": "TRN-822b443e-972c-431e-8dcf-c2b08de21136",
"is_bill_pay": false,
"is_direct_deposit": false,
"is_expense": true,
"is_fee": false,
"is_income": false,
"is_international": null,
"is_overdraft_fee": false,
"is_payroll_advance": false,
"latitude": null,
"localized_description": null,
"localized_memo": null,
"longitude": null,
"member_guid": "MBR-84ca0882-ad6c-4f10-817f-c8c0de7424fa",
"memo": null,
"merchant_category_code": 0,
"merchant_guid": "MCH-dcd9bbcd-11bb-076a-60c4-90f1101b3372",
"original_description": "ExxonMobil",
"user_guid": "USR-11141024-90b3-1bce-cac9-c06ced52ab4c"
}
],
"pagination": {
"current_page": 1,
"per_page": 25,
"total_entries": 176,
"total_pages": 8
}
}
For MX : https://docs.mx.com/api#core_resources_accounts
For Yodlee: https://developer.yodlee.com/Yodlee_API/docs/v1_1/Data_Model/Resource_Account
Schema
YODLEE
{
"account": [
{
"availableCash": {
"amount": 0,
"currency": "AUD"
},
"includeInNetWorth": true,
"moneyMarketBalance": {
"amount": 0,
"currency": "AUD"
},
"enrollmentDate": "string",
"estimatedDate": "string",
"memo": "string",
"guarantor": "string",
"interestPaidLastYear": {
"amount": 0,
"currency": "AUD"
},
"lastUpdated": "string",
"balance": {
"amount": 0,
"currency": "AUD"
},
"homeInsuranceType": "HOME_OWNER",
"id": 0,
"cash": {
"amount": 0,
"currency": "AUD"
},
"totalCreditLine": {
"amount": 0,
"currency": "AUD"
},
"providerName": "string",
"valuationType": "SYSTEM",
"marginBalance": {
"amount": 0,
"currency": "AUD"
},
"apr": 0,
"availableCredit": {
"amount": 0,
"currency": "AUD"
},
"currentBalance": {
"amount": 0,
"currency": "AUD"
},
"isManual": true,
"profile": {
"identifier": [
{
"type": "NIE",
"value": "string"
}
],
"address": [
{
"zip": "string",
"country": "string",
"address3": "string",
"address2": "string",
"city": "string",
"sourceType": "string",
"address1": "string",
"street": "string",
"state": "string",
"type": "HOME"
}
],
"phoneNumber": [
{
"type": "HOME",
"value": "string"
}
],
"email": [
{
"type": "PRIMARY",
"value": "string"
}
]
},
"escrowBalance": {
"amount": 0,
"currency": "AUD"
},
"nextLevel": "string",
"classification": "OTHER",
"loanPayoffAmount": {
"amount": 0,
"currency": "AUD"
},
"interestRateType": "FIXED",
"loanPayByDate": "string",
"faceAmount": {
"amount": 0,
"currency": "AUD"
},
"policyFromDate": "string",
"premiumPaymentTerm": "string",
"policyTerm": "string",
"repaymentPlanType": "STANDARD",
"availableBalance": {
"amount": 0,
"currency": "AUD"
},
"accountStatus": "ACTIVE",
"lifeInsuranceType": "OTHER",
"fullAccountNumber": "string",
"premium": {
"amount": 0,
"currency": "AUD"
},
"aggregationSource": "SYSTEM",
"overDraftLimit": {
"amount": 0,
"currency": "AUD"
},
"nickname": "string",
"term": "string",
"interestRate": 0,
"deathBenefit": {
"amount": 0,
"currency": "AUD"
},
"address": {
"zip": "string",
"country": "string",
"address3": "string",
"address2": "string",
"city": "string",
"sourceType": "string",
"address1": "string",
"street": "string",
"state": "string",
"type": "HOME"
},
"cashValue": {
"amount": 0,
"currency": "AUD"
},
"holder": [
{
"identifier": [
{
"type": "NIE",
"value": "string"
}
],
"gender": "string",
"ownership": "PRIMARY",
"name": {
"middle": "string",
"last": "string",
"fullName": "string",
"first": "string"
}
}
],
"401kLoan": {
"amount": 0,
"currency": "AUD"
},
"homeValue": {
"amount": 0,
"currency": "AUD"
},
"accountNumber": "string",
"createdDate": "string",
"interestPaidYTD": {
"amount": 0,
"currency": "AUD"
},
"providerAccountId": 0,
"collateral": "string",
"dataset": [
{
"lastUpdated": "string",
"updateEligibility": "ALLOW_UPDATE",
"additionalStatus": "LOGIN_IN_PROGRESS",
"nextUpdateScheduled": "string",
"name": "BASIC_AGG_DATA",
"lastUpdateAttempt": "string"
}
],
"runningBalance": {
"amount": 0,
"currency": "AUD"
},
"sourceId": "string",
"dueDate": "string",
"frequency": "DAILY",
"maturityAmount": {
"amount": 0,
"currency": "AUD"
},
"associatedProviderAccountId": [
0
],
"isAsset": true,
"principalBalance": {
"amount": 0,
"currency": "AUD"
},
"totalCashLimit": {
"amount": 0,
"currency": "AUD"
},
"maturityDate": "string",
"minimumAmountDue": {
"amount": 0,
"currency": "AUD"
},
"annualPercentageYield": 0,
"accountType": "string",
"originationDate": "string",
"totalVestedBalance": {
"amount": 0,
"currency": "AUD"
},
"rewardBalance": [
{
"expiryDate": "string",
"balanceToReward": "string",
"balanceType": "EXPIRING_BALANCE",
"balance": 0,
"description": "string",
"balanceToLevel": "string",
"units": "string"
}
],
"sourceAccountStatus": "IN_REPAYMENT",
"derivedApr": 0,
"policyEffectiveDate": "string",
"totalUnvestedBalance": {
"amount": 0,
"currency": "AUD"
},
"annuityBalance": {
"amount": 0,
"currency": "AUD"
},
"accountName": "string",
"totalCreditLimit": {
"amount": 0,
"currency": "AUD"
},
"policyStatus": "ACTIVE",
"shortBalance": {
"amount": 0,
"currency": "AUD"
},
"lender": "string",
"lastEmployeeContributionAmount": {
"amount": 0,
"currency": "AUD"
},
"providerId": "string",
"lastPaymentDate": "string",
"primaryRewardUnit": "string",
"lastPaymentAmount": {
"amount": 0,
"currency": "AUD"
},
"remainingBalance": {
"amount": 0,
"currency": "AUD"
},
"userClassification": "BUSINESS",
"bankTransferCode": [
{
"id": "string",
"type": "BSB"
}
],
"expirationDate": "string",
"coverage": [
{
"amount": [
{
"cover": {
"amount": 0,
"currency": "AUD"
},
"unitType": "PER_FAMILY",
"type": "DEDUCTIBLE",
"limitType": "IN_NETWORK",
"met": {
"amount": 0,
"currency": "AUD"
}
}
],
"planType": "PPO",
"endDate": "string",
"type": "VISION",
"startDate": "string"
}
],
"cashApr": 0,
"autoRefresh": {
"additionalStatus": "SCHEDULED",
"asOfDate": "string",
"status": "ENABLED"
},
"oauthMigrationStatus": "IN_PROGRESS",
"displayedName": "string",
"fullAccountNumberList": {
"paymentAccountNumber": "string",
"unmaskedAccountNumber": "string"
},
"amountDue": {
"amount": 0,
"currency": "AUD"
},
"currentLevel": "string",
"originalLoanAmount": {
"amount": 0,
"currency": "AUD"
},
"policyToDate": "string",
"loanPayoffDetails": {
"payByDate": "string",
"payoffAmount": {
"amount": 0,
"currency": "AUD"
},
"outstandingBalance": {
"amount": 0,
"currency": "AUD"
}
},
"paymentProfile": {
"identifier": {
"type": "REFERENCE_NUMBER",
"value": "string"
},
"address": [
{
"zip": "string",
"country": "string",
"address3": "string",
"address2": "string",
"city": "string",
"sourceType": "string",
"address1": "string",
"street": "string",
"state": "string",
"type": "HOME"
}
],
"paymentBankTransferCode": {
"id": "string",
"type": "ROUTING_NUMBER"
}
},
"CONTAINER": "bank",
"lastEmployeeContributionDate": "string",
"lastPayment": {
"amount": 0,
"currency": "AUD"
},
"recurringPayment": {
"amount": 0,
"currency": "AUD"
}
}
]
}
MX
{
"accounts": [
{
"guid": "ACT-82a93692-f756-534f-9b2e-ad10a0f38462",
"id": "A-e957b639-cdbe-4fe9-987d-e9e549031ca1",
"member_guid": "MBR-3bdc7d6b-efd4-1497-a0af-b23501cf9bd0",
"user_guid": "USR-11141024-90b3-1bce-cac9-c06ced52ab4c",
"account_number": null,
"apr": null,
"apy": null,
"available_balance": 5000.0,
"available_credit": null,
"balance": 5000.0,
"cash_balance": null,
"cash_surrender_value": null,
"credit_limit": null,
"currency_code": null,
"day_payment_is_due": null,
"death_benefit": null,
"holdings_value": null,
"interest_rate": null,
"institution_code": "mxbank",
"is_closed": false,
"is_hidden": true,
"last_payment": null,
"loan_amount": null,
"matures_on": null,
"minimum_balance": null,
"minimum_payment": null,
"name": "Personal Loan 1",
"original_balance": null,
"payoff_balance": null,
"started_on": null,
"total_account_value": null,
"subtype": "PERSONAL",
"type": "LOAN",
"created_at": "2017-10-20T17:06:55Z",
"last_payment_at": null,
"payment_due_at": null,
"updated_at": "2020-05-14T18:02:25Z"
}
],
"pagination": {
"current_page": 1,
"per_page": 25,
"total_entries": 21,
"total_pages": 1
}
}