This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

<@U6Z7P6T4Z> <@U03HQ088UKY> or any other Celigo experts in here....I'm trying to create a branch in my flow, but the field that I want to use is not available in the dropdown.  I tried it as an expression and still no go.  Any ideas?

image.png

Screenshot may help.  I'm looking for something like this applications.0.applicationdetails.properties.company_type, but I don't even get applicationdetails as an option in the dropdown.  Something I can do?

Yes it is possible, but unfortunately it's not easy. Do you have <https://chromewebstore.google.com/detail/zangabox/bamdljjdfabfogmdkbjjigjpeebmfdek?hl=en&amp;pli=1|this> plugin? Use this, then update the flow via api. I use the plugin all the time

We're working on reworking branching and filter UI this year and fixing this is going to be part of it

I don't, but I'll install it and try it out a little later.  Thanks Tyler, I'll let you know how it goes

Sounds good. I just tested this and it worked. Basically the backend supports it, but the UI doesn't let you just type in something that isn't in the drop down

Made this post for users in the future: <https://docs.celigo.com/hc/en-us/community/posts/32618912066203-How-to-Filter-or-Branch-on-Nested-Array-Fields-in-Input-Filters-Output-Filters-and-Branching|https://docs.celigo.com/hc/en-us/community/posts/32618912066203-How-to-Filter-or-Bra[…]ed-Array-Fields-in-Input-Filters-Output-Filters-and-Branching>

<@UHQ6BDUAX> or <@U03HQ088UKY> can’t you also pull out these nested fields using a transformation or in the response mapping of the lookup step?
For example if performing a lookup you can add
data.0.applications.0.applicationdetails (etc). And map it to [choose field id] and the response mapping will find the value nested within the array and expose it as a new parameter of the source record to be used in filters and branches?

You only couldn't if the step prior to the rule/filter is set to one-to-many. Your only option then would be a postResponseMap script on that prior lookup/import

thanks guys, finally have the time to jump back on this and i'm going to try both suggestions.  Appreciate the help.

<@U03HQ088UKY> made some progress, but the branching is working correctly.  When I preview, it looks like it will go to the right branch, but then it runs and goes to the other branch.  Not sure if Lorraine (from your support team) reached out, because we were trying to work on this together.  LMK if I can offer any other information about the issue.  Thanks!