Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Export query to sheet step only works if chain creator has permissions in the sheet?

Answered
Request Demo
  • Edited

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. 

0

Comments

2 comments

Date Votes
  • Official comment
    Wayne Paffhausen

    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

  • Leandro Casal

    Thanks Wayne Paffhausen

    0

Please sign in to leave a comment.