topic Re: How to skip null objects in a list in Workato Pros Discussion Board

How to skip null objects in a list

nitishjain — Tue, 24 Dec 2024 07:08:46 GMT

I'm getting null objects in my filtered list. how can I remove the null objects w/o using Pythion script?
Example:
[{"name" : "Nitish",

"Id": "010"},

{},

{"name" : "Nitesh",

"Id": "020"}]

Re: How to skip null objects in a list

shivakumara — Tue, 24 Dec 2024 09:30:39 GMT

Hi @nitishjain ,

Just use below solution in formula mode, Please let me know if you need further information.

Thanks and Regards,
Shivakumara A

Re: How to skip null objects in a list

nitishjain — Tue, 24 Dec 2024 14:05:39 GMT

in logger it removes by using "- [{}]" but how do I remove it in actual?

Re: How to skip null objects in a list

shivakumara — Tue, 24 Dec 2024 14:30:59 GMT

Hi @nitishjain,
What do you mean by 'actual'? Could you please ask the question more precisely?

Thanks and Regards,
Shivakumar K A

Re: How to skip null objects in a list

nitishjain — Thu, 26 Dec 2024 06:09:52 GMT

HI @shivakumara

Thanks for checking, I have a parse json where I'm creating a json structure and later on I'm using list where I checks some condition in all fields and get some empty objects in filtered response.
now I want to remove those empty objects.

Please let me know an optimized solution.

let me know if you want more details or we can connect over a call.

Thanks

Nitish

Re: How to skip null objects in a list

shivakumara — Thu, 26 Dec 2024 07:52:48 GMT

Hi @nitishjain ,
Once you receive the filtered response( includes empty items) use again the parse Json where need to pass following way
1. Add the sample response you receive as as sample request. ( your List response)
2. pass the actual array response in the below format.

Thanks and Regards,
Shivakumar A