Does this skill handle QuickBooks OAuth2 authentication?

Yes, it includes guidance on using the Intuit AuthClient for secure OAuth2 authentication, environment setup, and token refresh logic.

What is the maximum number of entities I can retrieve in one call?

QuickBooks Online returns a maximum of 1000 entities per query. This skill provides guidance on using pagination with start_position and max_results.

How do I perform a 'sparse update' to avoid overwriting data?

You should set the 'sparse' attribute to True on your object before calling the save() method to ensure only changed fields are sent to the API.

Why are the property names in PascalCase instead of snake_case?

The python-quickbooks library maps directly to the Intuit API schema, which uses PascalCase (e.g., DisplayName, TotalAmt) to ensure consistency with the official documentation.

Can I query QuickBooks objects using raw SQL?

Yes, the skill demonstrates how to use the .query() method to execute raw SQL-like strings against the QuickBooks Online API.

QuickBooks Online Python Integration

Name: QuickBooks Online Python Integration
Author: grailautomation

bygrailautomation

0•

Eコマースソリューション

Simplifies QuickBooks Online API integrations in Python with comprehensive support for CRUD operations, authentication, and financial object management.

The python-quickbooks skill provides a specialized reference for developers building integrations with QuickBooks Online using the ej2/python-quickbooks library. It streamlines complex accounting workflows by offering standardized patterns for OAuth2 authentication, querying entities like customers and vendors, and performing financial operations such as creating invoices, recording payments, and downloading PDFs. It includes critical guidance on handling Intuit’s PascalCase naming conventions, minor versions, and sparse updates to ensure robust, production-ready accounting automation.

主な機能

01OAuth2 authentication and token lifecycle management guidance

02Full CRUD operations for Customers, Vendors, Invoices, and Payments

03Advanced querying with filtering, raw SQL, and pagination support

04Automated PDF generation and email delivery for financial documents

05Batch update and create operations for high-volume data handling

060 GitHub stars

ユースケース

01Automating invoice generation and delivery from a custom SaaS platform

02Building automated dashboards to monitor unpaid bills and record payments

03Synchronizing customer and vendor data between a CRM and QuickBooks Online

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add grailautomation/claude-plugins python-quickbooks

For use in Claude.ai and ChatGPT

Download Skill