for anyone who uses AWS RDS Data API, does anyone know what “BadRequestException: Cannot find parameter: 13” could possibly mean? I logged the raw SQL, copied & pasted that into my PG client and ran it.. no problem inserting the data.
t
thdxr
02/22/2022, 6:17 PM
I've seen that error when I include a parameter in the sql but forget it in the params object
s
Sam Hulick
02/22/2022, 6:18 PM
yeah, that’s what I thought too. but I added logger middleware to RDS in the SDK, and the insert statement works fine
Sam Hulick
02/22/2022, 6:19 PM
maybe there’s a weird stray question mark and RDS is confusing that for a param
Sam Hulick
02/22/2022, 6:20 PM
nah.. that can’t be. this is the raw SQL. unless I’m confused about how this works
Sam Hulick
02/22/2022, 6:23 PM
although.. normally I’m inserting data into 12 columns. so there is something strange going on