Thread Discussion

Hey Chandler, Almost there! For a `location` field in HubDB, the correct format should be: ```json { "values": { "geo": { "lat": 41.8372...

You don’t need to include type and it should be name as lat for latitude lon for longitude measurements.

Hmm. I keep getting: "status": "error", "message": "Invalid value for location column `geo`: `{\"lat\":41.8372259,\"lon\":-85.6551229}`", "contex...

Can you try this? { "values": { "geo": "{\"lat\":41.8372259,\"lon\":-85.6551229}" } }

{ "status": "error", "message": "Invalid input JSON on line 1, column 559: Unrecognized character escape 'l' (code 108)", }

Hey @Chandler Ives — looks like the issue is due to improper escaping (possibly copy-pasting double-escaped strings). Here's a version that should wor...

I'm getting the unrecognized character escape error when I use this { "values": { "geo": "{\"lat\":41.8372259,\"lon\":-85.6551229}" } } Does...

Hey <@UJ3G9FH9U>, just to make sure we're on the same page could you please share the exact request body and the HubSpot API endpoint you're using? T...

Changing lng to long fixed it

Just wondering is this the final request " geo": {"type": "location", "lat": 41.8372259, "long": -85.6551229} "?

Yes!