This tool runs a xml script to automate recurring tasks. Useful on backup scenarios.
- The Configuration File
- Settings
- Execute Commands
The default configuration file is called "DoIt.config.xml". Its main sections are "Settings" and "Execute", which contains the settings used when executing and the steps to run, respectively.
If you want to use another configuration file you can use:
C:\DoIt\DoIt.exe /config="C:\DoIt\AnotherConfigFile.config.xml"Here is a configuration file example. Please use the full documentation for more commands or options.
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<!-- Here we load some data to use when executing -->
<Settings>
<ConnectionStrings>
<Database id="1">Data Source=localhost\sql2016express; Initial Catalog=database; Integrated Security=false; User Id=sa; Password=123;</Database>
<Storage id="1">DefaultEndpointsProtocol=https;AccountName=my_account;AccountKey=871oQKMifslemflIwq54e0fd8sJskdmw98348dMF0suJ0WODK73lMlwiehf34u0mm5ez6MdiewklFH3/w2/IEK==</Storage>
<MailServer id="1">host=smtp.domain.com; from=user@domain.com; port=587; ssl=true; user=user@domain.com; pass=123;</MailServer>
</ConnectionStrings>
<Exceptions mailServer="1" attachLogFile="true">
<Mail>admin1@company.com</Mail>
<Mail>admin2@company.com</Mail>
</Exceptions>
<LogFile toVar="logFile">%programdata%\DoIt\DoIt_{now:yyyy-MM-dd}.log</LogFile>
</Settings>
<!-- Here we put the script steps -->
<Execute>
<Log>We can use variables!</Log>
<SetValue>
<String to="my_var1" value="{now}" />
</SetValue>
<Log>Today is: {my_var1:yyyy-MM-dd}.</Log>
<Log>Load the files from a directory to a variable</Log>
<LocalDisk>
<ListFiles to="files_list" path="C:\MyFolder" searchPattern="*.*" allDirectories="false" fetchAttributes="false" where="" sort="" regex="" />
</LocalDisk>
<Log>We can also use loops!</Log>
<ForEach itemFrom="files_list" where="" sort="">
<Log>File: {files_list.filename}</Log>
</ForEach>
<Log>Here is how to execute a SQL command to the database with id=1</Log>
<Sql database="1">
<Execute timeout="30">insert into backups (start_date) values (getdate())</Execute>
</Sql>
<Log>Create a database backup and save the filename to the variable bak1</Log>
<Database id="1">
<Backup toFile="%programdata%\DoIt\MyDatabase_{now:yyyy-MM-dd_HH-mm}.bak" type="bak" toVar="bak1" />
</Database>
<Log>Upload the bak1 file to the storage with id=1</Log>
<Storage id="1">
<Upload file="{bak1}" toBlob="backups/Backup_{now:yyyy-MM-dd}/{bak1:filename}" deleteSource="true" />
</Storage>
</Execute>
</Configuration>You can encrypt/decrypt the connection strings from the configuration file using the following commands:
C:\DoIt\DoIt.exe /config="C:\DoIt\AnotherConfigFile.config.xml" /encryptionKey="test123"
Configuration file was encrypted.
C:\DoIt\DoIt.exe /config="C:\DoIt\AnotherConfigFile.config.xml" /decryptionKey="test123"
Configuration file was decrypted.To use an encrypted configuration file without decrypting it, you should use the following command:
C:\DoIt\DoIt.exe /config="C:\DoIt\AnotherConfigFile.config.xml" /cryptKey="test123"Use this tag to specify the log path and variable.
Tag Location: Configuration > Settings > LogFile
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Settings>
<LogFile toVar="logFile">%programdata%\DoIt\DoIt_{now:yyyy-MM-dd}.log</LogFile>
</Settings>
</Configuration>This tag set database and azure storage account connection strings.
Tag Location: Configuration > Settings > ConnectionStrings
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Settings>
<ConnectionStrings>
<Database id="1">Data Source=localhost\sql2016express; Initial Catalog=database; Integrated Security=false; User Id=sa; Password=123;</Database>
<Storage id="1">DefaultEndpointsProtocol=https;AccountName=my_account;AccountKey=871oQKMifslemflIwq54e0fd8sJskdmw98348dMF0suJ0WODK73lMlwiehf34u0mm5ez6MdiewklFH3/w2/IEK==</Storage>
<MailServer id="1">host=smtp.domain.com; from=user@domain.com; port=587; ssl=true; user=user@domain.com; pass=123;</MailServer>
</ConnectionStrings>
</Settings>
</Configuration>Use this tag to mail users if an exception occurs.
Tag Location: Configuration > Settings > Exceptions
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Settings>
<Exceptions mailServer="1" attachLogFile="true">
<Mail>admin1@company.com</Mail>
<Mail>admin2@company.com</Mail>
</Exceptions>
</Settings>
</Configuration>Backup SQL Server databases.
Tag Location: Configuration > Execute > Database > Backup
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Database id="1">
<Backup toFile="%programdata%\DoIt\MyDatabase_{now:yyyy-MM-dd_HH-mm}.bak" type="bak" withOptions="with compression" timeout="1800" toVar="bak1" />
</Database>
</Execute>
</Configuration>Backup Log SQL Server databases.
Tag Location: Configuration > Execute > Database > BackupLog
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Database id="1">
<BackupLog toFile="%programdata%\DoIt\MyDatabaseLog_{now:yyyy-MM-dd_HH-mm}.bak" withOptions="with compression" timeout="1800" toVar="bak1" />
</Database>
</Execute>
</Configuration>Add a new file to the specified zip package.
Tag Location: Configuration > Execute > Zip > AddFile
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Zip path="C:\MyFiles.zip" mode="write">
<AddFile name="C:\MyFile1.txt" deleteSource="true" zipFolder="" zipFilename="MainData.txt" />
<AddFile forEach="users_list" where="is_active=1" name="C:\Users\UserData{users_list.id}.csv" deleteSource="false" />
</Zip>
</Execute>
</Configuration>Download blob from a storage account and add it to the specified zip package.
Tag Location: Configuration > Execute > Zip > AddBlob
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Zip path="C:\MyFiles.zip" mode="write">
<AddBlob fromStorage="1" name="my_container/myblob1.txt" zipFolder="" zipFilename="File.txt" />
<AddBlob forEach="blobs_list" where="blob_length <= 5*1024*1024" fromStorage="1" name="{blobs_list.blob_container}/{blobs_list.blob_name}" snapshotTime="" dateTime="{blobs_list.blob_last_modified}" size="{blobs_list.blob_length}" timeout="60min" retryTime="30s" retryAttempts="0" />
</Zip>
</Execute>
</Configuration>Extract a zip package to the specified folder.
Tag Location: Configuration > Execute > Zip > Extract
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Zip path="C:\MyFiles.zip" mode="read">
<Extract toFolder="C:\MyFolder" />
</Zip>
</Execute>
</Configuration>Starts an external application.
Tag Location: Configuration > Execute > Process > Start
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Process>
<Start path="C:\MyApp.exe" args="" wait="true" time="" />
</Process>
</Execute>
</Configuration>Kills an executing process.
Tag Location: Configuration > Execute > Process > Kill
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Process>
<Kill id="" name="chrome" />
</Process>
</Execute>
</Configuration>List the executing processes. The returned datatable will contain the following columns:
- id (int)
- session_id (int)
- name (string)
- machine (string)
- start (DateTime)
- filename (string)
Tag Location: Configuration > Execute > Process > List
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Process>
<List name="" machine="" regex="" to="process_list" />
</Process>
</Execute>
</Configuration>Execute SQL commands.
Tag Location: Configuration > Execute > Sql > Execute
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Sql database="1">
<Execute timeout="30">insert into dbo.backups (start_date) values (getdate())</Execute>
<Execute timeout="30">
<Cmd>
update dbo.table set value1=@Value1, value2=@Value2 where id=@Id
</Cmd>
<Params>
<Value1 type="string">{str1}</Value1>
<Value2 type="string">{str2}</Value2>
<Id type="int">{id}</Id>
</Params>
</Execute>
</Sql>
</Execute>
</Configuration>Execute SQL queries and set the results to the specified variable.
Tag Location: Configuration > Execute > Sql > Select
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Sql database="1">
<Select to="users_table" timeout="30">
select us.id, us.name, us.email from dbo.users us where us.removed=0
</Select>
<Select to="users_table" timeout="30">
<Cmd>
select u.* from dbo.users u where u.id=@UserId
</Cmd>
<Params>
<UserId type="int">{user_id}</UserId>
</Params>
</Select>
</Sql>
</Execute>
</Configuration>Execute the SQL command/query and set the result to the specified variable.
Tag Location: Configuration > Execute > Sql > Scalar
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Sql database="1">
<Scalar to="user_id" timeout="30">
select us.id from users us where us.email='user@mycompany.com'
</Scalar>
<Scalar to="user_id" timeout="30">
<Cmd>
select us.id from users us where us.email=@Email
</Cmd>
<Params>
<Email type="string">{email}</Email>
</Params>
</Scalar>
</Sql>
</Execute>
</Configuration>Send an e-mail.
Tag Location: Configuration > Execute > Mail
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Mail server="1" to="other_user@domain.com" subject="Hello World">
<Body>
Here is my mail body.
</Body>
<Attachments>
<File path="C:\MyFileToSend.txt" />
<File path="C:\My2ndAttachment.txt" />
<SqlQuery database="1" dataFormat="csv|json|xml" zip="true|false" attachmentName="" zipEntryName="">
select t.id, t.total, t.date from orders t where t.date>=cast(getdate() as date)
</SqlQuery>
</Attachments>
</Mail>
</Execute>
</Configuration>Loop throught the rows in the specified table.
Tag Location: Configuration > Execute > ForEach
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<ForEach itemFrom="users_list" where="" sort="" parallel="1">
<Log>User Name: {users_list.name}.</Log>
</ForEach>
</Execute>
</Configuration>Write a new line to the previously specified log file.
Tag Location: Configuration > Execute > Log
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Log>Hello World!</Log>
</Execute>
</Configuration>Block the current thread for the specified time.
Tag Location: Configuration > Execute > Sleep
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Sleep time="30 seconds" />
</Execute>
</Configuration>Throw a new exception.
Tag Location: Configuration > Execute > Exception
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Exception assembly="" type="System.Exception" message="Oh no, something is wrong!" />
</Execute>
</Configuration>Try to run some commands for the specified retry times.
Tag Location: Configuration > Execute > Try
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Try retry="3" sleep="40 seconds">
<Catch>
<Exception type="System.Net.WebException" withMessage="(409) Conflict" />
<Exception type="Microsoft.WindowsAzure.Storage.StorageException" withMessage="(409) Conflict" />
</Catch>
<Execute>
<Log>The commands to run are here!</Log>
</Execute>
<Fail>
<Log>Command failed :(</Log>
</Fail>
</Try>
</Execute>
</Configuration>Write a new line in the specified csv file.
Tag Location: Configuration > Execute > Csv > WriteLine
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Csv path="C:\MyFile.csv" separator=";">
<WriteLine append="false">
<Column>id</Column>
<Column>name</Column>
<Column>email</Column>
</WriteLine>
</Csv>
<ForEach itemFrom="users_list">
<Csv path="C:\MyFile.csv" separator=";">
<WriteLine append="true">
<Column>{users_list.id}</Column>
<Column>{users_list.name}</Column>
<Column>{users_list.email}</Column>
</WriteLine>
</Csv>
</ForEach>
</Execute>
</Configuration>Write the datatable to the specified csv file.
Tag Location: Configuration > Execute > Csv > WriteData
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Csv path="C:\MyFile.csv" separator=";">
<WriteData data="users_list" where="" append="false">
<Column header="id">{users_list.id}</Column>
<Column header="name">{users_list.name}</Column>
<Column header="email">{users_list.email}</Column>
</WriteData>
</Csv>
</Execute>
</Configuration>Load the specified csv file to a new datatable.
Tag Location: Configuration > Execute > Csv > Load
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Csv path="C:\MyFile.csv" separator=";">
<Load to="users_list" where="" hasHeaders="true" />
</Csv>
</Execute>
</Configuration>Count the rows found in the specified table.
Tag Location: Configuration > Execute > DataTable > Count
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<DataTable>
<Count data="users_list" where="" to="users_count" />
</DataTable>
</Execute>
</Configuration>Sum values from the rows in the specified table
Tag Location: Configuration > Execute > DataTable > Sum
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<DataTable>
<Sum data="products_list" column="total" where="" to="total_products" />
</DataTable>
</Execute>
</Configuration>Calculate the average values from the rows in the specified table.
Tag Location: Configuration > Execute > DataTable > Avg
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<DataTable>
<Avg data="products_list" column="price" where="" to="avg_price" />
</DataTable>
</Execute>
</Configuration>Get the min value from the rows in the specified table.
Tag Location: Configuration > Execute > DataTable > Min
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<DataTable>
<Min data="products_list" column="price" where="" to="min_price" />
</DataTable>
</Execute>
</Configuration>Get the max value from the rows in the specified table.
Tag Location: Configuration > Execute > DataTable > Max
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<DataTable>
<Max data="products_list" column="price" where="" to="max_price" />
</DataTable>
</Execute>
</Configuration>Set values on the specified columns/rows.
Tag Location: Configuration > Execute > DataTable > SetRowValue
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<DataTable>
<SetRowValue data="users_list" where="">
<Column name="is_active" type="int">1</Column>
</SetRowValue>
</DataTable>
</Execute>
</Configuration>Find the rows that matches the where condition and set one of them to the specified variable.
Tag Location: Configuration > Execute > DataTable > GetDataRow
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<DataTable>
<GetDataRow fromData="users_list" to="user_row" where="id={orders.id_user}" index="0" />
</DataTable>
</Execute>
</Configuration>Create a new datatable with the rows existing in one datatable and not in other.
Tag Location: Configuration > Execute > DataTable > Diff
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<DataTable>
<Diff inData="blobs_list1" notInData="blobs_list2" columns="blob_container, blob_name, blob_content_md5" to="new_blobs_list" />
</DataTable>
</Execute>
</Configuration>Create a new datatable with the rows from other datatables.
Tag Location: Configuration > Execute > DataTable > Join
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<DataTable>
<Join data="blobs_list1, blobs_list2" to="all_blobs_list" />
</DataTable>
</Execute>
</Configuration>Create a new datatable only with the rows existing in all specified datatables.
Tag Location: Configuration > Execute > DataTable > Intersect
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<DataTable>
<Intersect data="blobs_list1, blobs_list2" columns="blob_name" rowsFrom="0" to="new_blobs_list" />
</DataTable>
</Execute>
</Configuration>Remove rows from the datatable when it matches the where clause.
Tag Location: Configuration > Execute > DataTable > RemoveRows
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<DataTable>
<RemoveRows from="users_list" where="is_active=0" />
</DataTable>
</Execute>
</Configuration>Insert a new row in the specified datatable.
Tag Location: Configuration > Execute > DataTable > InsertRow
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<DataTable>
<InsertRow to="files_list">
<Column name="id" type="int">1</Column>
<Column name="name" type="string">Test User</Column>
<Column name="email" type="string">testuser@company.com</Column>
</InsertRow>
</DataTable>
</Execute>
</Configuration>Filter rows in the specified datatable.
Tag Location: Configuration > Execute > DataTable > Filter
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<DataTable>
<Filter data="users_list" where="is_active=1" to="active_users_list" />
</DataTable>
</Execute>
</Configuration>Execute a simple operation using the specified values.
Tag Location: Configuration > Execute > SetValue > Calc
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<SetValue>
<Calc operation="+|-|*|/" value1="2" value2="3" to="my_calc" />
</SetValue>
</Execute>
</Configuration>Execute a date operation using the specified values.
Tag Location: Configuration > Execute > SetValue > CalcDate
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<SetValue>
<CalcDate to="limit_date" value="{today}" add="-6 months" operation="-|+" />
</SetValue>
</Execute>
</Configuration>Set the value to the specified string variable.
Tag Location: Configuration > Execute > SetValue > String
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<SetValue>
<String value="User Name: {users_list.name}" to="user_name_text" />
<String value="My name is 'John' and today is {today:yyyy-MM-dd}" to="string_test" />
<String value="Good morning, John!" to="string_test">
<Replace oldValue="morning" newValue="afternoon" />
<Replace oldValue="John" newValue="Peter" />
</String>
<String value="{string_test}" to="date_from_str" regex="(\d{4}\-\d{2}\-\d{2})" regexFlags="" regexGroup="" matchIndex="" />
<String value="{string_test}" to="name_from_str" regex="'([a-z]+)'" regexFlags="i" regexGroup="1" matchIndex="" />
</SetValue>
</Execute>
</Configuration>Set the date/time value to the specified variable.
Tag Location: Configuration > Execute > SetValue > Date
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<SetValue>
<Date value="{now}" to="start_date" />
</SetValue>
</Execute>
</Configuration>Query files from a folder. The returned datatable contains the following columns:
- full_path (string)
- directory (string)
- filename (string)
- extension (string)
- creation_time (DateTime)*
- last_write_time (DateTime)*
- length (long)*
The columns creation_time, last_write_time and length will only be filled if the parameter "fetchAttributes" is set to "true".
Tag Location: Configuration > Execute > LocalDisk > ListFiles
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<LocalDisk>
<ListFiles to="files_list" path="C:\MyFolder" searchPattern="*.*" allDirectories="false" fetchAttributes="false" where="" sort="" regex="" />
</LocalDisk>
</Execute>
</Configuration>Change the name from the specified file or move it to another parent folder.
Tag Location: Configuration > Execute > LocalDisk > MoveFile
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<LocalDisk>
<MoveFile path="C:\MyFile1.txt" to="C:\Folder\MyMovedFile.txt" />
</LocalDisk>
</Execute>
</Configuration>Change the name from the specified folder or move it to another parent folder.
Tag Location: Configuration > Execute > LocalDisk > MoveFolder
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<LocalDisk>
<MoveFolder path="C:\MyFolder1" to="C:\Folder\MyMovedFolder" />
</LocalDisk>
</Execute>
</Configuration>Copy the specified file to another file.
Tag Location: Configuration > Execute > LocalDisk > CopyFile
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<LocalDisk>
<CopyFile path="C:\MyFile1.txt" to="C:\Folder\MyFileCopy.txt" overwrite="true" />
</LocalDisk>
</Execute>
</Configuration>Delete the specified file.
Tag Location: Configuration > Execute > LocalDisk > DeleteFile
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<LocalDisk>
<DeleteFile path="C:\MyFile1.txt" />
</LocalDisk>
</Execute>
</Configuration>Delete the specified folder.
Tag Location: Configuration > Execute > LocalDisk > DeleteFolder
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<LocalDisk>
<DeleteFolder path="C:\MyFolder" recursive="false" />
</LocalDisk>
</Execute>
</Configuration>Upload a file to the specified Azure storage account.
Tag Location: Configuration > Execute > Storage > Upload
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Storage id="1">
<Upload file="C:\MyFile_{now:yyyy-MM-dd}.csv" toBlob="backups/Backup_{now:yyyy-MM-dd}/MyFile.csv" deleteSource="true" async="true" timeout="60min" retryTime="30s" retryAttempts="0" />
</Storage>
</Execute>
</Configuration>Download the specified blob.
Tag Location: Configuration > Execute > Storage > Download
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Storage id="1">
<Download blob="my_container/myblob.txt" toFile="C:\MyFile.txt" snapshotTime="" timeout="60min" retryTime="30s" retryAttempts="0" />
</Storage>
</Execute>
</Configuration>Delete the specified blob.
Tag Location: Configuration > Execute > Storage > DeleteBlob
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Storage id="1">
<DeleteBlob container="my_container" name="myblob.txt" />
</Storage>
</Execute>
</Configuration>Query blobs and set the resulting list to a variable. The returned datatable contains the following columns:
- blob_name (string)
- blob_extension (string)
- blob_container (string)
- blob_uri (string)
- blob_length (long)
- blob_last_modified (DateTimeOffset)
- blob_last_modified_utc (DateTime)
- blob_content_type (string)
- blob_content_md5 (string)
- blob_is_snapshot (bool)
- blob_snapshot_time (DateTimeOffset)
- metadata_name1 (string)*
- metadata_name2 (string)*
The columns with the name starting with "metadata_" will only be filled with the blob metadata if the parameter "details" contains the option "metadata" or the parameter "fetchAttributes" is set to "true".
Tag Location: Configuration > Execute > Storage > ListBlobs
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Storage id="1">
<ListBlobs to="blobs_list" container="container{now:yyyyMM}" prefix="" fetchAttributes="false" details="none|snapshots|metadata" where="" sort="" regex="" timeout="60min" retryTime="30s" retryAttempts="0" />
</Storage>
</Execute>
</Configuration>Query containers and set the resulting list to a variable. The returned datatable contains the following columns:
- name (string)
- public_access (string)
- etag (string)
- last_modified (DateTime)
- uri (long)
Tag Location: Configuration > Execute > Storage > ListContainers
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Storage id="1">
<ListContainers to="containers_list" prefix="un" where="" sort="" regex="" />
</Storage>
</Execute>
</Configuration>Copies a blob from one storage account to another.
Tag Location: Configuration > Execute > Storage > Copy
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Storage id="1">
<Copy blob="my_container1/my_blob.txt" toStorage="2" toBlob="my_container2/my_blob.txt" />
</Storage>
</Execute>
</Configuration>Perform a condition and run only the "True" or "False" inner tag, according to the result. The available condition types are:
- has-disk-space
- file-exists
- folder-exists
- has-rows
- is-datetime
- if
Tag Location: Configuration > Execute > Condition
<Condition type="has-disk-space" drive="C:\" min="10000">
<True>
<Log>True Result</Log>
</True>
</Condition><Condition type="file-exists" path="C:\MyFile.txt">
<True>
<Log>True Result</Log>
</True>
</Condition><Condition type="folder-exists" path="C:\MyFolder">
<True>
<Log>True Result</Log>
</True>
</Condition><Condition type="has-rows" data="customers_list">
<True>
<Log>True Result</Log>
</True>
</Condition><Condition type="is-datetime" days="all|mon|wed|fri|1|15" time="08-12">
<True>
<Log>True Result</Log>
</True>
</Condition>
<Condition type="is-datetime" days="1st sunday, 2nd mon, 2018-09-25, last friday">
<True>
<Log>True Result</Log>
</True>
<False>
<Log>False Result</Log>
</False>
</Condition>
<Condition type="if" value1="{files_count}" value2="0" comparison="greater" valueType="numeric">
<True>
<Log>True Result</Log>
</True>
<False>
<Log>False Result</Log>
</False>
</Condition>Make HTTP Requests.
Tag Location: Configuration > Execute > Http > Request
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Http>
<Request method="get" url="https://www.my-company-url.com/view/1" toFile="%programdata%\DoIt\get-request.html"></Request>
</Http>
<Http>
<Request method="post" url="https://www.my-company-url.com/save/1" toVar="resultData">
<Headers>
<Header name="header1">value1</Header>
<Header name="header2">value2</Header>
</Headers>
<Body type="application/json">{"id":5,"name":"User 5"}</Body>
</Request>
</Http>
</Execute>
</Configuration>List all files of a given folder using the connection data provided. The returned datatable contains the following columns:
- name (string)
- type (string) = "folder" | "file"
- length (long)
- datetime (DateTime)
Tag Location: Configuration > Execute > Ftp > List
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Ftp host="ftps://mydomain.com" port="21" user="user_name" password="password123">
<List path="wwwroot" to="files_list" />
</Ftp>
</Execute>
</Configuration>Download the specified file using the connection data provided.
Tag Location: Configuration > Execute > Ftp > Download
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Ftp host="ftps://mydomain.com" port="21" user="user_name" password="password123">
<Download path="wwwroot/myfile.zip" toFile="%programdata%\DoIt\myfile.zip" />
</Ftp>
</Execute>
</Configuration>Upload the specified file using the connection data provided.
Tag Location: Configuration > Execute > Ftp > Upload
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Ftp host="ftps://mydomain.com" port="21" user="user_name" password="password123">
<Upload file="%programdata%\DoIt\myfile.zip" toPath="wwwroot/myfile.zip" />
</Ftp>
</Execute>
</Configuration>Create the specified folders using the connection data provided.
Tag Location: Configuration > Execute > Ftp > CreateFolder
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Ftp host="ftps://mydomain.com" port="21" user="user_name" password="password123">
<CreateFolder path="wwwroot/myfolder/level2/level3" />
</Ftp>
</Execute>
</Configuration>Delete the specified folder using the connection data provided.
Tag Location: Configuration > Execute > Ftp > DeleteFolder
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Ftp host="ftps://mydomain.com" port="21" user="user_name" password="password123">
<DeleteFolder path="wwwroot/myfolder" />
</Ftp>
</Execute>
</Configuration>Delete the specified file using the connection data provided.
Tag Location: Configuration > Execute > Ftp > DeleteFile
<?xml version="1.0" encoding="utf-16" ?>
<Configuration>
<Execute>
<Ftp host="ftps://mydomain.com" port="21" user="user_name" password="password123">
<DeleteFile path="wwwroot/myfile.zip" />
</Ftp>
</Execute>
</Configuration>