Read XML within XML

bessa_lucas · Tue, 25 Apr 2017 3:40 pm

Hello everyone,
I am communicating with an API that I return the XML within XML.

<RESPOSTA><REGISTROS><REGISTRO><CODIGO>17</CODIGO><CHAVE_ACESSO>31170410556925000177550030000000171000000172</CHAVE_ACESSO><XML><?xml version="1.0" encoding="UTF-8"?> 
 
<nfeProc versao="3.10" xmlns="http://www.portalfiscal.inf.br/nfe"><NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe versao="3.10" Id="NFe31170410556925000177550030000000171000000172"><ide><cUF>31</cUF><cNF>00000017</cNF><natOp>Venda de produção própria, efetuada fora do estab.</natOp><indPag>1</indPag><mod>55</mod><serie>3</serie><nNF>17</nNF><dhEmi>2017-04-19T14:52:45-03:00</dhEmi><tpNF>1</tpNF><idDest>1</idDest><cMunFG>3148004</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>2</cDV><tpAmb>2</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>1</indPres><procEmi>0</procEmi><verProc>vê 4.38.1</verProc></ide><emit><CNPJ>10556925000177</CNPJ><xNome>OBERS LTDA - EPP</xNome><xFant>OBERS SISTEMAS</xFant><enderEmit><xLgr>R OLEGARIO MACIEL</xLgr><nro>203</nro><xBairro>CENTRO</xBairro><cMun>3148004</cMun><xMun>Patos de Minas</xMun><UF>MG</UF><CEP>38700122</CEP><cPais>1058</cPais><xPais>Brasil</xPais><fone>3438183800</fone></enderEmit><IE>0011044140070</IE><CRT>3</CRT></emit><dest><CNPJ>10835058000109</CNPJ><xNome>NF-E EMITIDA EM AMBIENTE DE HOMOLOGACAO - SEM VALOR FISCAL</xNome><enderDest><xLgr>R ZINHO BUENO</xLgr><nro>760</nro><xBairro>CENTRO</xBairro><cMun>3141207</cMun><xMun>Matutina</xMun><UF>MG</UF><CEP>38870000</CEP><cPais>1058</cPais><xPais>Brasil</xPais><fone>3436741048</fone></enderDest><indIEDest>1</indIEDest><IE>0011773850016</IE></dest><det nItem="1"><prod><cProd>2</cProd><cEAN/><xProd>Café Extra Forte 500g</xProd><NCM>09012100</NCM><CFOP>5103</CFOP><uCom>PC</uCom><qCom>12.0000</qCom><vUnCom>7.1500</vUnCom><vProd>85.80</vProd><cEANTrib/><uTrib>PC</uTrib><qTrib>12.0000</qTrib><vUnTrib>7.1500</vUnTrib><indTot>1</indTot></prod><imposto><vTotTrib>18.11</vTotTrib><ICMS><ICMS20><orig>0</orig><CST>20</CST><modBC>3</modBC><pRedBC>61.11</pRedBC><vBC>33.37</vBC><pICMS>18.00</pICMS><vICMS>6.01</vICMS></ICMS20></ICMS><IPI><cSelo>0.00000</cSelo><cEnq>999</cEnq><IPINT><CST>51</CST></IPINT></IPI><PIS><PISNT><CST>06</CST></PISNT></PIS><COFINS><COFINSNT><CST>06</CST></COFINSNT></COFINS></imposto></det><det nItem="2"><prod><cProd>3</cProd><cEAN/><xProd>Café Extra Forte 250g</xProd><NCM>09012100</NCM><CFOP>5103</CFOP><uCom>PC</uCom><qCom>20.0000</qCom><vUnCom>3.6000</vUnCom><vProd>72.00</vProd><cEANTrib/><uTrib>PC</uTrib><qTrib>20.0000</qTrib><vUnTrib>3.6000</vUnTrib><indTot>1</indTot></prod><imposto><vTotTrib>15.20</vTotTrib><ICMS><ICMS20><orig>0</orig><CST>20</CST><modBC>3</modBC><pRedBC>61.11</pRedBC><vBC>28.00</vBC><pICMS>18.00</pICMS><vICMS>5.04</vICMS></ICMS20></ICMS><IPI><cSelo>0.00000</cSelo><cEnq>999</cEnq><IPINT><CST>51</CST></IPINT></IPI><PIS><PISNT><CST>06</CST></PISNT></PIS><COFINS><COFINSNT><CST>06</CST></COFINSNT></COFINS></imposto></det><total><ICMSTot><vBC>61.37</vBC><vICMS>11.05</vICMS><vICMSDeson>0.00</vICMSDeson><vBCST>0.00</vBCST><vST>0.00</vST><vProd>157.80</vProd><vFrete>0.00</vFrete><vSeg>0.00</vSeg><vDesc>0.00</vDesc><vII>0.00</vII><vIPI>0.00</vIPI><vPIS>0.00</vPIS><vCOFINS>0.00</vCOFINS><vOutro>0.00</vOutro><vNF>157.80</vNF><vTotTrib>33.31</vTotTrib></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><dup><nDup>1</nDup><dVenc>2017-05-19</dVenc><vDup>157.80</vDup></dup></cobr><infAdic><infCpl>Vendedor: LEANDRO;Número da Pronta entrega: 42;Condição de pagamento: 30 dias;Total dos tributos (lei 12.741/2012) - Federais: 33,31</infCpl></infAdic></infNFe><Signature xmlns="http://www.w3.org/2000/09/xmldsig#"><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><Reference URI="#NFe31170410556925000177550030000000171000000172"><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><Transform Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><DigestValue>jvHfRDAZb3LJw1mfLM57+hU6Tc0=</DigestValue></Reference></SignedInfo><SignatureValue>pNXlOA8ofZsb0EmfSGe1+vD98AQvN3Bl1l69qmgtPBNerHZdIciQeWr9WPu8KkCjKGA9uMhCFlWEDZrB75Cgd887P/YAVSDDbti2/XZ5fsIaO7Di6Jl/wcbHCdyEtOGm1qD/+L/f7jzzGrBPFc8Dx21LbD1siHg87b9MK7hvY/MainjMipry5T4ocONGnegR+U/NCdL771BHHZ9GHqi3XfBTf/TRKH9K+2iUwVn14HVSm0+FXFEywKkdxWGMm0D7shsbV678vpWagFP0Nj2IqvKP+e96JAA3PjhvwSjxpK1rB5w+LWb06krTe96j1tE1hgNTdt4fcaWJPiwNAhNV+Q==</SignatureValue><KeyInfo><X509Data><X509Certificate>MIIH5jCCBc6gAwIBAgIIbgpZgQMpIjUwDQYJKoZIhvcNAQELBQAwcDELMAkGA1UEBhMCQlIxEzARBgNVBAoTCklDUC1CcmFzaWwxNjA0BgNVBAsTLVNlY3JldGFyaWEgZGEgUmVjZWl0YSBGZWRlcmFsIGRvIEJyYXNpbCAtIFJGQjEUMBIGA1UEAxMLQUMgTElOSyBSRkIwHhcNMTcwNDA0MTg1MzE4WhcNMTgwNDA0MTg1MzE4WjCB1jELMAkGA1UEBhMCQlIxCzAJBgNVBAgTAk1HMRQwEgYDVQQHEwtTQU8gR09UQVJETzETMBEGA1UEChMKSUNQLUJyYXNpbDE2MDQGA1UECxMtU2VjcmV0YXJpYSBkYSBSZWNlaXRhIEZlZGVyYWwgZG8gQnJhc2lsIC0gUkZCMRYwFAYDVQQLEw1SRkIgZS1DTlBKIEExMRAwDgYDVQQLEwdBUiBMSU5LMS0wKwYDVQQDEyRDQUZFIFNBTyBHT1RBUkRPIExUREE6MTA1NTY5MjUwMDAxNzcwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCtzsqs3xZhCWkogY/eKy+NskUc5YsqCiuCzQUjmGoJDAEh19eoIzI88xq/lXqvEigGqrCCwFKkAi4QjPmB8iW7T5Y4vCqV2VugN6mJb9ZTS9a6aBQi9XwV8EhtrZOg1IOlYOhfwjc4fouCxN86qz7Zqtn2vo8w1qAL5QiV9lthIJCi/MQVb7fiVYDqrf83vm2EQYfl8EQm8dKCkeIE4eIdKzG+JfgYiwkJTmwqQOW4RbpeHdnCWl1z9mpxNOB4lFbf5e5RoqX+J8gsWKmLhAr+DItNahYSp8D/bW3ik2WnhqyYIs7bBVM6OhjL3isfhM9MxKuFnlCvDXE+E0GnmACZAgMBAAGjggMbMIIDFzAfBgNVHSMEGDAWgBRZjSwlbOHzHl26JiFegQkoZYXVqDAOBgNVHQ8BAf8EBAMCBeAwbgYDVR0gBGcwZTBjBgZgTAECATswWTBXBggrBgEFBQcCARZLaHR0cDovL3JlcG9zaXRvcmlvLmxpbmtjZXJ0aWZpY2FjYW8uY29tLmJyL2FjLWxpbmtyZmIvYWMtbGluay1yZmItcGMtYTEucGRmMIH5BgNVHR8EgfEwge4wUKBOoEyGSmh0dHA6Ly9yZXBvc2l0b3Jpby5saW5rY2VydGlmaWNhY2FvLmNvbS5ici9hYy1saW5rcmZiL2xjci1hYy1saW5rcmZidjIuY3JsMFGgT6BNhktodHRwOi8vcmVwb3NpdG9yaW8yLmxpbmtjZXJ0aWZpY2FjYW8uY29tLmJyL2FjLWxpbmtyZmIvbGNyLWFjLWxpbmtyZmJ2Mi5jcmwwR6BFoEOGQWh0dHA6Ly9yZXBvc2l0b3Jpby5pY3BicmFzaWwuZ292LmJyL2xjci9saW5rL2xjci1hYy1saW5rcmZidjIuY3JsMIGVBggrBgEFBQcBAQSBiDCBhTBSBggrBgEFBQcwAoZGaHR0cDovL3JlcG9zaXRvcmlvLmxpbmtjZXJ0aWZpY2FjYW8uY29tLmJyL2FjLWxpbmtyZmIvYWMtbGlua3JmYnYyLnA3YjAvBggrBgEFBQcwAYYjaHR0cDovL29jc3AubGlua2NlcnRpZmljYWNhby5jb20uYnIwgbUGA1UdEQSBrTCBqoEgRklOQU5DRUlST0BDQUZFU0FPR09UQVJETy5DT00uQlKgGAYFYEwBAwKgDxMNVEFUSUFOQSBLSVJZVaAZBgVgTAEDA6AQEw4xMDU1NjkyNTAwMDE3N6A4BgVgTAEDBKAvEy0wNTAyMTk4MjAxNDQwNzA3NjY5MDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDCgFwYFYEwBAwegDhMMMDAwMDAwMDAwMDAwMB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEFBQcDBDAJBgNVHRMEAjAAMA0GCSqGSIb3DQEBCwUAA4ICAQAJqn4XeLFGghvDYvPCA3zvjR/YNZ2f5COvhYxGjOatE1hNXhBwKquFAHib1oLJ4nMZGiVlHskN+sG4xVTAWkO46rZqadJjJd1+BUPebRKVN3msgtaYqqhzn8EoN4QU5ZEDEWppvx6CErW3jJIXyIIwRLtxPEoCGaczAfMoqsuDUWyLQbny3DoQVYK7f0QWVymtJn8AT74fNeOxQc7/19roql6Z39N3EK6gJrJb/tZm4pWoDs8B1ThcGv6iQ5tRT5KBvwtUJciIYP2QvWQbNswzv04QiZMztIJ/yz4VJzkN829rKAYA2YNlrsU9ovjIAEq2PiIYBvAGPDpJaEsgn1k3roJdaVqvS1DyjsiFKFWq47/+YZsz5NNwHlrz1qz6/qTb3r8yZjD4z8RtZYtbb+BvcVGfcXKBVs0RRqHNVnVEdfFv7DBO0De9EZBNiiAKKNEsj+qJLvK51HcyeFS9nzBJsWSUz9TuXfeNQTGR+z23Mxzdd//g0dyevKwzGxim4c2n2DiuOs9iKxf1GvhNYOLvlf8Qw2U6+I9u7d9p6yAj3tMjjMQMDBnIzXRGfuz9qJ5HNSQYvdtChdvOvbnAjMsurtULiNN0+o2LzVtNCejaqgz+tk7DrxfWKU+skLK9jk8QniltwB32Eai8tdFwLTeSEoPv7uKRGGL3EtYx/Fz3gQ==</X509Certificate></X509Data></KeyInfo></Signature></NFe><protNFe versao="3.10"><infProt><tpAmb>2</tpAmb><verAplic>14.0.25</verAplic><chNFe>31170410556925000177550030000000171000000172</chNFe><dhRecbto>2017-04-19T14:50:14-03:00</dhRecbto><nProt>131170128665595</nProt><digVal>jvHfRDAZb3LJw1mfLM57+hU6Tc0=</digVal><cStat>100</cStat><xMotivo>Autorizado o uso da NF-e</xMotivo></infProt></protNFe></nfeProc></XML></REGISTRO><REGISTRO><CODIGO>18</CODIGO><CHAVE_ACESSO>31170410556925000177550030000000181000000188</CHAVE_ACESSO><XML><?xml version="1.0" encoding="UTF-8"?> 
 
<nfeProc versao="3.10" xmlns="http://www.portalfiscal.inf.br/nfe"><NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe versao="3.10" Id="NFe31170410556925000177550030000000181000000188"><ide><cUF>31</cUF><cNF>00000018</cNF><natOp>Venda de produção própria, efetuada fora do estab.</natOp><indPag>1</indPag><mod>55</mod><serie>3</serie><nNF>18</nNF><dhEmi>2017-04-19T14:52:50-03:00</dhEmi><tpNF>1</tpNF><idDest>1</idDest><cMunFG>3148004</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>8</cDV><tpAmb>2</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>1</indPres><procEmi>0</procEmi><verProc>vê 4.38.1</verProc></ide><emit><CNPJ>10556925000177</CNPJ><xNome>OBERS LTDA - EPP</xNome><xFant>OBERS SISTEMAS</xFant><enderEmit><xLgr>R OLEGARIO MACIEL</xLgr><nro>203</nro><xBairro>CENTRO</xBairro><cMun>3148004</cMun><xMun>Patos de Minas</xMun><UF>MG</UF><CEP>38700122</CEP><cPais>1058</cPais><xPais>Brasil</xPais><fone>3438183800</fone></enderEmit><IE>0011044140070</IE><CRT>3</CRT></emit><dest><CNPJ>71393490000181</CNPJ><xNome>NF-E EMITIDA EM AMBIENTE DE HOMOLOGACAO - SEM VALOR FISCAL</xNome><enderDest><xLgr>R MAJOR OLIMPIO FRANCO</xLgr><nro>187</nro><xBairro>CENTRO</xBairro><cMun>3141207</cMun><xMun>Matutina</xMun><UF>MG</UF><CEP>38870000</CEP><cPais>1058</cPais><xPais>Brasil</xPais><fone>3436741194</fone></enderDest><indIEDest>1</indIEDest><IE>4128633270053</IE></dest><det nItem="1"><prod><cProd>3</cProd><cEAN/><xProd>Café Extra Forte 250g</xProd><NCM>09012100</NCM><CFOP>5103</CFOP><uCom>PC</uCom><qCom>12.0000</qCom><vUnCom>3.6300</vUnCom><vProd>43.56</vProd><cEANTrib/><uTrib>PC</uTrib><qTrib>12.0000</qTrib><vUnTrib>3.6300</vUnTrib><indTot>1</indTot></prod><imposto><vTotTrib>9.20</vTotTrib><ICMS><ICMS20><orig>0</orig><CST>20</CST><modBC>3</modBC><pRedBC>61.11</pRedBC><vBC>16.94</vBC><pICMS>18.00</pICMS><vICMS>3.05</vICMS></ICMS20></ICMS><IPI><cSelo>0.00000</cSelo><cEnq>999</cEnq><IPINT><CST>51</CST></IPINT></IPI><PIS><PISNT><CST>06</CST></PISNT></PIS><COFINS><COFINSNT><CST>06</CST></COFINSNT></COFINS></imposto></det><det nItem="2"><prod><cProd>2</cProd><cEAN/><xProd>Café Extra Forte 500g</xProd><NCM>09012100</NCM><CFOP>5103</CFOP><uCom>PC</uCom><qCom>4.0000</qCom><vUnCom>7.1500</vUnCom><vProd>28.60</vProd><cEANTrib/><uTrib>PC</uTrib><qTrib>4.0000</qTrib><vUnTrib>7.1500</vUnTrib><indTot>1</indTot></prod><imposto><vTotTrib>6.04</vTotTrib><ICMS><ICMS20><orig>0</orig><CST>20</CST><modBC>3</modBC><pRedBC>61.11</pRedBC><vBC>11.12</vBC><pICMS>18.00</pICMS><vICMS>2.00</vICMS></ICMS20></ICMS><IPI><cSelo>0.00000</cSelo><cEnq>999</cEnq><IPINT><CST>51</CST></IPINT></IPI><PIS><PISNT><CST>06</CST></PISNT></PIS><COFINS><COFINSNT><CST>06</CST></COFINSNT></COFINS></imposto></det><total><ICMSTot><vBC>28.06</vBC><vICMS>5.05</vICMS><vICMSDeson>0.00</vICMSDeson><vBCST>0.00</vBCST><vST>0.00</vST><vProd>72.16</vProd><vFrete>0.00</vFrete><vSeg>0.00</vSeg><vDesc>0.00</vDesc><vII>0.00</vII><vIPI>0.00</vIPI><vPIS>0.00</vPIS><vCOFINS>0.00</vCOFINS><vOutro>0.00</vOutro><vNF>72.16</vNF><vTotTrib>15.24</vTotTrib></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><dup><nDup>1</nDup><dVenc>2017-05-19</dVenc><vDup>72.16</vDup></dup></cobr><infAdic><infCpl>Vendedor: Lucas;Número da Pronta entrega: 43;Condição de pagamento: 30 dias;Total dos tributos (lei 12.741/2012) - Federais: 15,24</infCpl></infAdic></infNFe><Signature xmlns="http://www.w3.org/2000/09/xmldsig#"><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><Reference URI="#NFe31170410556925000177550030000000181000000188"><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><Transform Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><DigestValue>lhjfW9aNGl8Op16WVNmwICRjvnU=</DigestValue></Reference></SignedInfo><SignatureValue>ThEj+6ixOu4xbvAq3LF0Rc1s/5zfgUJQ8hcUvfjnwoE02Wt5tCG/dYk5gjtPnNL59NDwPwlOTte6sXudDd2wHovofAhGvcbQ91dTlf+JPSCL0Ra9H5IeobjxAqqN2k2FS/iwTHiDITyDwES6QkJ+jQqZJQ/BUK5+cCTmUC2nehUZt1T2NC0E3d6+/jkozffN6hXLLtaGXY/vMjanWr7x6r6CJZcsXPxmeJ8nc2JJ9VZswWRU6B38TbXe4OSL9TNl/hR+nmWwuybC5Q4TuADE1HtFAvScSGG5sxbW826zpLT3JM2CzliduKnJA+/+hkNbi75SEpqOCpWnObjfWyAacw==</SignatureValue><KeyInfo><X509Data><X509Certificate>MIIH5jCCBc6gAwIBAgIIbgpZgQMpIjUwDQYJKoZIhvcNAQELBQAwcDELMAkGA1UEBhMCQlIxEzARBgNVBAoTCklDUC1CcmFzaWwxNjA0BgNVBAsTLVNlY3JldGFyaWEgZGEgUmVjZWl0YSBGZWRlcmFsIGRvIEJyYXNpbCAtIFJGQjEUMBIGA1UEAxMLQUMgTElOSyBSRkIwHhcNMTcwNDA0MTg1MzE4WhcNMTgwNDA0MTg1MzE4WjCB1jELMAkGA1UEBhMCQlIxCzAJBgNVBAgTAk1HMRQwEgYDVQQHEwtTQU8gR09UQVJETzETMBEGA1UEChMKSUNQLUJyYXNpbDE2MDQGA1UECxMtU2VjcmV0YXJpYSBkYSBSZWNlaXRhIEZlZGVyYWwgZG8gQnJhc2lsIC0gUkZCMRYwFAYDVQQLEw1SRkIgZS1DTlBKIEExMRAwDgYDVQQLEwdBUiBMSU5LMS0wKwYDVQQDEyRDQUZFIFNBTyBHT1RBUkRPIExUREE6MTA1NTY5MjUwMDAxNzcwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCtzsqs3xZhCWkogY/eKy+NskUc5YsqCiuCzQUjmGoJDAEh19eoIzI88xq/lXqvEigGqrCCwFKkAi4QjPmB8iW7T5Y4vCqV2VugN6mJb9ZTS9a6aBQi9XwV8EhtrZOg1IOlYOhfwjc4fouCxN86qz7Zqtn2vo8w1qAL5QiV9lthIJCi/MQVb7fiVYDqrf83vm2EQYfl8EQm8dKCkeIE4eIdKzG+JfgYiwkJTmwqQOW4RbpeHdnCWl1z9mpxNOB4lFbf5e5RoqX+J8gsWKmLhAr+DItNahYSp8D/bW3ik2WnhqyYIs7bBVM6OhjL3isfhM9MxKuFnlCvDXE+E0GnmACZAgMBAAGjggMbMIIDFzAfBgNVHSMEGDAWgBRZjSwlbOHzHl26JiFegQkoZYXVqDAOBgNVHQ8BAf8EBAMCBeAwbgYDVR0gBGcwZTBjBgZgTAECATswWTBXBggrBgEFBQcCARZLaHR0cDovL3JlcG9zaXRvcmlvLmxpbmtjZXJ0aWZpY2FjYW8uY29tLmJyL2FjLWxpbmtyZmIvYWMtbGluay1yZmItcGMtYTEucGRmMIH5BgNVHR8EgfEwge4wUKBOoEyGSmh0dHA6Ly9yZXBvc2l0b3Jpby5saW5rY2VydGlmaWNhY2FvLmNvbS5ici9hYy1saW5rcmZiL2xjci1hYy1saW5rcmZidjIuY3JsMFGgT6BNhktodHRwOi8vcmVwb3NpdG9yaW8yLmxpbmtjZXJ0aWZpY2FjYW8uY29tLmJyL2FjLWxpbmtyZmIvbGNyLWFjLWxpbmtyZmJ2Mi5jcmwwR6BFoEOGQWh0dHA6Ly9yZXBvc2l0b3Jpby5pY3BicmFzaWwuZ292LmJyL2xjci9saW5rL2xjci1hYy1saW5rcmZidjIuY3JsMIGVBggrBgEFBQcBAQSBiDCBhTBSBggrBgEFBQcwAoZGaHR0cDovL3JlcG9zaXRvcmlvLmxpbmtjZXJ0aWZpY2FjYW8uY29tLmJyL2FjLWxpbmtyZmIvYWMtbGlua3JmYnYyLnA3YjAvBggrBgEFBQcwAYYjaHR0cDovL29jc3AubGlua2NlcnRpZmljYWNhby5jb20uYnIwgbUGA1UdEQSBrTCBqoEgRklOQU5DRUlST0BDQUZFU0FPR09UQVJETy5DT00uQlKgGAYFYEwBAwKgDxMNVEFUSUFOQSBLSVJZVaAZBgVgTAEDA6AQEw4xMDU1NjkyNTAwMDE3N6A4BgVgTAEDBKAvEy0wNTAyMTk4MjAxNDQwNzA3NjY5MDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDCgFwYFYEwBAwegDhMMMDAwMDAwMDAwMDAwMB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEFBQcDBDAJBgNVHRMEAjAAMA0GCSqGSIb3DQEBCwUAA4ICAQAJqn4XeLFGghvDYvPCA3zvjR/YNZ2f5COvhYxGjOatE1hNXhBwKquFAHib1oLJ4nMZGiVlHskN+sG4xVTAWkO46rZqadJjJd1+BUPebRKVN3msgtaYqqhzn8EoN4QU5ZEDEWppvx6CErW3jJIXyIIwRLtxPEoCGaczAfMoqsuDUWyLQbny3DoQVYK7f0QWVymtJn8AT74fNeOxQc7/19roql6Z39N3EK6gJrJb/tZm4pWoDs8B1ThcGv6iQ5tRT5KBvwtUJciIYP2QvWQbNswzv04QiZMztIJ/yz4VJzkN829rKAYA2YNlrsU9ovjIAEq2PiIYBvAGPDpJaEsgn1k3roJdaVqvS1DyjsiFKFWq47/+YZsz5NNwHlrz1qz6/qTb3r8yZjD4z8RtZYtbb+BvcVGfcXKBVs0RRqHNVnVEdfFv7DBO0De9EZBNiiAKKNEsj+qJLvK51HcyeFS9nzBJsWSUz9TuXfeNQTGR+z23Mxzdd//g0dyevKwzGxim4c2n2DiuOs9iKxf1GvhNYOLvlf8Qw2U6+I9u7d9p6yAj3tMjjMQMDBnIzXRGfuz9qJ5HNSQYvdtChdvOvbnAjMsurtULiNN0+o2LzVtNCejaqgz+tk7DrxfWKU+skLK9jk8QniltwB32Eai8tdFwLTeSEoPv7uKRGGL3EtYx/Fz3gQ==</X509Certificate></X509Data></KeyInfo></Signature></NFe><protNFe versao="3.10"><infProt><tpAmb>2</tpAmb><verAplic>14.0.25</verAplic><chNFe>31170410556925000177550030000000181000000188</chNFe><dhRecbto>2017-04-19T14:50:14-03:00</dhRecbto><nProt>131170128665596</nProt><digVal>lhjfW9aNGl8Op16WVNmwICRjvnU=</digVal><cStat>100</cStat><xMotivo>Autorizado o uso da NF-e</xMotivo></infProt></protNFe></nfeProc></XML></REGISTRO><REGISTRO/></REGISTROS></RESPOSTA>

The problem is that in the API documentation, the XML is string type, and I wanted to return to CLOB.

I have tried in many ways, but without success.
When you arrive at "For", I receive the following message

ORA-01706: The value of the result of the user's role was too great
ORA-06512: in "obers.pkg_integrace_vendasexternas", line 2588
ORA-06512: In line 6

Select all

     -- GERA O XML DO RETORNO 
    doc := xmltype.createxml(envelope); 
     
    -- ABRE O CURSOR PARA VERIFICAR QUANTIDADE DE CODIGOS RETORNADOS 
    declare cursor listar_nfe 
      is 
       
    -- EXTRAI O VALOR DA TAG 
      select 
            extractvalue(VALUE(TAB_ID),'/REGISTRO/CODIGO')           id_nota_fiscal, 
            extractvalue(VALUE(TAB_ID),'/REGISTRO/CHAVE_ACESSO') x_chave, 
            --xmltype.createxml(extractvalue(VALUE(TAB_ID),'/REGISTRO/XML'))           x_xml, 
            --char_to_clob(extractvalue(VALUE(TAB_ID),'/REGISTRO/XML'))           x_xml 
            --extractvalue(VALUE(TAB_ID).getclobval(),'/REGISTRO/CHAVE_ACESSO') x_xml 
            --xmltype(envelope.xml).extract('//REGISTRO/XML/text()').getStringVal() 
             
            EXTRACTVALUE(xmltype(doc), '/REGISTRO/XML')  
           
             
            --extractvalue(value(tab_id), '/REGISTRO/XML/text()') x_xml 
            --xmltype(t.xml).extract('//fax/text()').getStringVal() from mytab t 
            --envelope.xmlval.extract('/REGISTRO/XML/text()').getClobVal() 
            --SELECT REMOVE_ESPACOS_TAG(XCTECABECMSG.EXTRACT ('/*').GETCLOBVAL ()) INTO XCTECABECMSGCLOB FROM DUAL; 
            --extractvalue(VALUE(TAB_ID),'/REGISTRO/XML') X_XML, 
             
            --extractValue(doc,'/RESPOSTA/MESSAGE')                    ds_mensagem 
        from 
            TABLE(XMLSequence(extract(doc,'/RESPOSTA/REGISTROS/REGISTRO'))) TAB_ID; 
 
    BEGIN 
      FOR REC IN listar_nfe 
        LOOP 
          BEGIN 
             
            arquivo := UTL_File.Fopen( 'DFE_DOWNLOAD', rec.x_chave||'-procNFe.xml' ,'w',32767); 
 
              
            --texto := rec.x_xml.getclobval(); 
            texto := rec.x_xml; 
             
         
            UTL_FILE.put_line ( arquivo, texto); 
            UTL_File.Fclose(arquivo); 
          END; 
        END LOOP; 
    END; 
   
  END;

