Skip to main content
Solved

Netsuite connection via SuiteQL not about to query PricingGroup Table

  • April 14, 2025
  • 1 reply
  • 53 views
B
Forum|alt.badge.img

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? 

Best answer by Cameron L

Hi ​@bgrassi,


The error "Unable to retrieve columns for table [PricingGroup]" 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.

    This topic has been closed for replies.

    1 reply

    C
    Forum|alt.badge.img+1
    • Cameron L
    • Employee
    • Answer
    • April 15, 2025

    Hi ​@bgrassi,


    The error "Unable to retrieve columns for table [PricingGroup]" 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.

      The 25% Accuracy Gap: MCP Provider Performance Across Enterprise Workloads
      Terms and ConditionsCookie settingsAccessibility statement