How can I increase the limit in the API? I need 5000 rows per request, but when I try to increase the limit, I'm getting this error. "o:errorDetails": [ { "detail": "The specified query parameter 'limit' is out of bounds. Provide value between 1 and 1000.", "o:errorQueryParam": "limit", "o:errorCode": "INVALID_PARAMETER" }

You can page the request with

runSuiteQLPaged

A simple example

let arrResults = []
const q = "SELECT ...."
let objIterator = query
    .runSuiteQLPaged({
        query: q,
        pageSize: 1000,
    })
    .iterator()

objIterator.each(function (page) {
    var objPage = page.value.data.iterator()

    objPage.each(function (row) {
        arrResults.push(row.value.asMap())
        return true
    })

    return true
})
return arrResults

https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_157960586441.html#subsect_157960586910