Hi, has anyone tried using python to get data from...
# suiteanalytics
r
Hi, has anyone tried using python to get data from Netsuite savedsearch into a csv or json file?
c
I’d have to ask why, when you can do it natively in NetSuite
r
Right, but we are trying to automate the process of extracting the data into an s3 bucket so we can use it for analytics, so looking at python program to read from savesearch and write to S3
c
You can do it using suitescript. You can upload to a s3 bucket with a simple POST request
r
ah ok, do know if there is a document or example of this?
c
https://docs.aws.amazon.com/AmazonS3/latest/API/sigv4-post-example.html you’d have to obviously take the form in the example and convert the params to something https.post likes, but shouldn't take too long. There's a https.post example here: https://stackoverflow.com/questions/41178188/netsuite-schedule-a-saved-search-and-http-post/41185950
Combine that with a scheduled job to do the extract and you're sorted
r
thanks!!
j
www.tacticalconnect.com automatically exports saved searches to S3 buckets.
r
it'l be great if you can add model for quicksight reports as well from netsuite data