Trying to insert spatial point data into our MySQL database with ST_PointFromText('POINT(-80.2143 26.0252)')
and Retool keeps adding apostrophes into the output, crashing the insert command.
MySQL 5.7
Code that executes properly on phpMyAdmin:
Code on Retool (I gave up on trying key value pairs via GUI as it interprets ST_PointFromText as a string):
Error output from Retool:
The JS Transformer code is below. I've tried this a few ways - trying to build the "ST_PointFromText" into the transformer output, but nothing seems to work right.
If I hard code the lat/long into the Retool code, it executes properly.
Any ideas as to why I'm getting apostrophes added to the output and how to prevent it from happening?