<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 Team, Thank you for all your support. I have a task to load File data into Table where in basically File is CSV file delimited with Pipe and Table scheme also created according to delimiter being used. If I tried to load this File into ta...
Hi team,At times we get some errors on fully functional chain commands as below two. We are using workiva ground runner.Example 1:"Failed to communicate with runner - this command was not executed"Example 2:"Listener refused the connection with th...
How can I build a connection to a Teradata table? I have been trying to create a query to pull values directly from a Teradata table but have been unsuccessful. Which BizzApps could I use to accomplish this? Thanks!
Hi Team. We have a spread sheet( F1 with Spread Sheet ID = 1). I created the copy of F1 as F2 which will have Spread sheet ID = 2. This Spread sheet ID = 2( NOT SHEET ID) I want to capture automatically through chains in workiva, is that possib...
I have a simple SFTP connector and perform a List Directory command. I get back an array of file names as json: ["File A", "File B"] what is the most efficient way to count the number of files? I tried adding an Array to CSV command then a Filte...
I had added skip condition in some of my commands, which I don't need now. When I remove the skip condition it doesn't get removed completely. I have to select one of the three conditions (success, warning, error). The command then always gets ski...
Hi! Is there a way to automate locking/unlocking a spreadsheet/sheet using a chain command?
I followed the Export pivot view to Spreadsheets via a chain receipt, but at final step "overwrite Sheet data command", i'm getting data output from the query, not the expected data output form the downloaded pivot.
I'm trying to setup a wdata chain to update a spreadsheet based on a query and then email the spreadsheet to myself. I've been able to get the query to publish to the spreadsheet but am stuck when trying to email the file. Is there a simple way t...
Hi There, I have a task to create links between two spreadsheets(1 & 2), where in values present in cells of sheet1 should be linked to sheet2 cell on some specific code(unique identifier). Curious to know if there is any way to achieve this lin...
My organization recently enabled wData and I'm trying to build a chain that takes a specific cell value from a spreadsheet and uses that to update the parameter of a query. After that, I would like to run the query and export the query results to ...
I have created a webhook trigger and it works in postman. However, my user wants to click on a url and want the chain to start automatically. I get a 405 error when I pass the url along with the bearer token.
Update: Variable Transform has been expanded to handle math operations such as incrementing a Dynamic Chain Variable value. The two methods below still work, but are no longer necessary. If you have a numeric Dynamic Chain Variable that you need t...
I have actually not tested the jdbc connector but as per the documentation it says ground runner should be installed if it is on-prem. Can I get rid of ground runner if they allowlist Workiva's IP or is it mandatory to have ground runner installed?
How do i send a csv file to a chain using http webhook trigger? I am able to send a json in raw format but it is failing when sending a csv file.
I am trying to upload a file to a table using chains via create file command. I don't have an option to specify the delimiter of the source file and it is taking comma by default. my source file contains descriptions which have commas. So, I canno...
I have some file content generated by some commands, let’s say Advanced Query I then have a group command, with a conditional that checks some condition If the condition matches, I modify the file by adding a column using the Insert Column comman...
Hi, I am bring level 0 data and metadata from EPBCS to Workiva tables. I need to know how can I aggregate/rollup data in Workiva using the aggregation property of metadata I am bringing from EPBCS. Thanks, Samir
Hi There - is there a way that we can restrict Workspace or Chain Owners to a particular type of Chain environment? We have separate DEV and PRODUCTION Chain environments. We would like to give our users access to the DEV environment, but restric...
How can I write formulas into a WDesk sheet from a Chain? the "Write Sheet Data" command does not seem to support anything other than data. I want to be able to add a totals row after I imported some data into a sheet.
I want to create a CSV file by hand in Chains, with various different values stitched together manually to be imported into a WDesk sheet. I used Create File to specify the first line of CSV based text: Amortization of lease payments,,,,, and lef...
I have setup the user and got client ID & secret. I am stuck on authentication step to get the bearer token? How do I issue POST reuest? which tool to use or is there any query that I can run in powerBI to get data which will authenticate the clie...
I have a very simple request I cannot seem to get working. I have a Get Sheet Data command, which fetches n amount of rows with a header row from a WDesk spreadsheet. Then all I want to do is iterate over all the data rows, extract all the colum...
If we build a handful of chains, how can I easily take these across workspaces and organizations? How do i easily deploy a set of chains i have built to another location??
I am stuck once again trying to do somethign that seems very trivial. I have a spreadsheet with several columns. I need to query columns A, B and say E and load that into a table. That is it. So what I built is: So I need the ability to refre...
I have three related questions: - In Wdesk, if I have several spreadsheets each with several sheets, each with several Wdata Connections, is there a way using Chains to enumerate all these Wdata connections and auto refresh them? - In Wdata, if ...
I need to generate a list of entries in a table, and based on the value in a specific cell in a spreadsheet (which I can read), I need to generate as many instances of rows (with different content). Say the cell had a value of 30, then I need to ...
I have an XLS file with an unknown number of sheets. Each sheet has data in a certain structured format. I want to get that file into a WDesk Spreadsheet, each sheet mapping to a sheet in WDesk. When I want to enumerate the sheets from a chain ...
We're in the process of connecting Wdata to our NetSuite environment. We'd like to use the NetSuite Token Authentication Connector. The goal is to use a Saved Search in NetSuite to aggregate the monthly financial data (either as a trial balance or...
We are trying to build an Assumption management process flow. As part of this we are looking at a situation where we need the spreadsheet tab to be exported into a CSV format as the final file using a chain. Can we accomplish this using a chain wi...
