Visma L7 REST API - Change log

18.6.2025

• purchaseorders POST/PUT
• New property CostType under Rows/Row/Postings/Posting
• products POST/PUT
• Added new property BatchControl
• products GET
• Added new properties batchControl and batchControlName

17.6.2025

• companies PUT
• Fixed bug that caused NOT in use company to go in use when updating company

11.6.2025

• companies GET
• Fixed bug that caused some companies returned multiple times when there was additional addresses in different languages

28.5.2025

• companies GET
• Added Additional addresses into result

26.5.2025

• manufevents GET
• New queryKey: showTimeEntries to toggle time entry events on/off from the result

21.5.2025

• purchaseinvoicerows GET
• New endpoint for requesting purchase invoice rows

15.5.2025

• manufschedulings POST
• Added new property PartNo for part number
• bookkeepingtransactions GET
• Minor fix for productCode and productName to appear in certain situations

13.5.2025

• companies GET
• Fixed return message to show deleted companies properly

12.5.2025

• salesrows GET
• Fixed issue where deleted rows didn't appear in result when getting modified rows

7.5.2025

• products GET
• Added support for only additional columns LTR settings

29.4.2025

• companies and salesorders2 POST/PUT
• Added support for additional addresses

10.4.2025

• dimensions GET
• New request parameters: queryWhere and extraWhere
• queryWhere can be given as parameter for request
• extraWhere is LTR setting for each dimension
• bookkeepingtransactions GET
• fixed record ordering when fetching with dblogRec

4.4.2025

• bookkeepingtransactions GET
• openTransactions now also include transactions in committed costs
• manufscheduling POST
• New endpoint for manufacturing task scheduling

3.4.2025

• manufphases PUT
• New properties to workSheets level: mainNumber, subNumber, rowNumber and newQuantity
• New properties enables to change manufactoring quantity for worksheet row
• Quantity change is allowed for stock orders only (not for customer orders)
• Requires L7 version 9.10

17.3.2025

• products PUT
• Added clarifications about key fields in schema documentation

14.3.2025

• salesorders2 PUT
• New attribute @Delete for ProductRow that allows deleting rows
• purchaseorderconfirmations PUT
• New property ConfirmationDate to set the confirmation date

13.2.2025

• salesorders GET
• Endpoint now returns orderSubType, orderSubTypeName and orderId fields like it says in schema

10.2.2025

• general description
• Added description that sting propertiest will be cut without warning if they exceed max length values.

7.2.2025

• bookkeepingtransactions GET
• Fixed dblogRec and missing deleted rows.

6.2.2025

• salesorder GET
• Fixed error "undefined variable:l7r_salesorder_partyX" when parties where undefined for rest user
• Improved performance when using both queryWhere and recAfter parameters

24.1.2025

• quantitativepricelists GET
• Added RowNumber property

9.1.2025

• salesrows GET
• Added support for only additional columns LTR settings
• stockbalances GET
• Added support for only additional columns LTR settings

8.1.2025

• projects POST
• New property 'parentSubNumber' that allows creating specification subnumbers for projects

20.12.2024

• salesorders2 PUT
• Using xml request didn't work and is now fixed

29.11.2024

• Several schemas
• Fixed several schemas due to single json bug

26.11.2024

• most GET endpoints
• Fixed maxlength of most endpoints additional properties and where to 99999 in LTR settings

12.11.2024

• All GET endpoints
• Added support for parameter queryWhere
• documented only in bookkeepingtransactions, companies and salesorders
• documentation will be updated later
• Projects GET
• Performance improvment
• Productevents GET
• Fixed rec after, earlier returned also given rec
• Companies GET
• Added fkaup.myos='2' (table alias fkaup_2) to get supplier information

7.11.2024

• salesinvoices POST
• New endpoint for saving sales invoices

5.11.2024

• bookkeepingtransactions GET
• It is now possible to request transactions with open status

1.11.2024

• companies PUT/POST
• New properties:
• ../AccountsReceivable/CreditLimitCheckLevelId
• ../AccountsPayable/Codeless

31.10.2024

• manufmaterials GET
• Added support for only additional columns LTR settings

30.10.2024

• salesinvoices GET
• Added support for only additional columns LTR settings
• purchaseinvoices GET
• Added support for only additional columns LTR settings

14.10.2024

• salesorders PUT
• Fixed update when sales line specification, removed specifications quietly, now returns error
• salesrows GET
• Fixed row text handling when row have multiple texts. Only one row text returned (teksti.tyyppi=1)

24.10.2024

• discounttables PUT/GET
• New endpoints for updating and getting discount tables from L7

14.10.2024

• purchaserows GET
• Added support for only additional columns LTR settings