Wed, 26 Apr 2017 6:17 pm

I searched for error or-01706 and I found the following [url=http://stackoverflow.com/questions/1378 ... ting-nodes]dica
https://forums.oracle.com/forums/messag ... 2#10736122

for version as of 11.2.0.2, can use

Select all

SELECT x.* 
FROM test_xml t 
   , XMLTable( 
       '/*/record' 
       passing t.xml_data 
       columns 
         test_3  clob path 'test_3' 
     ) x 
;

Select all

Mas para versão mais antiga, (10, por exemplo), aí se usa o getClobVal. 
SELECT dbms_xmlgen.convert(x.test_3.getClobVal(), 1) as test_3 
FROM test_xml t 
   , XMLTable( 
       '/*/record' 
       passing t.xml_data 
       columns 
         test_3  xmltype path 'test_3/text()' 
     ) x 
;

I hope this helps. If you got it, send the solution to us, "

dcp · Wed, 20 Sep 2017 9:16 am

Good morning,
I have a little doubt.
I have an XML here, but I can not return the value of the IPI <VIPI>, someone could help me. I do not know if it's because his value is 0.0, but I tested to change to another column for ex; '<CST>' which is on the same level as the node.

Select all

 
select Extractvalue(VALUE(xmlNFE),'/det/imposto/IPI/IPITtrib/vIPI','xmlns="http://www.portalfiscal.inf.br/nfe"') vIPI 
 from xml_nfe x, 
             TABle(XMLSequence(extract(x.xml_xmltype, 
                                       'nfeProc/NFe/infNFe/det', 
                                       'xmlns="http://www.portalfiscal.inf.br/nfe"'))) xmlNFE

Below the XML

Select all

<?xml version="1.0" encoding="UTF-8"?> 
<nfeProc versao="3.10" xmlns="http://www.portalfiscal.inf.br/nfe"> 
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"> 
<infNFe versao="3.10" Id="NFe35170304823980000183550010000349811009051927"> 
<ide> 
<emit> 
<dest> 
<det nItem="1"> 
<prod> 
<imposto> 
<ICMS> 
<IPI> 
<cEnq>999</cEnq> 
<IPITrib> 
<CST>99</CST> 
<vBC>0.00</vBC> 
<pIPI>0.00</pIPI> 
<vIPI>0.00</vIPI> 
</IPITrib> 
</IPI> 
<PIS> 
<COFINS> 
</imposto> 
</det> 
<det nItem="2"> 
<det nItem="3"> 
<det nItem="4"> 
<det nItem="5"> 
<det nItem="6"> 
<det nItem="7"> 
<total> 
<transp> 
<cobr> 
<infAdic> 
<compra/> 
</infNFe> 
<Signature xmlns="http://www.w3.org/2000/09/xmldsig#"> 
</NFe> 
<protNFe versao="3.10"> 
</nfeProc>

dcp · Wed, 20 Sep 2017 9:19 am

See:

DCP wrote: Good morning,
I have a little doubt.
I have an XML here, but I can not return the value of the IPI <VIPI>, someone could help me. I do not know if it's because his value is 0.0, but I tested to change to another column for ex; '<CST>' that stands at the same level of the node and also did not return anything.

Select all

 
select Extractvalue(VALUE(xmlNFE),'/det/imposto/IPI/IPITtrib/vIPI','xmlns="http://www.portalfiscal.inf.br/nfe"') vIPI 
 from xml_nfe x, 
             TABle(XMLSequence(extract(x.xml_xmltype, 
                                       'nfeProc/NFe/infNFe/det', 
                                       'xmlns="http://www.portalfiscal.inf.br/nfe"'))) xmlNFE

Below the XML

Select all

<?xml version="1.0" encoding="UTF-8"?> 
<nfeProc versao="3.10" xmlns="http://www.portalfiscal.inf.br/nfe"> 
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"> 
<infNFe versao="3.10" Id="NFe35170304823980000183550010000349811009051927"> 
<ide> 
<emit> 
<dest> 
<det nItem="1"> 
<prod> 
<imposto> 
<ICMS> 
<IPI> 
<cEnq>999</cEnq> 
<IPITrib> 
<CST>99</CST> 
<vBC>0.00</vBC> 
<pIPI>0.00</pIPI> 
<vIPI>0.00</vIPI> 
</IPITrib> 
</IPI> 
<PIS> 
<COFINS> 
</imposto> 
</det> 
<det nItem="2"> 
<det nItem="3"> 
<det nItem="4"> 
<det nItem="5"> 
<det nItem="6"> 
<det nItem="7"> 
<total> 
<transp> 
<cobr> 
<infAdic> 
<compra/> 
</infNFe> 
<Signature xmlns="http://www.w3.org/2000/09/xmldsig#"> 
</NFe> 
<protNFe versao="3.10"> 
</nfeProc>

/ quote]

