Bulk Insert query in postgres not inserting data SOLVED

App Building
1

I have a bulk insert query that passes an array of objects from a csv file into a table. I've used this same type of query a dozen or so times in retool and this one is not inserting any data and it isn't throwing any errors:

image
image1414×288 16.3 KB

image
image1144×238 10.3 KB

2

So it seems like the resulting {{ input.parsedValue }} is returning null. It is definitely a CSV file, column values match, no errant delimiters. Thoughts?

image

3

Okay - so I've passed the same file through a depracated file button and old query that is identically configured for the new query and it parses just fine:

image
image1204×256 28.9 KB

4

:man_facepalming: :man_facepalming:

Solved. The new component has a "parse file" toggle.

image