topic Re: How to use except formula in the nested object ? in Workato Pros Discussion Board

How to use except formula in the nested object ?

amalim — Mon, 14 Oct 2024 14:47:10 GMT

I have an array which look like this below. I can manage to remove the 1st level of fields using except formula.
users[0].except(:two_factor_auth_enabled,:signature).
I am trying to remove the nested object field using the below formula.
users[0].except(:two_factor_auth_enabled,:signature,:user_fields["city"]).
But it is not working as expected. Kindly give me the solution for this process.

"users": [ { "id": 12345, "name": "Abdul Khader Malim", "email": "amalim@logitech.com", "two_factor_auth_enabled": null, "signature": "", "user_fields": { "address_line_1": "3221 COLEMAN AVE", "address_line_2": null, "birth_year": null, "city": "OCEANSIDE", "company_school": null, "country": "country_nl", "gender": null, "newsletter_subscription": false, "postal_code": "92054", "region": null, "school_district": null, "site": null, "state": "CA" } } ]

Re: How to use except formula in the nested object ?

gary1 — Mon, 14 Oct 2024 17:05:24 GMT

I can't find a way to target the nested array either. You might have to break it out separately and combine them. I'm interested to know if you find a more elegant solution.

Re: How to use except formula in the nested object ?

ndy — Tue, 15 Oct 2024 03:06:45 GMT

Dear, @amalim

In Workato, the except formula does not directly work on nested object like you have in the user_fields. When you're trying to remove fields from a nested object, you can't use the except formula directly on fields within that nested structure.

To handle this is to reconstruct a new variable.

Re: How to use except formula in the nested object ?

timwolfe — Sat, 16 Nov 2024 16:00:38 GMT

To remove top-level and nested fields in your object, use this:

modified_users = users.map do |user|
user.except(:two_factor_auth_enabled, :signature).merge(
user_fields: user[:user_fields]&.except(:city)
)
end

This removes :two_factor_auth_enabled and :signature from the top-level and :city from the nested user_fields.