<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>.
Attempting to connect to SAP HANA JDBC using a ground runner. Connector was setup with credentials that are known to have access to the tables tested in the execute sql and get table definition nodes. This error is generated , url info left out ....
I'm new to Workiva. After executing successfully the chain using "Execute Query" Command in SAP HANA JDBC Bizapp I was expecting the CVC file to be generated, but this didn't happen. I can see the recorded retrieved in the logs preview. So, 1...
I am trying to download HFM data to a file. The ground runner is setup, and the integration user has the appropriate access. The HFM-Extract Data to File node works when the "Expand Only" options is checked but fails when it is not. This exact sa...
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: objectId size...
I am using the Chain called -> "Update Datasets in a Table chain template". Once I set up this Chain as follows: https://support.workiva.com/hc/en-us/articles/360058919852 . I have created an additional chain to execute the previous one with the f...
I would like to connect Workiva to the JIRA program in a bidirectional way. However, with the help of workiva, there is no specific connector present, so an HTTP Request connector can be used. I have the following questions on this point: 1- Conne...
When I try to perform a Chain I get the following error: Error authenticating with Workiva: Invalid client id: XXXXXXXXXX. The connection ID has been created in Wdesk-People-Add a grant in the user name select a user with chain owner permissions....
Attempting to set dynamic variables in a chain, and need to reference the value of one variable from the other. This is the first step in my chain. EffectiveDate: The current datetime, minus 1 month FilePath: A file name that contains the value ...
I am creating a copy of a working chain in a different workspace that will have a different connector. I am building a chain for a development instance of my source system versus the production instance. I have built the chain, created the table,...
I am building a chain to import data from from an external system. I have created all of the parts of the chain, gathering input, getting the data in CSV format and now I want to load this file into my wdata table. I have already created this ta...
I am trying to connect to an OTBI report . Here is the path for the report Path - /shared/Financials/General Ledger/Trial Balances/Trial Balance Report The documentation mentions replacing spaces with a +, but it only says that for the report na...
I am trying to connect to HFM. The ground runner is all setup and I have all the privileges. Running the Extract Member Lists returns this Oracle HFM (HFM 11.1.2.4)Version: 2.0.0 Authenticating...Error running command: Authentication error: Fai...
'In our previous system, we had one central template that we could create individual requests each quarter and push out to the countries automatically in one step. With the current set up, we have to copy and maintain 80+ separate templates with 1...
I need help outputting (excel file) data from column A to one sheet and outputting Column B to a different sheet. Also, if I were to run a query and needed to export parts of the results to different sheets which chains commands would I need to us...
I'm having a hard time connecting to the API where do we need to input this information to make the connection work? -> "https://developers.workiva.com/workiva-wdata/reference/wdata-authentication" I also get the following error code when I trie...
Hi, We are trying to insert exchange rates into a Snowflake table using Open Exchange’s API (https://docs.openexchangerates.org/) Currently, the chain looks like Image 1: The Open Exchange API outputs a single JSON Object string (Image 2). We are...
Hello, I put a "Run Pipeline" command into one of my chains, and when I ran the chain the Run Pipeline step failed with the below log. Can someone help me understand what does the error mean? Thanks! Lina ------------------------------------------...
My chain has a list files from SFTP going to a group iterator and then downloading each file to process it. There are 3 files that in the SFTP, only two work. This chain was working on all three files just yesterday. The chain has been rebuilt f...
Hi Team, I have a requirement to refresh the INcoming data connection into the Wdesk spreadsheet which is connected to Wdata query through chains. How can I achived it through chains?
A csv is being delivered to a sftp folder. The csv was created from a formatted excel report. This error keeps getting generated . Looking at the file in notepad++, row 8 does not look any different except for starting with a comma. Exit message:...
I'm doing a get request that return a .zip file, but automatically this BizApp converts file to .txt so is not possible to view any data because file is compress. My question is what would be the sequence to save file with .zip extension and then ...
I'm getting troubles writing data in a spreadsheet with Write Sheet Data command in chains, this command receive a csv, but an error when it executes: Result: Error updating sheet data: The field '%s' contains data that does not fit in the given r...
Looking for information on connecting MS SQL Server to Wdata using Wdata Chains. Thanks.
Hi Team, I have the Workiva chain with Workiva Bizapp with client ID say "XXX" which was running fine in the month of Jan,2022. Same chain , with same client ID is not working now, says Invalid Client ID, error in authenticating. Is there any rea...
Is there a limit to files uploaded via the Runtime File Upload node? I have a file that is 26meg and it rejects it. It isnt that big of a file, has anybody else encountered this?
I successfully used the Make Directory in File Utilities When I try to copy files to this directory, I get these errors. I cannot find any guidance on how to use the copy connector.
I have a set of excel files that are being delivered to an SFTP folder. It is a very simple process where the excel files are converted to csv and written to specific sheets in wdesk. Only the first line in the excel file is being converted, every...
I have downloaded a .txt file from the SFTP server. My task is to convert this txt file into csv file so that I can add a header row and upload the file data in a table.
Task is to pull the latest file from a table, and upload it on a sftp server in .csv format. List File command lists the different files present in the table (imported or staged) but the task is to pull that latest file with data and then upload i...