Index

Database Operation

• ajExecuteSp(stored_procedure_name, [parameter], [return_type], [transpose], [return_header], [data_source_id], [convert_to_text], [run_condition], [run_by_function_point_only])
• ajExecuteSql(sql_statement, [parameter], [return_type], [transpose], [return_header], [data_source_id], [convert_to_text], [run_condition], [run_by_function_point_only])
• ajCreateRec(table_name, column_headers, data, [table_schema], [return_type], [transpose], [include_header], [data_source_id], [convert_to_text], [run_condition], [run_by_function_point_only])
• ajCountRec(table_name, [filter_type], [filter_condition], [table_schema], [data_source_id], [run_condition], [run_by_function_point_only])
• ajReadRec(table_name, column_headers, [filter_type], [filter_condition], [sorting_criteria], [page_number], [rows_per_page], [table_schema], [transpose], [include_header], [data_source_id], [convert_to_text], [run_condition], [run_by_function_point_only])
• ajUpdateRec(table_name, column_headers, data, [filter_type], [filter_condition], [table_schema], [data_source_id], [run_condition], [run_by_function_point_only])
• ajMergeRec(table_name, column_headers, data, table_schema, [data_source_id], [run_condition], [run_by_function_point_only])
• ajDeleteRec(table_name, [column_headers], [data], [filter_type], [filter_condition], [table_schema], [data_source_id], [run_condition], [run_by_function_point_only])
• ajUploadLob(table_name, lob_info, filter_type, filter_condition, table_schema, [data_source_id], [run_condition], [run_by_function_point_only])
• ajDownloadLob(table_name, lob_info, filter_type, filter_condition, table_schema, [data_source_id], [run_condition], [run_by_function_point_only])

File Operation

• ajCheckFileExists(file_path, [run_condition], [run_by_function_point_only])
• ajReadFile(file_location, [column_separator], [left_enclosure_character], [right_enclosure_character], [begin_at_line], [number_of_lines], [character_set], [skip_empty_row], [run_condition], [run_by_function_point_only])
• ajRenameFile(file_path, new_name, [run_condition], [run_by_function_point_only])
• ajCopyFile(source_file_path, destination_file_path, [overwrite], [run_condition], [run_by_function_point_only])
• ajMoveFile(source_file_path, destination_file_path, [overwrite], [run_condition],[run_by_function_point_only])
• ajWriteFile(data, file_location, [write_option], [column_separator], [left_enclosure_character], [right_enclosure_character], [character_set], [number_of_retry], [interval_of_retry], [skip_empty_row], [run_condition], [run_by_function_point_only])
• ajDeleteFile(file_path, [run_condition], [run_by_function_point_only])
• ajReadWorkbook(source_workbook_path, data_range, [convert_to_text], [run_condition], [run_by_function_point_only])
• ajWriteWorkbook(data_range, target_workbook_path, start_address, [convert_to_text], [run_condition], [run_by_function_point_only])

External API Integration

• ajCallFunction(class_name, is_instance, constructor_parameter, method_name, method_parameter, [run_condition], [run_by_function_point_only])
• ajCallWsRest(url, [http_method], [body], [user_name], [password], [header], [content_type], [run_condition], [run_by_function_point_only])
• ajCallWsSoap(url, [http_method], [body], [user_name], [password], [header], [content_type], [run_condition], [run_by_function_point_only])

JSON & XML Handling

• ajFilterJson(json_data, json_path, [return_type], [data_name], [convert_to_text])
• ajMakeJson(header, data, [data_type], [exclude_column])
• ajMakeJsonFromSchema(tables_relationship_header, tables_relationship)
• ajMakeJsonFromTable(header, data, [data_name], [data_type], [exclude_column])
• ajMakeXML(header, data, [data_type], [exclude_column], [root_name], [element_name])
• ajMakeXMLFromSchema(tables_relationship_header, tables_relationship, [root_name])
• ajMakeXMLFromTable(header, data, [data_type], [exclude_column], [root_name], [element_name])
• ajPopulateJsonToTable(table_column, json_data, [traversal_level], [convert_to_text])

LDAP Function

• ajAuthenLdap(server_name, domain_name, user_id, password, [run_condition], [run_by_function_point_only])

Common Function

• ajCheckDataItem(header, data, data_dictionary, [error_definition], [transform])
• ajSendEmail(host, port, sender_address, to_address, cc_address, bcc_address, subject, message, [html_mail], [attachment_path], [run_condition], [run_by_function_point_only])
• ajFilterArray(in_array, include, [if_empty], [convert_to_text])
• ajSortArray(in_array, [sort_index], [sort_order], [by_col], [convert_to_text])
• ajRegExpCount(input_string, pattern, [start_position], [ignore_case], [multi_line])
• ajRegExpMatch(input_string, pattern, [start_position], [ignore_case], [multi_line], [global_match])
• ajGetAddress(cell_reference, [return_as_range], [address_type])
• ajGetLastUsedCellAddress(worksheet_name)
• ajGetUsedRangeAddress(cell_reference)

Error Handling

• ajRaiseError(error_message, [error_code], [cell_reference], [run_condition], [run_by_function_point_only])
• ajGetModelError([cell_reference], [error_code], [error_message])
• ajGetSystemError([cell_reference], [function_name], [error_message])