I need to generate XML UBL 2.1 format documents

Questions
1

Hello bubblers

I am building an e-invoicing app and I can’t find a plugin to generate XML UBL 2.1 document. Is there a way I can achieve this on bubble or I need to go back to code?

2

Hi Razvan,

Maybe someone has a better idea but in these cases (generating XML/JSON/other formats) I use ‘:format as text’ a lot.

For example, you have 2 data types:

  1. invoice

image

  1. invoiceLine

image

And you want to save the xml in another data type, you can do something like this:

image
image613×575 16.9 KB

  1. 'Search for invoices:first item:converted to list:format as text" retrieves the invoice and using :format as text, the details are formatted as XML:

image
image726×399 16.2 KB

image
image725×426 20.6 KB

  1. After that, the data from the related invoiceLine(s) is appended:

image
image760×420 16.9 KB

  1. The data is formatted as XML:

image
image761×442 20.4 KB

  1. And in the last stap the closing tag for invoice is added:

image
image846×419 15.4 KB

  1. Parts of the result

image
image928×615 9.05 KB

image

Disclaimer: I did not validate the XML, this is just an example of what is possible. :wink:

1 Like
3

That’s so cool. Thank you for your time and efforts to provide such detailed actions. I don’t see why this should not work…but is easy to test a validation. Anyaway…
A few questions please:
in ur screenshots I see XML = …
I am assuming that XML is a field you created as file in the data table invoice?
and where is the “type invoiceXML” coming from? you renamed you first datatable from invoice to invoiceXML?

Thank you so much for this. Really helpful.

4

N.p. Razvan! The data type invoiceXML is a 3rd data type, I did not rename the data type invoice. XML is a field in that 3rd data type just to save the XML. Yeah indeed, you can also save it in the invoice data type.

5

I had a lot of work to do because I am taking all the info from an SQL server and I only store partially (I do not store the invoice lines) the invoices on bubble…but after a few days of hard work, today I generated a few xml invoices and I got a successful validation thanks to your help. Now I only have one last step to do: to send the xml via API to the authorities and since they have a lousy documentation it is going to take a while :frowning:

Thank you again for your precious help.

1 Like