Connect MRPeasy to Microsoft Excel

Both apps 202MRPeasy 104Microsoft Excel 98

• Trigger
  Customer Order Status Changed

  Triggers when the status of a customer order changes.

• Trigger
  New Customer

  Triggers when a new customer is added in MRPeasy.

• Trigger
  New Customer Order

  Triggers when a new customer order is created in MRPeasy.

• Trigger
  New Item

  Triggers when a new stock item is created in MRPeasy.

• Trigger
  New Manufacturing Order

  Triggers when a new manufacturing order is created in MRPeasy.

• Trigger
  New Purchase Order

  Triggers when a new purchase order is created in MRPeasy.

• Trigger
  New Shipment

  Triggers when a new shipment is created in MRPeasy.

• Action
  Create Product Group

  Create a product group and return its ID.

• Action
  Delete BOM

  Delete a bill of materials (BOM) by BOM ID.

• Action
  Delete Customer Order

  Delete (cancel) a customer order

• Action
  Delete Incoming Invoice

  Cancels the invoice. The record is kept and excluded from reports and accounting; it is not removed from the database.

• Action
  Delete Invoice

  Delete (cancel) an invoice

• Action
  Delete Item

  Delete a stock item by product ID.

• Action
  Delete Manufacturing Order

  Delete (cancel) a manufacturing order

• Action
  Delete Parameter

  Delete a parameter by parameter ID. A parameter used by product variations or relations cannot be deleted.

• Action
  Delete Product Group

  Delete a product group by product group ID. Stock items in the group are left without a product group.

• Action
  Delete Relation

  Delete a relation

• Action
  Delete RMA Order

  Delete (cancel) an RMA order

• Action
  Delete Routing

  Delete a routing by routing ID.

• Action
  Delete Unit

  Delete a unit of measurement by unit ID. Stock items using the unit are left without a unit of measurement.

• Action
  Delete Workstation

  Delete a workstation by workstation ID. A workstation with unfinished planned works cannot be deleted.

• Action
  Delete Workstation Group

  Delete a workstation group by workstation group ID. A group that still has workstations cannot be deleted.

• Action
  Get Accounting Synchronization

  Get accounting integration synchronization log details by log ID, optionally filtered by app.

• Action
  Get Accounting Synchronizations By Action

  List accounting integration synchronization logs that contain entries for a specific action type and date range.

• Action
  Get Accounting Synchronization Sums

  Get aggregated cost totals per synchronization action type for a date range, optionally filtered by app.

• Action
  Get BOM

  Get bill of materials (BOM) details by BOM ID.

• Action
  Get Customer

  Get a customer with its contact details by customer ID. Deleted customers are returned.

• Action
  Get Customer Order

  Get a customer order with its product lines and the stock lots they are booked from by customer order ID. Archived and cancelled customer orders are returned.

• Action
  Get Customer Orders Statistics

  Summary of shipped Customer Orders for the requested period. The default period is from the start of the current year to now. Use `start_date` and `end_date` to adjust the period. Maximum period length is one year.

• Action
  Get Customers Statistics

  Summary of shipped orders by the customer for the requested period. The default period is from the start of the current year to now. Use `start_date` and `end_date` to adjust the period. Maximum period length is one year.

• Action
  Get Dashboard

  Get the requested home dashboard widgets with their current values and report links, considering account settings and user rights.

• Action
  Get General Ledger

  Get general ledger account balances and period totals for a date range.

• Action
  Get Goods Shipped Statistics

  Summary of shipped goods for the requested period. The default period is from the start of the current year to now. Use `start_date` and `end_date` to adjust the period. Maximum period length is one year.

• Action
  Get Incoming Invoice

  Returns one incoming invoice with its lines and custom field values.

• Action
  Get Inventory Item

  Get on-hand quantity and cost of a single stock item by stock item ID.

• Action
  Get Inventory Sum

  Get total inventory quantities and costs, including work in progress (WIP). Historical totals can be requested with the date parameter.

• Action
  Get Invoice

  Get a sales invoice with its product lines and linked customer orders by invoice ID. Cancelled invoices are returned.

• Action
  Get Item

  Get stock item details by product ID, including product-level settings and custom values.

• Action
  Get Item Engagement

  Get the engagement report for an item (BOMs where the item is used as a component). The report is keyed by the item variation ID (`{article_id}`), mirroring the web report.

• Action
  Get Lot

  Get a stock lot with its storage locations and serial numbers by stock lot ID.

• Action
  Get Lot Contents

  This report contains a list of lots that this lot consists of. If the product contains subassemblies, then the stock lots from which the used subassemblies are made are also displayed. Rows are returned in a fixed, stable order - by nesting level, then lot id.

• Action
  Get Lot Engagement

  This report shows the list of stock lots that whether contain items from this stock lot or are made from items from this stock lot. Rows are returned in a fixed, stable order — by nesting level, then lot id.

• Action
  Get Manufacturing Order

  Get a manufacturing order with its parts, operations and notes by manufacturing order ID. Archived and cancelled manufacturing orders are returned.

• Action
  Get Parameter

  Get parameter details with values by parameter ID.

• Action
  Get Product Group

  Get product group details by product group ID.

• Action
  Get Production Co Products Statistics

  Gets a list of co-products that were made during the selected period. The default period is the current month. Maximum period length is one month.

• Action
  Get Production Operations Statistics

  Gets a list of manufacturing operations that are planned for the selected period. Planned finish date is within the selected period. The default period is the current month. Maximum period length is one month.

• Action
  Get Production Orders Statistics

  Gets the manufacturing orders report for the selected period. The default period is the current month. Maximum period length is one month.

• Action
  Get Production Products Statistics

  Gets a manufacturing plan by products. Planned finish date is within the selected period. The default period is the current month. Maximum period length is one month.

• Action
  Get Purchase Order

  Get a purchase order with its product lines and incoming invoices by purchase order ID. Cancelled and archived purchase orders are returned.

• Action
  Get Relation

  Get a Matrix BOM relation with its lines by relation ID.

• Action
  Get RMA Order

  Get an RMA order with its items, invoices and shipments by RMA order ID. Archived and cancelled RMA orders are returned.

• Action
  Get Routing

  Get routing details with operations by routing ID.

• Action
  Get Serial

  Get a serial number with its component serial numbers by serial number ID.

• Action
  Get Shipment

  Get a shipment with its orders and products by shipment ID.

• Action
  Get Site

  Get production or storage site details by site ID.

• Action
  Get Stock Movement

  Get stock movement totals for a date range, including opening balance, inward and outward costs, WIP, and closing balance.

• Action
  Get Stock Movement Items

  List stock movement totals grouped by stock item for a date range, optionally filtered by available attributes.

• Action
  Get Stock Movement Transactions

  List detailed stock movement transactions for a date range, optionally filtered by available attributes.

• Action
  Get Stock Movement WIP

  List work-in-progress (WIP) materials consumed into in-progress manufacturing orders for a date range, optionally filtered by available attributes.

• Action
  Get Storage Location

  Get storage location details by storage location ID.

• Action
  Get Unit

  Get unit of measurement details by unit ID.

• Action
  Get User Action

  Get a user action by its ID.

• Action
  Get Variation

  Get a stock item variation by product ID and variation article ID.

• Action
  Get Vendor

  Vendors are read-only. Only GET method is supported. Other methods are disabled. A deleted vendor is still returned.

• Action
  Get Vendor Performance Statistics

  Delivery performance of the vendors in use for the requested period: punctuality, cost of the received purchases and, with Quality Control, rejections. Cancelled purchase orders are left out. Deleted vendors are left out unless they are named by ID or by code. The default period is from the start of

• Action
  Get Widgets

  Get the list of available widgets, considering account settings and user rights.

• Action
  Get Workstation

  Get workstation details by workstation ID.

• Action
  Get Workstation Group

  Get workstation group details by workstation group ID.

• Action
  Get Writeoff

  Get manual stock write-off details by write-off ID.

• Action
  List Accounting Synchronizations

  List accounting integration synchronization logs for a date range, optionally filtered by available attributes.

• Action
  List Accounts

  List chart of accounts entries, optionally filtered by available attributes.

• Action
  List BOMs

  List bills of materials (BOMs), optionally filtered by available attributes.

• Action
  List Customer Orders

  List customer orders with their product lines and the stock lots they are booked from, optionally filtered by available attributes. Archived and cancelled customer orders are left out unless the request filters by customer_order_id or by status. Product filters must match the same order line. Matchi

• Action
  List Customers

  List customers with their contact details, optionally filtered by available attributes. Deleted customers are left out unless the request filters by customer_id or by code.

