Item table not showing through netsuite2.com Suiteanalytics Connect
Trying to synchronize BigQuery to Netsuite via the SuiteAnalytics Connect service, using the netsuite2.com data source.
However, the items table does not present itself as a source table which I can access.
I have access to many other tables, transaction, transaction_lines etc. – just not the items table.
Any suggestions as to why?
What role are you using to access the service?
Thank you,
I’m using the ‘Data Warehouse Integrator’ role.
Actually, how come it says FivetranRole in the list?
It transpires there was a ‘rogue’ global permission entry for the employee, who holds the Data Warehouse Integrator role, which was preventing access to the Items table,
Employee->Access->Global Permissions->Items:None
This global permission has been removed, and access to the Items list is now available through the SuiteAnalytics Connect.
Thanks for your assistance.
Nigel.