I have several invoices that I made a json from SQL 2017, but I have a problem in the structure

0

I generate my JSON from SQL 2017 which generates this structure taken from a table.

"detalle": [{
        "numero": "1",
        "codigo": [{
            "tipo": "04",
            "codigo": "593"
        }, {
            "tipo": "04",
            "codigo": "12"
        }],
        "cantidad": "1.000",
        "unidad_medida": "Unid",
        "detalle": "Tour Manglar",
        "precio_unitario": "65435.00000",
        "monto_total": "65435.00000",
        "subtotal": "65435.00000",
        "impuestos": [{
            "codigo": "",
            "tarifa": "0.00",
            "monto": "0.00000"
        }, {
            "codigo": "01",
            "tarifa": "13.00",
            "monto": "73.97000"
        }, {}],
        "montototallinea": "65435.00000"
    }
--------------------------------
pero me gustaria tenerlo asi


"detalle": [{
        "numero": "1",
        "codigo": [{
            "tipo": "04",
            "codigo": "593"
        }],
        "cantidad": "1.000",
        "unidad_medida": "Unid",
        "detalle": "Tour Manglar",
        "precio_unitario": "65435.00000",
        "monto_total": "65435.00000",
        "subtotal": "65435.00000",
        "impuestos": [{
            "codigo": "",
            "tarifa": "0.00",
            "monto": "0.00000"
             }],
        "montototallinea": "65435.00000"
    }
    
asked by Jurgem 23.11.2018 в 00:31
source

0 answers