-
-
Save TheMuellenator/974c39779ec516c4c60e918c001e48ba to your computer and use it in GitHub Desktop.
#No Authentication | |
sheet_response = requests.post(sheet_endpoint, json=sheet_inputs) | |
#Basic Authentication | |
sheet_response = requests.post( | |
sheet_endpoint, | |
json=sheet_inputs, | |
auth=( | |
YOUR USERNAME, | |
YOUR PASSWORD, | |
) | |
) | |
#Bearer Token Authentication | |
bearer_headers = { | |
"Authorization": f"Bearer {YOUR TOKEN}" | |
} | |
sheet_response = requests.post( | |
sheet_endpoint, | |
json=sheet_inputs, | |
headers=bearer_headers | |
) |
{'sheet1': {'id': 3}} i get this output but my spreadsheet didn't change?????
id is an "extra data point" that sheety will generate. It won't be part of the column names you are trying to populate.
Ladies and gentlemen
@shoaibkhan5676 @Sir-AryanG-NTfV @MahalakahmiMallela and everyone else
for debugging :
-
Check first that you have actually created a new sheet to be able to edit it, not the one provided by angela.
-
Once you create the sheet make sure you add the headers ( date , time , exercise,duration, calories ) so that it will be able to update and avoid giving you (undefined 0 ) and other error {
"sheet1": {
"id": 2
}
} -
most importantly remember to change the ""workout stated in angela sheet """ in the for loop .
for exercise in result["exercises"]:
sheet_inputs = {
here instead of workouts place the name of your sheet, sheet1 in my example. "sheet1": {
"date": today_date,
"time": now_time,
"exercise": exercise["name"].title(),
"duration": exercise["duration_min"],
"calories": exercise["nf_calories"]
I think anyone who has the error of unauthorized can check both requests of the first post and the second get, if one of the request you forget to paste auth or token, you will get the error. PLS CHECK THE BOTH REQUESTS!
Yes.