Creating a valid JSON from a dataframe

[kovar-ursa]

I have a pandas dataframe with 'latitude' and 'longitude' columns in it. I'd like to convert this into an appropriate JSON payload for the POST API using the Python requests library. Try as I might, I keep getting an "invalid JSON" error message.

Does anyone have example code for doing this?

Thank you.

[kovar-ursa]

temp = df[['Latitude', 'Longitude']]
temp = temp.rename(columns={"Latitude": "latitude", "Longitude": "longitude"})
temp = temp.head(100)
result = temp.to_json(orient="records")
parsed = json.loads(result)
input_json = {"locations": parsed }
response = requests.post('https://api.open-elevation.com/api/v1/lookup', json = input_json)

This worked.