spernega · Wed, 20 Sep 2017 3:07 pm

Good afternoon DCP,

I took a test here.

Select all

/det/imposto/IPI/IPITtrib/vIPI',

I think there is one more for this so does not return anything, it is with osale did not find the way.

Select all

/det/imposto/IPI/IPITrib/vIPI',

dcp · Fri, 22 Sep 2017 11:23 am

Thank you very much.

Really a more T: Roll:
Hugs

dcp · Tue, 04 Sep 2018 9:36 am

Good morning Personal: LOL:

I have a problem in a query of an XML already imported into my database below I'll show you what you do.

Select all

   
  Select distinct x.xml_nfe_id,  
           Extractvalue(VALUE(xmlNFE),'//cProd') cprod, 
           Extractvalue(VALUE(xmlNFE),'//cEAN') cEAN, 
           Extractvalue(VALUE(xmlNFE),'//xProd') xprod, 
           Extractvalue(VALUE(xmlNFE),'//NCM') NCM, 
 
           --lote(med) 
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/nLote','xmlns="http://www.portalfiscal.inf.br/nfe"') nLote, 
           Nvl(Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/qLote','xmlns="http://www.portalfiscal.inf.br/nfe"'),  
           Extractvalue(VALUE(xmlNFE),'//qCom'))qLote, 
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/dFab','xmlns="http://www.portalfiscal.inf.br/nfe"') dFab, 
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/dVal','xmlns="http://www.portalfiscal.inf.br/nfe"') dVal, 
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/vPMC','xmlns="http://www.portalfiscal.inf.br/nfe"') vPMC, 
               
      from xml_nfe x, 
           TABle(XMLSequence(EXTRACT(x.xml_xmltype, 
                                     'nfeProc/NFe/infNFe/det', 
                                     'xmlns="http://www.portalfiscal.inf.br/nfe"'))) xmlNFE 
                                     
     where x.xml_nfe_id = 16

