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
Hi
Good question.
Looks like you have a malformed query.
Check the field description for guidance in the Zap Editor.
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;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.