Convert UBL to JSON
For the case where the next step is code, not a spreadsheet. The invoice comes out as JSON with the same field names the other exports use.
Drop an invoice here
What do you want to do with your invoice?
Nothing is downloaded yet.
View on screen
Export to:
Seller and buyer
Line items
| # | Description | Qty | Unit | Unit price | VAT % | Net amount |
|---|
Tax breakdown and totals
| Category | Rate | Taxable base | VAT amount |
|---|
Payment and references
Remittance items
| # | Qualifier | Reference | Amount | Paid |
|---|
EDI segments
| Segment | Element | Value |
|---|
Why JSON and not the raw XML
The raw XML is already structured, but the way the standard wants, not the way an integration wants: deeply nested, namespace-prefixed, with the same value reachable by three paths. The JSON here is the flattened result of the mapping, so a UBL file and a CII file produce the same keys and your code stops caring which syntax arrived.