11.10.2024

• salesorders2 POST
• Fixed row RowNumber and SupplierNo properties descriptions

7.10.2024

• budgettransactions POST
• New endpoint for saving budget transactions

30.9.2024

• products PUT
• New property Delete for Codes and Measures

19.9.2024

• Quantitative pricelists GET and PUT
• New endpoints for quantitative pricelists
• employees GET
• Added support for only additional columns LTR settings
• purchaseinvoices POST
• If LTR setting 'ready invoices' is on for rest user, L7 won't accept invoices with missing data
• Requires L7 version 9.9.14

12.9.2024

• projects GET
• Now supports LTR additional properties and only additional properties settings

10.9.2024

• purchaseorderconfirmation PUT
• New property ConfirmationInfo for order row text
• Requires L7 version 9.9.15

22.8.2024

• bookkeepingtransactions POST
• New property taxRatePercent that allows tax rate to be brought as number instead of L7 code
• projectNumber property can now be empty
• Requires L7 version 9.9.13

21.8.2024

• purchaseinvoices POST
• Added user setting Ready-invoices for checked and accepted invoices
• bookkeepingtransactions GET
• fixed dblogRec fetch, didn't return all changed rows

16.8.2024

• products POST/PUT
• New property Stocks/Stock/Quantity

15.8.2024

• manufcomponents GET
• Additionals properties setting and Only additional properties setting for manufcomponents GET endpoint
• manufevents GET
• Additional properties setting and Only additional properties setting for manufevents GET endpoint
• manufphases GET
• Additional properties setting and Only additional properties setting for manufphases GET endpoint
• companies POST/PUT
• Clarified ContactPerson and ContactInfo MasterId property explanation

26.6.2024

• bookkeepingtransactions GET
• Fixed paging when using startDate and kptilioRec parameters
• Performance optimization
• when endDate is empty, now using current date as endDate
• RestClient included in LTR update package
• GET endpoints to csv-file or excel-file from command line
• Handles pagination and reads all data at single command
• Files are in LTR's subfolder 4field\images\RestClient

6.6.2024

• New endpoint contractprices GET
• New endpoint Purchase needs POST
• Requires L7 version 9.9.6.

3.6.2024

• products POST/PUT
• New property References.Reference.DocuRec that ads support for document group when request contains reference documents
• New property References.Reference.Base64Data for base64 encoded document data

28.5.2024

• bookkeepingtransactions GET
• Performance optimized when using dblogRec

15.5.2024

• bookkeepingtransactions POST
• Now gives error if attachment filename length is more than 35 characters
• New endpoint contractprices PUT

14.5.2024

• projects POST
• Added sba property

3.5.2024

• companies GET
• Rec after didn't work properly

2.5.2024

• companies GET
• Added support for only additional columns

19.4.2024

• manufphases PUT
• New property: person
• salesorder and salesorder2 POST/PUT
• VendorNumber isn't required field anymore

18.4.2024

• Stocktransferproposals POST/PUT
• New endpoint for stock transfer proposals

4.4.2024

• Stockbalances GET
• Added product's usage unit (usageUnit = HINSTO.KAYTTOYKS)

22.3.2024

• Products POST/PUT
• Price/CostType and Price/CountryOfOrigin changed to required field

15.2.2024

• Bookkeepingtransactions GET
• Added endDate parameter
• Fixed error handling, startDate, kptilioRec or dblogRec must be given
• CSV is disabled when using dblogRec parameter
• Added support for only additional columns
• Salesorders GET
• Added support for only additional columns
• Projects GET
• fixed datatype for subNumberOrderDate and modifiedTs

18.1.2024

• Saleorders POST
• Added AllowCodelessKits, BinLocation, Currency and PrintIt properties
• Minor fix in common_dates description
• Saleorders2 POST
• Added BinLocation, Currency and PrintIt properties

12.1.2024

• SalesInvoices GET
• statusCode query (queryKey2) now accept comma separated list of statusCodes

22.11.2023

• purchaseinvoices GET
• Added new parameter invoiceSource to define if invoices are fetched from 'old' purchase invoicing (ORLASKU), or 'new' invoicing (PCIHDR)
• invoiceSource = 0 or empty, data will be fetched from ORLASKU
• invoiceSource = 1, data will be fetched from PCIHDR
• Added new parameter InvoiceTypeName that is the meaning of InvoiceType value

14.11.2023

• All GET endpoints
• Maximum page size for text/csv is 100000

10.11.2023

• salesorder POST/PUT
• Fixed the error when saveconfiguration POST/PUT couldn't handle the request with several structured rows.

7.11.2023

