Bulk Insert with Transformer Mysql

Queries and Resources
, ,
1

Hey - I am trying to do a Bulk insert records - but I am unable to see this mentioned in the retool docs anywhere!!

I do a bit of transformation before attempting to insert. One of the user inputs is a multiselect, hence I need to unpack it into single rows for the db.

My code and transformer is :point_down:

Screen Shot 2022-09-15 at 11.22.37 am
Screen Shot 2022-09-15 at 11.22.37 am1760×1458 294 KB

When I Run this I am faced with the good old, uninformative error of records.map is not a function. I have tried different return types in my transformer. My datatypes are 100% correct for the table I am inserting into.

Screen Shot 2022-09-15 at 11.23.14 am
Screen Shot 2022-09-15 at 11.23.14 am732×534 32.7 KB

Any help would be great.

2

Hello @BKM
The easiest way to handle this would be for us to look at your data and figure out what the code is doing.

Please could you email us at support@retool.com or start a chat with support:

Thanks

3