- Data Connectors Overview
- Free and Open Source Software (FOSS) License
- Redistributable Files
- OAuth Authorization
- Licensing
- ADO.NET provider for CSV
- ADO.NET provider for Dynamics 365 Sales
- ADO.NET provider for Google Analytics
- ADO.NET provider for JSON
- ADO.NET provider for Kintone
- ADO.NET provider for OData
-
ADO.NET provider for QuickBooks Online
- Getting Started
- Creating Connection
- Connection Pooling
- Authentication
- Querying Data
- Batch Processing
- Schema Details
- Caching
- Entity Framework
- LINQ Queries
-
QuickBooks Online Tables
- Accounts
- Attachables
- Bill Payments
- Bills
- Budgets
- Class
- Company Currency
- Company Info
- CreditCardPayments
- CreditMemos
- Customers
- CustomerTypes
- Departments
- Deposits
- Employees
- Entitlements
- Estimates
- Exchange Rates
- Invoices
- Items
- Journal Code
- JournalEntries
- PaymentMethods
- Payments
- Preferences
- PurchaseOrders
- Purchases
- RefundReceipts
- Sales Receipts
- TaxAgency
- TaxClassifications
- TaxCodes
- TaxPayments
- TaxRates
- Terms
- TimeActivities
- Transfers
- VendorCredits
- Vendors
- Invoices
- ADO.NET provider for Salesforce
- ADO.NET provider for ServiceNow
- ADO.NET provider for Magento
- ADO.NET provider for Snowflake
- SQL Compliance
- Incremental Caching
- Proxy Server
- Logging
- Scaffolding
- DbFactory Support
- Visual Studio Integration
- Walkthrough
Exchange Rates
| Name | Type | ReadOnly | Filterable | Description |
|---|---|---|---|---|
| SourceCurrencyCode | string | false | true | The source currency from which the exchange rate is specified. Specify as a three letter string representing the ISO 4217 code for the currency. |
| TargetCurrencyCode | string | false | false | The target currency against which the exchange rate is specified. Specify as a three letter string representing the ISO 4217 code for the currency. |
| Rate | double | false | false | The exchange rate between SourceCurrencyCode and TargetCurrencyCode on the AsOfDate date. |
| AsOfDate | date | false | true | Date on which this exchange rate was set. |
| MetaData_LastUpdatedTime | datetime | true | true | The time the record was last updated. |