My Products
Help
danielboylan
CONTRIBUTOR ***

Visma XML document format

by danielboylan

Hi!

Is it possible to get files such as invoices. order confirmation, packing slips etc from the API in Visma XML format? If so what would i query for?

If not, is it suggested to use the orderDocument table to build such files?

Also, is it possible to use table names in the GUI, similiar to using SQL names in Visma Business GUI. This would make it easier to find out what tables to run queries towards.

2 REPLIES 2

by Øyvind Årseth

@danielboylan Visma XML as format was abandoned many years ago, and has not been maintained, so no, it is not supported. 
The orderDocument table is probably your best starting point. Different names in GUI as in Visma Business is not yet supported, can't say when (or if) it will be. 

omelhus
PARTNER

by omelhus

You can use https://model.vbnxt.rocks/ to generate the GraphQL query field selection that alias to the corresponding SQL name. Just hold shift or ctrl and press the "copy" button and it will be copied to your clipboard.

This will result in the following being saved to your clipboard:
OrdDocNo: orderDocumentNo
DocTp: documentType
DocDt: documentDate
FormNo: formNo
LayNo: layoutNo
PgElNo: pageElementNo
OrdNo: orderNo

... and 200+ more lines.

 

omelhus_0-1695814275774.png