-
URGENT: Scheduled Script Running Infinitely – Need Immediate Help
Hi everyone, I’m facing a critical issue. One of my Scheduled Scripts is running infinitely, and I’m unable to stop it. It seems like the script is continuously rescheduling itself, and it's affecting system performance. I suspect the issue might be in the code where it is rescheduling itself without a proper stop…
-
Unable to filter supportCase records using lastModifiedDate via REST API
Hi, I am trying to pull data out based on the lastModifiedDate field using the REST API. I am successful on getting this to work for records such as salesOrders but when trying to do the same for supportCase records, I am getting the following response:…
-
Fail to fetch table "assemblyItemBom" through SuiteTalk
Our company uses Advanced Bill of Materials and we could not fetch any data by calling "bomAssembly" via either SuiteQL or SuiteTalk, table not found. I found the following post explaining the change, however, I still could not fetch data through the new provided table name "assemblyItemBom". I assume our company's profile…
-
Migrating NetSuite’s Database from Legacy to NS2: Challenges and Key Insights
Transitioning NetSuite’s database from the old version to NS2 is far from straightforward. As I discussed in my previous post, numerous variables come into play, including changes in field and table names and structural differences. Additionally, differing values within fields and table linkages necessary to retrieve data…
-
NetSuite Authentication Issue
I am an integration partner trying to connect to Netsuite's REST web service using PostMan. My role has all the required permissions (basically the same as admin), a bearer token has been issued and the integration has been set up as followsThe error message received when trying to connect is { "type":…
-
SuiteQL Query Tool questions
Hi, Mostly we are just querying Netsuite to get recent data to copy to our database. Main tables used are transaction - transactionline - transactionaccountline etc I have been doing most of my work using the REST API. Someone recommended this tool: SuiteQL Query Tool…
-
Trying to match a Netsuite search export count to rest api query count
Hi, I am trying to match a netsuite search export to rest api query in postman The netsuite report export finds 29 Records the REST API query funds 40 Records I can't figure out why the rest api has more? Company added a special text field to the transactionline table called 'custcol1'. This is the main field I search on.…
-
Unable to make REST Web Service suiteql work in Python
Trying out a suiteql query through the rest service and it does not appear to be working. I am trying the example as per: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_157909186990.html url_q = "https://xxxxxx.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=10&offset=10" header_q = {…
-
REST API - Getting back too many records - more than needed
Hi, When the client tells me there are just a small amount of records per day (less than 50), well, my rest api search is bringing back many hundreds instead. Example: SELECT * FROM transactionline tl, transaction t, subsidiary s WHERE t.trandate = '2/1/2021' and tl.transaction = t.id and s.name LIKE '%MYCOMPANY%' Not sure…
-
Need help with REST api queries and slowness
Hi, I can use some help working with the rest API queries and a slowness issue. Many of my queries happen quickly with no problems, however some of them are quite slow or seem to never complete. -> note: I do understand that select all "*" is a waste of resources and will slow down the process. Soon I will simply select…