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 JOIN transaction ON ( transaction.ID \u003d TransactionLine.transaction ) left JOIN PreviousTransactionLineLink AS PTLL ON ( PTLL.NextDoc \u003d TransactionLine.Transaction ) AND ( PTLL.NextLine \u003d TransactionLine.ID ) AND PTLL.linktype \u003d \u0027POrdReq\u0027 join account a on a.id\u003d transactionline.custcolaccount WHERE (TransactionLine.mainline\u003d\u0027F\u0027 and transaction.type\u003d\u0027PurchOrd\u0027 and transaction.status not in ( \u0027A\u0027,\u0027C\u0027 ) and BUILTIN.DF(transaction.custbodyunifier) \u003d \u0027Yes\u0027 and transaction.tranid in (\u0027\u0027))"}
Getting Error as shown below:. Please NOTE: It works absolutely fine next time when I trigger it.
Error:
HTTP 429, {"type":"https://www.rfc-editor.org/rfc/rfc9110.html#section-15.5.1","title":"Bad Request","status":429,"o:errorDetails":[{"detail":"Concurrent request limit exceeded. Request blocked. Verify your concurrency limits at Setup > Integration > Integration Management > Integration Governance.","o:errorCode":"CONCURRENCY_LIMIT_EXCEEDED"}]}