Forum Discussion

Thom's avatar
Thom
New Contributor II
3 years ago
Solved

Detect XML attribute xsi:nil and apply null value

I am using a SOAP Execute to retrieve information from an API. The payload is being converted to JSON. The problem is any field that is null returns with an attribute of @xsi:nil:“true”. This is j...
SOAP
  • Thom's avatar
    Thom
    3 years ago

    Expanding on the solution provided and using information from the web related to javascript, I came up with the following statement. There was experimentation involved for sure.
    $.mapValues((value,key)=> typeof(value) == ‘object’ && value.hasOwnProperty(“@xsi:nil”)? null :value).mapKeys((value,key)=> key.replace(‘ns2:’,‘’))
    mapValues and mapKeys are admittedly a bit of a black box for me still.
    Thanks @JensDeveloper for leading me done a good path.

JensDeveloper's avatar
JensDeveloper
Contributor II
3 years ago

Hi @Thom

I see that when its null it’s always an object with two properties and when it has a value its type is a string. So I created a pipeline that checks which type it is and based on that it gets the value or puts null as the value. The pipeline below:
Soap_format_2023_06_22.slp (4.6 KB)

Let me know if it helps

Jens

Thom's avatar
Thom
New Contributor II
3 years ago

Thanks for this example. I was envisioning something that iterated through all the fields in the document and converting these objects to null. Do you believe that to be possible?
Any number of fields could be null and that could be different in each document being processed.
Thanks again.