<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>.
Is there a quick and easy way to automate a check to confirm that a Connection ID is valid and/or accessible by the executor of a chain? We currently have multiple control sheets that list Connection IDs and are used to trigger refreshes across mu...
I’m currently exploring how to leverage the Workiva connector to Workday ERP for financial reporting purposes. Specifically, I’m looking to build spreadsheets in Workiva that can pull data directly from Workday using the Workiva connector. To help...
Hi How can I save List Directory output to a file (1 file name per line) without having to iterate over each item in the array output? I
Hello, I am building a chain to extract a document to DOCX using Workiva API. At the second step of the chain, Workiva returns in the HTTP Header the Location (i.e. URL) of the file in a JSON format that looks like this "Location":["https://ap...
When I make an HTTP call from values in a csv file is there a way to easily sent values conditionally? For example, if the user enters something in the spreadsheet then put that value in the body, if they enter nothing don't send anything for that...
I have two chains, one (A) which makes a call to an API to retrieve an access token (embedded in the returned JSON) and a second (B) which I want to be able to consume that token and use it with a target system. (There are several use cases requir...
Hi, I am attempting to retrieve a list of logins for our entire organization for the past three months. Ideally, this chain will be scheduled and set to run at the end of each quarter to retrieve an updated file. I am iterating over the 'data' var...
Hi Team, I have run a simple query and trying to get the output in spreadsheet, but getting below error. I am not getting the output in Wdata. While giving the spreadsheet URL in input data, I am getting this error. Error running query: unable ...
Hi All, We just enabled the Oracle OTBI connector and are trying to run reports out of our general ledger. I am getting an error that says the report wasn't found at the specified path. I attached pictures of my chain parameters, the error, and th...
I am attempting to retrieve a list of Workiva users, including their email, active status, and workspace roles using the List Users Workiva command. I am having trouble converting the JSON output to CSV using the Array to CSV or Object to CSV comm...
We are getting an "Update connection" error in our outgoing connection to another workspace. We have checked the permission on the sheet and we are owners of the sheet. Do you happen to know how to fix this?
The client we are working with does not allow external connections to access their corporate environment. To comply with this restriction, we need a solution that enables data to be sent directly to Workiva, without requiring the platform itself t...
I have JSON data from an API call which contains about 500k records and 90+ fields and I am using the Array to CSV command to convert the data to CSV before importing to a Wdata table. The Array to CSV command currently takes about 7-8 minutes to...
Hi I'm trying to parse a couple of JSON properties to CSV. Here's a JSON sample: { "data": [ { "id": 1234, "codes": [ "AA", "BB", "CC" ] } ]} Here's ...
HiI've encountered a limitation with the List Directory command: WARNING: The maximum amount of files (500) to be printed and available in the output has been reached I'm trying to insert all file names into a SQL table. The folder contains more t...
HiI'm trying to insert data from a API JSON response into a SQL table. Certain string properties in the JSON response contains either a comma, pipe or tab delimiter, which breaks in the SQL insert. I've tried removing the pipe delimiter from the J...
I have created a chain that runs a query and saves the result to a Workiva spreadsheet - that works fine! I would like to save the results of the query (or spreadsheet) to a CSV file and then push it out to an external file system (SFTP/S3/Google)...
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...
I have several chains that run code to gather latest data from datbase, format files, upload files to table, then refresh queries and connections. Can I set up a button or shortcut within my spreadsheets to run these chains? Trying to get more peo...
Hi Is it possible to convert a column to an array with the following structure? I don't want to include the column name in the result.["11111", "22222", "33333"]
I am investigating how to connect to SAP Business Planning and Consolidation (SAP BPC) to automate ESEF reporting in Workiva. I see that there are no specific connectors for this. Would anyone know the best way to make this connection?
Does anyone know how the "arguments" in the 'Run Script' command are passed through to Python? Currenty my first argument is the specific script file and workiva is able to run it but I am getting an error where my script is asking for input(), o...
OneDrive List Drives command errors "https://login.microsoftonline.com/common/oauth2/v2.0/token responded with status 400"
Hello, I'm wondering how one would go about integrating Workiva Wdata with an on-premise Oracle PeopleSoft ERP. Does anyone have any expertise in this area? I'd like to know some high-level details about how the configuration would work and what ...
I have a chain setup that grabs a file from my desktop every morning and loads it into a Wdata Table and refreshed a Wdata query. I now need a chain to refresh the connection that goes between my spreadsheet and the query. I used "Refresh Connecti...
I set up the template chain Load Data to Wdata | Replace Dataset It works great and streamlines my process. But I want to go further and have it run automatically every day at 8:45AM. Since it requires inputs, I think the schedule option is disab...
I am currently using Workiva chains, and have a structure in which one chain uses the Run Chain command to call another chain inside of it. Inside of that secondary chain, I want to set up a conditional that is based upon a variable that is set in...
Hi everyone, I'm trying to copy a Workiva document using a chain. My goal is to not only copy the document itself but also the related spreadsheet while maintaining the connections to queries. Has anyone attempted this before? Any tips or guidance...
I have recently created a new trigger chain or chain to run multiple other chains (in case the terminology doesn't fit), I created this by copying an existing trigger chain and change the parameters on which it runs. It runs as expected and all th...
Hi How can I access each chunk file after it's been split using either of the two Split commands? The command output only includes a list of file names and not the Absolute Paths.