Hi All. Apologies if this is a repeat question as I am new to this Slack forum. Has anyone used the relatively new NetSuite REST API to pull data into a data warehouse? We have an issue in that the Refresh token cannot be refreshed itself and so it expires. Hence a human must re-authenticate every few days. Any other platform we have integrated with allows the regeneration of refresh tokens. Thanks

use Token-based Authentication (_*TBA*_) instead, it does not have an expiration date

@Paul Smullen My feedback has nothing to do with authentication, but... If you're going to be pulling a large volume of data (and I suspect you will be, because it's a data warehouse project), then you might want to consider using SuiteQL calls made via RESTlets. You'll be able to get larger responses (up to 5,000 rows at a time), and potentially more efficient responses as well. I wrote about that approach here: https://timdietrich.me/blog/netsuite-suiteql-restlet/

@Paul Smullen, save yourself time, money and frustration and talk to @Josh_SatoriReporting about using Tactical Connect. It'll be worth the 5 min chat.

@Paul Smullen we have both a saved search based connector and pre-built NetSuite data warehouse. Happy to chat further - feel free to shoot me a direct message if you are interested.

Thanks a lot for your feedback and ideas guys. We have built out a full integration to the REST API at Uniformity.io that can copy NetSuite data on a fully automated schedule to any database/warehouse. The page size is not an issue for us Tim -but thanks for the idea. We expect paging and our framework for all of our connectors works in the same way. The only nuisance with NetSuite is the Refresh tokens expiring - which is unlike any other OAuth integration we have done. The TBA approach may resolve that but then we need to manually set that up - whereas the OAuth can be fully self service from the customer side. Thanks again for the inputs.

The Three-Step TBA Authorization Flow is fairly similar to the oauth 2 code grant flow, major difference is the crypto that is used