A connection can be refreshed with a Refresh Connection command in a chain. For outgoing connections, it requires a destination parameter in the command to refresh the outgoing connection.
- Get the Connection ID for the outgoing connection from a Wdata table.
In a table, Datasets > Details > Connection ID - In Chain Builder, create a chain and add Refresh Connection command to the chain along with Workiva connector
-
Edit the command and fill out the connection ID and create a Destination Parameter as seen below
Key: fileName
Value: <any name without space>
- Save the command, publish the chain and then run it.
Things to know
Without the Destination Parameter, the command will fail after 10 minutes with this error message:
- "An error was encountered while running the operation".
To fix the error:
- Go to the failed outgoing connection and click "Edit Connection".
- Change the name and click "Save and Refresh"
- Make sure that it runs successfully.
- Edit the chain and mark the checkbox for "Use Previous Destination Parameter."
- Save and publish the chain and run it
Note that if the outgoing connection was already run in the UI and successful, there is no need to set the fileName key. Instead, mark the checkbox for "Use Previous Destination Parameters" in the command so that it can use the same fileName created during the UI run. This fileName is a dataset name in the table (Sheet22 in the below screenshot).