fix boolean coercion

icecrasher321 · icecrasher321 · commit df918194cf63 · 2026-03-16T16:23:16.000-07:00
diff --git a/apps/sim/app/api/table/import-csv/route.ts b/apps/sim/app/api/table/import-csv/route.ts
@@ -123,7 +123,9 @@ function coerceValue(value: unknown, colType: ColumnType): string | number | boo
     }
     case 'boolean': {
       const s = String(value).toLowerCase()
-      return s === 'true'
+      if (s === 'true') return true
+      if (s === 'false') return false
+      return null
     }
     case 'date': {
       const d = new Date(String(value))

Original file line number	Diff line number	Diff line change
`@@ -123,7 +123,9 @@ function coerceValue(value: unknown, colType: ColumnType): string \| number \| boo`
`123`	`123`	`}`
`124`	`124`	`case 'boolean': {`
`125`	`125`	`const s = String(value).toLowerCase()`
`126`		`- return s === 'true'`
	`126`	`+ if (s === 'true') return true`
	`127`	`+ if (s === 'false') return false`
	`128`	`+ return null`
`127`	`129`	`}`
`128`	`130`	`case 'date': {`
`129`	`131`	`const d = new Date(String(value))`