I am working with a customer and facing some issue while querying the saved search in NetSuite via Boomi.
I was following the thread https://community.boomi.com/people/atul.gupta538842 and having a little similar issue. I am able to get the results when the saved search has standard fields but failing the moment saved search is updated to include GroupBy for fields and sum of Transaction|Amount. The error I am getting is below:
NetSuite Sandbox 1 connector: com.boomi.connector.api.ConnectorException: Error Received during Netsuite Query
Message: We cannot return search columns for summary saved search 242.
Just to mention that the USER is admin and having all permissions on saved search (configured as PUBLIC) access.
- Does anyone has any solution around this?
- Is this our connector’s limitation (We cannot return search columns for summary saved search 242) when we define GroupBy fields and summary of amount in saved search?