• Action
  List Custom Fields

  List custom fields, optionally filtered by available attributes.

• Action
  List General Ledger Transactions

  List general ledger transactions for an account and date range.

• Action
  List Incoming Invoices

  List incoming invoices (bills) from vendors, optionally filtered by available attributes.

• Action
  List Inventory

  List stock items with on-hand quantities and costs, optionally filtered by available attributes. Historical inventory can be requested with the date parameter.

• Action
  List Inventory Critical

  Critical on-hand report: stock items whose projected quantity (available + expected available) has fallen below their reorder point. The report reflects the current situation; it cannot be requested for a past date.

• Action
  List Invoices

  List sales invoices with their product lines and linked customer orders, optionally filtered by available attributes. Cancelled invoices are left out unless the request filters by invoice_id or by status.

• Action
  List Items

  List stock items/products and their current inventory and planning data, optionally filtered by available attributes.

• Action
  List Lots

  List stock lots with their storage locations and serial numbers, optionally filtered by available attributes. Stock lots with nothing available and nothing booked are left out unless the request narrows to them, and cancelled stock lots are left out unless the request filters by lot_id, code or stat

• Action
  List Manufacturing Orders

  List manufacturing orders with their target stock lots, optionally filtered by available attributes. Archived and cancelled manufacturing orders are left out unless the request filters by manufacturing_order_id or by status.

• Action
  List Parameters

  List parameters with their values, optionally filtered by available attributes.

• Action
  List Product Groups

  List product groups, optionally filtered by available attributes.

• Action
  List Purchase Orders

  List purchase orders with their product lines and incoming invoices, optionally filtered by available attributes. Cancelled and archived purchase orders are left out unless the request filters by purchase_order_id or by status.

• Action
  List Relations

  List Matrix BOM relations, optionally filtered by available attributes. The lines of a relation are returned by the relation details.

• Action
  List RMA Orders

  List RMA orders with their returned and outbound items, optionally filtered by available attributes. Archived and cancelled RMA orders are left out unless the request filters by rma_order_id or by status. The returned item filters match an order when one of its returned items meets all of them; the

• Action
  List Routings

  List routings with their operations, optionally filtered by available attributes.

• Action
  List Serials

  List serial numbers with their component serial numbers, optionally filtered by available attributes.

• Action
  List Shipments

  List shipments with their orders and products, optionally filtered by available attributes.

• Action
  List Sites

  List production and storage sites, optionally filtered by available attributes.

• Action
  List Storage Locations

  List storage locations within sites, optionally filtered by available attributes.

• Action
  List Units

  List units of measurement, optionally filtered by available attributes.

• Action
  List User Actions

  List the actions users made, optionally filtered by available attributes. User actions are read-only.

• Action
  List User Action Types

  Returns all available user action codes and their text descriptions.

• Action
  List Variations

  List variations of a stock item by product ID when Matrix BOM functionality is enabled and the item has parameters.

• Action
  List Vendors

  Vendors are read-only. Only GET method is supported. Other methods are disabled. Deleted vendors are left out unless they are named by ID or by code.

• Action
  List Workstation Groups

  List workstation groups, optionally filtered by available attributes.

• Action
  List Workstations

  List workstations, optionally filtered by available attributes.

• Action
  List Writeoffs

  List manual stock write-offs, optionally filtered by available attributes.

• Action
  Partially Update Product Group

  Partially update the editable fields of a product group by product group ID.

• Action
  Update Product Group

  Replace the editable fields of a product group by product group ID.

• Action
  Add Chart

  Add a chart to a worksheet using microsoft graph api.

• Action
  Add Named Item

  Add Named Item

• Action
  Add Sharepoint Worksheet

  Add a new worksheet to a sharepoint excel workbook using microsoft graph sites api.

• Action
  Add Table

  Create a table over a range in an Excel workbook.

• Action
  Add Table Column

  Add a column to a table using microsoft graph api.

• Action
  Add Table Row

  Add a row to a table using microsoft graph api.

• Action
  Add Workbook Permission

  Tool to grant access to a workbook via invite. use when you need to share a specific workbook file with designated recipients and roles.

• Action
  Add Worksheet

  Add a new worksheet to an excel workbook using microsoft graph api.

• Action
  Apply Table Filter

  Apply a filter to a table column using microsoft graph api.

