In jiffy Default functions repository will have following functions.

Select data

Select table from the Jiffy table .

INPUT :

1. Table name – Type string

2. columns names- Type string- comma separated, filter criteria like “origin”=‘JFK’ and “Destination = ‘BLR’

OUTPUT :

Selected column data in string format.

Update data:

Update the data in Jiffy table .

INPUT :

1. Table name

2. UUID – UUID of required row

3. column name - One column name needs to update

4. column value

Insert data:

Single row insert

INPUT :

1. Table name,

2. Column names to inserted with comma separated,

3. data – comma separated like “JFK”,“BLR”

OUTPUT :

    UUID of inserted data

Insert data into inline tables: Single row insert

INPUT :

1. Table name,

2. Column names to inserted with comma separated,

3. UUID of parent tables by comma separated

4. data – comma separated like “JFK”,“BLR”

OUTPUT :

UUID of inserted data

Bulk insert:

Multiple rows insert

INPUT :

1. Table name

2. Columns named to inserted with comma separated

3. data – table type

OUTPUT :

UUID’s of inserted data – Table type

Bulk insert into inline tables :

Multiple rows insert

INPUT :

1. Table name

2. Columns named to inserted with comma separated

3. UUID of parent tables by comma separated

4. data – table type

OUTPUT :

UUID’s of inserted data – Table type

These function will be accessible inside the custom function as well.

Delay in seconds

Delay function to wait for number of seconds specified

Syntax

Delay in seconds(time_in_seconds)

Sample

1. Delay in seconds(5)*

Parameter Details

Input Parameter Name	Description
time_in_seconds	time in seconds

Get Last Downloaded File

Get the last downloaded file uri, within the web automation context. File will be present in the following location of client machine. C:jiffyserviceJAMrunsExec[Number = Latest exec file]

Syntax

Get Last Downloaded File()

Sample

1. Get Last Downloaded File()*

Parameter Details

Not Applicable

Get Text From Position

Gets the text from the presentation space based on the row and column position of the field

Syntax

Get Text From Position(row_index, col_index)

Sample

1. Get Text From Position(4, 14)

Parameter Details

Input Parameter Name	Description
row_index	row index value
row_index	col index value

Get Text From Relative Field

Gets the text from the field by taking input as ‘Relative Field name’, field position from the relative field and field presence (before or after)

Syntax

Get Text From Relative Field(element_name, before_or_after, field_position)

Sample

1. Get Text From Relative Field(Order,after,2) => Y

Consider the scenario of fetching text from mainframe screen

Parameter Details

Input Parameter Name	Description
element_name	feild relative to which the string has to be fetched
before_or_after	value should be before or after
field_position	field position value

Input Text With Element Name

Input the text into the screen’s unprotected field from the given element name with field presence (before or after)

Syntax

Input Text With Element Name(ID,User1,after)

Sample

1. Input Text With Element Name(ID,User1,after)*

Parameter Details

Input Parameter Name	Description
element_name	feild relative to which the string has to be inputed
input_value	String to input on screen
before_or_after	value should be before or after

Download File

Download file from url

Syntax

Download file from url(url,extension)

Sample

1.Download file.

Parameter Details

Input Parameter Name	Description
url	url of the file
extension	extension of the file

Create Jiffy URL

Create Jiffy URL from path

Syntax

Create Jiffy URL(path)

Sample

1. Create Jiffy URL.

Parameter Details

Input Parameter Name	Description
Path	Path of jiffy url

Create JDI URL

Create JDI URL from path

Syntax

Create JDI URL(path)

Sample

1. Create Jiffy URL.

Parameter Details

Input Parameter Name	Description
Not applicable

WinKeys

Utility for sending keystroke/string to windows

Syntax

WinKeys(window_title, key_text, is_spcl_key, modifiers)

Sample

1. WinKeys(Save As,Order,False ,None) => Order
2. WinKeys(new27 - notepad++,s,True ,^) => ctrl+s

Parameter Details

Input Parameter Name	Description
window_title	url of the file
key_text	extension of the file
is_spcl_key	True to send as special key otherwise False
modifiers	Modifier key.Use None if no modifier

Attach To Window

Attach to a running application

Syntax

Attach To Window(title, exe_name, pid)

Sample

1. Attach To Window(JIFFY | Actionables, None, None)

Parameter Details

