Exibir origem

Introdução

O Web Service wsProcess é o responsável pela execução de processos do sistema

Como funciona

Estão expostos no wsProcess alguns serviços, onde para consumi-los é necessário enviar através de uma requisição um envelope SOAP, passando os parâmetros de cada serviço.

Serviços Disponíveis

Serviço responsável por executar processos com parâmetros XML.

Os parâmetros solicitado pelo ExecuteWithXmlParams são:

ProcessServerName tipo String

strXmlParams tipo String

Para pegar o parâmetro XML é necessário executar o processo através da biblioteca.

Acesse a biblioteca e execute o processo que deseja utilizar

No exemplo foi utilizado o processo de Cópia de Consultas SQL entre Coligadas

Linha RM > TBC - Web Service Process > image2015-7-9 15:50:6.png

Selecionar para qual Coligada deseja copiar a consulta SQL e execute o processo.

Linha RM > TBC - Web Service Process > image2015-7-9 15:55:54.png

Linha RM > TBC - Web Service Process > image2015-7-9 16:5:25.png

Após o processo ter sido executado com sucesso siga para o passo 2

Agora é necessário pegar o ID do Job que foi gerado pelo processo

Acesse o menu "Ambiente | Gerenciamento de Jobs"

Linha RM > TBC - Web Service Process > image2015-7-9 16:37:43.png

Após saber qual é o ID do Job siga para o Passo 3

Sabendo qual é o ID do Job é necessário utilizar a ferramenta TotvsWSClient.

Saiba como configurar e utilizar a ferramenta através do link TotvsWSClient

Após executar o TotvsWsClient acesse a visão de processos

Linha RM > TBC - Web Service Process > image2015-7-9 16:55:39.png

Informe o Job do processo e clique em carregar

Linha RM > TBC - Web Service Process > image2015-7-9 16:57:22.png

Será exibido o registro equivalente ao ID Job informado

Linha RM > TBC - Web Service Process > image2015-7-9 16:59:18.png

Dê dois cliques no registro e siga para o próximo passo

Após abrir o registro serão exibidos os dados do registro, Propriedades e o XML

Linha RM > TBC - Web Service Process > image2015-7-9 17:2:22.png

Acesse a Aba XML, clique na opção de "Codificar como CDATA" e copie o XML, pois é ele que será passado como parâmetro do processo

Linha RM > TBC - Web Service Process > image2015-7-9 17:10:51.png

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tot="http://www.totvs.com/">
   <soapenv:Header/>
   <soapenv:Body>
      <tot:ExecuteWithXmlParams>
         <!--Optional:-->
         <tot:ProcessServerName>GlbProcCopyConsSQL</tot:ProcessServerName>
         <!--Optional:-->
         <tot:strXmlParams>&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-16&quot;?&gt;
