<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>.
I have two commands running in parallel, but now I want to make sure the first parallel command runs after waiting for 5 seconds. How can I introduce Delay (or WAIT) of 5 seconds in my chain, before a particular command?
Hi, this is the first time we need to call external api, may you guide me?
I am trying to design a solution for automatically retrieving ESG metric data from a source system (using the Data Management Suite) that can identify adjustment/restatement situations. I.e., historical source data may change without notice, and I...
Hi Is it possible to create multiple schedules for a single chain such that each schedule is executed using a different set of chain variable values? Crude example:Schedule 1 Use chain using chain variable value = 'A' Schedule 2 Use chain using ch...
I am using the Update a table's query dataset as a chain (Update a table's query dataset as a chain – Support Center (workiva.com)) and I get an error in the Download query results block. The error is as follows: Error running query: object Id siz...
Hello! I am currently trying to reproduce the chain from the January Beverage Break session for rolling forward financial reports. I am replacing the Create Spreadsheet and Create Sheet commands because I have found that when I use these Workiva c...
In the UI for a Wdata table, you can add data three ways, as shown: However, when working with the Workiva connector commands in a chain, while there are the "Import file into table" and "Import spreadsheet into table" commands (corresponding to ...
I am using the put to update a select list with a list of values. When I run it I get {"code":409,"body":"duplicate select list name"} Request Status: 409 Conflict Result: Non-200 response code received: 409 Here is my list of select list, no ...
I would like to export the dataset that is shown in Chains > Monitor (to CSV or similar) so that I can actually work with this information. (The reason is that I'm trying to understand, for a few of our regularly scheduled chains, how long they ar...
Hello: I've tried creating a chain that automatically launches a query without parameters and exports the result to a specific section of a spreadsheet. The chain contains a "Run query" and "Export Query result" nodes but gives an error when tryin...
Has anyone been able to automatically add data to the Update List command (in the workiva connector ) dataset without all the items going to one selection. At the moment we are adding the file text from list file content node. All the items in the...
Where do you find these lists after you create them? How do they get used in a query? All the chain documentation seems to assume that these pieces of information are known before hand.
do we know why the links between the chain commands are so unstable? in the first run everything was fine in one flow but some links failed in other flows, we fixed those failed links and the 2nd run failed again as the fixed links work now but th...
Hello, I am experiencing an issue with this chain. This is configured so that the right side of the chain will pick up the current year file from the SFTP folder and run it through a couple of transformations. It will then un-import the old file, ...
Is there a way to do a mass backup of the chains in an Environment. I know I can export 1 chain at a time, but I would like to export all of the chains. I'm working on a Disaster Recovery plan for my company.
I am trying to reference global parameters in the function run query. Under type, it does not have global parameter. When I try to recreate the parameters, I do not have a value so I put default value. That is what is listed in the global paramete...
Hello all,I will be linking Tagetik with Workiva soon and wanted to ask if anyone has any experience or tips. I found out that Tagetik uses APIs and wanted to ask which connector I should use since I wanted to link Tagetik with Workiva through it....
Hello everyone, currently I am working on a project in which I need to build a CCH Tagetik-Workiva interface. Do you have any tips for me, what should I look for? Is there a connector like the SAP connector? Which articles or courses could you rec...
Does anyone know of a process mining tool that has integration with Workiva (something like Celonis or Oracle process mining or ARIS or any other process mining/mapping tool).
is there a step by step process to build a chain that will export sheet dataout to csv? All o fthe guides assume steps - i am loolking for a true guide - click this do that and use this id etc... detailed.
We have created a chain and on running it we are given an error of Invalid client ID. We have created the connector recently/successfully have checked the client ID again and again. We have tried all the solutions but sill we get the same error. P...
In the Workiva connector's "Export Query Result" command, there is a toggle at the bottom labeled "Export as Dataset" as shown here: The information in the help icon simply repeats, "Optional: Export query results as a dataset," and nothing about...
Hi, I am looking into chain implementation and I am confused about the data the metadata function gives me. is there a way to get file IDs of table imports through this command?Thanks
Hi, Is it possible to use IBM Planning Analytics TM1 connector to connect to Cognos Controller? Br Martin
The clients Adaptive Planning admin and myself are having an issue with the "Edit Export Data" The parameters Dimension Value Filters and Dimension Data, we are unable to get all members of a dimension to return. Direct children is selected. The ...
Hello! I am having a problem with my chain. This chain helps with the rollforward by coping the information of an specific range of cells of the current year and pasting it in another range of cells of the past year. The problem appears when a per...
Hi, I just made a chain that copies the information from an specific region an paste it in another region. The chain does this in all the sheets of a spreadsheet, but I want to add something. I want to know all the times the chain and the values a...
Hi!! I want to store the column number where a specific value is located in a cell of a spreadsheet with chains in Workiva. Is it possible?
I have a chain with 2 consecutive 'Refresh Connection' commands and one of them consistently fails. The first refreshes a WDesk sheet's incoming connection and succeeds every time. The second refreshes a WData table's incoming connection (from the...
Hi community, I've been having the following annoying issue with the chain scheduler and cannot pinpoint the root cause: I have a chain set to run every two hours at half past: While it runs fine most of the time, every now and then it decides to...
