The REST API details for fetching the locations list from the NetSuite account, we use the SQL query, and the details for that are given below:
The API type: POST
Endpoint URL: https://359045-sb1.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql
Request body: {
“q”: “SELECT * FROM location WHERE location.isinactive = ‘F'”
}