0
Does anyone know how to create an SQL Server database to run a stream Webservice ?
The idea is to create a process from the execution of Procedure
I read about the Ole Automation Stored Procedures of SQL Server but I’m having doubts about how to assemble them because I need to pass the URL
http://SERVIDOR/webdesk/ECMWorkflowEngineService?wsdl'
and XML
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ws="http://ws.workflow.ecm.technology.totvs.com/">
<soapenv:Header/>
<soapenv:Body>
<ws:simpleStartProcess>
<username>usuario</username>
<password>senha</password>
<companyId>1</companyId>
<processId>processo</processId>
<comments>GERADO VIA WS</comments>
<attachments>
<!--Zero or more repetitions:-->
<item>
<attachmentSequence>?</attachmentSequence>
<!--Zero or more repetitions:-->
<attachments>
<!--Optional:-->
<attach>?</attach>
<!--Optional:-->
<descriptor>?</descriptor>
<!--Optional:-->
<editing>?</editing>
<!--Optional:-->
<fileName>?</fileName>
<!--Optional:-->
<fileSelected/>
<fileSize>?</fileSize>
<!--Optional:-->
<filecontent>cid:702686015833</filecontent>
<!--Optional:-->
<fullPatch>?</fullPatch>
<!--Optional:-->
<iconPath>?</iconPath>
<!--Optional:-->
<mobile>?</mobile>
<!--Optional:-->
<pathName>?</pathName>
<!--Optional:-->
<principal>?</principal>
</attachments>
<!--Optional:-->
<colleagueId>?</colleagueId>
<!--Optional:-->
<colleagueName>?</colleagueName>
<companyId>?</companyId>
<!--Optional:-->
<crc>?</crc>
<!--Optional:-->
<createDate>?</createDate>
<!--Optional:-->
<createDateTimestamp>?</createDateTimestamp>
<!--Optional:-->
<deleted>?</deleted>
<!--Optional:-->
<description>?</description>
<!--Optional:-->
<documentId>?</documentId>
<!--Optional:-->
<documentType>?</documentType>
<!--Optional:-->
<fileName>?</fileName>
<!--Optional:-->
<newAttach>?</newAttach>
<!--Optional:-->
<originalMovementSequence>?</originalMovementSequence>
<!--Optional:-->
<permission>?</permission>
<processInstanceId>?</processInstanceId>
<size>?</size>
<!--Optional:-->
<version>?</version>
</item>
</attachments>
<cardData>
<!--Zero or more repetitions:-->
<item>
<!--Zero or more repetitions:-->
<item>codigoProduto</item>
<item>"Item"</item>
</item>
</cardData>
</ws:simpleStartProcess>
</soapenv:Body>
</soapenv:Envelope>
Does anyone have any idea how to do that ?