Is it possible to list all subscriptions for a cus...
# suiteqle
Eystein Bye
03/19/2021, 12:39 PMIs it possible to list all subscriptions for a customer with suiteql ?
t
tdietrich
03/19/2021, 1:32 PMI think you'll find them in the CustomerSubscriptions table. There's also a ContactSubscriptions. (And the subscriptions themselves are in "Subscription.")
e
Eystein Bye
03/19/2021, 1:44 PMCustomerSubscriptions and ContactSubscriptions work 👍 But I dont have a table called Subscription
Eystein Bye
03/19/2021, 1:52 PMIs there any way I can list all tables? OA_TABLES does not work
t
tdietrich
03/19/2021, 2:38 PMNo, not yet. But you can use this technique to get to the same data that the Record Catalog uses: https://timdietrich.me/blog/netsuite-records-catalog-api/
The latest version of the SuiteQL Query Tool uses that to provide table info directly in the tool. Details are here: https://timdietrich.me/blog/netsuite-suiteql-query-tool-suitelet-update-20210316/
e
Eystein Bye
03/22/2021, 8:03 AMThank you @tdietrich 🙂
👍 1
6 Views