Why geolocation data type data is not updating in the target org?


Question.

I am trying to migrate data of Lat_and_Long__c custom field (it's of Geolocation field type ) from one org to another org, but Lat_and_Long__c field data not updating in the target org.

What's wrong ?

My export.json:

{
     "query": "SELECT Name, Lat_and_Long__c from Account",
     "operation": "Upsert",
     "externalId": "Name"
}

Answer.

The proper query for the custom geolocation field Lat_and_Long__c is:

SELECT Name, Lat_and_Long__Latitude__s, Lat_and_Long__Longitude__s FROM Account
Last updated on 17th May 2023