The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
OneStream - NetSuite
Looking for others experiencing issues getting a YTD dataset out of NetSuite for loading into OS. Also looking to connect with other users who use NetSuite for the ERP and OneStream for planning. ...
Yeah, have utilised the REST API in the past to integrate with NetSuite although not from OneStream. From memory one of the challenges was NetSuite timing out queries if they took too long and I think possibly lowering that timeout at some point. This was a while ago though.
The trick with the RestAPI is to launch a SuiteScript that contains the query in it instead of just launching a query. The queries take a long time but when you do it through a SuiteScript the response time is much faster. Point being that the timeout issue can be mitigated.
