Forum Discussion

acesario's avatar
acesario
Contributor II
5 years ago

SoapExecute Workday Read Get Course Sections fails with error message 'Course_Section_Reference is required' when it actually exists in the request

I am attempting to get a web service response from workday, but hitting an error which does not make sense to me
error: Course_Section_Reference’ is required, on internal element 'Course Section Request References

There is no ‘Course Section Request References’ section, only a ‘Request References’ section which I do have populated:

My pipeline snaps…

The wsdl: https://wd5-impl-services1.workday.com/ccx/service/*mytenant*/Student_Records/v35.0?wsdl
The operation: {urn:com.workday/bsvc/Student_Records}Get_Course_Sections

The custom envelope:
<SOAP-ENV:Envelope
xmlns:SOAP-ENV=“http://schemas.xmlsoap.org/soap/envelope/
xmlns:ns0=“urn:com.workday/bsvc”>
SOAP-ENV:Header
ns0:Workday_Common_Header
ns0:Include_Reference_Descriptors_In_Response$Include_Reference_Descriptors_In_Response</ns0:Include_Reference_Descriptors_In_Response>
</ns0:Workday_Common_Header>
</SOAP-ENV:Header>
SOAP-ENV:Body
<ns0:Get_Course_Sections_Request ns0:version=“$version”>
ns0:Request_References#foreach($Course_Section_Reference in $Request_References.Course_Section_Reference)
<ns0:Course_Section_Reference ns0:Descriptor=“$Course_Section_Reference.Descriptor”>#foreach($ID in $Course_Section_Reference.ID)
<ns0:ID ns0:type=“$ID.type”>$ID.value</ns0:ID>#end
</ns0:Course_Section_Reference>#end
</ns0:Request_References>
ns0:Request_Criteria
<ns0:Course_Reference ns0:Descriptor=“$Request_Criteria.Course_Reference.Descriptor”>#foreach($ID in $Request_Criteria.Course_Reference.ID)
<ns0:ID ns0:type=“$ID.type”>$ID.value</ns0:ID>#end
</ns0:Course_Reference>
<ns0:Section_Listing_Reference ns0:Descriptor=“$Request_Criteria.Section_Listing_Reference.Descriptor”>#foreach($ID in $Request_Criteria.Section_Listing_Reference.ID)
<ns0:ID ns0:type=“$ID.type”>$ID.value</ns0:ID>#end
</ns0:Section_Listing_Reference>#foreach($Section_Status_Reference in $Request_Criteria.Section_Status_Reference)
<ns0:Section_Status_Reference ns0:Descriptor=“$Section_Status_Reference.Descriptor”>#foreach($ID in $Section_Status_Reference.ID)
<ns0:ID ns0:type=“$ID.type”>$ID.value</ns0:ID>#end
</ns0:Section_Status_Reference>#end#foreach($Academic_Period_Reference in $Request_Criteria.Academic_Period_Reference)
<ns0:Academic_Period_Reference ns0:Descriptor=“$Academic_Period_Reference.Descriptor”>#foreach($ID in $Academic_Period_Reference.ID)
<ns0:ID ns0:type=“$ID.type”>$ID.value</ns0:ID>#end
</ns0:Academic_Period_Reference>#end
ns0:Start_Date$Request_Criteria.Start_Date</ns0:Start_Date>
ns0:End_Date$Request_Criteria.End_Date</ns0:End_Date>
</ns0:Request_Criteria>
ns0:Response_Filter
ns0:As_Of_Effective_Date$Response_Filter.As_Of_Effective_Date</ns0:As_Of_Effective_Date>
ns0:As_Of_Entry_DateTime$Response_Filter.As_Of_Entry_DateTime</ns0:As_Of_Entry_DateTime>
ns0:Page$Response_Filter.Page</ns0:Page>
ns0:Count$Response_Filter.Count</ns0:Count>
</ns0:Response_Filter>
</ns0:Get_Course_Sections_Request>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

My mapper:

1 Reply

  • fmdf's avatar
    fmdf
    New Contributor III

    Thanks for the idea. It still isn’t executing. It shows GREEN after I run, but the log files in SQL are not showing that it executes.

    • del's avatar
      del
      Contributor III

      It still sounds to me like the Snap execution option is incorrectly set:

      That may not be the case here, but it brings up this thought for anyone that hasn’t experienced it yet:

      When you change the Snap Execution to Validate & Execute, on a snap that defaults to Execute, then you later use the right-click context menu to disable the snap, then later the same menu to enable the snap, the snap reverts back to its default setting of Execute instead of the Validate & Execute setting you last saved. So, each time this occurs, you have to edit the snap once more to get back to the Validate & Execute setting.