Day 38 Step 5 L335 - Solution

main.py

#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
)

{'errors': [{'detail': 'The caller does not have permission'}]}
Please how do I rectify this, anyone?

please share your code.

Solution: First make a copy of the sheet with a new name and then make sure that the email id used for logging to google sheets is the same in sheety as well.
This should help rectify the problem.

solucao desse erro
User
{
"errors": [
{
"detail": "The caller does not have permission"
}
]
}

Process finished with exit code 0

solucao pra mim
pra quem ta tendo esse erro simples apague seu projeto atual da API sheety cria uma nova planilha ou copia da angela click na planilha e pega link dessa planilha coloca quando for cria o projeto de novo na api sheety onde pede o link de sua planilha aqui resolveu assim,
demorou muito pra mim resolver isso ..

Can the USERNAME, PASSWORD , and TOKEN be any?

Yes.

{'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 :

1. Check first that you have actually created a new sheet to be able to edit it, not the one provided by angela.

2. 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
   }
   }

3. 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!