Please post code - not pictures of code (unless the context is important, in which case post both) so we can copy them for testing or modification. Please see Wiki - how to post code on this forum.
Don't logger.error("some error" + str(e) - you lose the except trackback and cause information, the most valuable part.
Use logger.error("Some error", e), so that the exception goes through the automatic logging machinery and captures the stacktrace.
Additionally, stuff this script into a Project Library Script and put the initialization of the httpClient outside of any function definitions so you can reuse the same client instead of spawning a new one every time the function runs.
Something along the lines of:
import json
logger = system.util.getLogger("SmartSheetUpdate")
SHEET_HEADERS = {}
SHEET_URL = "https://some url here"
sheetClient = system.net.httpClient()
def abc(payload):
""" """
response = sheetClient.get(url=SHEET_URL, headers=SHEET_HEADERS)
Once in a project library, you may want to install my Integration Toolkit and do this:
@system.util.runInGateway
def abc(payload):
...
... so you can call it in the designer but it will run in the gateway. And you'll likely be able to see what is wrong.
(Designer scope is a variant of Vision Client scope--not related to Gateway Scope at all.)
Where do I find this integration toolkit?
I did this definitely much easier
And then to my Module Sales page. (But this one is free.)
My issue is our network firewall.