Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
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