Error when increasing limit in get rest call Sales Order for Account in CX

Summary:

Content (please ensure you mask any confidential information):

We try to get all the sales order data present in Order Management (OM) for customer account in CRM (Sales) using the REST API in Groovy using Application Composer.

"https://fa-enmh-test-saasfaprod1.fa.ocs.oraclecloud.com/fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub?q=BuyingPartyId" and print the value of the above-mentioned field, "Submitteddate," on a custom date field on the CRM Account profile page called 'Last Order Date'.

We were able to fetch the 25 records. So we are trying to get the latest order, and by increasing the limit to 1000 in Groovy, we were getting 500 internal server errors.