any information about querying the OPPORTUNITY tab...
# ask-stanley-ai
v
any information about querying the OPPORTUNITY table or record type using NETSUITE2?
c
AI generated answer (using internal Slack threads):
Based on the conversations, you can query the OPPORTUNITY table or record type in NETSUITE2 by using SuiteQL and selecting from the Transaction table where the type is 'Opprtnty'. Here is the SQL query you can use:
Copy code
SELECT * FROM Transaction WHERE Type = 'Opprtnty'
Please note that the account you're using needs to have permissions on: Transactions > Opportunity. As for the multiselect fields on custom records, it seems there might be some issues with them returning a 500 error. However, it's not clear from the conversations whether this is a known limitation or if there's a different way to request multiselect fields. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.826809347
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.818660736
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.817486227
Please provide your feedback on this answer.