Hi, I need to extract some values from netsuite to a data warehouse. The contractor do not want to use ODBC to collect data, so I have set up a solution to extract data by using REST API/webservice. However, I have realized that using the REST API endpoints (https://system.netsuite.com/help/helpcenter/en_US/APIs/REST_API_Browser/record/v1/2020.1/index.html) is way to slow relative to the amount of data I am dealing with. I can collect data though suiteql query using /services/rest/query/v1/suiteql, but I am having trouble deciphering the custom fields of the table. The returned json file contains f.ex. custbody_sta_einvoicin#_20. These custom fields are not mentioned in the analytic browser(https://5157020-sb2.app.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/analytics/record/transaction.html). I could manually decipher them by comparing the result to the output of the REST API endpoints, but that would be a very poor solution. Anyone who has any experience in extracting custom fields from Netsuite?

@Sturla Svendsen, Tactical Connect will do exactly what you need

Happy to help! @Sturla Svendsen would you like to chat further?

@darrenhillconsulting, @Josh_SatoriReporting, thank you for you interest in the matter. The contractor prefers to solve this without using third-party connectors, so it is unfortunately not an option

Okay, thanks for the reply