Accounting · Beta
Fishbowl Advanced
API integration
Ship Accounting features without building the integration. Full Fishbowl Advanced API access via Proxy and 50+ MCP-ready tools for AI agents — extend models and mappings to fit your product.
Built for specific customer use cases. Issues are resolved quickly.
Talk to usUse Cases
Why integrate with Fishbowl Advanced
Common scenarios for SaaS companies building Fishbowl Advanced integrations for their customers.
Embed Fishbowl in your E-commerce OMS
Let multi-channel merchants route Shopify, BigCommerce, and Amazon orders into Fishbowl for fulfillment while syncing live inventory counts back to storefronts. Truto handles Fishbowl's session-based auth and the asymmetric Import/SQL API model so you can ship this without becoming Fishbowl API experts.
Power a shop floor manufacturing app
Give production managers a modern tablet UI on top of Fishbowl's manufacture order lifecycle — pulling active MOs, issuing them on QA completion, and logging inspector notes as memos. Truto exposes the full MO lifecycle (create, issue, unissue, close, memo) through a single consistent interface.
Launch a mobile warehouse barcoding product
Build a scanner-first app that lets warehouse staff perform cycle counts, inventory moves, and scrap write-downs against Fishbowl in real time. Truto lets you fire inventory mutation endpoints without managing login sessions or Fishbowl's quirky request shapes.
Offer a B2B dealer and wholesale portal
Let dealers log into your portal, see their customer-specific negotiated pricing from Fishbowl, and submit wholesale sales orders directly into the warehouse queue. Truto normalizes the mix of SQL data queries, best-price lookups, and bulk imports needed to make this work.
Add procurement and PO automation to your spend product
Let finance and procurement teams create, issue, close, void, and annotate purchase orders in Fishbowl from your spend management or AP tool. Truto gives you native CRUD plus lifecycle actions on POs through one integration.
What You Can Build
Ship these features with Truto + Fishbowl Advanced
Concrete product features your team can ship faster by leveraging Truto’s Fishbowl Advanced integration instead of building from scratch.
Sales order push via bulk import
Format orders from your app as JSON and push them into Fishbowl using the Sales-Order-Details import flow to create pending orders in the warehouse queue.
Live inventory sync to external storefronts
Poll Fishbowl inventory on a schedule to keep Shopify, Amazon, or your own catalog accurate and prevent overselling across channels.
Full manufacture order lifecycle control
Create MOs, issue and unissue them, close short, delete, and attach shop floor memos — all from your product's UI.
Barcode-driven inventory movements
Trigger cycle counts, location moves, inventory additions, and scrap write-downs against a specific part from a mobile or scanner interface.
Customer-specific pricing lookups
Fetch product best prices and part best costs so sales reps, quoting tools, or dealer portals can show the correct negotiated price per customer.
Purchase order management and memos
Create, update, issue, close, and void POs, and attach PO memos for audit trails from inside your procurement product.
Custom SQL-powered reporting views
Run targeted SQL queries against Fishbowl to extract Sales Orders, Customers, or Products with exactly the filters your product needs — no native read endpoint required.
SuperAI
Fishbowl Advanced AI agent tools
Comprehensive AI agent toolset with fine-grained control. Integrates with MCP clients like Cursor and Claude, or frameworks like LangChain.
list_all_fishbowl_advanced_data_queries
Execute a data query against the database using SQL. Pass the SQL as query (SELECT only; the connector rejects anything else). Use it to read sales orders, customers, products and other tables that have no REST read endpoint (e.g. SELECT id, num FROM so WHERE statusId = 20).
create_a_fishbowl_advanced_import
Import data via our CSV methods, but in JSON format (Content-Type application/json). In the request, the name parameter should be replaced by the case-sensitive default name of the CSV import/export with "-" replacing any spaces. Example: Sales Order Details -> Sales-Order-Details. Required: import_name. Body: a JSON array of rows, the first row being the CSV header (Fishbowl's 'Import data via JSON'). Use it to create or update records that have no REST write endpoint (sales orders, customers, parts, products...).
list_all_fishbowl_advanced_inventory
Searches for inventory. The connector pages through all results (pageNumber/pageSize, up to totalPages).
create_a_fishbowl_advanced_inventory_addition
Adds inventory. Required: part_id.
create_a_fishbowl_advanced_inventory_cycle_count
Cycles inventory. Required: part_id.
create_a_fishbowl_advanced_inventory_move
Moves inventory from one location to another. Required: part_id.
create_a_fishbowl_advanced_inventory_scrap
Scraps inventory. Parts that have tracking only require the primary tracking value. Required: part_id.
list_all_fishbowl_advanced_location_groups
Searches for location groups. The connector pages through all results (pageNumber/pageSize, up to totalPages).
create_a_fishbowl_advanced_login_session
This logs the user in to Fishbowl and returns the list of Access Rights. The first time your Integrated App logs in, you'll need to approve the App in Fishbowl. If the user has enabled MFA (multi-factor authentication), the response will return HTTP 401 with a response header "MFA: Required". The connector logs in on connect and every 30 minutes; you rarely need this directly.
fishbowl_advanced_login_sessions_close
This logs the user out of Fishbowl, ending the current session. The connector logs in on connect and every 30 minutes; you rarely need this directly.
create_a_fishbowl_advanced_manufacture_order_issue
Issues the manufacture order with the specified ID. Required: manufacture_order_id.
list_all_fishbowl_advanced_manufacture_order_memos
Retrieves a list of memos for the specific object. Required: manufacture_order_id. Memos of a manufacture order.
get_single_fishbowl_advanced_manufacture_order_memo_by_id
Retrieves the details of an existing memo. You only need to provide the unique memo ID. Required: id, manufacture_order_id. Memos of a manufacture order.
create_a_fishbowl_advanced_manufacture_order_memo
Creates a memo. Required: manufacture_order_id, memo. Memos of a manufacture order.
update_a_fishbowl_advanced_manufacture_order_memo_by_id
Updates a memo. Required: id, manufacture_order_id, memo. Memos of a manufacture order.
delete_a_fishbowl_advanced_manufacture_order_memo_by_id
Deletes the memo with the specified ID. Required: id, manufacture_order_id. Memos of a manufacture order.
create_a_fishbowl_advanced_manufacture_order_unissue
Unissues the manufacture order with the specified ID. Required: manufacture_order_id.
list_all_fishbowl_advanced_manufacture_orders
Searches for manufacture orders. The connector pages through all results (pageNumber/pageSize, up to totalPages).
get_single_fishbowl_advanced_manufacture_order_by_id
Retrieves the details of an existing manufacture order. You only need to provide the unique manufacture order ID. Required: id.
create_a_fishbowl_advanced_manufacture_order
Creates a manufacture order. Required: configurations.
update_a_fishbowl_advanced_manufacture_order_by_id
Updates a manufacture order. Configurations will only be updated when the order status is 'Entered'. Manufacture orders linked to sales orders will not have their configurations updated. Required: id, configurations.
fishbowl_advanced_manufacture_orders_close
Closes short the manufacture order with the specified ID. Required: manufacture_order_id.
delete_a_fishbowl_advanced_manufacture_order_by_id
Deletes the manufacture order with the specified ID. Required: id.
list_all_fishbowl_advanced_part_best_costs
Retrieves the best cost for a specific part. The cost will be in the currency of the vendor. Related guide: Vendor Part Cost. Required: part_id.
list_all_fishbowl_advanced_parts
Searches for parts. The connector pages through all results (pageNumber/pageSize, up to totalPages).
delete_a_fishbowl_advanced_part_by_id
Deletes the part with the specified ID. Required: id.
delete_a_fishbowl_advanced_payment_by_id
Deletes the Payment with the specified ID. Required: id.
list_all_fishbowl_advanced_plugin_info
Searches for plugin information. Required: plugin, authorization.
create_a_fishbowl_advanced_plugin_info
Creates a plugin information. Required: plugin, authorization.
update_a_fishbowl_advanced_plugin_info_by_id
Updates a plugin information. Required: id, plugin, authorization.
delete_a_fishbowl_advanced_plugin_info_by_id
Deletes the plugin information with the specified ID. Required: id, plugin, authorization.
list_all_fishbowl_advanced_product_best_prices
Retrieves the best unit price for the specific product. Related guide: Pricing Rule. Required: product_id.
delete_a_fishbowl_advanced_product_by_id
Deletes the product with the specified ID. Required: id.
create_a_fishbowl_advanced_purchase_order_issue
Issues the purchase order with the specified ID. Required: purchase_order_id.
fishbowl_advanced_purchase_order_items_close
Close shorts the purchase order item with the specified ID. Required: purchase_order_id, po_item_id.
list_all_fishbowl_advanced_purchase_order_memos
Retrieves a list of memos for the specific object. Required: purchase_order_id. Memos of a purchase order.
get_single_fishbowl_advanced_purchase_order_memo_by_id
Retrieves the details of an existing memo. You only need to provide the unique memo ID. Required: id, purchase_order_id. Memos of a purchase order.
create_a_fishbowl_advanced_purchase_order_memo
Creates a memo. Required: purchase_order_id, memo. Memos of a purchase order.
update_a_fishbowl_advanced_purchase_order_memo_by_id
Updates a memo. Required: id, purchase_order_id, memo. Memos of a purchase order.
delete_a_fishbowl_advanced_purchase_order_memo_by_id
Deletes the memo with the specified ID. Required: id, purchase_order_id. Memos of a purchase order.
create_a_fishbowl_advanced_purchase_order_unissue
Unissues the purchase order with the specified ID. Required: purchase_order_id.
list_all_fishbowl_advanced_purchase_orders
Searches for purchase orders. The connector pages through all results (pageNumber/pageSize, up to totalPages).
get_single_fishbowl_advanced_purchase_order_by_id
Retrieves the details of an existing purchase order. You only need to provide the unique purchase order ID. Required: id.
create_a_fishbowl_advanced_purchase_order
Creates a purchase order. Required: vendor.
update_a_fishbowl_advanced_purchase_order_by_id
Updates a purchase order. Optional parameters that are not passed in will be reset to their default values. Best practice is to send the complete object you would like to save. Required: id, vendor.
fishbowl_advanced_purchase_orders_close
Close shorts the purchase order with the specified ID. Required: purchase_order_id.
fishbowl_advanced_purchase_orders_void
Voids the purchase order with the specified ID. Required: purchase_order_id.
delete_a_fishbowl_advanced_purchase_order_by_id
Deletes the purchase order with the specified ID. Required: id.
delete_a_fishbowl_advanced_sales_order_by_id
Deletes the sales order with the specified ID. Required: id.
list_all_fishbowl_advanced_uoms
Searches for units of measure. The connector pages through all results (pageNumber/pageSize, up to totalPages).
get_single_fishbowl_advanced_uom_by_id
Retrieves the details of a unit of measure. You only need to provide the unique UOM ID. Required: id.
create_a_fishbowl_advanced_uom
Creates a unit of measure.
update_a_fishbowl_advanced_uom_by_id
Update a unit of measure. Required: id.
delete_a_fishbowl_advanced_uom_by_id
Deletes the unit of measure with the specified ID. Required: id.
list_all_fishbowl_advanced_users
Searches for users. The connector pages through all results (pageNumber/pageSize, up to totalPages).
list_all_fishbowl_advanced_vendors
Searches for vendors. The connector pages through all results (pageNumber/pageSize, up to totalPages).
Why Truto
Why use Truto’s MCP server for Fishbowl Advanced
Other MCP servers give you a static tool list for one app. Truto gives you a managed, multi-tenant MCP infrastructure across 1050+ integrations.
Auto-generated, always up to date
Tools are dynamically generated from curated documentation — not hand-coded. As integrations evolve, tools stay current without manual maintenance.
Fine-grained access control
Scope each MCP server to read-only, write-only, specific methods, or tagged tool groups. Expose only what your AI agent needs — nothing more.
Multi-tenant by design
Each MCP server is scoped to a single connected account with its own credentials. The URL itself is the auth token — no shared secrets, no credential leaking across tenants.
Works with every MCP client
Standard JSON-RPC 2.0 protocol. Paste the URL into Claude, ChatGPT, Cursor, or any MCP-compatible agent framework — tools are discovered automatically.
Built-in auth, rate limits, and error handling
Tool calls execute through Truto’s proxy layer with automatic OAuth refresh, rate-limit handling, and normalized error responses. No raw API plumbing in your agent.
Expiring and auditable servers
Create time-limited MCP servers for contractors or automated workflows. Optional dual-auth requires both the URL and a Truto API token for high-security environments.
How It Works
From zero to integrated
Start with Fishbowl Advanced in a free sandbox, usually ready within one business day. No boilerplate, no maintenance burden.
Link your customer’s Fishbowl Advanced account
Use Truto’s frontend SDK to connect your customer’s Fishbowl Advanced account. We handle all OAuth and API key flows — you don’t need to create the OAuth app.
We handle authentication
Don’t spend time refreshing access tokens or figuring out secure storage. We handle it and inject credentials into every API request.
Call our API, we call Fishbowl Advanced
Truto’s Proxy API is a 1-to-1 mapping of the Fishbowl Advanced API. You call us, we call Fishbowl Advanced, and pass the response back in the same cycle.
Unified response format
Every response follows a single format across all integrations. We translate Fishbowl Advanced’s pagination into unified cursor-based pagination. Data is always in the result attribute.
FAQs
Common questions about Fishbowl Advanced on Truto
Authentication, rate limits, data freshness, and everything else you need to know before you integrate.
How does authentication to Fishbowl Inventory work through Truto?
Fishbowl uses session-based auth. Truto handles creating a login session and closing it when done, so your end users just provide their Fishbowl credentials once and your product calls the API without managing session tokens.
How do we read Sales Orders, Customers, or Products if Fishbowl has no REST endpoints for them?
Fishbowl exposes these core objects through a SQL query interface rather than REST reads. Truto's data queries tool lets you send standard SQL (e.g., SELECT id, num FROM so WHERE statusId = 20) to extract exactly the records you need.
How do we create Sales Orders, Customers, or Parts?
Writes for these objects go through Fishbowl's Import mechanism. You send a JSON payload mimicking the CSV header format (like Sales-Order-Details) via the create import tool, and Truto normalizes that request shape for you.
Which objects support native CRUD vs. SQL/Import workarounds?
Manufacture Orders, Purchase Orders, UOMs, their memos, and inventory movements (move, scrap, addition, cycle count) have native endpoints with full lifecycle actions. Sales Orders, Customers, and Products rely on the SQL query reads and Import writes pattern.
Can we support customer-specific pricing and costing?
Yes. Truto exposes product best prices and part best costs, which return the correct price or cost for a given product based on the customer-specific pricing rules configured in Fishbowl.
How fresh is the inventory data we can pull?
Inventory is pulled on-demand via the inventory list endpoint, so freshness depends on how often your product polls. Most e-commerce integrations poll every few minutes to keep external storefronts in sync.
Does Truto support Fishbowl's manufacture and purchase order lifecycle actions?
Yes. Beyond create/read/update/delete, Truto exposes issue, unissue, close, and (for POs) void actions, plus full memo CRUD, so you can model the complete MO and PO lifecycle in your product.
From the Blog
Fishbowl Advanced integration guides
Deep dives, architecture guides, and practical tutorials for building Fishbowl Advanced integrations.
Fishbowl Advanced
Get Fishbowl Advanced integrated into your app
Our team understands what it takes to make a Fishbowl Advanced integration successful. A short, crisp 30 minute call with folks who understand the problem.