|
Klassiske filtyper er ikke lenger tilgjengelige for bruk fra og med januar 2021. Du kan overføre klassiske filer eller laste ned en PDF-fil. Finn ut mer

Refreshing Connection Error

Be om demo

I have a chain setup that grabs a file from my desktop every morning and loads it into a Wdata Table and refreshed a Wdata query.

I now need a chain to refresh the connection that goes between my spreadsheet and the query.

I used "Refresh Connection" chain module and copies the connection ID. When I run the chain I keep getting the following error. I can refresh the connection with no issue from the spreadsheet itself. I also attached the yellow error message as well, it does not provide for detail.

Error checking connection refresh status: error uploading file to spreadsheets 
 
Result: Error checking connection refresh status: error uploading file to spreadsheets
0

Kommentarer

2 kommentarer

Dato Stemmer
  • JP Thomas

    For anyone with this same issue, I figured it out.

    In your spreadsheet, go to "File" in the menu bar, then "Permissions"

    You have to go into permissions and give access to your "Connector" if that makes sense. Your Workiva connector that you used when you set up your chains.

    My connector didn't have access to the spreadsheet so it was failing. As soon as I gave it owner/edit access the chain was able to run and refresh my connection.

    0
  • JP Thomas

    My connector was in the same list as other users in my company, it was easy to miss because it just looks like another name.

    0

Logg på for å legge inn en kommentar.