ItemPrices
Download every item's <b>base</b> price as an xlsx — the catalogue-wide base sheet, and the round-trip template for M:IO.CommonAPI.Controllers.v1.Catalog.ItemPricesController.BulkUpsertBasePrices(IO.Domain.Shared.Enums.PriceType,System.Collections.Generic.List{IO.Catalog.Contracts.DTO.Pricelists.BasePriceSheetRow},System.Threading.CancellationToken). Columns are <c>itemCode, price, quantity, fromDate, endDate</c>; the price type comes from `type` and every emitted row is a `relation=Item, relationId=0` row. <br><b>Tenant-primary only</b>, matching the import rather than the two sibling exports. This sheet exists to be edited and posted back, so a caller who could fetch it but not import it would hold a file they cannot use. R1 still applies underneath: a purchase sheet omits rows on items the caller does not own — though for a tenant-primary caller that is every item.<br>Answers `204` when nothing is exportable, `202` with a job id above IO.Admin.BulkExportOptions.SyncRowThreshold, and takes no row filter — the base sheet pins no axis, so it offers none (see IO.Catalog.Contracts.DTO.Pricelists.BasePricesExportRequest).
get/v1/Items/prices/base/download/xlsx
Query parameters
type0 | 1 required
AsOfstring date required
statusPriceRowStatus[]
{"stackTrail":"paths:/v1/Items/prices/base/download/xlsx:get:parameters:3:schema","oasType":"schema","type":"unknown","title":"Account"}
Account
Response
Success
string binary required
Changes
Changed in 1 of the 2 revisions of this API.1
- ○
endpoint added
endpoint-added
This revision also has 2 changes that name no endpoint, such as unreferenced schemas being removed. See the revision's changelog
- ○