• All GET endpoints
• Added support to content-type text/csv
• Added support to content-type text/xml, intended xml
• Added support to content-type text/json, intended json
• Added support to data typed JSON, numeric values and null values not returned as strings, user specific setting
• Added support to JSON array without type, user specific setting

9.10.2023

• purchaseinvoices POST
• Schema STD value fix for purchase invoice row texts (A703 was X137)

2.10.2023

• product POST/PUT
• Fixed response schema to show correct example

29.9.2023

• New Rest resourceupdates POST to update resourcecalendar for manufacturing phases
• Requires L7 version 9.7.9

30.8.2023

• SalesOrder2 POST/PUT
• Sub number status can be set to values 8 or 9. Requires L7 version 9.7.7.

16.8.2023

• Bookkeepingtransactions POST
• Raised transaction amount limit / request from 1000 to 2000

9.8.2023

• Projects GET
• Returns now also projects when first sub number's buyer is empty
• Single file json
• fixed structural errors in single file version (L7RestApi_single.json)

13.6.2023

• Manufphases PUT
• Added new properties: phaseName, additionalInfo1, additionalInfo2 and additionalInfo3
• Fixed response example to show what API actually returns

5.6.2023

• Purchase Invoices GET
• Fixed error l7r_siv_where
• added "extra where" and "additional properties" settings for endpoint

2.6.2023

• Salesorders POST/PUT
• Fixed response party.contactpersons.contactperson as array

23.5.2023

• Salesorders2 POST/PUT
• Fixed response example schema and error response is now returned as array

22.5.2023

• Salesorders POST/PUT
• Moved TariffItems to common schema
• Added Kits and their Materials and Phases properties to Rows/ProductRow

10.5.2023

• Products POST/PUT
• Fixed schema error with references and texts
• Bookkeepingtransactions POST
• Fixed schema files/file/name element length from 50 to 35

9.5.2023

• Dimensions GET
• inUse field now returns TILIT.TILILAJI when requesting for accounts

3.5.2023

• Fixed number formats in several schema files

28.4.2023

• Purchaseorders POST/PUT
• Fixed response to return OrderNo field with newly formed or modified purchase order number
• Fixed PartyIds schema to show as array

20.4.2023

• Purchase invoices GET (beta)

18.4.2023

• Bookkeepingtransactions GET
• Fixed error when invoice amounts where over 100 000 000

11.4.2023

• New enpoint Purchase orders PUT
• Requires L7 version 9.6.14

11.4.2023

• New salesinvoicepayments POST

21.3.2023

• Single file json
• fixed structural errors in single file version (L7RestApi_single.json)

17.3.2023

• Manufcomponents GET
• Added salesRowDeliveryDate property

8.2.2023

• Fixes to companies POST/PUT
• New property AccountsReceivable/Invoicing/CombineInvoices
• Fixed bug that caused L7 not save company correctly in some situation, when certain STD value was missing

1.2.2023

• New Manufcomponents GET
• New Manufevents GET
• New Manufresources GET

31.1.2023

• New Manufphases GET

4.1.2023

• New Salesorders2 POST/PUT
• L7 9.6.3

Version 2247

• Employees GET
• New endpoint for employees GET
• Beta release
• Bookkeepings GET
• Fixed supplierNumber and buyerNumber properties
• Added supplierSearchName and buyerSearchName properties
• Salesorders POST/PUT
• Fixed json response arrays like descriped in documentation. When only one element in arrays, response was property, not array (etc. references.reference)

Version 2245

• Purchaseinvoices POST
• Fixed purchaseorder order number and line number

Version 2243

• Dblogs POST
• Required REST profile check fixed, allowed now also with profiles 371-375
• Purchaseinvoices POST
• Invoice number not required anymore
• Products POST/PUT
• Fixed prices, measures as codetables in L7 version 9.5.15

Version 2241

• Adhocs GET
• Support to base64 encoded files. base64filedata named column encoded automatically
• Companies GET
• Fixed modifiedAfter DBLOG search, when only FKAUP is changed in L7 database
• Products GET
• Fixed schema documentation for HINSTO.KAYTTOYKS from unitCode to usageUnit (response not changed)
• Salesorder POST/PUT
• Added support for sales row references

Version 2239

• Productevents GET
• New endpoint for product events GET
• Beta release
• Salesinvoices GET
• New endpoint for sales invoices GET
• Beta release
• Bookkeeping Transactions POST
• Fixed license code check
• Products GET
• Added new properties fastCode, salesDiscountGroup etc.

Version 2237

• Salesorders POST/PUT
• Added support for reference document base64data, requires L7 version 9.5.8
• Products POST/PUT
• Added support for business unit

Version 2236

