<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 using list sheets command in the Microsoft excel connector. I am getting a json array. Can someone please let me know ho w I can iterate over the list? The json output is as below [ "R&D", "Ops", "G&A", "Mkt", "Sales", "No Dept" ] My goal is ...
Hi Workiva support team, We've created a chain that exports a query to a sheet, but apparently the export to sheet step only works if permissions (editor+) in the sheet are granted to the user that created the chain. Is the described behavior righ...
Hi Workiva support team, We've found an issue with a runtime input step that remained running indefinitely in one of our chains (image below). We had to manually stop the process and re run it, then it worked ok. This process runs daily, generally...
I am currently using the unpivot tool to change header values into a new column. I had to manually input the column headers for the tool to work. I tried using an extract value tool to get the header names and tried to use that as a variable in th...
I am unable to migrate the query results from one workspace to another using chains. The following chain recipe was followed by me However, while running the above chain, I am getting an error in the last chain connector "overwrite sheet data" Er...
Hi Team I have two files one with Double quotes in data(") , One without the Double quotes("). Using Find and replace tool in File utilities, I am replacing (") with BLANKS. but when am processing the 2nd file without the double quotes, its gi...
Hi, I was trying to use the 'update dataset in a table chain template' (https://support.workiva.com/hc/en-us/articles/360058919852-Update-Datasets-in-a-Table-chain-template) to update/overwrite my dataset imported to a table. My chain looks like t...
Hi, I was trying to follow the steps in https://support.workiva.com/hc/en-us/articles/360050552311-Extract-Data-from-Oracle-Hyperion-Financial-Management-to-Workiva-as-a-File, and is having some problems with the 'Create File' command. Below is m...
I have read that there is a time limit of 10 minutes on API calls from workiva. My calls are timing out at 2 minutes no matter what I set the timeout parm to be. Am I missing parm somewhere? I am working in development environment. Thanks Pam
Hi, I am trying to create a chain which can be used to send query result from one workspace to another, after having a discussion with the Workiva Spoc but the chain is throwing an error while it is being executed. The error is : unable to match u...
Hi, I'm trying to use the 'Extract Data to File' command in the Oracle HFM BizApps, and received the following error message: I'm using a .txt file as my configuration file and it contains the following (12 dimensions are used for the HFM POV). ...
Hi! I have a client that we are trying to configure the Sage Intacct Connector in Workiva and they are currently using a 2-step security verification in Sage Intacct. I wanted to know if this will cause any issue when trying to connect from Workiv...
I've tested a POST token request using Postman with clientID and secret and it retrieves the token ok. However, when I set an HTTP request in WData I get the error: "error":"invalid_request","error_description":"AADSTS900144: The request body must...
Hi Workiva Team, We are running into an issue where our chain is skipping a command for no reason. This issue only started occurring today and the chain has been unchanged for a few weeks (and this problem did not occur before). Below are 2 screen...
Hi, I have a requirement to append the error message in a directory(folder in Ground Runner) every time without over-writing the content. Please advise. Thanks, Madhuri Desai.
Hi Commmunity team, Does someone was able to follow the step by step instructions to Extract data from Oracle Hyperion Financial Management to Workiva as a file ? I was able to set up all the command lines but when I executed the chain, the below ...
Hello, I frequently receive over write Spreadsheet errors when executing my chain. From what I can tell through manual counts, I don't exceed the 2M cells in the spreadsheet or the 50K linked sources. Is there a way to get the total cells/linked...
Hi Team,I am trying to update data in spreadsheet (already present in Workiva) by using the component "Overwrite Sheet Data" however I am getting below error. Can you please help me resolve the issue Loading data into cell region: A1: Job queued....
I am using a HTTP Get command to make an API call to SAP OData service. We are attempting to pull a set of records for a specified accounting period. The API call is successful, but we are now running into an issue where the SAP OData service is l...
Hi, I am unable to create a table using Chains. The create table task fails with below error Error authenticating with Workiva: Invalid client id: Also whom should we connect to in order to provide access/rights to our id
the client resets Snowflake JDBC connetor password very frequently and suggesting us to use the passoword from Azure key vault for each execution. Is there a possibility? Thanks, Ganesh
Hi team,I am using chains to rollforward historical data. Below is the screenshot of my chain.The rollforward works fine but I am facing issue with the formatting of the text. It seems the Write Sheet command sets the formatting to ones. Is there ...
Hi Team, I have a datafile which has some values embraced within quotes like "ABC" and am trying to do Unpivot over this data file. Getting the error as below. Error executing command: parse error on line 9289, column 161: bare " in non-quoted-f...
I'm building a chain to automate pushing updated query results to a spreadsheet. I'm encountering an error in the Overwrite Sheet Data node that I can't solve. Please see structure of the chain below: Below is the error I am receiving: 🔌 Work...
We are looking to using the SAP Hana connector to load interface files being transformed in wdesk, is anyone currently using the SAP Hana connector for this or something similar?
Hi Team, I am using Command Group Iterator to read(Get sheet Data) and to write(Write sheet) into a spreadsheet. Output of these commands are "Value1, Value2, Value3... ValueN". Instead of this, I want to rename these values as sheet names. Ca...
Hi Team, I am new to Workiva. I am working on retrieving a CSV file from SFTP and updating the file records into a table in Workday. I am able to retrieve the file from SFTP. But the chain is getting error at the "Create file" command giving an er...
I'm trying to use the SFTP command "List Directories" for a specific folder. When I use the wildcard "*" I'm able to connect to the directory but when I use a filepath to a more specific folder I get the "Directory not found" error. Am I using the...
Hi Team, How to retail formulae and formating intact during copying of the spread sheet in Wdesk platform in workiva through chains?
Hi Team, I have a requirement to move/copy data from tab1 of Spread sheet1 to tab2 of spread sheet2 using chains, noting down spread sheet1 & 2 have around 200 tabs each. Kindly suggest the suitable way and command for this. Thanks, Madhuri De...