&lt;GlbParamsProcCopyColig xmlns:i=&quot;http://www.w3.org/2001/XMLSchema-instance&quot; z:Id=&quot;i1&quot; xmlns:z=&quot;http://schemas.microsoft.com/2003/10/Serialization/&quot; xmlns=&quot;http://www.totvs.com.br/RM/&quot;&gt;
  &lt;CanParallelize xmlns=&quot;http://www.totvs.com/&quot;&gt;true&lt;/CanParallelize&gt;
  &lt;Context xmlns:d2p1=&quot;http://www.totvs.com.br/RM/&quot; z:Id=&quot;i2&quot; xmlns=&quot;http://www.totvs.com/&quot;&gt;
    &lt;d2p1:_params xmlns:d3p1=&quot;http://schemas.microsoft.com/2003/10/Serialization/Arrays&quot;&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$CODUNIDADEBIB&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:int&quot;&gt;1&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$CHAPAFUNCIONARIO&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;00001&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$EXERCICIOFISCAL&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:int&quot;&gt;2&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$CODFILIAL&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:int&quot;&gt;1&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$RHTIPOUSR&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;01&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$CODCOLIGADA&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:int&quot;&gt;1&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$EDUTIPOUSR&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;F&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$CODLOCPRT&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:int&quot;&gt;5&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$CODUSUARIO&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;mestre&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$CODUSUARIOSERVICO&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$CODSISTEMA&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;G&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$CODTIPOCURSO&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:int&quot;&gt;2&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$CODIGOEXTERNO&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;-1&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
      &lt;d3p1:KeyValueOfanyTypeanyType&gt;
        &lt;d3p1:Key xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:string&quot;&gt;$IDPRJ&lt;/d3p1:Key&gt;
        &lt;d3p1:Value xmlns:d5p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d5p1:int&quot;&gt;2&lt;/d3p1:Value&gt;
      &lt;/d3p1:KeyValueOfanyTypeanyType&gt;
    &lt;/d2p1:_params&gt;
    &lt;d2p1:Environment&gt;DotNet&lt;/d2p1:Environment&gt;
  &lt;/Context&gt;
  &lt;Initialized xmlns=&quot;http://www.totvs.com/&quot;&gt;true&lt;/Initialized&gt;
  &lt;IsolateProcess xmlns=&quot;http://www.totvs.com/&quot;&gt;false&lt;/IsolateProcess&gt;
  &lt;MaximumQuantityOfPrimaryKeysPerProcess xmlns=&quot;http://www.totvs.com/&quot;&gt;1000&lt;/MaximumQuantityOfPrimaryKeysPerProcess&gt;
  &lt;MinimumQuantityOfPrimaryKeysPerProcess xmlns=&quot;http://www.totvs.com/&quot;&gt;1&lt;/MinimumQuantityOfPrimaryKeysPerProcess&gt;
  &lt;PrimaryKeyList xmlns:d2p1=&quot;http://schemas.microsoft.com/2003/10/Serialization/Arrays&quot; xmlns=&quot;http://www.totvs.com/&quot;&gt;
    &lt;d2p1:ArrayOfanyType&gt;
      &lt;d2p1:anyType xmlns:d4p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d4p1:short&quot;&gt;1&lt;/d2p1:anyType&gt;
      &lt;d2p1:anyType xmlns:d4p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d4p1:string&quot;&gt;G&lt;/d2p1:anyType&gt;
      &lt;d2p1:anyType xmlns:d4p1=&quot;http://www.w3.org/2001/XMLSchema&quot; i:type=&quot;d4p1:string&quot;&gt;Exemplo&lt;/d2p1:anyType&gt;
    &lt;/d2p1:ArrayOfanyType&gt;
  &lt;/PrimaryKeyList&gt;
  &lt;PrimaryKeyNames xmlns:d2p1=&quot;http://schemas.microsoft.com/2003/10/Serialization/Arrays&quot; xmlns=&quot;http://www.totvs.com/&quot;&gt;
    &lt;d2p1:string&gt;CODCOLIGADA&lt;/d2p1:string&gt;
    &lt;d2p1:string&gt;APLICACAO&lt;/d2p1:string&gt;
    &lt;d2p1:string&gt;CODSENTENCA&lt;/d2p1:string&gt;
  &lt;/PrimaryKeyNames&gt;
  &lt;QuantityOfSplits xmlns=&quot;http://www.totvs.com/&quot;&gt;0&lt;/QuantityOfSplits&gt;
  &lt;ShouldParallelize xmlns=&quot;http://www.totvs.com/&quot;&gt;false&lt;/ShouldParallelize&gt;
  &lt;IsReplaceExistingRecordsVisible&gt;true&lt;/IsReplaceExistingRecordsVisible&gt;
  &lt;ReplaceExistingRecords&gt;false&lt;/ReplaceExistingRecords&gt;
  &lt;TargetColigadas xmlns:d2p1=&quot;http://schemas.microsoft.com/2003/10/Serialization/Arrays&quot;&gt;
    &lt;d2p1:int&gt;6&lt;/d2p1:int&gt;
  &lt;/TargetColigadas&gt;
&lt;/GlbParamsProcCopyColig&gt;</tot:strXmlParams>
      </tot:ExecuteWithXmlParams>
   </soapenv:Body>
</soapenv:Envelope>

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
   <s:Body>
      <ExecuteWithXmlParamsResponse xmlns="http://www.totvs.com/">
         <ExecuteWithXmlParamsResult>1</ExecuteWithXmlParamsResult>
      </ExecuteWithXmlParamsResponse>
   </s:Body>
</s:Envelope>

Para utilização dos Web Services através do aplicativo "Totvs Web Service Test", clique aqui.

@FRAMEWORK

Canais de Atendimento

Chamado: Através do Portal TOTVS - www.suporte.totvs.com.br

Telefônico: 4003-0015 Escolhendo as opções 2-2-3-9-5 (Framework) ou 2-2-3-9-4 (BI)

Produto	Framework
Versão	11.82.XX
Processo	Web Services
Subprocesso	Utilizando o Web Service wsProcess

Status do Documento:	Produção
Data:	30/06/2015
Versão:	11.82.XX
Versão Anterior:	11.82.XX
Autores:	Diego Henrique Pener Fábio Augusto Amaral Melo Nunes Welbert Marques Silva Wesley Avelino De Carvalho