/soap:Envelope/soap:Body//*[2]//*[2]//*[2]/*/*/*/value[@*]
/soap:Envelope/soap:Body//*[2]//*[2]/*[2]/*[1]/*[1]/*[1]//@name
/soap:Envelope/soap:Body/*[ApplicationArea]/*[Sender]/*[ReferenceId]/ReferenceId/text()
--Script to get data for some period of time --
select sbj_no from sjb where sbj_no in(
select sbj_no from prj.sbj_activity where CREATED_DATETIME > sysdate - interval '1' day and ASSIGN = 'N'
)
and INIT_SERVICE_CODE IN ('name1', 'name2', 'name3')
and sbj_no not in(select sbj_NO from prj.sbj_activity where ACTIVITY_CODE = 'actcode')
order by created_datetime desc fetch first 100 row only
select count(isr_no) from C07_isr_activity where CXX_XXXXXX = 'XX' and CXX_START_DATETIME >= to_date('01 MAY 2021', 'DD MON YYYY')
using System;
using System.Configuration;
using System.IO;
using System.Net;
using System.Xml;
using System.Threading;
namespace OneMDS_CreateJob
{
public class NewJob
{
static void Main(string[] args)
{
execJob(); Thread thr1 = new Thread(execJob); thr1.Start();
}
public static void execJob()
{
string sFileName;
string[] aJobTypes = ConfigurationManager.AppSettings["JobTypes"].Split(',');
string ServerName = ConfigurationManager.AppSettings["ServerName"];
for (int r = 0; r < aJobTypes.Length; r++) {
sFileName = aJobTypes[r] + ".xml";
if (File.Exists(sFileName)){
Console.WriteLine("file name is " + sFileName);
HttpWebRequest Req = (HttpWebRequest)WebRequest.Create(@"http://" + ServerName + "/Cgi.Ssp.Web.Site/InboundJobService.asmx");
Req.ContentType = "text/xml;charset=\"utf-8\"";
Req.Accept = "text/xml";
Req.Method = "POST";
XmlDocument SOAPReqBody = new XmlDocument();
SOAPReqBody.Load(aJobTypes[r] + ".xml");
using (Stream stream = Req.GetRequestStream())
{
SOAPReqBody.Save(stream);
}
//Geting response from request
using (WebResponse Serviceres = Req.GetResponse())
{
using (StreamReader rd = new StreamReader(Serviceres.GetResponseStream()))
{
var ServiceResult = rd.ReadToEnd();
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(ServiceResult);
XmlNodeList jobId = xmlDoc.GetElementsByTagName("JobNumber");
Console.WriteLine("jobID " + jobId[0].InnerText);
}
}
}
}
}
}
}