topic Re: Python Payload WHERE clause syntax error in Python Questions

Python Payload WHERE clause syntax error

kapalczynski — Fri, 19 Jan 2024 15:27:28 GMT

I am creating a data parameter to pass to my Rest Service to Delete a bunch of records.

This works great on my laptop via VPN into my work servers

When a DBA runs this from the server itself I get a syntax error on the WHERE clause... I am very puzzled... wondering if anyone has seen this before...

Again it runs fine from my computer but its not on the server....

whereclause='1=1' gis_payload = { 'token': portaltoken, 'f': 'json', 'where': f'''{whereclause}''' } print(gis_payload) response = requests.request("POST", url=url, data=gis_payload)

When I print the gis_Payload variable it looks good to me...

{'token': 'LRbp-wYEmcO_OFXps89bFEt3HZX34KhpqEAIWJeZE7rgxULrvuAFsSp-cqpkaB74K5ccaDNzjlXuYYCn33cyknr1Vo6', 'f': 'json', 'where': '1=1'}

Re: Python Payload WHERE clause syntax error

JohannesLindner — Fri, 19 Jan 2024 17:15:15 GMT

Is there any reason to use an f-string here? Does this work?

whereclause='1=1' gis_payload = { 'token': portaltoken, 'f': 'json', 'where': whereclause } print(gis_payload) response = requests.request("POST", url=url, data=gis_payload)

Re: Python Payload WHERE clause syntax error

kapalczynski — Fri, 19 Jan 2024 17:34:34 GMT

I will check... I converted to this before I saw your responce

whereclause="{}".format("1=1") gis_payload = { 'token': portaltoken, 'f': 'json', 'where': whereclause }