[sqlwin] Dúvida XML

Wed, 11 Jul 2007 13:20:25 -0700 

Olá lista,

 

  A leitura dos campos "IdPayMethod" e "VlOrderDiscount" não estão sendo
feito corretamente. Imagino que seja devido à string "xsi:type="xsd:int"".
Alguém sabe o que está acontecendo? Alguém sabe qual a forma correta de ler
um arquivo nesse formato? 

 

        Utilizei o código:

 

        ! Busca Tag's enviadas por parametro

Call SalArrayGetUpperBound( rpar_str_vet_ResultTag, 1, nu_index_max )

Set nu_index = 0

While nu_index <= nu_index_max

     !

     If rpar_str_vet_ResultTag[ nu_index ] != ''

              Call oSOAP_Response.getElementsByTagName( oNamedNodeMap,
rpar_str_vet_ResultTag[ nu_index ] )

              If oNamedNodeMap.first( oNode )

                   Set rpar_str_vet_Result[ nu_index ] = SalStrTrimX(
SalStrUpperX( oNode.getTextContent( ) ))

     !

     Set nu_index = nu_index + 1

 

 

    XML:

  

  <?xml version="1.0" encoding="utf-8" standalone="no" ?> 

- <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/";
xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>

- <soap:Body>

- <GetReceiptResponse xmlns="http://tempuri.org/";>

- <GetReceiptResult>

  <IdOrder>5</IdOrder> 

  <DsDispId>4M506M38O7</DsDispId> 

  <DtOrder>2007-06-08T16:04:00.047</DtOrder> 

  <VlTotalOrder>39100</VlTotalOrder> 

  <VlTotalProduct>40900</VlTotalProduct> 

  <VlTotalShipCost>0</VlTotalShipCost> 

  <VlProductDiscount>900</VlProductDiscount> 

  <VlShipCostDiscount>0</VlShipCostDiscount> 

  <NuParcelsNumber>1</NuParcelsNumber> 

  <VlParcelsValue>40000</VlParcelsValue> 

  <NuItemCount>1</NuItemCount> 

  <IdOrderStatus>404</IdOrderStatus> 

  <IdPayMethod xsi:type="xsd:int">1</IdPayMethod> 

  <VlOrderDiscount xsi:type="xsd:int">0</VlOrderDiscount> 

  <IdCustomer>1</IdCustomer> 

  <DsName>Cassiano Macedo Taira</DsName> 

  <DsAddress>Joaquim Eugênio de Lima</DsAddress> 

  <DsDistrict>Jardim Paulista</DsDistrict> 

  <DsNumber>680</DsNumber> 

  <DsComplement>12º Andar</DsComplement> 

  <DsZip>01403-000</DsZip> 

  <DsCity>São Paulo</DsCity> 

  <DsPhone>3288-5737</DsPhone> 

  <DsPhoneDDD>11</DsPhoneDDD> 

  <IdState>SP</IdState> 

  <IdCountry>BR</IdCountry> 

  <DsCardNumber>cV0CKWpyCN+vK8yllJbOJ21HzirHlFAb</DsCardNumber> 

  <DsCardOwner>CASSIANO M TAIRA</DsCardOwner> 

  <DsCardType>Visa</DsCardType> 

  <DsCardComp>111</DsCardComp> 

  <DsCardMonthExpires>11</DsCardMonthExpires> 

  <DsCardYearExpires>2011</DsCardYearExpires> 

  <DsCardCic>34013173859</DsCardCic> 

  </GetReceiptResult>

  </GetReceiptResponse>

  </soap:Body>

  </soap:Envelope>

    

 

Rodrigo Scarano

Target Sistemas 
*  <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]

Rua Turiassu, 390 - 2º Andar - Perdizes - SP 
CEP 05005-000 São Paulo Brasil 
Tel.: 55 11 3801 4015 

site.:  <http://www.targetsis.com.br%20/> www.targetsis.com.br 

Tecnologia da Informação Aplicada ao Distribuidor
  • [sqlwin] Dúvida XML Rodrigo Scarano - Target Sistemas
    • [sqlwin] Dúvida XML Rodrigo Scarano - Target Sistemas

Responder a