• Purchase invoices POST
• Fixed license code
• All endpoints
• Clarify difference between empty and missing properties/elements in common documentation

Version 2233

• All endpoints
• Re-factored schemas to support single-file json
• Download of single-file json for tools like NSWAG, Postman, Insomnia etc.
• Some minor errors fixed in documentation
• Dblog POST
• Cleanup splitted into parts to support huge cleanups
• Purchase invoices POST
• New endpoint for purchase invoices POST, requires L7 version 9.5.6
• Response will be changed in future, supports only work/warehouse invoices
• Beta release
• Productprice GET
• Amount changed to required parameter

Version 2223

• Companies POST/PUT
• Added property CustomerEdiId (OVTTUN.TUNNUS), requires L7 version 9.5.2.27
• Purchase rows GET
• Beta release

Version 2219

• All POST/PUT endpoints
• Changed L7 timeout from 100 to 600 seconds
• ping GET
• New endpoint to test server connection

Version 2217

• Dimensions GET
• Added settings for extra properties for each dimension
• Salesorders POST/PUT
• Added property BusinessUnit

Version 2209

• Companies POST
• Allow new company's number from request
• All endpoints
• Fixed logfile error on simultaneous requests

Version 2207

• Purchaseorder POST
• Fixed license code

Version 2205

• All endpoints
• JSON request validated strictly, trailing commas are not allowed
• Projects POST
• Fixed subType handling (MYTYO.TILAUSLAJI)
• Fixed salesman and costCenter handling to new desired sub number(MYTYO.VASTUUHENKILO, MYTYO.KUSTPKA)

Version 2203

• Companies GET
• Fixed contact person's contact numbers
• Projects POST
• Added support to create given sub number for project
• Dimensions GET
• First release

Version 2201

• Salesorder POST/PUT
• Added property OrderId, BlockeInvoice

Version 2151

• bookkeepingtransactions bug fix
• Fixed bug that caused only one attachment file to appear on transaction even when there was several fileIds
• All GET requests
• Fixed timeout handling, Previous "Communication link failed" and "LNA session closed" errors removed

Version 2149

• Purchase order confirmation PUT
• First release, requires L7 9.4
• Projects GET
• First release
• Products POST/PUT
• First release, requires L7 9.4
• Salesorder POST/PUT
• Added OrderSubType (MYTYO.TYYPPI)
• Bookkeepings POST/PUT
• Improved error messages
• Employee POST/PUT
• Improved error messages

Version 2145

• All GET endpoints
• Improved error messages
• Reference 1-5 can be leaved empty in settings, removed from response in that case
• Companies GET
• Contact person's and number's recs added

Version 2139

• Companies POST/PUT
• New properties: AccountsPayable.Postings
• New properties in AccountsReceivable.Invoicing.ElectronicInvoiceElectronicInvoice
• Bookkeepings POST
• Attacment support

Version 2137

• Salesorders POST/PUT
• New properties: Charges
• Bookkeepings POST
• First release, Requires L7 version 9.3.15

Version 2135

• Manufphases PUT
• First release

Version 2131

• Salesorders POST/PUT
• New properties: SalesAccount, TaxBase

Version 2122

• All endpoints
• Documentation splitted into multiple json-files
• Purchaseorders POST
• Create new purchase orders.
• Projects POST
• Create new projects.
• Stockbalances GET
• Fixed settings usage for history days and order filtering

Version 2118

• All endpoints
• Increased max maxQueryStringLength to 8192 on server.
• Salesorders POST/PUT
• New properties (requires L7 9.3 version): AllowInvoicing and ByPostings
• Stockbalances GET
• New properties: estimatedArrivalDate, openPurchaseAmount, openSalesAmount

Version 2114

• Productevents POST
• Create billing and cost events including changes in stock balances.
• Customers POST/PUT
• New properties (requires L7 9.3 version): AccountsPayable.Parties and AccountsReceivable.Parties

Version 2112

• Products GET
• New properties: shape, shapeName, purchaseType, purchaseTypeName
• Salesorders GET
• New properties: orderStatus, mainOrderType, mainOrderTypeName, mainOrderCostCentre, mainOrderCostCentreName
• Salesrows GET
• New properties: unitPrice, discounts, rowSum, vatSum, rowSumIncludingVat
• Stockbalances GET
• New properties: searchName, name, size, manufacturersCode, productGroup, groupName

Version 2102

• Dblogs POST
• Cleanup of L7 dblog table

Version 2101

• General
• HTTP-header parameter names are case-insensitive

Version 2051

• Companies POST/PUT
• Company/AccountsReceivable/Invoicing/ElectronicInvoice
• Company/@InUse