> ## Documentation Index > Fetch the complete documentation index at: https://docs.assetinfinity.ai/llms.txt > Use this file to discover all available pages before exploring further. # List stock in each store > Stock with reorder context. available_quantity is generated from the ledger, not stored. ## OpenAPI ````yaml /api-reference/integration.json get /inventory_available openapi: 3.0.0 info: description: >- The calls an integration needs first. Every endpoint the application uses is in the complete reference. title: Asset Infinity integration API version: 12.2.3 servers: - url: https://app.assetinfinity.ai/api security: [] tags: - description: >- Exchange an API key, or an email and password, for a short-lived session token, and send it as `Authorization: Bearer ` on every other call. name: Signing in - description: >- Where assets are and work happens. A location belongs to a site and may sit inside another location. name: Sites and locations - description: >- The asset register: read it, add to it, correct it, move an asset between sites and locations, and change its status. name: Assets - description: >- Report a problem. A request is triaged by a person, who turns it into a work order or turns it down. name: Work requests - description: >- Raise a job, give it to somebody, move it through the organisation's statuses, complete it and close it. name: Work orders - description: >- Send readings in. A meter reading brings the meter forward and raises any maintenance the usage has made due. A sensor reading can open or clear an alert. name: Meters and sensors - description: >- The part catalogue and what is on the shelf in each store, and the three movements an outside system most often records: a delivery in, an issue out and a correction. name: Parts and stock - description: >- Have the product call your system when something happens, instead of asking it on a timer. name: Webhooks - description: >- The calls behind every register that has no call of its own, answers to the organisation's own fields, and the two calls that answer what to send. `list_options` returns the ids a field accepts. `describe_call` returns the fields any call takes. name: Any record externalDocs: description: PostgREST Documentation url: https://postgrest.org/en/v12/references/api.html paths: /inventory_available: get: tags: - Parts and stock summary: List stock in each store description: >- Stock with reorder context. available_quantity is generated from the ledger, not stored. parameters: - $ref: '#/components/parameters/rowFilter.inventory_available.stock_id' - $ref: '#/components/parameters/rowFilter.inventory_available.part_id' - $ref: '#/components/parameters/rowFilter.inventory_available.part_number' - $ref: '#/components/parameters/rowFilter.inventory_available.part_name' - $ref: '#/components/parameters/rowFilter.inventory_available.part_category' - $ref: >- #/components/parameters/rowFilter.inventory_available.unit_of_measure - $ref: '#/components/parameters/rowFilter.inventory_available.warehouse_id' - $ref: '#/components/parameters/rowFilter.inventory_available.warehouse_code' - $ref: '#/components/parameters/rowFilter.inventory_available.warehouse_name' - $ref: '#/components/parameters/rowFilter.inventory_available.site_id' - $ref: >- #/components/parameters/rowFilter.inventory_available.inventory_location_id - $ref: >- #/components/parameters/rowFilter.inventory_available.on_hand_quantity - $ref: >- #/components/parameters/rowFilter.inventory_available.reserved_quantity - $ref: >- #/components/parameters/rowFilter.inventory_available.available_quantity - $ref: >- #/components/parameters/rowFilter.inventory_available.on_order_quantity - $ref: >- #/components/parameters/rowFilter.inventory_available.in_transit_quantity - $ref: >- #/components/parameters/rowFilter.inventory_available.average_unit_cost - $ref: >- #/components/parameters/rowFilter.inventory_available.average_unit_cost_currency_id - $ref: >- #/components/parameters/rowFilter.inventory_available.minimum_quantity - $ref: '#/components/parameters/rowFilter.inventory_available.reorder_point' - $ref: >- #/components/parameters/rowFilter.inventory_available.maximum_quantity - $ref: '#/components/parameters/rowFilter.inventory_available.safety_stock' - $ref: >- #/components/parameters/rowFilter.inventory_available.at_or_below_reorder_point - $ref: '#/components/parameters/rowFilter.inventory_available.criticality' - $ref: '#/components/parameters/rowFilter.inventory_available.tracking_mode' - $ref: '#/components/parameters/rowFilter.inventory_available.is_consumable' - $ref: >- #/components/parameters/rowFilter.inventory_available.last_movement_at - $ref: >- #/components/parameters/rowFilter.inventory_available.last_counted_at - $ref: >- #/components/parameters/rowFilter.inventory_available.primary_image_file_id - $ref: '#/components/parameters/rowFilter.inventory_available.custom_fields' - $ref: '#/components/parameters/rowFilter.inventory_available.row_version' - $ref: '#/components/parameters/rowFilter.inventory_available.created_at' - $ref: '#/components/parameters/rowFilter.inventory_available.created_by_id' - $ref: >- #/components/parameters/rowFilter.inventory_available.created_by_name - $ref: '#/components/parameters/rowFilter.inventory_available.created_source' - $ref: '#/components/parameters/rowFilter.inventory_available.updated_at' - $ref: '#/components/parameters/rowFilter.inventory_available.updated_by_id' - $ref: >- #/components/parameters/rowFilter.inventory_available.updated_by_name - $ref: '#/components/parameters/select' - $ref: '#/components/parameters/order' - $ref: '#/components/parameters/range' - $ref: '#/components/parameters/rangeUnit' - $ref: '#/components/parameters/offset' - $ref: '#/components/parameters/limit' - $ref: '#/components/parameters/preferCount' responses: '200': content: application/json: schema: items: $ref: '#/components/schemas/inventory_available' type: array application/vnd.pgrst.object+json: schema: items: $ref: '#/components/schemas/inventory_available' type: array application/vnd.pgrst.object+json;nulls=stripped: schema: items: $ref: '#/components/schemas/inventory_available' type: array text/csv: schema: items: $ref: '#/components/schemas/inventory_available' type: array description: OK '206': description: Partial Content components: parameters: rowFilter.inventory_available.stock_id: in: query name: stock_id required: false schema: type: string rowFilter.inventory_available.part_id: in: query name: part_id required: false schema: type: string rowFilter.inventory_available.part_number: in: query name: part_number required: false schema: type: string rowFilter.inventory_available.part_name: in: query name: part_name required: false schema: type: string rowFilter.inventory_available.part_category: in: query name: part_category required: false schema: type: string rowFilter.inventory_available.unit_of_measure: in: query name: unit_of_measure required: false schema: type: string rowFilter.inventory_available.warehouse_id: in: query name: warehouse_id required: false schema: type: string rowFilter.inventory_available.warehouse_code: in: query name: warehouse_code required: false schema: type: string rowFilter.inventory_available.warehouse_name: in: query name: warehouse_name required: false schema: type: string rowFilter.inventory_available.site_id: in: query name: site_id required: false schema: type: string rowFilter.inventory_available.inventory_location_id: in: query name: inventory_location_id required: false schema: type: string rowFilter.inventory_available.on_hand_quantity: in: query name: on_hand_quantity required: false schema: type: string rowFilter.inventory_available.reserved_quantity: in: query name: reserved_quantity required: false schema: type: string rowFilter.inventory_available.available_quantity: in: query name: available_quantity required: false schema: type: string rowFilter.inventory_available.on_order_quantity: in: query name: on_order_quantity required: false schema: type: string rowFilter.inventory_available.in_transit_quantity: in: query name: in_transit_quantity required: false schema: type: string rowFilter.inventory_available.average_unit_cost: in: query name: average_unit_cost required: false schema: type: string rowFilter.inventory_available.average_unit_cost_currency_id: in: query name: average_unit_cost_currency_id required: false schema: type: string rowFilter.inventory_available.minimum_quantity: in: query name: minimum_quantity required: false schema: type: string rowFilter.inventory_available.reorder_point: in: query name: reorder_point required: false schema: type: string rowFilter.inventory_available.maximum_quantity: in: query name: maximum_quantity required: false schema: type: string rowFilter.inventory_available.safety_stock: in: query name: safety_stock required: false schema: type: string rowFilter.inventory_available.at_or_below_reorder_point: in: query name: at_or_below_reorder_point required: false schema: type: string rowFilter.inventory_available.criticality: in: query name: criticality required: false schema: type: string rowFilter.inventory_available.tracking_mode: in: query name: tracking_mode required: false schema: type: string rowFilter.inventory_available.is_consumable: in: query name: is_consumable required: false schema: type: string rowFilter.inventory_available.last_movement_at: in: query name: last_movement_at required: false schema: type: string rowFilter.inventory_available.last_counted_at: in: query name: last_counted_at required: false schema: type: string rowFilter.inventory_available.primary_image_file_id: in: query name: primary_image_file_id required: false schema: type: string rowFilter.inventory_available.custom_fields: in: query name: custom_fields required: false schema: type: string rowFilter.inventory_available.row_version: in: query name: row_version required: false schema: type: string rowFilter.inventory_available.created_at: in: query name: created_at required: false schema: type: string rowFilter.inventory_available.created_by_id: in: query name: created_by_id required: false schema: type: string rowFilter.inventory_available.created_by_name: in: query name: created_by_name required: false schema: type: string rowFilter.inventory_available.created_source: in: query name: created_source required: false schema: type: string rowFilter.inventory_available.updated_at: in: query name: updated_at required: false schema: type: string rowFilter.inventory_available.updated_by_id: in: query name: updated_by_id required: false schema: type: string rowFilter.inventory_available.updated_by_name: in: query name: updated_by_name required: false schema: type: string select: description: Filtering Columns in: query name: select required: false schema: type: string order: description: Ordering in: query name: order required: false schema: type: string range: description: Limiting and Pagination in: header name: Range required: false schema: type: string rangeUnit: description: Limiting and Pagination in: header name: Range-Unit required: false schema: default: items type: string offset: description: Limiting and Pagination in: query name: offset required: false schema: type: string limit: description: Limiting and Pagination in: query name: limit required: false schema: type: string preferCount: description: Preference in: header name: Prefer required: false schema: enum: - count=none type: string schemas: inventory_available: description: >- Stock with reorder context. available_quantity is generated from the ledger, not stored. properties: at_or_below_reorder_point: format: boolean type: boolean available_quantity: format: numeric type: number average_unit_cost: format: numeric type: number average_unit_cost_currency_id: description: >- Note: This is a Foreign Key to `asset_cost_to_keep.currency_id`. format: uuid type: string created_at: format: timestamp with time zone type: string created_by_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string created_by_name: format: character varying maxLength: 200 type: string created_source: format: text type: string criticality: format: character varying maxLength: 20 type: string custom_fields: format: jsonb in_transit_quantity: format: numeric type: number inventory_location_id: description: >- Note: This is a Foreign Key to `bin_settings.id`. format: uuid type: string is_consumable: format: boolean type: boolean last_counted_at: format: timestamp with time zone type: string last_movement_at: format: timestamp with time zone type: string maximum_quantity: format: numeric type: number minimum_quantity: format: numeric type: number on_hand_quantity: format: numeric type: number on_order_quantity: format: numeric type: number part_category: format: character varying maxLength: 60 type: string part_id: description: |- Note: This is a Primary Key. format: uuid type: string part_name: format: character varying maxLength: 250 type: string part_number: format: character varying maxLength: 80 type: string primary_image_file_id: format: uuid type: string reorder_point: format: numeric type: number reserved_quantity: format: numeric type: number row_version: format: bigint type: integer safety_stock: format: numeric type: number site_id: description: >- Note: This is a Foreign Key to `entry_currencies.for_site_id`. format: uuid type: string stock_id: description: |- Note: This is a Primary Key. format: uuid type: string tracking_mode: format: character varying maxLength: 20 type: string unit_of_measure: format: character varying maxLength: 30 type: string updated_at: format: timestamp with time zone type: string updated_by_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string updated_by_name: format: character varying maxLength: 200 type: string warehouse_code: format: character varying maxLength: 60 type: string warehouse_id: description: >- Note: This is a Foreign Key to `warehouse_settings.id`. format: uuid type: string warehouse_name: format: character varying maxLength: 200 type: string type: object ```` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.