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

In RESTlet script, I am trying to preform simple search for customer by custom field, but when I am execute the script I get 0 results, when I try same code on console I get results, I have the relevant premission for customer list, what else should i look for?

Do you want to share your code incase it's not the search but the flow/logic, fresh eyes may help

``` let customerSearch = search.create({
                    type: 'customer',
                    filters:
                        [
                            ["custentity12", "is", customerSfdc]
                        ],
                    columns:
                        [
                            search.createColumn({name: "internalid", label: "Internal ID"})
                        ]
                });
                let customerResults = customerSearch.run().getRange(0, 1);```

and you have output the value of "customerSfdc" to know that's correct?

maybe try removing the filter to see if it returns anything.

maybe its something in premissions of the role

but you get no permission violation right?

I would have thought you'd have an error if it was permissions

<@UA4ATEE59> so I have found the problem, its was with the role subsidiaries, I switched ACCESSIBLE SUBSIDIARIES to ALL instead of USER SUBSIDAIRY

becouse the user subsidairy is parent company and the customer are not

Glad you got this sorted, it's curious to me that you had no role specific error message :thinking_face: