Upsert to retool database gives an error - null value in column \"id\" of relation \"eandata\" violates not-null constraint"

Queries and Resources
1

Hi All,

trying to figure out what is going wrong here, it worked one time but after that I always get this error. Seems a bit weird because there are no records with a null value in the column ID

So I have a query that gets data from a rest api, the result is flattened with query 6, then I want to push all the data to my retool database and I get this error.

image
image1154×618 95.7 KB

2

Is there a column in the data you're upserting that is missing information and the column in the db cannot be empty?