---
title: Fishbowl Advanced API Integration on Truto
slug: fishbowl
category: Accounting
canonical: "https://truto.one/integrations/detail/fishbowl/"
---

# Fishbowl Advanced API Integration on Truto



**Category:** Accounting  
**Status:** Beta

## MCP-ready AI tools

Truto exposes 56 tools for Fishbowl Advanced that AI agents can call directly.

- **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).

## How it works

1. **Link your customer's Fishbowl Advanced account.** Use Truto's frontend SDK; we handle every OAuth and API key flow so you don't need to create the OAuth app.
2. **Authentication is automatic.** Truto refreshes tokens, stores credentials securely, and injects them into every API request.
3. **Call Truto's API to reach Fishbowl Advanced.** The Proxy API is a 1-to-1 mapping of the Fishbowl Advanced API.
4. **Get a unified response format.** Every response uses a single shape, with cursor-based pagination and data in the `result` field.

## Use cases

- **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

- **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.

## FAQs

### 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.

## Related reading

- [Connect Fishbowl Advanced to ChatGPT: Manage Orders & Inventory](https://truto.one/blog/connect-fishbowl-advanced-to-chatgpt-manage-orders-inventory/) — Learn how to connect Fishbowl Advanced to ChatGPT using an auto-generated MCP server. Automate inventory tracking, purchase orders, and manufacturing workflows.
- [Connect Fishbowl Advanced to Claude: Query Data & Track Production](https://truto.one/blog/connect-fishbowl-advanced-to-claude-query-data-track-production/) — A technical guide to connecting Fishbowl Advanced to Claude via a managed MCP server. Learn how to configure tools, execute raw SQL queries, and automate manufacturing workflows.
- [Connect Fishbowl Advanced to AI Agents: Automate Sourcing & Sales](https://truto.one/blog/connect-fishbowl-advanced-to-ai-agents-automate-sourcing-sales/) — Learn how to connect Fishbowl Advanced to AI Agents using Truto's /tools endpoint. Fetch tools, bind them to an LLM, and build autonomous workflows.
