Formatting data from a SQL query to pass into the Mapbox Map component's Points field

App Building
1

I have an SQL query returning latitude and longitude values but I wonder if the formatting is incorrect. My array returns with double quotes and does not populate the map. Any suggestions?
image
Array Returned in this format: [
[
{
"Latitude": "37.9515395692405",
"Longitude": "-121.955457021247"
},
{
"Latitude": "38.3607843262217",
"Longitude": "-121.989967876263"
},
{
"Latitude": "38.3607843262217",
"Longitude": "-121.989967876263"
},

2

Could it be your lat lon are backwards?

1 Like
3

I would take your actual output and try it. It's probably the quotes and the lat lon being backwards.

1 Like
4

That component expects lowercase key names. Change your names to latitude and longitude.

1 Like