Here I have an XML that has 7 products, I have a product that has 2 different lots, the problem is this !!
I was able to bring the 2 batches, but the same comes in the same record according to the code below

Select all

   
         --lote(med) 
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/nLote','xmlns="http://www.portalfiscal.inf.br/nfe"') nLote, 
           Nvl(Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/qLote','xmlns="http://www.portalfiscal.inf.br/nfe"'),  
           Extractvalue(VALUE(xmlNFE),'//qCom'))qLote, 
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/dFab','xmlns="http://www.portalfiscal.inf.br/nfe"') dFab, 
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/dVal','xmlns="http://www.portalfiscal.inf.br/nfe"') dVal, 
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/vPMC','xmlns="http://www.portalfiscal.inf.br/nfe"') vPMC,

I need to make a break to make the other lot appear on a different record, I will show the return and product in which it has 2 batches:!:.

Select all

EX: 4	16	000000000000642276	00382906422767	ANTICORPO ANTI-HLA-DR V450 100 T RUO/GMP	30021229	80398598065767	1.0001.000	2018-02-082018-03-06	2019-11-302019-11-30	0.000.00

I have already used the following statement below, separating the batch of XmlNFE but so it generates Cartesian: Cry :

Select all

 
from xml_nfe x, 
             TABle(XMLSequence(extract(x.xml_xmltype, 
                                       'nfeProc/NFe/infNFe/det', 
                                       'xmlns="http://www.portalfiscal.inf.br/nfe"'))) xmlNFE, 
             TABle(XMLSequence(EXTRACTVALUE(x.xml_xmltype, 
                                       'nfeProc/NFe/infNFe/det/prod', 
                                       'xmlns="http://www.portalfiscal.inf.br/nfe"')))  lote

