api-gateway
VerifiedCall third-party APIs through the Maton gateway, which injects the credential for an app the user has already connected. Use this skill when the user names a connected app and a concrete action in it - read a mailbox, query a CRM, file an issue, update a spreadsheet, run a query through a connected search or scraping provider. Every call goes to an app the user connected. It is not a general-purpose browser or network client, and it cannot reach a service with no Maton connection. It also manages event triggers, webhook destinations that forward event payloads to an external URL until deleted, and local `--exec` handlers that run a script per event - separate, high-risk capabilities beyond a normal API call. Default to read and list calls; every write, connection, trigger, destination, or handler needs explicit user confirmation.
references/quickbooks/README.md
View on GitHub# QuickBooks
## API Reference
> **Safety:** All write operations (POST, PUT, PATCH, DELETE) require explicit user confirmation before execution. Verify the target resource and intended effect with the user first. See the main [SKILL.md](../../SKILL.md#security--permissions) for full security policy.
**App name:** `quickbooks`
**Upstream base URL:** `quickbooks.api.intuit.com`
Replace the upstream base URL with the app name. Everything after the base URL including query strings is kept as-is. Any account-specific part of the base URL and the API credentials are stored in the Maton connection, and the gateway injects both so requests never carry them. For example:
- Upstream: `https://quickbooks.api.intuit.com/v3/company/:realmId/companyinfo/:realmId`
- Gateway: `https://api.maton.ai/quickbooks/v3/company/:realmId/companyinfo/:realmId`
### Company Info API
#### Get Company Info
```bash
maton api '/quickbooks/v3/company/:realmId/companyinfo/:realmId'
```
#### Get Preferences
```bash
maton api '/quickbooks/v3/company/:realmId/preferences'
```
### Customers API
#### Query Customers
```bash
maton api '/quickbooks/v3/company/:realmId/query?query=SELECT%20*%20FROM%20Customer%20MAXRESULTS%20100'
```
With filter:
```bash
maton api '/quickbooks/v3/company/:realmId/query?query=SELECT%20*%20FROM%20Customer%20WHERE%20Active%3Dtrue'
```
#### Get Customer
```bash
maton api '/quickbooks/v3/company/:realmId/customer/{customerId}'
```
**Note:** `{customerId}` is a placeholder. Replace it with a real value before sending the request.
#### Create Customer
A create carries no `Id` or `SyncToken` - those identify an existing record and belong to the update and deactivate calls below. `DisplayName` must be unique in the company file.
```bash
maton api -X POST '/quickbooks/v3/company/:realmId/customer' -H 'Content-Type: application/json' --input - <<'JSON'
{
"DisplayName": "John Doe",
"PrimaryEmailAddr": {"Address": "john@example.com"}
}
JSON
```
#### Deactivate Customer (Soft Delete)
```bash
maton api -X POST '/quickbooks/v3/company/:realmId/customer' \
-H 'Content-Type: application/json' \
--input - <<'EOF'
{
"Id": "123",
"SyncToken": "1",
"DisplayName": "John Doe",
"Active": false
}
EOF
```
#### Update Customer
Requires `Id` and `SyncToken` from previous GET:
```bash
maton api -X POST '/quickbooks/v3/company/:realmId/customer' \
-H 'Content-Type: application/json' \
--input - <<'EOF'
{
"Id": "123",
"SyncToken": "0",
"DisplayName": "John Doe Updated",
"PrimaryPhone": {"FreeFormNumber": "555-9999"}
}
EOF
```
### Vendors API
#### Query Vendors
```bash
maton api '/quickbooks/v3/company/:realmId/query?query=SELECT%20*%20FROM%20Vendor%20MAXRESULTS%20100'
```
#### Get Vendor
```bash
maton api '/quickbooks/v3/company/:realmId/vendor/{vendorId}'
```
**Note:** `{vendorId}` is a placeholder. Replace it with a real value before sending the request.
#### Create Vendor
```bash
maton api -X POST '/quickbooks/v3/company/:realmId/vendor' \
-H 'Content-Type: application/json' \
--input - <<'EOF'
{
"DisplayName": "Acme Supplies",
"PrimaryEmailAddr": {"Address": "vendor@example.com"}
}
EOF
```
### Items API
#### Query Items
```bash
maton api '/quickbooks/v3/company/:realmId/query?query=SELECT%20*%20FROM%20Item%20MAXRESULTS%20100'
```
#### Get Item
```bash
maton api '/quickbooks/v3/company/:realmId/item/{itemId}'
```
**Note:** `{itemId}` is a placeholder. Replace it with a real value before sending the request.
#### Create Item
```bash
maton api -X POST '/quickbooks/v3/company/:realmId/item' \
-H 'Content-Type: application/json' \
--input - <<'EOF'
{
"Name": "Consulting Services",
"Type": "Service",
"IncomeAccountRef": {"value": "1"}
}
EOF
```
### Payments API
#### Query Payments
```bash
maton api '/quickbooks/v3/company/:realmId/query?query=SELECT%20*%20FROM%20Payment%20MAXRESULTS%20100'
```
#### Create Payment
Simple payment:
```bash
maton api -X POST '/quickbooks/v3/company/:realmId/payment' -H 'Content-Type: application/json' --input - <<'JSON'
{
"CustomerRef": {"value": "123"},
"TotalAmt": 100.00,
"Line": [
{
"Amount": 100.00,
"LinkedTxn": [{"TxnId": "456", "TxnType": "Invoice"}]
}
]
}
JSON
```
Payment linked to invoice:
```bash
maton api -X POST '/quickbooks/v3/company/:realmId/payment' -H 'Content-Type: application/json' --input - <<'JSON'
{
"CustomerRef": {"value": "123"},
"TotalAmt": 100.00,
"Line": [
{
"Amount": 100.00,
"LinkedTxn": [{"TxnId": "456", "TxnType": "Invoice"}]
}
]
}
JSON
```
### Bills API
#### Query Bills
```bash
maton api '/quickbooks/v3/company/:realmId/query?query=SELECT%20*%20FROM%20Bill%20MAXRESULTS%20100'
```
#### Create Bill
```bash
maton api -X POST '/quickbooks/v3/company/:realmId/bill' \
-H 'Content-Type: application/json' \
--input - <<'EOF'
{
"VendorRef": {"value": "123"},
"Line": [
{
"DetailType": "AccountBasedExpenseLineDetail",
"Amount": 250.00,
"AccountBasedExpenseLineDetail": {
"AccountRef": {"value": "1"}
}
}
]
}
EOF
```
### Accounts API
#### Query Accounts
```bash
maton api '/quickbooks/v3/company/:realmId/query?query=SELECT%20*%20FROM%20Account'
```
Filter by type:
```bash
maton api '/quickbooks/v3/company/:realmId/query?query=SELECT%20*%20FROM%20Account%20WHERE%20AccountType%20%3D%20%27Bank%27'
```
### Invoices API
#### Query Invoices
```bash
maton api '/quickbooks/v3/company/:realmId/query?query=SELECT%20*%20FROM%20Invoice%20MAXRESULTS%20100'
```
#### Create Invoice
```bash
maton api -X POST '/quickbooks/v3/company/:realmId/invoice' -H 'Content-Type: application/json' --input - <<'JSON'
{
"CustomerRef": {"value": "123"},
"Line": [
{
"Amount": 100.00,
"DetailType": "SalesItemLineDetail",
"SalesItemLineDetail": {
"ItemRef": {"value": "1"},
"Qty": 1
}
}
]
}
JSON
```
#### Void Invoice
```bash
maton api -X POST '/quickbooks/v3/company/:realmId/invoice?operation=void' \
-H 'Content-Type: application/json' \
--input - <<'EOF'
{
"Id": "123",
"SyncToken": "0"
}
EOF
```
#### Delete Invoice
```bash
maton api -X POST '/quickbooks/v3/company/:realmId/invoice?operation=delete' -H 'Content-Type: application/json' --input - <<'JSON'
{
"Id": "123",
"SyncToken": "0"
}
JSON
```
#### Get Invoice
```bash
maton api '/quickbooks/v3/company/:realmId/invoice/{invoiceId}'
```
**Note:** `{invoiceId}` is a placeholder. Replace it with a real value before sending the request.
### Reports API
#### Profit and Loss
```bash
maton api '/quickbooks/v3/company/:realmId/reports/ProfitAndLoss?start_date=2024-01-01&end_date=2024-12-31'
```
#### Balance Sheet
```bash
maton api '/quickbooks/v3/company/:realmId/reports/BalanceSheet?date=2024-12-31'
```
### Batch API
Execute multiple queries in a single request:
```bash
maton api -X POST '/quickbooks/v3/company/:realmId/batch' -H 'Content-Type: application/json' --input - <<'JSON'
{
"BatchItemRequest": [
{"bId": "1", "Query": "SELECT * FROM Customer MAXRESULTS 2"},
{"bId": "2", "Query": "SELECT * FROM Vendor MAXRESULTS 2"}
]
}
JSON
```
### Bill Payments API
#### Create Bill Payment
```bash
maton api -X POST '/quickbooks/v3/company/:realmId/billpayment' \
-H 'Content-Type: application/json' \
--input - <<'EOF'
{
"VendorRef": {"value": "123"},
"TotalAmt": 250.00,
"PayType": "Check",
"CheckPayment": {
"BankAccountRef": {"value": "23"}
},
"Line": [
{
"Amount": 250.00,
"LinkedTxn": [{"TxnId": "456", "TxnType": "Bill"}]
}
]
}
EOF
```
**Note:** Use a Bank account (AccountType: "Bank") for `BankAccountRef`.
### Special Handling
Use `:realmId` in the path and it will be automatically replaced with the connected company's realm ID.
### Query Language
QuickBooks uses a SQL-like query language:
```sql
SELECT * FROM Customer WHERE DisplayName LIKE 'John%' MAXRESULTS 100
```
Operators: `=`, `LIKE`, `<`, `>`, `<=`, `>=`, `IN`
### SyncToken for Updates
All update operations require the current `SyncToken` from the entity. The SyncToken is incremented after each successful update.
1. GET the entity to retrieve current `SyncToken`
2. Include `Id` and `SyncToken` in the POST body
3. If the SyncToken doesn't match, the update fails (optimistic locking)
### Void vs Delete
- **Void**: Sets transaction amount to 0, adds "Voided" note, keeps record. Use for audit trail.
- **Delete**: Permanently removes the transaction. Use `?operation=delete` query parameter.
Both require `Id` and `SyncToken` in the request body.
### Notes
- `:realmId` is automatically replaced by the router
- All queries must be URL-encoded
- Use `MAXRESULTS` to limit query results (default varies by entity)
- Include `SyncToken` when updating entities (for optimistic locking)
- Dates are in `YYYY-MM-DD` format
- Soft delete entities (Customer, Vendor, Item) by setting `Active: false`
- Transactions (Invoice, Payment, Bill) can be voided or deleted
### Resources
- [QuickBooks API Overview](https://developer.intuit.com/app/developer/qbo/docs/get-started)
- [Query Customers](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/customer#query-a-customer)
- [Get Customer](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/customer#read-a-customer)
- [Create Customer](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/customer#create-a-customer)
- [Update Customer](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/customer#full-update-a-customer)
- [Query Invoices](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/invoice#query-an-invoice)
- [Get Invoice](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/invoice#read-an-invoice)
- [Create Invoice](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/invoice#create-an-invoice)
- [Update Invoice](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/invoice#full-update-an-invoice)
- [Delete Invoice](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/invoice#delete-an-invoice)
- [Send Invoice](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/invoice#send-an-invoice)
- [Query Items](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item#query-an-item)
- [Get Item](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item#read-an-item)
- [Create Item](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item#create-an-item)
- [Update Item](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item#full-update-an-item)
- [Query Accounts](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/account#query-an-account)
- [Get Account](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/account#read-an-account)
- [Create Account](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/account#create-an-account)
- [Update Account](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/account#full-update-an-account)
- [Query Payments](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/payment#query-a-payment)
- [Get Payment](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/payment#read-a-payment)
- [Create Payment](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/payment#create-a-payment)
- [Update Payment](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/payment#full-update-a-payment)
- [Delete Payment](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/payment#delete-a-payment)
- [Query Vendors](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/vendor#query-a-vendor)
- [Get Vendor](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/vendor#read-a-vendor)
- [Create Vendor](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/vendor#create-a-vendor)
- [Update Vendor](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/vendor#full-update-a-vendor)
- [Query Bills](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/bill#query-a-bill)
- [Get Bill](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/bill#read-a-bill)
- [Create Bill](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/bill#create-a-bill)
- [Update Bill](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/bill#full-update-a-bill)
- [Delete Bill](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/bill#delete-a-bill)
- [Profit and Loss Report](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/report-entities/profitandloss)
- [Balance Sheet Report](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/report-entities/balancesheet)
- [Query Reference](https://developer.intuit.com/app/developer/qbdesktop/docs/develop/exploring-the-quickbooks-desktop-sdk/query-requests-and-responses)
- [Maton CLI Manual](https://cli.maton.ai/manual)
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| canvas-designanthropics/skillsCreate beautiful visual art in .png and .pdf documents using design philosophy. You should use this skill when the user asks to create a poster, piece of art, design, or other static piece. Create original visual designs, never copying existing artists' work to avoid copyright violations. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| docxanthropics/skillsUse this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files) or Word templates (.dotx files). Triggers include: any mention of 'Word doc', 'word document', '.docx', '.dotx', or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx or .dotx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a 'report', 'memo', 'letter', 'template', or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| pdfanthropics/skillsUse this skill whenever the user wants to do anything with PDF files. This includes reading or extracting text/tables from PDFs, combining or merging multiple PDFs into one, splitting PDFs apart, rotating pages, adding watermarks, creating new PDFs, filling PDF forms, encrypting/decrypting PDFs, extracting images, and OCR on scanned PDFs to make them searchable. If the user mentions a .pdf file or asks to produce one, use this skill. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| pptxanthropics/skillsUse this skill any time a .pptx or .potx file is involved in any way — as input, output, or both. This includes: creating slide decks, pitch decks, or presentations; reading, parsing, or extracting text from any .pptx or .potx file (even if the extracted content will be used elsewhere, like in an email or summary); editing, modifying, or updating existing presentations; combining or splitting slide files; working with templates (.potx), layouts, speaker notes, or comments. Trigger whenever the user mentions "deck," "slides," "presentation," or references a .pptx or .potx filename, regardless of what they plan to do with the content afterward. If a .pptx or .potx file needs to be opened, created, or touched, use this skill. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |