Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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