unexpected number in JSON at position X when running query for map vis #1551
Description
We encountered an issue while fetching the underlying data of a map vis:
The issue is that the response of the looker api contains invalid JSON objects for the field users.approx_location which fails to be parsed using the typescript sdk.
I tested it on the API Explorer on the looker website and I saw that the data looks like this:
which obviously is not a valid object.
Is this a known issue and does it apply to all map vises or is it just an isolated issue that is related to the sample data for partner instances?
Edit
I tested both
GET /queries/49/run/json_bi
and
POST /queries/run/json_bi
and both returned the same bad data
Part of data:
...
"rows": [
{
"users.approx_location": {
"value": 33.8,
-118.3
},
"users.country": {
"value": "USA"
},
"order_items.order_count": {
"Female": {
"value": "730"
},
"Male": {
"value": "824"
},
"null": {
"value": null
}
},
"users.count": {
"Female": {
"value": "643"
},
"Male": {
"value": "682"
},
"null": {
"value": null
}
},
"order_items.total_sale_price": {
"Female": {
"value": "$39,194.18"
},
"Male": {
"value": "$46,958.68"
},
"null": {
"value": null
}
},
"order_items.average_spend_per_user": {
"Female": {
"value": "$60.96"
},
"Male": {
"value": "$68.85"
},
"null": {
"value": null
}
}
},
{
"users.approx_location": {
"value": 33.8,
-118.3
},
"users.country": {
"value": "USA"
},
"order_items.order_count": {
"Female": {
"value": "698"
},
"Male": {
"value": "506"
},
"null": {
"value": null
}
},
"users.count": {
"Female": {
"value": "610"
},
"Male": {
"value": "453"
},
"null": {
"value": null
}
},
"order_items.total_sale_price": {
"Female": {
"value": "$36,832.17"
},
"Male": {
"value": "$26,203.86"
},
"null": {
"value": null
}
},
"order_items.average_spend_per_user": {
"Female": {
"value": "$60.38"
},
"Male": {
"value": "$57.85"
},
"null": {
"value": null
}
}
},
...