POST https://{ACCOUNT_ID}.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=100&offset=0
{
“q” : “SELECT BUILTIN_RESULT.TYPE_STRING(TRANSACTION.id) AS internalid FROM TRANSACTION, transactionLine WHERE TRANSACTION.ID = transactionLine.TRANSACTION AND ((transactionLine.subsidiary IN (‘x’) AND TRANSACTION.TYPE IN (‘<transactiontype> ex:PurchOrd‘) AND TRANSACTION.createddate BETWEEN TO_TIMESTAMP('2024-05-15 23:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_TIMESTAMP('2024-05-16 23:00:00', 'YYYY-MM-DD HH24:MI:SS') AND transactionLine.mainline = ‘T’)) ORDER BY TRANSACTION.id DESC”
}