• Action
  Apply Table Sort

  Apply a sort to a table using microsoft graph api.

• Action
  Autofit Range

  Autofit columns or rows intersecting a workbook range.

• Action
  Calculate Function

  Run one allowlisted Microsoft Graph v1.0 workbook function.

• Action
  Calculate Workbook

  Calculate Excel Workbook

• Action
  Clear Range

  Tool to clear values, formats, or contents in a specified worksheet range. use when you need to reset cells before adding new data.

• Action
  Clear Table Filter

  Clear a filter from a table column using microsoft graph api.

• Action
  Clear Table Filters

  Clear All Table Filters

• Action
  Clear Table Sort

  Clear Table Sort

• Action
  Close Session

  Tool to close an existing excel workbook session. use when you need to explicitly end a persistent session to release workbook locks.

• Action
  Convert Table To Range

  Convert a table to a range using microsoft graph api.

• Action
  Copy Drive Item

  Create a non-destructive asynchronous copy of a file or folder. Metadata and permissions are not copied; the new item inherits destination-folder permissions. Version history is copied only when explicitly requested.

• Action
  Create Folder

  Create a folder under a parent Microsoft Graph drive item.

• Action
  Create Workbook

  Create an .xlsx workbook in the user's OneDrive, from a file URL or blank.

• Action
  Delete Named Item

  Permanently delete a workbook-scoped named item; this cannot be undone.

• Action
  Delete Range

  Delete worksheet cells and shift the remaining cells up or left.

• Action
  Delete Table

  Permanently delete an Excel table by its ID or name.

• Action
  Delete Table Column

  Delete a column from a table using microsoft graph api.

• Action
  Delete Table Row

  Delete a row from a table using microsoft graph api.

• Action
  Delete Worksheet

  Tool to delete a worksheet from the workbook. use when cleaning up unused or temporary sheets after verifying no dependencies exist. example: "delete 'sheet2' after review."

• Action
  Export Workbook To Pdf

  Tool to export an Excel workbook to PDF via Microsoft Graph's format conversion. Use when you need a PDF version of an Excel file for sending, storing, or attaching.

• Action
  Get Application

  Get Excel Application

• Action
  Get Chart

  Get chart

• Action
  Get Chart Axis

  Tool to retrieve a specific axis from a chart. use when you need properties like min, max, interval, and formatting of the chart axis.

• Action
  Get Chart Component

  Get chart component

• Action
  Get Chart Data Labels

  Tool to retrieve the data labels object of a chart. use when you need to inspect label settings like position, separator, and visibility flags after creating or updating a chart.

• Action
  Get Chart Image

  Get chart image

• Action
  Get Chart Legend

  Tool to retrieve the legend object of a chart. use after creating or updating a chart when you need to inspect legend visibility and formatting.

• Action
  Get Chart Point

  Get chart point

• Action
  Get Chart Series

  Get chart series

• Action
  Get Derived Range

  Return a range derived from another range by navigation or geometry.

• Action
  Get Named Item

  Retrieve a workbook-scoped named item by exact name.

• Action
  Get Named Item Range

  Get Named Item Range

• Action
  Get Range

  Get a range from a worksheet using microsoft graph api.

• Action
  Get Range Format

  Read one formatting component from a workbook range.

• Action
  Get Session

  Create a session for an excel workbook using microsoft graph api.

• Action
  Get Sharepoint Range

  Get a range from a worksheet in sharepoint using microsoft graph sites api.

• Action
  Get Sharepoint Worksheet

  Get a worksheet by name or id from a sharepoint excel workbook using microsoft graph sites api.

• Action
  Get Table

  Retrieve one workbook- or worksheet-addressed table by ID or exact name.

• Action
  Get Table Column

  Tool to retrieve a specific column from a workbook table. use when you need to fetch column properties and data by its id or name.

• Action
  Get Table Column Range

  Get Table Column Range

• Action
  Get Table Range

  Get Table Range

• Action
  Get Table Row

  Get Table Row

• Action
  Get Table Row Range

  Get Table Row Range

• Action
  Get Table Sort

  Get Table Sort

• Action
  Get Visible Range

  Read cells visible after worksheet filtering.

• Action
  Get Workbook

  Tool to retrieve the properties and relationships of a workbook. use when you need to inspect comments, names, tables, or worksheets.

