Export query to sheet step only works if chain creator has permissions in the sheet?
已回答Hi Workiva support team,
We've created a chain that exports a query to a sheet, but apparently the export to sheet step only works if permissions (editor+) in the sheet are granted to the user that created the chain. Is the described behavior right?
We want the sheet permissions to be independent from the chain creator as he shouldnt have access to the sheet. Is there a way to achieve this?
Thanks, regards.
-
正式评论
Hello Leandro,
The OAUTH user that was generated for the API Key is what is populated in the Workiva Connector. This user must have the proper permissions to make updates/edits to the sheet. If you have configured that to be the same person, they you will need to perform some updates to your OAUTH setup and the Workiva Connector.
Please see the attached documentation for the setup / configure of the Workiva Connector and how it relates to the OAUTH API Key you have generated.
https://support.workiva.com/hc/en-us/articles/360045097312-Workiva-connector
评论
2 条评论