Issues sending SQL data to API
I’m developing a Javascript script to retrieve delivery data from an SQL database and use it to create a delivery route using the Navixy API.
After connecting to the SQL database, a function retrieves delivery records from the SQL database’s Deliveries table. The retrieved data is then used to create a delivery route using the createDeliveryRoute function.
When I run my script, I get no error, but no route is created.
Converting mysql UTC time field in JS?
I’m having trouble understanding where I’m going wrong in calculating a date/time difference. It seems to stem from timezone difference, but it’s not clear where the issue is. Below are all the pieces. Where did I go wrong? Thanks!