When I’m trying to use Execute Anonymous with a large chunk of code, the following error pops up:
Line: undefined, Column: undefined
Response to EXEC was : . HTTP CODE[414]
(414 stands for Request-URI Too Long)
Sometimes I just need to remove a few tabs and line breaks to make the request short enough. Is there any way to bypass this limitation, or maybe there is another way to quickly execute a script without creating a new class?
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
The Developer Console is using the REST version of the Tooling API to perform the execute anonymous call. The length issue is a restriction of how the call encodes the apex into the URL.
/executeAnonymous/?anonymousBody= <url encoded body>
It is URL encoding your Apex onto the query string. Clearly there are limits to how long this can be.
I found a few viable alternatives.
- Create a temporary Apex class with the anon Apex in a static method. Then call that static method from Anon Apex. This works, but kind of defeats the purpose of anon apex.
- Use a tool (or direct call) that runs the Anonymous Apex via the SOAP API. The SOAP API puts the anonymous Apex in the SOAP POST request, so it doesn’t care what the length is (beyond the Apex upper limits on class size).
- You can also run Anonymous Apex code via the older Apex SOAP API.
Method 2
You can also save the anonymous apex into a file and run it via the CLI. Sample command:
sfdx force:apex:execute -f "C:tempMyApexScript.apex" > result.log
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0