Here is my XML in which I have a problem Detail for the <DET NITEM = "6"> What has two <nlote>

Select all

 
<?xml version="1.0"?> 
<nfeProc xmlns="http://www.portalfiscal.inf.br/nfe" versao="3.10"> 
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"> 
<infNFe versao="3.10" Id="NFe42180521551379002141550070000439241833120732"> 
<ide> 
<emit> 
<dest> 
<entrega> 
<det nItem="1"> 
<prod> 
<cProd>000000000000340364</cProd> 
<cEAN>00382903403646</cEAN> 
<xProd>ANTICORPO CD19 PE SJ25C1 50 T RUO/GMP</xProd> 
<NCM>30021229</NCM> 
<CFOP>6108</CFOP> 
<uCom>UN</uCom> 
<qCom>1.0000</qCom> 
<vUnCom>1218.3000000000</vUnCom> 
<vProd>1218.30</vProd> 
<cEANTrib>382903403646</cEANTrib> 
<uTrib>UN</uTrib> 
<qTrib>1.0000</qTrib> 
<vUnTrib>1218.3000000000</vUnTrib> 
<indTot>1</indTot> 
<xPed>1-18935</xPed> 
<med> 
<nLote>7276698</nLote> 
<qLote>1.000</qLote> 
<dFab>2017-10-03</dFab> 
<dVal>2019-08-31</dVal> 
<vPMC>0.00</vPMC> 
</med> 
</prod> 
<imposto> 
<infAdProd>L./Q. 7276698 / 1.000 - 20190831</infAdProd> 
</det> 
<det nItem="2"> 
<prod> 
<cProd>000000000000347344</cProd> 
<cEAN>00382903473441</cEAN> 
<xProd>ANTICORPO CD3 PERCP SK7 100 T RUO/GMP</xProd> 
<NCM>30021229</NCM> 
<CFOP>6108</CFOP> 
<uCom>UN</uCom> 
<qCom>1.0000</qCom> 
<vUnCom>2586.3300000000</vUnCom> 
<vProd>2586.33</vProd> 
<cEANTrib>382903473441</cEANTrib> 
<uTrib>UN</uTrib> 
<qTrib>1.0000</qTrib> 
<vUnTrib>2586.3300000000</vUnTrib> 
<indTot>1</indTot> 
<xPed>1-18935</xPed> 
<med> 
<nLote>8017907</nLote> 
<qLote>1.000</qLote> 
<dFab>2018-01-17</dFab> 
<dVal>2019-09-30</dVal> 
<vPMC>0.00</vPMC> 
</med> 
</prod> 
<imposto> 
<infAdProd>L./Q. 8017907 / 1.000 - 20190930</infAdProd> 
</det> 
<det nItem="3"> 
<prod> 
<cProd>000000000000347747</cProd> 
<cEAN>00382903477470</cEAN> 
<xProd>ANTICORPO CD56 PE MY31 100 T RUO/GMP</xProd> 
<NCM>30021229</NCM> 
<CFOP>6108</CFOP> 
<uCom>UN</uCom> 
<qCom>1.0000</qCom> 
<vUnCom>2074.8300000000</vUnCom> 
<vProd>2074.83</vProd> 
<cEANTrib>382903477470</cEANTrib> 
<uTrib>UN</uTrib> 
<qTrib>1.0000</qTrib> 
<vUnTrib>2074.8300000000</vUnTrib> 
<indTot>1</indTot> 
<xPed>1-18935</xPed> 
<med> 
<nLote>8051660</nLote> 
<qLote>1.000</qLote> 
<dFab>2018-02-20</dFab> 
<dVal>2020-01-31</dVal> 
<vPMC>0.00</vPMC> 
</med> 
</prod> 
<imposto> 
<infAdProd>L./Q. 8051660 / 1.000 - 20200131</infAdProd> 
</det> 
<det nItem="4"> 
<prod> 
<cProd>000000000000554657</cProd> 
<cEAN>00382905546570</cEAN> 
<xProd>TAMPAO PHARMINGEN STAIN BSA 500ML</xProd> 
<NCM>38220090</NCM> 
<CFOP>6108</CFOP> 
<uCom>UN</uCom> 
<qCom>5.0000</qCom> 
<vUnCom>500.3400000000</vUnCom> 
<vProd>2501.70</vProd> 
<cEANTrib>382905546570</cEANTrib> 
<uTrib>UN</uTrib> 
<qTrib>5.0000</qTrib> 
<vUnTrib>500.3400000000</vUnTrib> 
<indTot>1</indTot> 
<xPed>1-18935</xPed> 
<med> 
<nLote>7342525</nLote> 
<qLote>5.000</qLote> 
<dFab>2017-12-08</dFab> 
<dVal>2019-12-25</dVal> 
<vPMC>0.00</vPMC> 
</med> 
</prod> 
<imposto> 
<infAdProd>L./Q. 7342525 / 5.000 - 20191225</infAdProd> 
</det> 
<det nItem="5"> 
<prod> 
<cProd>000000000000344563</cProd> 
<cEAN>00382903445639</cEAN> 
<xProd>ANTICORPO STEM CELL ENUMERATION KIT 50 T</xProd> 
<NCM>30021229</NCM> 
<CFOP>6108</CFOP> 
<uCom>UN</uCom> 
<qCom>1.0000</qCom> 
<vUnCom>2868.0000000000</vUnCom> 
<vProd>2868.00</vProd> 
<cEANTrib>382903445639</cEANTrib> 
<uTrib>UN</uTrib> 
<qTrib>1.0000</qTrib> 
<vUnTrib>2868.0000000000</vUnTrib> 
<indTot>1</indTot> 
<xPed>1-18935</xPed> 
<med> 
<nLote>7296964</nLote> 
<qLote>1.000</qLote> 
<dFab>2017-10-23</dFab> 
<dVal>2019-09-30</dVal> 
<vPMC>0.00</vPMC> 
</med> 
</prod> 
<imposto> 
<infAdProd>L./Q. 7296964 / 1.000 - 20190930</infAdProd> 
</det> 
<det nItem="6"> 
<prod> 
<cProd>000000000000642276</cProd> 
<cEAN>00382906422767</cEAN> 
<xProd>ANTICORPO ANTI-HLA-DR V450 100 T RUO/GMP</xProd> 
<NCM>30021229</NCM> 
<CFOP>6108</CFOP> 
<uCom>UN</uCom> 
<qCom>2.0000</qCom> 
<vUnCom>2205.0300000000</vUnCom> 
<vProd>4410.06</vProd> 
<cEANTrib>382906422767</cEANTrib> 
<uTrib>UN</uTrib> 
<qTrib>2.0000</qTrib> 
<vUnTrib>2205.0300000000</vUnTrib> 
<indTot>1</indTot> 
<xPed>1-18935</xPed> 
<med> 
<nLote>8039859</nLote> 
<qLote>1.000</qLote> 
<dFab>2018-02-08</dFab> 
<dVal>2019-11-30</dVal> 
<vPMC>0.00</vPMC> 
</med> 
<med> 
<nLote>8065767</nLote> 
<qLote>1.000</qLote> 
<dFab>2018-03-06</dFab> 
<dVal>2019-11-30</dVal> 
<vPMC>0.00</vPMC> 
</med> 
</prod> 
<imposto> 
<infAdProd>L./Q. 8039859 / 1.000 - 20191130 L./Q. 8065767 / 1.000 - 20191130</infAdProd> 
</det> 
<det nItem="7"> 
<prod> 
<cProd>000000000000551478</cProd> 
<cEAN>00382905514784</cEAN> 
<xProd>HU ANTI-CD66C PE MAB 100TST B6.2/CD66</xProd> 
<NCM>30021229</NCM> 
<CFOP>6108</CFOP> 
<uCom>UN</uCom> 
<qCom>1.0000</qCom> 
<vUnCom>1395.9300000000</vUnCom> 
<vProd>1395.93</vProd> 
<cEANTrib>382905514784</cEANTrib> 
<uTrib>UN</uTrib> 
<qTrib>1.0000</qTrib> 
<vUnTrib>1395.9300000000</vUnTrib> 
<indTot>1</indTot> 
<xPed>1-18935</xPed> 
<med> 
<nLote>7306645</nLote> 
<qLote>1.000</qLote> 
<dFab>2017-11-02</dFab> 
<dVal>2022-12-31</dVal> 
<vPMC>0.00</vPMC> 
</med> 
</prod> 
<imposto> 
<infAdProd>L./Q. 7306645 / 1.000 - 20221231</infAdProd> 
</det> 
<total> 
<transp> 
<cobr> 
<infAdic> 
</infNFe> 
<Signature xmlns="http://www.w3.org/2000/09/xmldsig#"> 
</NFe> 
<protNFe xmlns="http://www.portalfiscal.inf.br/nfe" versao="3.10"> 
</nfeProc>

Thanks to all for support: D

Read XML within XML

Who is online