Excel ODBC connection through SuiteConnect unable to bring in newly created custom records, custom fields, and custom search.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the issue of not being able to bring in newly created custom records, custom fields, and custom search through Excel ODBC connection via SuiteConnect could be due to a few reasons: 1. Permissions: Ensure that the user account associated with your ODBC connection has the necessary permissions to access the custom records, custom fields, and custom search. You can verify this by going to the role assigned to the user in NetSuite and checking if the required permissions are granted. 2. SuiteQL: If you have access to SuiteQL, you can check if the custom fields are showing in

OA_COLUMNS

by running a query like this:

SELECT * FROM OA_COLUMNS WHERE COLUMN_NAME = 'your_field_id'

. Replace

'your_field_id'

with the ID of your custom field. 3. Schema Introspection: You can use a UI that introspects the schema for you, such as DataGrip, or use the

OA_TABLES

view which lists all tables. This can help you see your custom fields name to create an ODBC SQL. Remember, generic NetSuite documentation will not include your customizations, so you'll need to explore these options to access your custom fields and records. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******