Try replace $record.entity.internalId with $baseRef.internalId.
Hello, SpiroTaleski $baseRef.internalId should be used if I want to get data of an object based on internalId field of that object. However, in my use case, I want to get data of an object not based on internalId field but on some other field of the same object which is why I was trying with $record.entity.internalId But when I try to do that pipeline fails (INVALID_KEY_OR_REF)
Then try with NetSuite Search Snap . This snap allows querying by various fields(that you will see in the target schema), depending on the object.
SpiroTaleski As I had mentioned in my first post I tried with NetSuite Search SNAP but here I am not sure what exact expression I can pass in input Mapper for NetSuite search to only get the specific record, because if I try Expression as {} and Target path as $searchRecord then it returns almost everything, however, I only want specific record & fields.
So I tried the below mapping, but then I got the error: INVALID_SEARCH_OPERATOR, platformCore:message=You need to provide a valid search field operator
