<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 am trying to build a chain that brings CSV file into WData table. The first step i used was Get File/Folder Info The second step used was the Create File, but getting this error message when executing. Command description: Accepts CSV/JSON file ...
Hi, I'm looking for a way to dynamically update a runtime variable dropdown list from a wdata table. I have the wdata table refreshing, so I just need a way to link that to the runtime variable dropdown. Is that possible? Wdata table: https...
I have a chain that has been working for couple months. All of the sudden, I got an error "Result: Error updating sheet data: unknown error (status 422): {} " without any changes to the chain. I also tried to write the data into a new sheet in the...
New to workiva and trying to connect a new chain with a service account for Oracle Fusion where SSO has been implemented on the Oracle instance with an IdP. Oracle documentation states using "Choose Login Page', but in testing, this does not work,...
I have a chain connecting to an SFTP doing a "list directory" and then looping through each file to download and put it in a different SFTP server. This works, but it takes too long to loop through the 100+ files on the source SFTP. I'm looking t...
I am trying to use the "Get File" File Utilities Connector to work. I have a groundrunner set up and I am typing the file name exactly as it is shown in the folder. It fails every time and says "File Not Found". Please Help. I have nothing entered...
I am getting "No Matching Columns" error on File Import step in Chain. The file is Tab delimited. I can't convert it to comma delimited as some of the column values have comma as a valid value. FYI. I am successfully able to load the file manually...
Hi There, I'm seeking input on how to pull consolidated balances from FCCS into Workiva using FCCS connectors. If anyone has experience with this, could you please share your approach? We are pulling balances into Workiva on a monthly basis, mul...
I am attempting to run a GET command to retrieve a list of data connections (per the developer site linked here https://developers.workiva.com/wdata-v1/wdata-listconnections/#list-connections). However, I am continuously getting the following outp...
Our IT team tried to install Workiva Ground Runner on SUSE v15 Linux OS and ran into below error: "cannot execute binary file: Exec format error" Can anyone confirm if SUSE Linux distribution is supported for ground runner installation?
Hello, I am new to chains and trying to achieve the following functionality: Download encrypted csv file from external source using SFTP connector Decrypt file Create Workiva file from the decrypted file Import Workiva file into Workiva table Th...
Hi All, I am trying to export the list of Workiva users in a chain and then upload to a Workiva table. I am able to get the list of users using the "List Users" command in the chain. But then I'm not able to convert the JSON output using any of th...
Hi , We want to connect our SAP S4HANA On-premise system with workiva, where we want to use CDS View from S4HANA to load data into workiva..? Tried to find some standard document but unable to find how to integrate. Please let me know if anyone h...
How difficult would it be to (how would I do it?) use a connected query to automate a refresh to the data in a spreadsheet and then publish the changes? I see the WData commands but I do not see any guidance on how to build a query to use them. Ma...
Hello All We have connected SAP BW 7.5 which is in HANA database to Workiva. All the confifuration is done. Now when we run/execute the chain using the BW connector calling/reading the data from BW query we are getting the error. Below --------TY...
Hello, I am trying to figure out if it is possible to parse a date/time variable in a chain to reflect a single digit month. I see that %m is a two-digit month in the documentation provided by Workiva but cannot find any information to indicate th...
Hi all, I hope you are doing well! Recently I have been training myself to understand the information flow of Workiva Chains. As a user with a finance/business background, it was particularly hard to wrap my head around the pivot, unpivot, transpo...
I am trying to develop a process where I need to create links with chains. Searching in the API, I didn't found anything that allows me to create those links. Are there any option to do it? Thank you.
I'd like a command that we can enter in the endpoint for an API in the Oracle Fusion Cloud connector. Similar to how we'd use Postman or SoapUI. I'd like to automate data loads using wdata, where we can record the call and results for each iterat...
I am currently exploring the possibility of connecting Tableau Dashboard to Workiva and seeking insight from other users who have experience with this integration. Has anyone here successfully connected the two platforms? If so, could you share yo...
Hi How can I reference an element in an outer iteration if an element with the same name already exists in the inner iteration? Here's a sample JSON payload: The element I'm referring to in this example is the "id" element. It exists in the "data"...
Hi, we want to have connection from sap BW on hana to workiva, using premium connector, would like to know is it possible to use premium connector with sap BW on hana..? Regards, Arvind
Thanks for joining us for Chains Boot Camp! We hope the newly release content will be beneficial in your Data Management journey. Check out the recap below to see everything was released during Chains Boot Camp. Monday - Chains Foundations Webina...
Hello! I am attempting to use a Batch Refresh Connection command to refresh a connection within one of our spreadsheets. I would like to have a list of parameter values within the spreadsheet that users can maintain and use as the source and desti...
The goal is to inform stakeholders how long it takes for updates to be synchronized.
I am having problems in a chain to apply a condition in output interpretation in error actions, following the same steps as listed in an article in workiva: https://support.workiva.com/hc/en-us/articles/360036003671-Manage-commands-in-chains I am ...
Hi, I am looking for options to use a chain to extract the data from a DB or an ERP, load it into a WData Table then use Query for further processing. I read through support docs, community posts, and other sources, but there isn't a direct connec...
hi, is it possible for the Wdata chain overwrite sheet data command to overwrite only certain region in a sheet? for example, we have a sheet that receives data from other sheet through the chain, but it also has some validation and comments on th...
Hi We want to create a real time workflow with Salesforce by triggering a chain to execute based on an event in Salesforce. Salesforce provides two options to achieve this: 1. Outbound Message Actions Outbound Message Actions (salesforce.com) 2. C...
Hi, We are investigating the option to connect Workiva to the Databricks, but do not see such connector in the list of Workiva connectors. Is it such connection supported, possible. If yes, than how can we do such connection. Thank you. Best Regar...
