Forum Discussion

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

Aleksandar_A
3 years ago
Hi @arvindnsn,

You can try to filter out documents that have “error” keys, and later on to split them using JSON Splitter Snap.

$result.filter(x => x.hasPath("error"))

Let me know if this helps you.

BR,
Aleksandar.

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

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.