<i class="w-icon w-icon-md icon-match-section wk-mr-6 w-pb-4 w-icon-twfr-wdata-chains processed" data-section-id="360007128032"></i><i class="w-icon w-icon-md icon-match-section wk-mr-6 w-pb-4 w-icon-twfr-switch processed" data-section-id="360007128012"></i><br>General Q&A and discussion on Chains and Connections, including Spreadsheet integrations. For Wdata questions, <a href="/hc/en-us/community/topics/360001321432" target="no follow">visit this topic</a>. To see what Connections are available, go <a href="https://www.workiva.com/wdata/connectors" target="no follow">here</a>.
Hi there. We have a spreadsheet that is auto-populated via a chain ("Overwrite Sheet" command) multiple times per day. We then publish the contents of the sheet to other users as a connected sheet. This requires us to hit the "REPUBLISH" icon e...
Hi There - Trying to use the Advanced query command under Tabular Transformation. There is a note at the bottom of the query section that says the SQL commands of INSERT UPDATE and CREATE are not supported (see screen shot below). Is there a li...
Hi - Question on using a chain iterator. See screen shot below. The values entered into the iterator section of a chain command - Do these represent values that are used in other sections of the chain command configuration? In the example below ...
What would be typical process of importing data directly from the general ledger to financial reports in Workiva? What files or connectors need to be created to facilitate such process? Also can this be done in house by your client or has to eng...
Hello,I have a chain that normally runs fine with no errors, but periodically it will error out. Given that this only errors out sometimes, I feel the issue is not with the query itself. Does anyone know what this error message means, and what c...
Hi, I tried to follow the instruction here https://support.workiva.com/hc/en-us/articles/360035643812 to schedule a chain. I don't see the same options when I go into Chain Settings as recommended on the article. Mine looks like this... Thanks for...
Hello, I would like to know if I can connect my Wdata Tables directly to my Spreadsheets. As i understand how it work, i only can connect my wdata query to a spreadsheets. Thanks for your help Rafael
hello, I have this message when i tried to run my chain just to create a spreedsheet. Thanks for your help
Hello, i would like to create a connexion to BOX with Wdata chain builder but i have no idea where can i found the properties like the CLIENT ID, Client secret, client ID and entreprise ID. Where can i found those informations ? Thanks for yo...
Hi There - I am running into an issue using the "Un-Import File From Table" Command. The chain this command is in, fetches the file ID of the file in the data table (and after using the Array to CSV and an advance query to get the file ID) un-im...
I have a List Files command that produces an empty list because my table has no files. I can see its output is [] (for deprecated json). The next node is "Convert JSON to CSV". It has a skip condition called "Success -> String File List (Deprec...
I have a list of sheets I need to iterate, and for each I need to determine if the file already exists. So I have a group of commands to check that, but for each result I need to perform a different group of operations. However the group iterati...
I have a Spreadsheet with several sheets. I want to iterate each sheet, get the data, append a column to each sheet (the name of the sheet), and then import that into one wdata table. In one test I created a chain with the List Sheets Workiva c...
When running the chain for the "Download query result" step, I am receiving the below error. Any idea on how to remedy this?
HI there - through chains I can automatically run a query every day. This same query is connected to a Spreadsheet. Is there a way to have the spreadsheet automatically refresh each time the chain is run to run the query? This way, we dont have t...
Hi There - I have simple CSV file with a few columns of data on a securities portfolio. Each row is a separate investment security. Each month end the total number of securities changes (and therefore the number of rows changes). I created a ...
If you are using a GroundRunner and a Chain is failing with the error 'Error executing transformation "Did not receive response from runner"', you may need to change the settings in the GroundRunner config file. In the config file, set "LONG_POLL ...
If a chain using an Oracle Hyperion Financial Management connection returns an "Exception in Thread \<Directory Name>\" java.lang error (such as "Exception in thread \"<Directory name>\" java.lang.NoClassDefFoundError: org/apache/commons/pool/Keye...
Hi, We are trying to download and upload file to workiva using API. I was checking the documentation where it is looking for fileId, tableID. Where to get these parameters value? Is there any documentation available for these parameters?
We tried building and running a workflow using chains within WData. But, while executing, we are facing the below error message. ‘Error authenticating with Workiva: Invalid client id: a8cefde7fa764feaa6b44a361ea57***.’
We have been wanting to set up sync with Workiva and Yardi for items that come directly from the general ledger to reduce the time it takes to populate the 10Qs and 10Ks. I was wondering about how much time is required to invest in one time setup ...
By default, GroundRunners automatically create log files in the \Contents\log\ directory of their installation locations. To ease access to these log files for troubleshooting, you can automatically download a GroundRunner's output.log file to a t...
When you use an Oracle Hyperion Financial Management (HFM) or Oracle HFM Legacy connection to run the Extract Data to Database command as part of a chain, it asks for a Data Source Name (DSN) input. The DSN provides information about the relationa...
Two-way data connections would prove efficient.
We are looking for integrating Wdesk with Tableau so that data from workiva can flow in Tabelau as a data source and dashboard can be created.
Are any of you working with the Anaplan direct connect? If so, how was the integration process and how has your experience been so far?
Is there anyway to link wDesk & Hyperion Financial Management (HFM)? Workiva was looking into this several years ago.
I am thinking about going this route with my bank. Our external system is very powerful, however, lacks the presentation and charting capabilities that Workiva has. Was hoping I can get some feedback from other users who use this feature. How d...
Curious if there was already a connector made for Access to bypass using Excel as our data sync intermediary. Thanks!
