Hi, I am trying to fetch data from spreadsheet using API, I have shared file with "Any one with Link". It works fine with other spreadsheets but does not work with xlsx format spreadsheet. It throws 400 error with message of failed precondition. I am Trying to fetch data from this sheet:-https://docs.google.com/spreadsheets/d/1gmts8EeBFMzkDStutlpO6NusF6h9es_i/edit#gid=1349111614
This messag :- "Google.Apis.Requests.RequestError This operation is not supported for this document [400] Errors [ Message[This operation is not supported for this document] Location[ - ] Reason[failedPrecondition] Domain[global] ] " sharing image of code snippet[image: snippet.png]e Thanks -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-spreadsheets-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/f42968a4-e048-4b97-8273-528e9ce9c193n%40googlegroups.com.