API CALL array to JS or JSON

Hi,

I have this code on JSON/JAVA (I dont know nothing about code),

I need on node “items” create one item for each conected record on table with numer 1 (Reference to imagen)
and on node “Mercancias” create one “mercancia” for each conected record on table with number 2 (Reference to imagen)

This code is for make a invoice with many items (Conected to Mexico Goverment system)

{
“Receiver”: {
“Name”: “X PERSONA SA DE CV”,
“CfdiUse”: “P01”,
“Rfc”: “EKU9003173C9”
},
“CfdiType”: “T”,
“NameId”: “33”,
“ExpeditionPlace”: “78240”,

 "Items": [
        {
            "Quantity": {field from table 1},
            "ProductCode": {field from table 1},
            "UnitCode": {field from table 1},
            "Unit": {field from table 1},
            "Description": {field from table 1},
            "IdentificationNumber": {field from table 1},
            "UnitPrice": {field from table 1}
            "Subtotal": {field from table 1},
            "Total": {field from table 1}
        }
    ]

,
“Complemento”: {
“CartaPorte20”: {
“TranspInternac”: “No”,
“Ubicaciones”: [
{
“TipoUbicacion”: “Origen”,
“IDUbicacion”: “OR101010”,
“RFCRemitenteDestinatario”: “EKU9003173C9”,
“FechaHoraSalidaLlegada”: “2021-11-24 12:00”,
“DistanciaRecorrida”: “1”,
“Domicilio”: {
“Pais”: “MEX”,
“CodigoPostal”: “78000”,
“Estado”: “SLP”,
“Municipio”: “028”,
“Localidad”: “05”,
“Colonia”: “0001”,
“Calle”: “calle”
}
},
{
“TipoUbicacion”: “Destino”,
“IDUbicacion”: “DE202020”,
“RFCRemitenteDestinatario”: “AAA010101AAA”,
“FechaHoraSalidaLlegada”: “2021-11-25 12:00”,
“TipoEstacion”: “Seleccionar”,
“DistanciaRecorrida”: “1”,
“Domicilio”: {
“Pais”: “MEX”,
“CodigoPostal”: “78000”,
“Estado”: “SLP”,
“Municipio”: “028”,
“Localidad”: “05”,
“Colonia”: “0001”,
“Calle”: “calle”
}
}
],

 "Mercancias": {
                "UnidadPeso": "KGM",
                "Mercancia": [
                    {
                        "Cantidad": {field from table 2},
                        "BienesTransp": {field from table 2},
                        "Descripcion": {field from table 2"},
                        "ClaveUnidad": {field from table 2},
                        "PesoEnKg": {field from table 2},
                        "ValorMercancia": {field from table 2},
                        "Moneda": {field from table 2},
                        "CantidadTransporta": [
                            {
                                "Cantidad": {field from table 2},
                                "IDOrigen": {field from table 2},
                                "IDDestino": {field from table 2}
                            }
                        ]
                    }
                ]

,
“Autotransporte”: {
“PermSCT”: “TPAF01”,
“NumPermisoSCT”: “NumPermisoSCT”,
“IdentificacionVehicular”: {
“ConfigVehicular”: “C2”,
“PlacaVM”: “plac892”,
“AnioModeloVM”: “2000”
},
“Seguros”: {
“AseguraRespCivil”: “SW Seguros”,
“PolizaRespCivil”: “SW Seguros”
}
}
},
“FiguraTransporte”: [
{
“TipoFigura”: “01”,
“RFCFigura”: “VAAM130719H60”,
“NombreFigura”: “Franciso Perez Lopez”,
“NumLicencia”: “a234567890”
}
]
}
}
}

1 Like

Hola Alexis, puedo ayudarte con esta consulta, ya lo tengo trabajando en mis aplicaciones para Costa Rica,

Es necesario utilizar “Pipes” de Tadabase para lograr esto, puedes escribirme a kruizf201@gmail.com para ayudarte a desarrollar esta solución