Predefined Functions

Last Updated: Oct 19, 2021


Whenever I am executing the task with Predefined function Insert Data into a Inline Jiffy table, I get the error message as "Column not present in Table", although the column is present in the Inline table. Image description

This error occurs when the column name you provided does not match exactly with the column name in the table.

The column names are case-sensitive.

Copy the exact column names from the Inline Jiffy table and provide in the parameter Column_name of the function, comma-separated and rerun the task.

I am using the Get Table Value function to extract the data from the Document table, but the function fails with an error “Unable to decode table object”.

This error occurs when the table input parameter given for the Get Table Value function is not a Data Table. Get Table Value function is used to retrieve data from transient Data Tables. To retrieve data from Document Table, use Jiffy Select node.
Click here to know more about Get Table Value function.

While executing Web UI node, I get an error in step data using predefined function Get Table Value, "Given row number one is more than available data rows zero.". Image description

This error occurs when for the row number given in the predefined function Get Table Value, no data is present in the Data Table from which value is being extracted. Ensure that the result set that populates the Data Table has data for the given row and column number.
For example, if you are populating the Data Table from a search result of a website, search manually with the same inputs and ensure data is fetched.
Else, change the inputs of the automation for which data is available in the result set and provide a row and column number that has data.

Download From Server function fails with the error, “Failed to download/replace the fie…..”. Image description

This error can occur due to multiple reasons:

  1. Check if the file with same name as the attachment is opened in the machine. If yes, close the file.
  2. Check if the given file path exists.
  3. Check if you have Write access in the given file path.
  4. Check if the attachment file name has / in it. If yes, make sure that the attachment name is renamed without any / in it.

Windows dose not allow to save the file names with characters / \ : * ? < > |

When deleting a folder from local C drive using Predefined function DeleteFolder I get the error "Access is denied".

This error occurs when the user does not have required permissions for the given folder/file.
Perform the following steps to provide full access.

  1. Go to the Properties of the folder that you want to delete.
  2. Navigate to Security select the user which you use and click the Edit button.
  3. Check the Full control and click the Apply button.
Image description

Did you find what you were looking for?