Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
NetSuite Rest API: Error intermittently
Hi Team,
I am trying to fetch data from NetSuite via REST API - 'Search Records'
AppName: Generic, REST Method Name: POST
REST URL: /services/rest/query/v1/suiteql
*** Payload Data:
{"q":"SELECT custcolaccount, transaction.id, transaction.trandisplayname, transaction.transactionnumber, transaction.tranid as po_number, BUILTIN.DF(TransactionLine.subsidiary) as subsidiary, transaction.custbody6 as header_memo, BUILTIN.DF(transaction.status) as status, BUILTIN.DF(transaction.custbodyunifier) as send_to_unifier, BUILTIN.DF(transaction.currency) as currency, transaction.employee as requestor_id, BUILTIN.DF(transaction.employee) as requestor, transaction.duedate as receive_by, transaction.entity as vendor_id, BUILTIN.DF(transaction.entity) as vendor, transaction.createddate, transaction.createdby as createdby_id, BUILTIN.DF(transaction.createdby) as createdby, to_char( transaction.lastmodifieddate, \u0027YYYY-MM-DD HH:MI:SS\u0027 ) as lastmodifieddate, transaction.lastmodifiedby as lastmodifiedby_id, BUILTIN.DF(transaction.lastmodifiedby) as lastmodifiedby, TransactionLine.uniquekey as line_uniqueKey, TransactionLine.id as po_line, BUILTIN.DF(TransactionLine.item) as item, BUILTIN.DF(TransactionLine.itemtype) as itemtype, TransactionLine.memo, TransactionLine.linesequencenumber, TransactionLine.quantity, TransactionLine.rate, nvl(BUILTIN.DF(TransactionLine.units),\u0027NA\u0027) as units, a.displaynamewithhierarchy as account, BUILTIN.DF(TransactionLine.custcolcostcode_farm_transline) as farm, BUILTIN.DF(TransactionLine.custcolsystem_transline) as system, BUILTIN.DF(TransactionLine.custcolcostcode_disc_transline) as discipline, TransactionLine.linelastmodifieddate, custcolrequiredbydate, TransactionLine.accountinglinetype, nvl(PTLL.previousdoc,\u00270\u0027) as PR_internal_id FROM TransactionLine INNER