I am trying to get an XML then parse the json to populate a sharepoint list, But I am getting problems with the ones more that 1 line
{
"?xml": {
"@version": "1.0",
"@encoding": "UTF-8"
},
"cfdi:Comprobante": {
"@Version": "3.3",
"@Serie": "A",
"@Folio": "4542",
"@Fecha": "2021-12-16T10:13:43",
"@Sello": "e7wKQ2lrEoDvt/8PmCSZuyQ/ntsOhFV7R6onzUR/opcQaA6zsvJdmwQE0fojcaO8vizvQxPaCfn/n3KoSlRD00VkCBNT4FcWJQpc7V78OCmsnvO/BXyKSzTb2hzMydnLH70XSocTJK/5afYKd1ESIgqMv04upVHiqvR+CrIJdzWpQQmCuf/Gr3TlYNEhBaksDL+mF2FXUxD5XBXjXmcW5UskB6vgOejH4ZDuYQpcKwYvi1y6xyaCYYU9qW0Z32VIzE47kFnV3hTUYavGL9L3kVPIWzSgxPDEqdiO0cKdNRIHevGXfPkofyAVkQRlB2r3BOMucfpEDDVT/JAjaQnkBw==",
"@FormaPago": "99",
"@NoCertificado": "00001000000413533074",
"@Certificado": "MIIGBTCCA+2gAwIBAgIUMDAwMDEwMDAwMDA0MTM1MzMwNzQwDQYJKoZIhvcNAQELBQAwggGyMTgwNgYDVQQDDC9BLkMuIGRlbCBTZXJ2aWNpbyBkZSBBZG1pbmlzdHJhY2nDs24gVHJpYnV0YXJpYTEvMC0GA1UECgwmU2VydmljaW8gZGUgQWRtaW5pc3RyYWNpw7NuIFRyaWJ1dGFyaWExODA2BgNVBAsML0FkbWluaXN0cmFjacOzbiBkZSBTZWd1cmlkYWQgZGUgbGEgSW5mb3JtYWNpw7NuMR8wHQYJKoZIhvcNAQkBFhBhY29kc0BzYXQuZ29iLm14MSYwJAYDVQQJDB1Bdi4gSGlkYWxnbyA3NywgQ29sLiBHdWVycmVybzEOMAwGA1UEEQwFMDYzMDAxCzAJBgNVBAYTAk1YMRkwFwYDVQQIDBBEaXN0cml0byBGZWRlcmFsMRQwEgYDVQQHDAtDdWF1aHTDqW1vYzEVMBMGA1UELRMMU0FUOTcwNzAxTk4zMV0wWwYJKoZIhvcNAQkCDE5SZXNwb25zYWJsZTogQWRtaW5pc3RyYWNpw7NuIENlbnRyYWwgZGUgU2VydmljaW9zIFRyaWJ1dGFyaW9zIGFsIENvbnRyaWJ1eWVudGUwHhcNMTkwMjE1MDAxNDI0WhcNMjMwMjE1MDAxNDI0WjCBpTEeMBwGA1UEAxMVSkFWSUVSIFBPTkNFIE1BUlRJTkVaMR4wHAYDVQQpExVKQVZJRVIgUE9OQ0UgTUFSVElORVoxHjAcBgNVBAoTFUpBVklFUiBQT05DRSBNQVJUSU5FWjEWMBQGA1UELRMNUE9NSjY2MDMxMVNXMTEbMBkGA1UEBRMSUE9NSjY2MDMxMUhNTk5SVjA1MQ4wDAYDVQQLEwV1bmljYTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAIENCJSsu5ZZ5K7sjdbVV0DRJSlrxxZw/KdAVUNiUWa0JLn8rc4bgSzLlEkUVoqTfFyTCYnbfJL5oJckCrZ/uDYl9M6/kifSxVSgi2giDMuP3fyBDUIZzbtKaFAQGBH9OeOQa7alFpowdRM8iVt7MPPZJYoz6E4PHCduuN0RUiIdmgTe+TL+/PcfVeCgSERA0M9rXMB/edhI29wSyFitHuzDydH+H0hnHc9PCW5qeq9RaHIqs6jymWRbeg3FBvP87ski5nSR6tzIo06Bh92dtBD9jJDBGvxBrvRAGeulSCgAOpRWbiI7YMyet2uOsBdchzriu/k3nvWsyt2nMwao8RkCAwEAAaMdMBswDAYDVR0TAQH/BAIwADALBgNVHQ8EBAMCBsAwDQYJKoZIhvcNAQELBQADggIBAJFx5FAivDXVUR//kkCh2gTHQp00qS1aFTNP+6Vi4BtSVnKkdLO231UKpCbQhPsjRbkz2PakjBAMxf4gAfWCfrKhLFcgu4d8fYGJGeRfNiKhxpRbkCIGYTB8lSJqFYXTUf4MzPl+8hDwKVWRTxZcNgwB7/b7jXoMkpAu7ChVnVoOcqH8Uo5WqEjHIqtUeS47wZCIstS83+jTTf3UOWSL++x3r/+tn1v5g/lr8sbNmZoizdshyxgpIGu3MB9jZN2c6/TdSs3EsJLWN6Dqy4nMFo7Oe6/ulzTwITAT++gxCB5xaxXgyJ6SfVTCX4OgN23z+9K+ytWlOZglRZHWLLlqMD7NSUm6z+8IcdaC9FtTIOPtYmTj2S0mNhIG8WXEIxNwFbNyeuVnsqarSKpJp6FNdV6Wu+S7XG1rfkl0bbkswPxOV7VCE54DmW2mHh1cvbSD1P3siWTHyFkSJA7ihHGARFFE+IXhURVPCDTd5m5FVsW8qKXu/IfVYljO5i8y/w+H1pRv6xOA0vRi+xp3CPbms6BaImM+Q2yQFpbANUEGokToX0PYR0uRwgVV8P3zoqDyB9wMZdK/OqoLE7PzxP/+JCcg+XX1BZ56yv/ixdpiBE0UusYJ/T23o5HVSJIAtvKZcTkrGLDXmqq/ONsBvAalHP1AFS62JFhfoH27DG/Hsdp6",
"@SubTotal": "8694.10",
"@Moneda": "MXN",
"@TipoCambio": "1",
"@Total": "9737.40",
"@TipoDeComprobante": "I",
"@MetodoPago": "PPD",
"@LugarExpedicion": "80189",
"cfdi:Emisor": {
"@Rfc": "POMJ660311SW1",
"@Nombre": "JAVIER PONCE MARTINEZ",
"@RegimenFiscal": "612"
},
"cfdi:Receptor": {
"@Rfc": "RCA940729470",
"@Nombre": "RYDER CAPITAL, S. DE R.L. DE C.V.",
"@UsoCFDI": "G03"
},
"cfdi:Conceptos": {
"cfdi:Concepto": [
{
"@ClaveProdServ": "78101804",
"@NoIdentificacion": "12345-15",
"@Cantidad": "1.00",
"@ClaveUnidad": "E48",
"@Descripcion": "FLETE EN RUTA LOCAL CAMIONETA 1.5 TONELADAS",
"@ValorUnitario": "1722.00",
"@Importe": "1722.00",
"cfdi:Impuestos": {
"cfdi:Traslados": {
"cfdi:Traslado": {
"@Base": "1722.00",
"@Impuesto": "002",
"@TipoFactor": "Tasa",
"@TasaOCuota": "0.160000",
"@Importe": "275.52"
}
},
"cfdi:Retenciones": {
"cfdi:Retencion": {
"@Base": "1722.00",
"@Impuesto": "002",
"@TipoFactor": "Tasa",
"@TasaOCuota": "0.040000",
"@Importe": "68.88"
}
}
}
},
{
"@ClaveProdServ": "78101804",
"@NoIdentificacion": "12345-15",
"@Cantidad": "2.00",
"@ClaveUnidad": "E48",
"@Descripcion": "FLETE EN RUTA LOCAL CAMIONETA 3.5 TONELADAS",
"@ValorUnitario": "2198.55",
"@Importe": "4397.10",
"cfdi:Impuestos": {
"cfdi:Traslados": {
"cfdi:Traslado": {
"@Base": "4397.10",
"@Impuesto": "002",
"@TipoFactor": "Tasa",
"@TasaOCuota": "0.160000",
"@Importe": "703.54"
}
},
"cfdi:Retenciones": {
"cfdi:Retencion": {
"@Base": "4397.10",
"@Impuesto": "002",
"@TipoFactor": "Tasa",
"@TasaOCuota": "0.040000",
"@Importe": "175.88"
}
}
}
},
{
"@ClaveProdServ": "78101804",
"@NoIdentificacion": "12345-15",
"@Cantidad": "1.00",
"@ClaveUnidad": "E48",
"@Descripcion": "FLETE EN RUTA LOCAL RABON, CORRESPONDIENTE A HOJAS DE RUTA Nos. 3248, 3249, 3251, 3253",
"@ValorUnitario": "2575.00",
"@Importe": "2575.00",
"cfdi:Impuestos": {
"cfdi:Traslados": {
"cfdi:Traslado": {
"@Base": "2575.00",
"@Impuesto": "002",
"@TipoFactor": "Tasa",
"@TasaOCuota": "0.160000",
"@Importe": "412.00"
}
},
"cfdi:Retenciones": {
"cfdi:Retencion": {
"@Base": "2575.00",
"@Impuesto": "002",
"@TipoFactor": "Tasa",
"@TasaOCuota": "0.040000",
"@Importe": "103.00"
}
}
}
}
]
},
"cfdi:Impuestos": {
"@TotalImpuestosRetenidos": "347.76",
"@TotalImpuestosTrasladados": "1391.06",
"cfdi:Retenciones": {
"cfdi:Retencion": {
"@Impuesto": "002",
"@Importe": "347.76"
}
},
"cfdi:Traslados": {
"cfdi:Traslado": {
"@Impuesto": "002",
"@TipoFactor": "Tasa",
"@TasaOCuota": "0.160000",
"@Importe": "1391.06"
}
}
},
"cfdi:Complemento": {
"tfd:TimbreFiscalDigital": {
"@Version": "1.1",
"@UUID": "79185C0C-D8B1-481B-AEA8-148A81061E4A",
"@FechaTimbrado": "2021-12-16T11:13:44",
"@RfcProvCertif": "EEL961104G96",
"@SelloCFD": "e7wKQ2lrEoDvt/8PmCSZuyQ/ntsOhFV7R6onzUR/opcQaA6zsvJdmwQE0fojcaO8vizvQxPaCfn/n3KoSlRD00VkCBNT4FcWJQpc7V78OCmsnvO/BXyKSzTb2hzMydnLH70XSocTJK/5afYKd1ESIgqMv04upVHiqvR+CrIJdzWpQQmCuf/Gr3TlYNEhBaksDL+mF2FXUxD5XBXjXmcW5UskB6vgOejH4ZDuYQpcKwYvi1y6xyaCYYU9qW0Z32VIzE47kFnV3hTUYavGL9L3kVPIWzSgxPDEqdiO0cKdNRIHevGXfPkofyAVkQRlB2r3BOMucfpEDDVT/JAjaQnkBw==",
"@NoCertificadoSAT": "00001000000506194045",
"@SelloSAT": "SUjFfy54qumaaOvqgyGa2PK6iWm+2fq2ikW7JI9whtNCFMeQp0XHKjOeNDeBo6PDH4aJNupociLb1xkSrnC8LUlwHtbn512y5Rpc7dXhv+WE7WvWCJGO39K0c/NPUmsCL02heu3oezWeEmPwxw6NmAGGXO7q7GHuyVTz+c81gRJSs32oeIi3aDC9EWUt+/uLDvbCwzRxH0VTv4hOsrt3e3IYRbGQZWOpkt0q/5HHOcJuaPlH3iqjNtJbvA8Weoae7mdXheKrxPULmfRoPxV4RfHEvmIr1SayhtkPHMsjtryDm/CBB0jgkhG0BybcwUmpUL7gloFURdIp+AzpskKX8w=="
}
}
}
}
Schema
{
"type": "object",
"properties": {
"?xml": {
"type": "object",
"properties": {
"@version": {
"type": "string"
},
"@encoding": {
"type": "string"
}
}
},
"cfdi:Comprobante": {
"type": "object",
"properties": {
"cfdi:Emisor": {
"type": "object",
"properties": {
"@Rfc": {
"type": "string"
},
"@Nombre": {
"type": "string"
},
"@RegimenFiscal": {
"type": "string"
}
}
},
"cfdi:Receptor": {
"type": "object",
"properties": {
"@Rfc": {
"type": "string"
},
"@Nombre": {
"type": "string"
},
"@UsoCFDI": {
"type": "string"
}
}
},
"cfdi:Conceptos": {
"type": "object",
"properties": {
"cfdi:Concepto": {
"type": "object",
"properties": {
"cfdi:Impuestos": {
"type": "object",
"properties": {
"cfdi:Traslados": {
"type": "object",
"properties": {
"cfdi:Traslado": {
"type": "object",
"properties": {
"@Base": {
"type": "string"
},
"@Impuesto": {
"type": "string"
},
"@TipoFactor": {
"type": "string"
},
"@TasaOCuota": {
"type": "string"
},
"@Importe": {
"type": "string"
}
}
}
}
},
"cfdi:Retenciones": {
"type": "object",
"properties": {
"cfdi:Retencion": {
"type": "object",
"properties": {
"@Base": {
"type": "string"
},
"@Impuesto": {
"type": "string"
},
"@TipoFactor": {
"type": "string"
},
"@TasaOCuota": {
"type": "string"
},
"@Importe": {
"type": "string"
}
}
}
}
}
}
},
"@ClaveProdServ": {
"type": "string"
},
"@NoIdentificacion": {
"type": "string"
},
"@Cantidad": {
"type": "string"
},
"@ClaveUnidad": {
"type": "string"
},
"@Descripcion": {
"type": "string"
},
"@ValorUnitario": {
"type": "string"
},
"@Importe": {
"type": "string"
}
}
}
}
},
"cfdi:Impuestos": {
"type": "object",
"properties": {
"cfdi:Retenciones": {
"type": "object",
"properties": {
"cfdi:Retencion": {
"type": "object",
"properties": {
"@Impuesto": {
"type": "string"
},
"@Importe": {
"type": "string"
}
}
}
}
},
"cfdi:Traslados": {
"type": "object",
"properties": {
"cfdi:Traslado": {
"type": "object",
"properties": {
"@Impuesto": {
"type": "string"
},
"@TipoFactor": {
"type": "string"
},
"@TasaOCuota": {
"type": "string"
},
"@Importe": {
"type": "string"
}
}
}
}
},
"@TotalImpuestosRetenidos": {
"type": "string"
},
"@TotalImpuestosTrasladados": {
"type": "string"
}
}
},
"cfdi:Complemento": {
"type": "object",
"properties": {
"tfd:TimbreFiscalDigital": {
"type": "object",
"properties": {
"@xmlns:tfd": {
"type": "string"
},
"@xsi:schemaLocation": {
"type": "string"
},
"@Version": {
"type": "string"
},
"@UUID": {
"type": "string"
},
"@FechaTimbrado": {
"type": "string"
},
"@RfcProvCertif": {
"type": "string"
},
"@SelloCFD": {
"type": "string"
},
"@NoCertificadoSAT": {
"type": "string"
},
"@SelloSAT": {
"type": "string"
}
}
}
}
},
"@xmlns:xsi": {
"type": "string"
},
"@xsi:schemaLocation": {
"type": "string"
},
"@Version": {
"type": "string"
},
"@Serie": {
"type": "string"
},
"@Folio": {
"type": "string"
},
"@Fecha": {
"type": "string"
},
"@Sello": {
"type": "string"
},
"@FormaPago": {
"type": "string"
},
"@NoCertificado": {
"type": "string"
},
"@Certificado": {
"type": "string"
},
"@SubTotal": {
"type": "string"
},
"@Moneda": {
"type": "string"
},
"@TipoCambio": {
"type": "string"
},
"@Total": {
"type": "string"
},
"@TipoDeComprobante": {
"type": "string"
},
"@MetodoPago": {
"type": "string"
},
"@LugarExpedicion": {
"type": "string"
},
"@xmlns:cfdi": {
"type": "string"
}
}
}
}
}
Error Message
[
{
"message": "Invalid type. Expected Object but got Array.",
"lineNumber": 0,
"linePosition": 0,
"path": "cfdi:Comprobante.cfdi:Conceptos.cfdi:Concepto",
"schemaId": "#/properties/cfdi:Comprobante/properties/cfdi:Conceptos/properties/cfdi:Concepto",
"errorType": "type",
"childErrors": []
}
]