For the past week, I have been receiving a 500 server error when attempting to use the Google Sheets node inside an iterator with approximately 30 iterations. I have even manually added some javascript inside the iterator to delay 3 seconds each time, in case it was a rate limit I was hitting.
Error Message:
exec command error: request to pd server code 500 error: Error: "<!DOCTYPE html>\n<html lang=en>\n <meta charset=utf-8>\n <meta name=viewport content=\"initial-scale=1, minimum-scale=1, width=device-width\">\n <title>Error 502 (Server Error)!!1</title>\n <style>\n *{margin:0;padding:0}html,co [...truncated...] px;width:150px}\n </style>\n <a href=//www.google.com/><span id=logo aria-label=Google></span></a>\n <p><b>502.</b> <ins>That’s an error.</ins>\n <p>The server encountered a temporary error and could not complete your request.<p>Please try again in 30 seconds. <ins>That’s all we know.</ins>\n"
Update: think it is a rate limit issue. Increased the timeout between iterations to 5 seconds and seems to be working OK now, but takes longer for the full scenario to complete.
Would be great if LateNode had better logic for error handling within the iterator. I.e. wait 10 seconds and try again, or try 3 times before stopping the entire scenario.
Hey! I was just about to write to you, but you already answered Usually, this happens due to timeouts. In these situations, it’s a good idea to add a ‘Wait’ node for 3-4 seconds, which solves most similar issues.
As for improved error handling, the developers are currently in the process of planning that feature. I believe we’ll see something along those lines relatively soon.