Input Parameter Name	Description
title	Title of the target window.Use None if not using
exe_name	Name of the exe file.Use None if not using
pid	Process ID.Use None if not using

Send String As Characters*

Sending a string as separate characters

Syntax

Send String As Characters(String to Send)

Sample

1. Send String As Characters(abc)

Parameter Details

Input Parameter Name	Description
title	Title of the target window.Use None if not using
input_string	String to Send

Upload To Server

Upload file to Jiffy File Server

Syntax

Upload To Server(file_to_upload)

Sample

1. Upload To Server(C:UsersUser1DownloadswebAutomation.docx)

Parameter Details

Input Parameter Name	Description
title	Title of the target window.Use None if not using
file_to_upload	Location of the file to upload to file server

Download From Server

Download file from Jiffy File Server

Syntax

Download From Server(download_location, fid)

Sample

1. Download From Server(C:UsersUser1Documents,112233)

Parameter Details

Input Parameter Name	Description
title	Title of the target window.Use None if not using
download_location	Location to save the file which is downloaded from file server
fid	File Id

Get Table Row Count

Download file from Jiffy File Server

Syntax

Get Table Row Count(table)

Sample

1. Get Table Row Count(table1)

Parameter Details

Input Parameter Name	Description
title	Title of the target window.Use None if not using
Get Table Row Count	Data Table Variable

Get Table Value

Get Element By row Column Number

Syntax

Get Table Value(table,row_number,columnNumber)

Sample

1.Get Table Value(table1,2,3)

Parameter Details

Input Parameter Name	Description
Table	Data Table Variable
rowNumber	RowNumber
Column Number	Column Number

Set Table Value

Set Element By row Column Number

Syntax

Set Table Value(table,row_number,columnNumber,value)

Sample

1.Set Table Value(table1,2,3,value)

Parameter Details

Input Parameter Name	Description
Table	Data Table Variable
rowNumber	RowNumber
Column Number	Column Number
value	Value to be updated

File Explorer

Returns a table of files and their associated properties. Takes an input of Table Name defined in ‘Table Definitions’ and path of the folder to be explored

Syntax

File Explorer(table_name,folder_path)

Sample

1. File Explorer(table1, C:UsersUser1DocumentsFolder1) =>

Parameter Details

Input Parameter Name	Description
table_name	table_name
folder_path	folder_path

Empty Table

To empty the contents of the specified table.

Syntax

Empty Table (table_name) = output

Sample

1. Empty Table (table1)* = Empties the contents of the specified table.

Parameter Details

Input Parameter Name	Description
table_name	Name of the table that must be emptied/td>

Search Value From Table

Returns a table of files and their associated properties.

Syntax

Search Value From Table (table, start_row_no, start_column_no, text)

Sample

1. Search Value From Table (table1,2,3, Image)

Parameter Details

Input Parameter Name	Description
Table	Data Table Variable
Start Row Number	Row Number from which the search must begin
Start Column Number	Column Number from which the search must begin
Text	Text to be searched

Convert Table To XML

Returns Data in tabular XML format.

Syntax

Convert Table To XML (row number, column letter, cell data)

Sample

1. Convert Table To XML (2, C, C2)

Parameter Details

Input Parameter Name	Description
Row Number	Row number of the cell
Column Letter	Column Letter of the cell
Cell Data	Cell value of the cell

Alter Implicit Delay

To change the implicit delay in Web UI node.

Syntax

Delay ()

Sample

1. Delay (50) => 50 sec

Parameter Details

Input Parameter Name	Description
Delay	Type the value in seconds

Alter Send Key Delay

To change the delay between the characters in input or send key action.

Syntax

Delay ()

Sample

1. Delay (50) => 50 sec

Parameter Details

Input Parameter Name	Description
Delay	Type the value in seconds

SendMail

SendMail default expression sends mail through Simple Mail Transfer Protocol (SMTP, a protocol for sending e-mail messages between servers). The Email ID provided in the Email host user field is the “From address” of the mail that must be sent.

Syntax

SendMail(to,subject,body)

Sample

SendMail(xyz@gmail.com,test,This is a demo)

Parameter Details

Input Parameter Name	Description
to	Address of the mail recipient
subject	Subject of the mail
body	Content of the mail

If the provided Email ID exists/valid, then the “Recipient address accepted” message is displayed. If the provided Email ID does not exist/not valid, then the “Invalid email address” message is displayed.