capabilities.work

Business Central Upsert an Item

A 3-step recipe with Microsoft Dynamics NAV. We can help you get access.

Recipe · 3 steps

Business Central Upsert an Item

Upsert a single inventory item in a Business Central company by its number.

  1. Search the company item list for an item whose number equals the supplied value, returning at most one match.
  2. Patch the matched item with the supplied pricing and category fields.
  3. Create a new item in the company using the supplied fields when no existing item matched the number.
What you'll need to have ready
  • companyId: The UUID of the Business Central company.
  • number: The item number used to detect an existing item.
  • displayName: The item display name.
  • type: The item type (e.g. Inventory, Service, Non-Inventory).
  • unitPrice: The item unit sales price.
  • unitCost: The item unit cost.
  • itemCategoryCode: The item category code.
  • baseUnitOfMeasureCode: The base unit of measure code.
For your developer

Arazzo workflow navision:upsert-item, 3 operations: listItems → updateItem → createItem. Specs on APIs.io.