• Action
  Get Worksheet

  Get a worksheet by name or id from an excel workbook using microsoft graph api.

• Action
  Get Worksheet Protection

  Get Worksheet Protection

• Action
  Get Worksheet Used Range

  Tool to retrieve a worksheet's used range (active data region) without specifying a fixed range address. Use when you need to read all data from a sheet but don't know the exact range. The valuesOnly option helps filter out formatting-only cells.

• Action
  Insert Range

  Tool to insert a new cell range into a worksheet, shifting existing cells down or right. use when you need to create space for new content without overwriting.

• Action
  List Chart Points

  List chart points

• Action
  List Charts

  List charts in a worksheet using microsoft graph api.

• Action
  List Chart Series

  Tool to list all data series in a chart. use when you need to enumerate chart series for further analysis.

• Action
  List Comments

  Tool to list comments in an excel workbook. use when you need to retrieve all workbook comments via microsoft graph api.

• Action
  List Drive Item Children

  Tool to list immediate children (files/folders) of a folder DriveItem using driveId and itemId. Returns an array of child DriveItems with stable identifiers and pagination support.

• Action
  List Files

  List files and folders in a drive root or specified path.

• Action
  List Named Items

  List named items in a workbook using microsoft graph api.

• Action
  List Sharepoint Tables

  List tables in a sharepoint worksheet using microsoft graph sites api.

• Action
  List Sharepoint Worksheets

  List worksheets in an excel workbook stored in sharepoint using microsoft graph sites api.

• Action
  List Table Columns

  List columns in a table using microsoft graph api.

• Action
  List Table Rows

  List rows in a table using microsoft graph api.

• Action
  List Tables

  List tables in a worksheet using microsoft graph api.

• Action
  List Workbook Permissions

  Tool to list permissions set on the workbook file. use when you need to see which users or links have access to a specific excel file by supplying its drive and item ids. example: "list permissions for workbook with drive id 'b!abc123' and item id '0123456789abcdef'."

• Action
  List Worksheets

  List worksheets in an excel workbook using microsoft graph api.

• Action
  Merge Cells

  Merge cells in a worksheet range using microsoft graph api.

• Action
  Protect Worksheet

  Tool to protect a worksheet using optional protection options. use when you need to prevent editing certain parts of a sheet before sharing. example: "protect 'sheet1' to lock formatting and sorting."

• Action
  Reapply Table Filters

  Reapply All Table Filters

• Action
  Reapply Table Sort

  Reapply Table Sort

• Action
  Refresh Session

  Refresh Excel Session

• Action
  Search Files

  Tool to search OneDrive drive items by query to discover Excel workbook IDs. Use when you need to find Excel files by name before performing workbook operations.

• Action
  Search Microsoft 365 Content

  Search OneDrive and SharePoint content using Microsoft Search.

• Action
  Set Chart Data

  Set chart data

• Action
  Set Chart Position

  Set chart position

• Action
  Sort Range

  Sort a range in a worksheet using microsoft graph api.

• Action
  Unmerge Range

  Split a merged worksheet range back into separate cells.

• Action
  Unprotect Worksheet

  Remove protection from a worksheet so it can be edited again.

• Action
  Update Chart

  Update a chart in a worksheet using microsoft graph api.

• Action
  Update Chart Component

  Update chart component

• Action
  Update Chart Legend

  Tool to update formatting or position of a chart legend. use when adjusting legend settings after confirming chart and worksheet exist.

• Action
  Update Chart Series

  Rename one Excel chart series by ID or zero-based collection position.

• Action
  Update Named Item

  Update a workbook named item's visibility or comment.

• Action
  Update Range

  Update a range in a worksheet using microsoft graph api.

• Action
  Update Range Format

  Update exactly one formatting component on a workbook range.

• Action
  Update Sharepoint Range

  Update a range in a sharepoint worksheet using microsoft graph sites api.

• Action
  Update Table

  Update a table in a workbook using microsoft graph api.

• Action
  Update Table Column

  Update Table Column

• Action
  Update Table Row

  Update Table Row

• Action
  Update Worksheet

  Update worksheet properties (name, position) in an excel workbook using microsoft graph api.

• Action
  Upload Workbook

  Tool to upload an external Excel file from a URL into OneDrive/SharePoint. Downloads the file server-side and uploads it to the specified drive location, returning the driveItem metadata for subsequent Excel operations.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.