I am using getUnderlyingDataAsync JS API to fetch data and to check the rowcount for a sheet for my local validation purpose and it works for creator role and not working for viewer or worker role. I got the below error. Is there any way I can bypass this error and why do we need to have this restriction for API calls?
ERROR Error: Uncaught (in promise): Error executing JS API command:
getUnderlyingDataAsync
Details:
api-get-worksheet-underlying-logical-table-data: {"code":0,"message":"PermissionDeniedException"}, status: 403, textStatus: error
at X (polyfills.0e0307f4410f68cf.js:1:16680)
at polyfills.0e0307f4410f68cf.js:1:15763
at v (main.bc6c811d2bb612a1.js:1:835786)
at Y (main.bc6c811d2bb612a1.js:1:835995)
.............
