# Netsuite ODBC Driver missing fields in table

**URL:** <https://community.cdata.com/t/netsuite-odbc-driver-missing-fields-in-table/224>\
**Category:** CData Drivers\
**Tags:** question, driver, netsuite\
**Created:** [June 28, 2023, 1:20am UTC](https://community.cdata.com/t/netsuite-odbc-driver-missing-fields-in-table/224 "2023-06-28T01:20:37Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![luisjacobo](https://avatars.discourse-cdn.com/v4/letter/l/bc79bd/32.png) [@luisjacobo](https://community.cdata.com/u/luisjacobo)\
**Post date:** [June 28, 2023, 1:20am UTC](https://community.cdata.com/t/netsuite-odbc-driver-missing-fields-in-table/224/1 "2023-06-28T01:20:37Z")

</div>

Hi, I am trying to use the NETSUITE ODBC driver within Visual Studio SSIS project, everything connects good but when selecting some tables, I noticed that there are some missing fields in the table, for example in the table item, the field subsidiary is missing:

 ![2911290f-acc0-4811-aebb-e16f5b0c22d9.png](https://us1.discourse-cdn.com/cdata/original/1X/2254848b2e9395100034f1e7baa9b7efca970f8a.png)

But in the log file, the json has it:

 ![f65c6868-3e7b-41a4-866f-4afa952cd71e.png](https://us1.discourse-cdn.com/cdata/original/2X/b/b5de4693524a3e593fadefb8995c05357f23cdd5.png)

Should I need to set something else in the configuration?

How can I solve this?

Thanks.

---

<div class="post-metadata">

**Author:** ![Elizabeth\_G](https://avatars.discourse-cdn.com/v4/letter/e/6bbea6/32.png) [@Elizabeth\_G](https://community.cdata.com/u/Elizabeth_G)\
**Post date:** [June 28, 2023, 7:14pm UTC](https://community.cdata.com/t/netsuite-odbc-driver-missing-fields-in-table/224/2 "2023-06-28T19:14:16Z")

</div>

@luisjacobo Thank you for reaching out. As this issue appears to be more technical, could you please reach out to [support@cdata.com](mailto:support@cdata.com) to create a support case, so we can review the logging?

When testing this on my end, I was able to reproduce this behavior with SuiteQL’s item table. However, it does not appear that Subsidiary is showing up in the HTTP response, so it would be helpful to have a logfile to investigate why this is occurring.

---

<div class="post-metadata">

**Author:** ![luisjacobo](https://avatars.discourse-cdn.com/v4/letter/l/bc79bd/32.png) [@luisjacobo](https://community.cdata.com/u/luisjacobo)\
**Post date:** [June 28, 2023, 7:16pm UTC](https://community.cdata.com/t/netsuite-odbc-driver-missing-fields-in-table/224/3 "2023-06-28T19:16:43Z")

</div>

Log file attached.

---

<div class="post-metadata">

**Author:** ![anonymous](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@anonymous](https://community.cdata.com/u/anonymous)\
**Post date:** [June 28, 2023, 7:23pm UTC](https://community.cdata.com/t/netsuite-odbc-driver-missing-fields-in-table/224/4 "2023-06-28T19:23:49Z")

</div>

Due to sensitive nature of log files we would rather you send directly to support, thanks.

---

<div class="post-metadata">

**Author:** ![luisjacobo](https://avatars.discourse-cdn.com/v4/letter/l/bc79bd/32.png) [@luisjacobo](https://community.cdata.com/u/luisjacobo)\
**Post date:** [June 28, 2023, 7:25pm UTC](https://community.cdata.com/t/netsuite-odbc-driver-missing-fields-in-table/224/5 "2023-06-28T19:25:50Z")

</div>

Thanks John, I’m sending it through email.