Question

PostgreSQL error: psycopg2.errors.InvalidTextRepresenstation malformed array literal: "testname@email.com" LINE 3

  • 28 July 2023
  • 1 reply
  • 481 views

Hello,

I am new to Zapier, and I was trying to connect my JotForm submissions to my Postgres DB to directly get the submissions into Postgres DB as new row entries. But I’m not able to connect them properly.
I would appreciate any help on this matter.

I’m not able to find what to input in rows and ID column,
I even tried inputting an extra step which I’ve also added below in the screenshot
 

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @pbrightfarms 

Good question.

Looks like you have a malformed query.

Check the field description for guidance in the Zap Editor.

 

 

Existing columns causing an error when using Custom Query

Double-check if your column names contain any uppercase characters. This will cause an error, as by default they are converted to lowercase. To fix your query, you’ll need to wrap the column name in double quotes.

In the example below, you’ll want to put double quotes around the column named myStatus.
SELECT id, “myStatus” FROM my_table LIMIT 50;