Hi
I have a few questions about retrieving data from a Netsuite integration (I have tried searching the help documentation though couldn't find the answers)
- I can see that it is possible to retrieve a saved search's results with, for example, SOAP. However, I have found a number of Google results saying it is not possible to retrieve results which are grouped (sum, count, max,etc) or in formula columns. Is that correct?
- An alternative to 1. suggested is to save the results of a saved search to a csv file in the filing cabinet and for the SOAP webservices to retrieve that
a. Is that possible?
b.. Would the webservices request be retrieving the file as an object or would it be reading its contents?
3 if the method in 2. is used, is there a way to trigger a map reduce or scheduled script from the webservices call so that the information in the csv file is updated in real time?
e.g. On an external website (which is integrated to Netsuite), a user selects a customer name (the search's filter parameter)
--. This sends a request to Netsuite to retrieve data for the customer
--> This triggers a map reduce or scheduled script which exports an existing saved search's results to a csv file that is saved to the filing cabinet
--> The data from the file in the filing cabinet is returned as a 'response' to the webservice request and the data retrieved from the csv file is displayed on the website
Is this possible?
4 As another alternative, is it possible for SOAP webservices to retrieve data from a suitelet? (which is displaying the search results)
Thanks