1 Reply Latest reply: Jul 8, 2014 2:02 PM by Fernando Tonial RSS

    Load value from xml into variable

      Hi...

       

      I have an webservice with 3 values into parameters- vClientCode,vFirstName,vLastName

      the result returns by XML is Varification Code.

       

      My Script goes like this:

       

      vClientCode = 999;

      vFirstName = 'John';

      vLastName = 'Smith';

       

      I to load into a new variable, called- vVarificationCode,  the XML result.

       

      Thank You.

        • Re: Load value from xml into variable
          Fernando Tonial

          Please, put the script.

           

          Maybe yoou try this.

           

          // Start of [Fornecedores.xml] LOAD statements
          Table:
          LOAD
            FornecedorID,
              NomeEmpresa,
              NomeContato,
              Endereco,
              Cidade,
              CodigoPostal,
              País,
              Fone,
              Fax
          FROM Fornecedores.xml (XmlSimple, Table is [Fornecedores/_empty_]);
          // End of [Fornecedores.xml] LOAD statements
          
          SET FornecedorID= Peek('FornecedorID');
          

           

          Best Regards.

          Tonial.