How to use soap execute against workday?

Question

Do I have to update Customize envelope? or just generate the template? I always got an error when use soap execute for Put_Provisioning_Group_Assignment. The same column mapping is working for workday write snap.

acesario · Answer

@sdeng  Did you ever get this working successfully via soap execute?   I have this working for a get request, but not for a submit. curious about the soap template, and how that factors into the solution. Any advice?

tlikarish · Answer

I’m not really a soap expert, but from what I understand you configure the snap with a WSDL and then can use that and incoming data to generate the soap envelope.
Maybe if you share more information about the pipeline and how the snap is configured I can provide some more pointers.
Also, here is a video that talks about how to use Soap in SnapLogic. You can also refer to the documentation.

sdeng · Answer

Yes, here’s the code generated:
&lt;SOAP-ENV:Envelope
xmlns:SOAP-ENV=“http://schemas.xmlsoap.org/soap/envelope/”
xmlns:ns0=“urn:com.workday/bsvc”&gt;
SOAP-ENV:Header
ns0:Workday_Common_Header
ns0:Include_Reference_Descriptors_In_Response$Include_Reference_Descriptors_In_Response&lt;/ns0:Include_Reference_Descriptors_In_Response&gt;
&lt;/ns0:Workday_Common_Header&gt;
&lt;/SOAP-ENV:Header&gt;
SOAP-ENV:Body
&lt;ns0:Put_Provisioning_Group_Assignment_Request ns0:version=“$version”&gt;
&lt;ns0:Provisioning_Group_Assignment_Reference ns0:Descriptor=“$Provisioning_Group_Assignment_Reference.Descriptor”&gt;#foreach($ID in $Provisioning_Group_Assignment_Reference.ID)
&lt;ns0:ID ns0:type=“$ID.type”&gt;$ID.value&lt;/ns0:ID&gt;#end
&lt;/ns0:Provisioning_Group_Assignment_Reference&gt;
ns0:Provisioning_Group_Assignment_Data
&lt;ns0:Person_Reference ns0:Descriptor=“$Provisioning_Group_Assignment_Data.Person_Reference.Descriptor”&gt;#foreach($ID in $Provisioning_Group_Assignment_Data.Person_Reference.ID)
&lt;ns0:ID ns0:type=“$ID.type”&gt;$ID.value&lt;/ns0:ID&gt;#end
&lt;/ns0:Person_Reference&gt;
&lt;ns0:Worker_Reference ns0:Descriptor=“$Provisioning_Group_Assignment_Data.Worker_Reference.Descriptor”&gt;#foreach($ID in $Provisioning_Group_Assignment_Data.Worker_Reference.ID)
&lt;ns0:ID ns0:type=“$ID.type”&gt;$ID.value&lt;/ns0:ID&gt;#end
&lt;/ns0:Worker_Reference&gt;
ns0:Provisioning_Group$Provisioning_Group_Assignment_Data.Provisioning_Group&lt;/ns0:Provisioning_Group&gt;
ns0:Status$Provisioning_Group_Assignment_Data.Status&lt;/ns0:Status&gt;
ns0:Last_Changed$Provisioning_Group_Assignment_Data.Last_Changed&lt;/ns0:Last_Changed&gt;
&lt;/ns0:Provisioning_Group_Assignment_Data&gt;
&lt;/ns0:Put_Provisioning_Group_Assignment_Request&gt;
&lt;/SOAP-ENV:Body&gt;
&lt;/SOAP-ENV:Envelope&gt;
Updated to below:
&lt;SOAP-ENV:Envelope
xmlns:SOAP-ENV=“http://schemas.xmlsoap.org/soap/envelope/”
xmlns:ns0=“urn:com.workday/bsvc”&gt;
SOAP-ENV:Header
ns0:Workday_Common_Header
ns0:Include_Reference_Descriptors_In_Response$Include_Reference_Descriptors_In_Response&lt;/ns0:Include_Reference_Descriptors_In_Response&gt;
&lt;/ns0:Workday_Common_Header&gt;
&lt;/SOAP-ENV:Header&gt;
SOAP-ENV:Body
&lt;ns0:Put_Provisioning_Group_Assignment_Request ns0:version=“$version”&gt;
&lt;ns0:Provisioning_Group_Assignment_Reference ns0:Descriptor=“$Provisioning_Group_Assignment_Reference.Descriptor”&gt;#foreach($ID in $Provisioning_Group_Assignment_Reference.ID)
&lt;ns0:ID ns0:type=“$ID.type”&gt;$ID.value&lt;/ns0:ID&gt;#end
&lt;/ns0:Provisioning_Group_Assignment_Reference&gt;
ns0:Provisioning_Group_Assignment_Data
&lt;ns0:Person_Reference ns0:Descriptor=“$Provisioning_Group_Assignment_Data.Person_Reference.Descriptor”&gt;#foreach($ID in $Provisioning_Group_Assignment_Data.Person_Reference.ID)
&lt;ns0:ID ns0:type=“$ID.type”&gt;$ID.value&lt;/ns0:ID&gt;#end
&lt;/ns0:Person_Reference&gt;
&lt;ns0:Worker_Reference ns0:Descriptor=“$Provisioning_Group_Assignment_Data.Worker_Reference.Descriptor”&gt;foreach($ID in $Provisioning_Group_Assignment_Data.Worker_Reference.ID)
&lt;ns0:ID ns0:type=“$ID.type”&gt;$ID.value&lt;/ns0:ID&gt;end
&lt;/ns0:Worker_Reference&gt;
ns0:Provisioning_Group$Provisioning_Group_Assignment_Data.Provisioning_Group&lt;/ns0:Provisioning_Group&gt;
ns0:Status$Provisioning_Group_Assignment_Data.Status&lt;/ns0:Status&gt;
ns0:Last_Changed$Provisioning_Group_Assignment_Data.Last_Changed&lt;/ns0:Last_Changed&gt;
&lt;/ns0:Provisioning_Group_Assignment_Data&gt;
&lt;/ns0:Put_Provisioning_Group_Assignment_Request&gt;
&lt;/SOAP-ENV:Body&gt;
&lt;/SOAP-ENV:Envelope&gt;
In the mapper before, I map it like below:

got below error:
Failure: Unable to write key: $.ID.type, Reason: Expecting object for JSON-Path field reference ‘type’, found: String, Resolution: Please file a defect against the snap

Forum Discussion

How to use soap execute against workday?

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?