invantive documentation
Invantive Support ForumsLog In / Sign Up

ArticleByNumber: Fortnox Article by Number

read only REST

  • Catalog: Fortnox
  • Schema: Articles
  • Label: Article by Number

Retrieve an article Retrieves the details of an article. You need to supply the unique article number that was returned when the article was created or retrieved from the list of articles.

Can only retrieve data.

Summary

Retrieves the details of an article. You need to supply the unique article number that was returned when the article was created or retrieved from the list of articles.

API Source

  • Endpoint: /3/articles/{ArticleNumber}
  • Operation: get /3/articles/{ArticleNumber}

Performance Characteristics

Characteristic Value
Average access latency (ms) 356
Full scan rows per minute 85,000
Point query rows per minute 168

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
ArticleNumber `` identifies the article
financialyear `` Selects what financial year that should be used (does not work on every table).
financialyeardate `` Selects by date, what financial year that should be used (does not work on every table).
fromdate `` Defines a selection based on a start date. Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).
lastmodified `` Retrieves all records since the provided timestamp (does not work on every table).
todate `` Defines a selection based on an end date. Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).

Table Columns

The columns of the table ArticleByNumber are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
Article_Active char Article Active filters on the platform, writable, Article.Active
Article_ArticleNumber varchar2(50) Article Number filters on the platform, writable, Article.ArticleNumber
Article_Bulky char Article Bulky filters on the platform, writable, Article.Bulky
Article_ConstructionAccount int32 Article Construction Account filters on the platform, writable, Article.ConstructionAccount
Article_CostCalculationMethod varchar2 Article Cost Calculation Method filters on the platform, writable, Article.CostCalculationMethod
Article_DefaultStockLocation varchar2 Article Default Stock Location filters on the platform, writable, Article.DefaultStockLocation
Article_DefaultStockPoint varchar2 Article Default Stock Point filters on the platform, writable, Article.DefaultStockPoint
Article_Depth int32 Article Depth filters on the platform, writable, Article.Depth
Article_Description varchar2(200) Article Description filters on the platform, writable, Article.Description
Article_DirectCost double Article Direct Cost filters on the platform, writable, Article.DirectCost
Article_DisposableQuantity double Article Disposable Quantity filters on the platform, writable, Article.DisposableQuantity
Article_EAN varchar2(30) Article EAN filters on the platform, writable, Article.EAN
Article_EUAccount int32 Article EU Account filters on the platform, writable, Article.EUAccount
Article_EUVATAccount int32 Article EU VAT Account filters on the platform, writable, Article.EUVATAccount
Article_Expired char Article Expired filters on the platform, writable, Article.Expired
Article_ExportAccount int32 Article Export Account filters on the platform, writable, Article.ExportAccount
Article_FreightCost double Article Freight Cost filters on the platform, writable, Article.FreightCost
Article_Height int32 Article Height filters on the platform, writable, Article.Height
Article_Housework char Article House Work filters on the platform, writable, Article.Housework
Article_HouseworkType varchar2 Article House Worktype filters on the platform, writable, Article.HouseworkType
Article_Manufacturer varchar2(50) Article Manufacturer filters on the platform, writable, Article.Manufacturer
Article_ManufacturerArticleNumber varchar2(50) Article Manufacturer Article Number filters on the platform, writable, Article.ManufacturerArticleNumber
Article_Note varchar2(10000) Article Note filters on the platform, writable, Article.Note
Article_OtherCost double Article Other Cost filters on the platform, writable, Article.OtherCost
Article_PurchaseAccount int32 Article Purchase Account filters on the platform, writable, Article.PurchaseAccount
Article_PurchasePrice double Article Purchase Price filters on the platform, writable, Article.PurchasePrice
Article_QuantityInStock double Article Quantity in Stock filters on the platform, writable, Article.QuantityInStock
Article_ReservedQuantity double Article Reserved Quantity filters on the platform, writable, Article.ReservedQuantity
Article_SalesAccount int32 Article Sales Account filters on the platform, writable, Article.SalesAccount
Article_SalesPrice double Article Sales Price filters on the platform, writable, Article.SalesPrice
Article_StockAccount int32 Article Stock Account filters on the platform, writable, Article.StockAccount
Article_StockChangeAccount int32 Article Stock Change Account filters on the platform, writable, Article.StockChangeAccount
Article_StockGoods char Article Stock Goods filters on the platform, writable, Article.StockGoods
Article_StockPlace varchar2(100) Article Stock Place filters on the platform, writable, Article.StockPlace
Article_StockValue double Article Stock Value filters on the platform, writable, Article.StockValue
Article_StockWarning double Article Stock Warning filters on the platform, writable, Article.StockWarning
Article_SupplierName varchar2 Article Supplier Name filters on the platform, writable, Article.SupplierName
Article_SupplierNumber varchar2 Article Supplier Number filters on the platform, writable, Article.SupplierNumber
Article_Type varchar2 Article Type filters on the platform, writable, Article.Type
Article_Unit varchar2 Article Unit filters on the platform, writable, Article.Unit
Article_VAT double Article VAT filters on the platform, writable, Article.VAT
Article_WebshopArticle char Article Webshop Article filters on the platform, writable, Article.WebshopArticle
Article_Weight int32 Article Weight filters on the platform, writable, Article.Weight
Article_Width int32 Article Width filters on the platform, writable, Article.Width
Article__url varchar2 Article URL filters on the platform, writable, Article.@url

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: