my options are SOAP and SuiteScript, which one is the fastest and most reliable way to fetch calculated custom fields?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** Based on the conversations, both SOAP and SuiteScript can be used to fetch calculated custom fields from NetSuite. However, the choice between the two depends on your specific needs and comfort level with each method. SOAP, used with SuiteTalk API, can be a bit complex to set up, especially if you're new to it. It involves using NetSuite's WSDL, a large XML file that provides all the intellisense for making requests. However, once set up, it can be a powerful tool for fetching data from NetSuite. On the other hand, SuiteScript, especially when used with RESTlets, can be a simpler and more straightforward method to fetch data. It involves making regular REST requests, which can be easier to handle, especially if you're working with a JavaScript-based application. However, it's important to note that not all data might be accessible via RESTlets. For example, it was mentioned that there might not be a way to grab all the Custom Item Fields via a RESTlet. In terms of speed, one of the conversations suggested using a SuiteQL search for fetching custom fields from a native address record without loading the customer record. This might be a faster method compared to loading the entire record. In conclusion, both SOAP and SuiteScript have their pros and cons. The choice between the two would depend on your specific needs, the data you need to fetch, and your comfort level with each method.