Update Datasets in a Table chain template
AnsweredI 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 following parameters
- Flie prefix : 1
- Table ID : 4d370b3289b94c7c9dc8bbb8b2692727
- Datasheet file: QWNjb3VudB82MzIzIzODE5NTQ0MzEzODU2
- Replace frequency: Add new datasheet
When I run the chain with the above parameters I get the following error: Error with input file: unable to find the input file specified
Could you help me with this error.
Attached are screenshots of the configuration parameters and the error:
-
Hello Pablo,
The error is occurring at the Create File command because it appears you are attempting to pass in the Workspace ID rather than a flat file (please see screenshot below). In the template, the "Dataset file" input from the Runtime Inputs command should contain the file to be created. To resolve the error, adjust the Create File command so that the dataset that you want to upload to the Wdata Table is being supplied rather than an ID.
0Thank you. Additionally if I enter the Get table Metadata block to enter the data of this table as a Dataset file I get the following error in the chain:
Could you help me with this error?
0could you please help me with this error?
0Hello again, Pablo!
I've also drummed up a ticket for you here and pinged our engineers. Should you want to contact them directly, you can reference ticket ID #224932. Let me know if you have any questions for me in the meantime.
0Hi Pablo,
You'll need to ensure that the you're importing matches the schema of the table it's being imported into. Inspect the contents of the file to check it's structure and header. If it doesn't match, an error will be thrown. You can get more information by navigating to the table in Wdata, and hover your mouse over the orange triangle for the dataset that failed to import. The tooltip message should give you more information. From this screen, you can also inspect and/or download the file to further investigate.
0Please sign in to leave a comment.
Comments
5 comments