Skip to main content

Was trying to access the PricingGroup Table in Netsuite via SuiteQL and keep getting back this error: 
The query failed with the following error:\r\nUnable to retrieve columns for table PricingGroup].

Query for reference: 
 

{

    "query": "SELECT TOP 10 * FROM NetSuite7.Netsuite.PricingGroup"

}

I have been having this issue with several other tables and/or fields that just don’t seem to be accessible via SuiteQL. 


Another example is on the Item table I can’t return PurchaseUnit or StockUnit. 

 

Why isn’t everything just available and query able in SuiteQL? 

Hi ​@bgrassi,


The error "Unable to retrieve columns for table ePricingGroup]" indicates the driver was unable to retrieve the metadata for the table and can be caused by a different underlying issue or error. Regarding NetSuite, this error is frequently due to missing permissions for the authenticated user's role. Based on this list of necessary SuiteQL permissions, NetSuite: SuiteQL Tables & Permissions Reference, the PricingGroup table requires the "Setup - Accounting Lists" role permission. Additionally, the CData documentation below goes over the most commonly required permissions for NetSuite tables:

https://cdn.cdata.com/help/DNK/ado/pg_permissions.htm

Should an issue persist after confirming the user's role permissions, it would be best to review a log file to see the NetSuite API's response. If a different error is found in the logging, please send it to our support team for further review using the following link. The documentation below goes over generating log files: 

https://cdn.cdata.com/help/DNK/ado/pg_advancedlogging.htm

Please let us know how this helps.

CData's Winter 2025 Release
Terms and ConditionsCookie settings