SERVIZIO OPERAZIONI

147.8.3.15 esempio QUERY DB ESTERNI

https://ftp.etere.com/file/d/DriveO/DATA/federico/rai/API_SAMPLES/15%20ExecuteQuery.xml


<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:edit="http://www.media.rai.it/Editing/" xmlns:oper="www.media.rai.it/Operations">
<soapenv:Header/>
<soapenv:Body>
<edit:AddOperations>
<!-- Optional: -->
<edit:bus>
<oper:UniqueIdentifier>5dbd979d-4491-4c37-95e9-37a2294f2771</oper:UniqueIdentifier>
<!-- Optional: -->
<oper:NotifyUri/>
<!-- Optional: -->
<oper:Operations>
<!-- Zero or more repetitions: -->
<oper:OperationInfo>
<!-- Optional: -->
<oper:Dependency> </oper:Dependency>
<oper:Delayed>1</oper:Delayed>
<!-- Optional: -->
<oper:Name>eo_ExecuteQuery</oper:Name>
<!-- Optional: -->
<oper:XmlEdl>
<!-- You may enter ANY elements at this point -->
<Operation>
<Name>ExecuteQuery</Name>
<ConnectionString>Initial Catalog=Etere;Data Source=ZRMLS434.ict.corp.rai.it,6000;User ID=dba_Etere;Password=e4i5t7u5;Network Library=dbmssocn;Application Name=EtereWeb;MultipleActiveResultSets=True</ConnectionString>
<QueryString>select top 10 * from filmati where cod_progra like 'MEM%'</QueryString>
<Timeout>60</Timeout>
<XmlResponse>true</XmlResponse>
</Operation>
</oper:XmlEdl>
<!-- Optional: -->
<oper:OperationType>ot</oper:OperationType>
<oper:OperationGuid>ebb0cd4a-2f6d-4847-aa22-225fcdb3248a</oper:OperationGuid>
<!-- Optional: -->
<oper:NotifyUri/>
<oper:AsOf>2021-03-30T10:45:00</oper:AsOf>
<oper:EveryMinutes>2</oper:EveryMinutes>
<oper:Enabled>true</oper:Enabled>
<oper:RequireUniqueName>true</oper:RequireUniqueName>
<oper:NotCreateIfExists>true</oper:NotCreateIfExists>
<oper:Priority>3</oper:Priority>
<oper:NotifyOnlyError>true</oper:NotifyOnlyError>
<!-- Optional: -->
<oper:Category>C</oper:Category>
</oper:OperationInfo>
</oper:Operations>
</edit:bus>
</edit:AddOperations>
</soapenv:Body>
</soapenv:Envelope>