# \#suiteql

**URL:** https://community.cdata.com/tag/suiteql/181.md

[Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md)

---

## [Important Update: NetSuite SuiteQL Schema Changes](https://community.cdata.com/t/important-update-netsuite-suiteql-schema-changes/1123)

<div class="topic-metadata">

**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\
**Replies:** 0\
**Last updated:** [June 30, 2025, 12:07pm UTC](https://community.cdata.com/t/important-update-netsuite-suiteql-schema-changes/1123 "2025-06-30T12:07:25Z")

</div>

Action Required: This update affects customers using NetSuite SuiteQL schema. SuiteTalk schema users are not impacted. Summary We are notifying CData customers of critical changes to NetSuite SuiteQL Schema due to NetSu…

---

## [Encountering "Unable to retrieve columns for table \[tablename\]" error when querying invoice and timeentry tables within NetSuite's SuiteQL schema](https://community.cdata.com/t/encountering-unable-to-retrieve-columns-for-table-tablename-error-when-querying-invoice-and-timeentry-tables-within-netsuites-suiteql-schema/1050)

<div class="topic-metadata">

**Author:** [@matthewr](https://community.cdata.com/u/matthewr)\
**Replies:** 1\
**Last updated:** [March 12, 2025, 9:42pm UTC](https://community.cdata.com/t/encountering-unable-to-retrieve-columns-for-table-tablename-error-when-querying-invoice-and-timeentry-tables-within-netsuites-suiteql-schema/1050 "2025-03-12T21:42:38Z")

</div>

When executing queries on either of the invoice or timeentry tables in the SuiteQL schema within your NetSuite connection, you may receive the following error, replacing \<tablename\> with the name of the table being queri…

---

## [NetSuite - Custom Entities and Custom Events Missing when using SuiteQL Schema](https://community.cdata.com/t/netsuite-custom-entities-and-custom-events-missing-when-using-suiteql-schema/465)

<div class="topic-metadata">

**Author:** [@IrdiD](https://community.cdata.com/u/IrdiD)\
**Replies:** 0\
**Last updated:** [October 17, 2023, 7:19pm UTC](https://community.cdata.com/t/netsuite-custom-entities-and-custom-events-missing-when-using-suiteql-schema/465 "2023-10-17T19:19:09Z")

</div>

Due to the way that NetSuite handles metadata using SuiteQL’s native tables (i.e. it isn’t provided), there is currently no API-provided way to determine the correct custom field(s) / metadata available for tables with i…

---

## [Seeing NULL data points where there should be dates?](https://community.cdata.com/t/seeing-null-data-points-where-there-should-be-dates/225)

<div class="topic-metadata">

**Author:** [@Theo](https://community.cdata.com/u/Theo)\
**Replies:** 0\
**Last updated:** [June 28, 2023, 9:28pm UTC](https://community.cdata.com/t/seeing-null-data-points-where-there-should-be-dates/225 "2023-06-28T21:28:35Z")

</div>

When using a CData NetSuite connector for a NetSuite data source, you may encounter NULL data values that correspond to Date fields in your original data. This has been seen occurring when using the SuiteQL API in partic…