My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges

rco_joe Green Ribbon

Comments

  • Yep, I grab the web query using a php command like this which is still using the old url format, but it still works for now: $data = file_get_contents('https://system.na1.netsuite.com/app/reporting/webquery.nl?compid=.....); Then the script removes all the "<td>", "<tr>", "\n", "</table></body></html>", "<html><head><meta…
    in Run a report using suitescript Comment by rco_joe Jun 20, 2019 11:52AM
  • Sorry, I totally missed that important detail, none the less, I do have a solution for you that we use for reports. Have you used the excel query url for reports? Its pretty slick, I grab it with curl, then parse the saved text file easily with a php script to get it into a tab delimited file which i then use sqlldr to…
    in Run a report using suitescript Comment by rco_joe Jun 20, 2019 10:46AM
  • Wait a second here, its totally possible to retrieve a saved report and export it to a database using suitescripts 1.0 and I'm sure there are ways to do it in 2.0 as well. We do this on a hourly basis because of the limitations imposed on saved searches to not allow us to run nested queries. Google "NetSuite RESTlet Saved…
    in Run a report using suitescript Comment by rco_joe Jun 20, 2019 9:46AM