i need help in scripting in schedule job
script-
// Updated with new WSDL "https://wd3-services1.myworkday.com/ccx/service/customreport2/gea/int-servicenow/ServiceNow_NewHire_-_newversion?wsdl" with additional fields - Location City, Location Country, Company, Department - modified on 15-Nov-2018
var s = new sn_ws.SOAPMessageV2('Workday integartion-Org level','ReportBinding.Execute_Report'); //create an empty SOAP message
var response = s.execute();
var respBd = response.getBody();
var xmldoc = new XMLDocument(respBd.toString(), true);
//var nodelist = xmldoc.getNodes("//*[name()='wd:Worker_group']/*");
var nodelist = xmldoc.getNodes("//*[name()='wd:Report_Entry']/*");
for(var i=0;i<nodelist.getLength();i++){
//gs.print(nodelist.item(i).getNodeName() +' : '+nodelist.item(i).getTextContent() + ': ' +i);
var ndname = nodelist.item(i).getNodeName();
var ndval = nodelist.item(i).getTextContent();
if(ndname == "wd:Email")
{
//gs.print("#### start of gliderecord ####");
var wdint = new GlideRecord('u_workday_integration_org_level');
wdint.initialize();
wdint.u_employee_email = ndval;
}
else if(ndname == "wd:Employee_ID")
{
wdint.u_employee_id = ndval;
}
// else if (ndname == "wd:Worker_group")
// {
// wdint.u_worker_group = ndval;
// }
else if(ndname == "wd:Organization_Level")
{
wdint.u_organization_level = ndval;
}
else if (wdint.u_employee_id && wdint.u_employee_email && wdint.u_organization_level) {
wdint.insert();
gs.print("#### End of gliderecord ####");
wdint.initialize();
}
}
wsdl- xml-
<wsdl:definitions xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:wd="urn:com.workday.report/GEA_Management_Levels_to_SNow__WS_" xmlns:nyw="urn:com.netyourwork/aod" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapbind="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:httpbind="http://schemas.xmlsoap.org/wsdl/http/" xmlns:mimebind="http://schemas.xmlsoap.org/wsdl/mime/" name="Report" targetNamespace="urn:com.workday.report/GEA_Management_Levels_to_SNow__WS_">
<wsdl:documentation/>
<wsdl:types>
<xsd:schema elementFormDefault="qualified" attributeFormDefault="qualified" targetNamespace="urn:com.workday.report/GEA_Management_Levels_to_SNow__WS_">
<xsd:element name="Report_Data" type="wd:Report_DataType"/>
<xsd:element name="Execute_Report" type="wd:Execute_ReportType"/>
<xsd:simpleType name="RichText">
<xsd:restriction base="xsd:string"/>
</xsd:simpleType>
<xsd:simpleType name="Unique_IdentifierReferenceEnumeration">
<xsd:restriction base="xsd:string">
<xsd:annotation>
<xsd:appinfo>
<wd:enumeration xmlns:wd="urn:com.workday/bsvc" value="IID"/>
<wd:enumeration xmlns:wd="urn:com.workday/bsvc" value="WID"/>
</xsd:appinfo>
</xsd:annotation>
</xsd:restriction>
</xsd:simpleType>
<xsd:complexType name="Report_ParametersType">
</xsd:complexType>
<xsd:complexType name="Unique_IdentifierObjectType">
<xsd:annotation xmlns:wstxns1="urn:com.workday/bsvc" wstxns1:Is_Reference_ID="1"/>
<xsd:sequence>
<xsd:element name="ID" type="wd:Unique_IdentifierObjectIDType" minOccurs="0" maxOccurs="unbounded"/>
</xsd:sequence>
<xsd:attribute name="Descriptor" type="xsd:string">
<xsd:annotation>
<xsd:documentation>
Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.
</xsd:documentation>
</xsd:annotation>
</xsd:attribute>
</xsd:complexType>
<xsd:complexType name="Unique_IdentifierObjectIDType">
<xsd:annotation>
<xsd:documentation>
Contains a unique identifier for an instance of an object.
</xsd:documentation>
</xsd:annotation>
<xsd:simpleContent>
<xsd:extension base="xsd:string">
<xsd:attribute name="type" type="wd:Unique_IdentifierReferenceEnumeration" use="required">
<xsd:annotation>
<xsd:documentation>
The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".
</xsd:documentation>
</xsd:annotation>
</xsd:attribute>
</xsd:extension>
</xsd:simpleContent>
</xsd:complexType>
<xsd:complexType name="Worker_groupType">
<xsd:sequence>
<xsd:element name="Email" type="xsd:string" minOccurs="0"/>
<xsd:element name="Employee_ID" type="xsd:string" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="Report_EntryType">
<xsd:sequence>
<xsd:element name="Worker_group" type="wd:Worker_groupType" minOccurs="0"/>
<xsd:element name="Organization_Level" type="xsd:decimal" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="Report_DataType">
<xsd:sequence>
<xsd:element name="Report_Entry" type="wd:Report_EntryType" minOccurs="0" maxOccurs="unbounded"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="Execute_ReportType">
<xsd:sequence>
<xsd:element name="Report_Parameters" type="wd:Report_ParametersType" minOccurs="0"/>
<xsd:element name="Authentication" type="wd:AuthenticationType" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="MoneyType">
<xsd:simpleContent>
<xsd:extension base="xsd:decimal">
<xsd:attribute name="Currency_Code" type="xsd:string"/>
</xsd:extension>
</xsd:simpleContent>
</xsd:complexType>
<xsd:complexType name="AuthenticationType">
<xsd:sequence>
<xsd:element name="Proxy_User_Name" type="xsd:string" minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
</xsd:complexType>
</xsd:schema>
</wsdl:types>
<wsdl:message name="Execute_ReportInputMsg">
<wsdl:part name="body" element="wd:Execute_Report"/>
</wsdl:message>
<wsdl:message name="RequestMsg">
<wsdl:part name="Proxy_User_Name" type="xsd:string"/>
</wsdl:message>
<wsdl:message name="Report_DataOutputMsg">
<wsdl:part name="body" element="wd:Report_Data"/>
</wsdl:message>
<wsdl:message name="ResponseMsg">
<wsdl:part name="body" type="wd:Report_DataType"/>
</wsdl:message>
<wsdl:portType name="ReportPort">
<wsdl:documentation/>
<wsdl:operation name="Execute_Report">
<wsdl:input name="Execute_ReportInput" message="wd:Execute_ReportInputMsg"/>
<wsdl:output name="Execute_ReportOutput" message="wd:Report_DataOutputMsg"/>
</wsdl:operation>
</wsdl:portType>
<wsdl:portType name="ReportPortREST">
<wsdl:operation name="Execute_Report">
<wsdl:input name="Execute_ReportInput" message="wd:RequestMsg"/>
<wsdl:output name="Execute_ReportOutput" message="wd:ResponseMsg"/>
</wsdl:operation>
</wsdl:portType>
<wsdl:binding name="ReportBinding" type="wd:ReportPort">
<soapbind:binding style="document" transport="http://schemas.xmlsoap.org/soap/http"/>
<wsdl:operation name="Execute_Report">
<soapbind:operation style="document"/>
<wsdl:input name="Execute_ReportInput">
<soapbind:body use="literal"/>
</wsdl:input>
<wsdl:output name="Execute_ReportOutput">
<soapbind:body use="literal"/>
</wsdl:output>
</wsdl:operation>
</wsdl:binding>
<wsdl:binding name="ReportRESTBinding" type="wd:ReportPortREST">
<httpbind:binding verb="GET"/>
<wsdl:operation name="Execute_Report">
<httpbind:operation location="Execute_Report"/>
<wsdl:input>
</wsdl:input>
<wsdl:output>
<mimebind:content type="text/xml" part="body"/>
</wsdl:output>
</wsdl:operation>
</wsdl:binding>
<wsdl:service name="ReportService">
<wsdl:port name="Report" binding="wd:ReportBinding">
<soapbind:address location="https://wd3-services1.myworkday.com/ccx/service/Report2/gea/int-servicenow/GEA_Management_Levels_to_SNow__WS_"/>
</wsdl:port>
<wsdl:port name="ReportREST" binding="wd:ReportRESTBinding">
<httpbind:address location="https://wd3-services1.myworkday.com/ccx/service/customreport2/gea/int-servicenow/GEA_Management_Levels_to_SNow__WS_"/>
</wsdl:port>
</wsdl:service>
</wsdl:definitions>
