AnsweredAssumed Answered

Netsuite Query Code: INVALID_SAVEDSEARCH

Question asked by somesh_sharma702004 on Nov 7, 2017

Friends,

 

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

Code: INVALID_SAVEDSEARCH

Type: ERROR

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?

Outcomes