โ03-03-2021 10:22 AM
I have been trying to delete a field on an object in Workday and havenโt found a way. If Iโm just writing a SOAP request, I can pass in an empty tag like โ< emptytag/>โ to delete a value. With SnapLogic, Iโm not sure how to achieve that. I have tried setting the value to null, setting it to an empty string, and not passing it in at all. No luck. Any ideas?
โ03-03-2021 04:53 PM
I have run into cases with the Workday web services where deleting a field must contain a descriptor value in the tag in order to successfully perform the delete. I have a use case for this, but Iโm using the SOAP snap in this particular case instead of the Workday Write snap.
If youโre using Workday Write, I recommend populating the field Descriptor attribute with any non-empty string value. In my SOAP experience, the non-empty text that you use doesnโt matter. You should leave the fields ID type and value out of the mapper.
โ03-04-2021 03:58 AM
Unfortunately, this did not work using the Workday Write snap. I think part of the issue is that Iโm trying to delete a date, and I think the descriptor field only applies to objects.
โ03-04-2021 06:37 AM
Well, thatโs unfortunate. My only other โguessโ would be to use the value โ{empty}โ (with curly braces) for the date field value. This is a method used in Workday EIB templates to delete data. But that may just be something the EIB loader can interpret.
If that doesnโt work, my final suggestion would be to use the SOAP snap for this particular case. For our Workday integrations, we use a combination of SOAP, REST, and/or Workday Snaps - depending on the benefit either brings us for each case.