Chains

There are a lot of moving pieces when it comes to building data integrations and automations using Chains. This quick reference guide organizes frequently used resources when setting up new workspaces and building chains. If you’re brand new to Ch...

Kim Gresham Learning Champion

Hi, I have a requirement to retrieve data from a source system to Workiva. Data is exposed through API and in JSON format. I can just fine retrieve most of the values but not when the values are in an array. As an example below by using 'Array to ...

Martin Jul

When creating integrations that utilize Spreadsheets, it is important to consider their limits during the architecture phase of your build. In this post, I will focus on the max cell limit. Spreadsheets have a maximum cell limit of 2,000,000 cells...

Jeff Hickey

We have text filled in via Message file node in the chains: "The length of books is not being supported for Entity with code/s <variable> Books used: <variable>. Please reupload the report with revised books. If the issue still persists please rai...

Lukas Rakickas

Hello,  I'm using HTTP Get node to connect to Databricks catalog and I can see the data in the format: {"statement_id":"xyz","status":{"state":"SUCCEEDED"},"manifest":{"format":"JSON_ARRAY","schema":{"column_count":2,"columns":[{"name":"account_id...

Bharath Goolla

How to use the Stop Chain command in Chains?

Daniela Smits

Hi, We are checking to see if there are any connectors in Workiva to use to connect to Dremio data source. Do we have ability to connect using ODBC connectivity? Thanks Sri

Srikanth Adi

When setting up the Workiva connector there are a number of issues that can occur, below we cover the most common ones. If none of these help you please contact our support team and make sure to include the full error message. Error authenticating...

Alexander Hall

Hello! I am exploring using chain tasks with the end result being on a presentation slide. Is there any way to visually show that something in the presentation is not completed because it is reliant on a different task being submitted? Example: Th...

Molly Michener

Hi Folks, I am trying to extract data from a Wdata table using Run query and export query results to another Wdata table. My Plan is to run query and export results into a csv , which can then be fed to the template "Chain Load Data to Wdata ", bu...

Usman Ali

I am trying to refresh a chain that was created by a colleague who is on PTO right now. it keeps failing at the "import file" step.I don't know to which file/query/table this step has been linked. I only have the ID. How can i trace back the sourc...

Kelly Rodriguez

Brooke Mortvedt - Mike Davis Use Case Is there any direct connector or native integration between Oracle EPM FCCS and Workiva? Does Workiva ONLY support file-based ingestion (CSV/JSON) for FCCS data? Is there a way to load FCCS data directly int...

Sanjana Soni

I have a template in a sheet with the formulas referencing to other sheets. Is it possible to duplicate the sheet and change the formulas references using chains? Manually, we can duplicate the sheet and use the replace all function to change the ...

Pavan Kapalavayi

Hello, We are currently working on establishing a connection to Databricks using the HTTP Connector within Chains. We have successfully configured the HTTP POST node to connect to Databricks and receive the access token in .txt format as part of ...

Bharath Goolla

  Mike Davis (Workiva)   Our finance team requires automated, repeatable delivery of complete Trial Balance (TB) data—including zero‑value intersections—into the Workiva Wdata platform to support accurate financial reporting and reduce manual ...

Sanjana Soni

I'm sending a list from workiva to snowflake to in a chain. These are used as for filtering down so they are meant to go into an IN() function. The problem is if I send the through as one text I get message back from snowflake that the object exce...

Joshua Richards

Hi everyone,  I recently built a chain in wdata to automate the preparation of a monthly journal entry using transaction details from a group of excel files created by a third party system. The chain then automatically uploads that journal entry t...

Jeremy Pond

Hi I'm trying to add a date column in my data by using pipelines. The preview result i'm getting is 46002 which is apparently an excel serial number. I have selected the below parameters including the data type and the format but it's still not sh...

Chelsea Carter

Hi,  I'm working on configuring a chain to send notifications to admin users based on specific Workspace activities, and also log those activities into a spreadsheet. However, I'm currently stuck on the first part: retrieving the full list of acti...

Lorena Rojas

I have a chain with command group that is iterating runs and I am using stack file to stack each result up. Now I need to take the last iteration and upload it to a table. I did some research and seem like Dynamic Chain Variable can help define wh...

Jase the Ace

Hello, We are trying to run the "Array to csv" connector for a JSON response as below. It runs successfully but its output has no values.   {"pov":[],"columns":[["Q1","Q2","Q3","Q4"]],"rows":[{"headers":["FCCS_Net Income","BU_XXXXX","FY25","AN2222...

Rajesh Shrestha

Hi, I am having issues with creating a document file in the Prototype Workiva API. I can request the Access Token and use a HTTP GET Request to view all the documents in the workspace no problem. However, when I try to use a POST Request to create...

Thomas Jackson

Hey there! We are looking to send data prepared in Wdesk back to Snowflake using Wdesk. Coming up a bit short on how that's prepared and what the chain should look like so figured I'd ask here to see if anyone else has tried to do this and has don...

Brian Tokar

I'm trying to export Workiva audit and application logs out of the workiva environment into my organizational to collect or be ingested by my Splunk so we are able to monitor workiva from a splunk dashboard or run various queries From my organizat...

Michael Williams

Hi We've noticed that the ground runners "tmp" grows in size quite a bit. Is it possible to relocate the ground runners "tmp" folder to a different drive without reinstalling the entire service?

Chad Weber

Hi Is it possible to schedule a chain to run once a year on a specific date? I don't see an option for this under the "Schedules" section. Unless I'm missing something?

Chad Weber

HI Team We have an SAP API which has an Key date in the link (API) wanted to convert the date to the system date, In the GET request.  https://sapcom:111/v1/td/XT/RPTransactionData(P_KeyDate=datetime'2025-03-11T14:49:52') The Key date should be us...

Takkellapatikiran Kumar (Capgemini Norge AS,Oslo)

Good day Are there any customers that are currently on Infor FSM Cloud Suite that is the source of data for Workiva? If so, would greatly appreciate meeting with you  Stacie Follis stacie.follis@childrens.com  

Stacie Follis

Hello We have a report with a number of incoming connections (35+), all needing the same 2 parameters updating - one is the same on all (date), however the other parameter is different for each incoming connection and is multi-select. I am trying ...

Shilen Patel

Hi I don't find any PDF commands in the chain builder, but I'll ask anyway - Is it possible to create or edit PDF documents in a chain? Essentially, we want to add a new page to an existing PDF document or alternatively create a new single page PD...

Chad Weber