A consulting, implementation and managed services firm, passionate about the ‘Future of Work’.

We help enterprises leverage the latest Robotic Process Automation, Intelligent Automation and innovative resourcing solutions.

The Symphony team is an experienced group of practitioners known for being champions of innovation and the implementers of change. We are recognized and respected experts in the technologies and approaches that represent the ‘Future of Work’.

We are recognized as a leading automation service provider. Our extensive experience, process-first approach, and background in consulting and outsourcing services, allows us to create clear value and rapid ROI for our clients around the world.

d797799d-f55b-4ca4-9bd2-4c6301e27e44.jpg

Head of UiPath Implementation

Head of UiPath

Built to enterprise-level and industry-leading standards, this snippet utilizes the Excel Application Scope so that it can be run entirely in the background. 

  

It is 100% reusable with pre and post conditions to ensure safe and reliable operation, and can be configured to read in table headers or not, by setting the in\_BoolAddHeader to true or false. A spreadsheet password can also be provided when applicable.

*   ​​**Pre-Condition:**​ Check for existence of the required Workbook, if not found, throw Application Exception.
*   **Post-Condition:** Checks if the output DataTable is initialised​.

**Arguments:**

*   ​in\_BoolAddHeaders
*   ​out\_DtExtractedData
*   ​​in\_StrSheetName
*   in\_StrWorkbookFileName
*   ​in\_StrWorkbookFilePath
*   ​in\_StrRange
*   in\_StrWorkbookPassword (Optional)

Extract data from a singl​e sheet within a given Workbook, factoring in password protection if applicable.

Built to enterprise-level and industry-leading standards, this component utilises the Excel Application Scope so that it can be run entirely in the background. It is 100% reusable with pre and post conditions to ensure safe and reliable operation and can be configured to write table headers or not, by setting the in\_BoolAddHeaders argument to true or false. A spreadsheet password can also be provided when applicable.

**​​Pre-Condition:​** Input arguments are not null or not initialised

**Post-Condition:** Workbook written to exists​.

**Arguments:**

​in\_BoolAddHeaders

​in\_DtToWrite

​​in\_StrSheetName

​​in\_StrWorkbookFileName

​in\_StrWorkbookFilePath

in\_StrStartingCellReference

​in\_StrWorkbookPassword (Optional)

Write data to a single sheet within a given Workbook, factoring in password protection and overwriting any existing data.​

SyForms will permit the RPA developers to build (Windows) Forms in similar to the way it is done with Visual Studio.

The Form has got features to interact directly with UiPath and permit to work with the automation and its Data by:

*   Inputting
*   Getting
*   Visualizing
*   Manipulating

Overall, the Syforms custom activity aims to satisfy the need for Front Office/Attended automation of interacting with its user.

You can find [more info](https://devpost.com/software/uipath-form-designer) about SyForms on the Hackathon submission it initially came from.

The Story, Examples and discussions on the Forum Post [here](https://forum.uipath.com/t/syforms-uipath-forms-designer/63539).

The solution proposes to export configurable data contained by the queue items in the Orchestrator and save them as an Excel file.

It is possible to use the current Orchestrator context of the Robot (No Auth) or connect to a different Orchestrator/Tenant, providing an Orchestrator.

**Arguments**

*   Required StrQueueName The Orchestrator Queue Name.
*   Required StrReportDestionationPath The location where the xlsx report will be saved Required (with Auth) StrOrchestratorServerURL The Orchestrator from where the queue report will be permformed (ex:http://platform.uipath.com/). 
*   Required StrColumnMapping The expected report columns - See Column mapping Details bellow.
*   Required (with Auth) StrTenancyName The Orchestrator Tenant consider - Let Blank for 'Default' - The tenancy name is only considered if Auth is used.
*   Required (with Auth) StrCredentialName Criterion to determine if Auth is used - The Credentialname which will be used to pull Credential From either Orchestrator. or the Windows Crendential manager - The Solution is using GetAppCrendentials Workflow from ReFramework.
*   Optional DtmReportFrom The Date from when the Queue Items will be considered.
*   Optional DtmReportTo The Date until when the Queue Items will be considered.

  

**Columns Mapping Details:**

The column mapping will have to be specific as a CSV string to determine the data exported.

It is possible to export different type of data based on prefix

**Prefixes / Description**

**data.** Refer to the Specific content 

**exc.** Refer to the exception property

**output.** Refer to the output data stored

**No prefix** Refer to a property of the Queue Item (ex: Status, Priority etc…)

Example of Column mapping strings:

Priority, Key, Status, exc.Details, exc.Type, exc.Reason

CreationTime, StartProcessing, EndProcessing, data.TransactionID, RetryNumber, output.ConfirmationNumber, exc.Details, exc.type, exc.reason

It is recommended to have a read on the API documention (example [here](https://platform.uipath.com/swagger/ui/index#!/QueueItems/QueueItems_GetById)) to see which properties will be available for extraction.

An UiPath project aiming to simplifly reporting based on a specific Orchestrator queue based on the REST API.

The solution proposes to export configurable data contained by the queue items in the Orchestrator and save them as an Excel file.

It is possible to use the current Orchestrator context of the Robot (No Auth) or connect to a different Orchestrator/Tenant, providing an Orchestrator.

  

**Arguments**

*   Required StrQueueName The Orchestrator Queue Name.
*   Required StrReportDestionationPath The location where the xlsx report will be saved Required (with Auth) StrOrchestratorServerURL The Orchestrator from where the queue report will be permformed (ex:http://platform.uipath.com/).
*   Required StrColumnMapping The expected report columns - See Column mapping Details bellow.
*   Required (with Auth) StrTenancyName The Orchestrator Tenant consider - Let Blank for 'Default' - The tenancy name is only considered if Auth is used.
*   Required (with Auth) StrCredentialName Criterion to determine if Auth is used - The Credentialname which will be used to pull Credential From either Orchestrator. or the Windows Crendential manager - The Solution is using GetAppCrendentials Workflow from ReFramework.
*   Optional DtmReportFrom The Date from when the Queue Items will be considered.
*   Optional DtmReportTo The Date until when the Queue Items will be considered.

**Columns Mapping Details:**

The column mapping will have to be specific as a CSV string to determine the data exported.

It is possible to export different type of data based on prefix

**Prefixes / Description**

**data.** Refer to the Specific content

**exc.** Refer to the exception property

**output.** Refer to the output data stored

**No prefix** Refer to a property of the Queue Item (ex: Status, Priority etc…)

Example of Column mapping strings:

Priority, Key, Status, exc.Details, exc.Type, exc.Reason

CreationTime, StartProcessing, EndProcessing, data.TransactionID, RetryNumber, output.ConfirmationNumber, exc.Details, exc.type, exc.reason

It is recommended to have a read on the API documention (example [here](https://platform.uipath.com/swagger/ui/index#!/QueueItems/QueueItems_GetById)) to see which properties will be available for extraction.

This is useful for the following tasks with Shared/Group Mailbox : read mail, send mail, forward mail, save attachment, reply to mail and move mail

7a70dee7-d03d-4f2c-a5e0-2b472c257690.png

The UiPath JSON Manipulation Activity Package uses C# to manipulate and filter JSON text data. This package offers a set of activities to either search through or filter an input JSON text data item. You can also turn serialized JSON string into a datatable.

  

Many API requests return responses in JSON text format. This package makes efficient C# JSON manipulation facilities available which would otherwise require conversions and looping in UiPath. With this package you can directly index and filter JArray and JObjects strings.

  

Code samples demonstrating the usage of each activity are available as a C# and VB UiPath Project within in the .docx guide.

This UiPath JSON Manipulation Package provides activities to manipulate and filter JSON text data.

The JSON Manipulation Activity Package uses C# to manipulate and filter JSON text data. Since many API requests return responses in JSON text format this package offers a set of activities to either search through or filter an input JSON text data item. It also allows turning a serialized JSON string into a data table as well as enables direct indexing and filtering of JArray and JObjects strings.

  

Code samples demonstrating the usage of each activity are available as a C# and VB UiPath Project within the .docx guide.

  

**Check if Array or Object**

This activity checks to see if the JSON text is an Array or an object. If neither, an exception is thrown.

**Count Entries In Array (**[**Demo Video**](https://youtu.be/P-nF2guYHB8)**)**

This activity counts the number of entries within a JSON array.

**Datatable to JSON**

Converts to Datatable into JSON text

**Filter JSON Array Entries**

This activity filters rows of a JSON Array text based on the input field/value collection.

**Filter JSON Keys**

This activity filters JSON text to include/exclude keys with names in the input Datatable.

**Get Entry by Index (**[**Demo Video**](https://youtu.be/CjqxVtPMvts)**)**

This activity gets the value of a specific entry of a JArray given its index.

**JSON to Datatable**

This activity converts JSON text to a Datatable.

**JSON to Datatable (Skipping JArray)**

This activity converts JSON text to a Datatable. Array entry data from the JSON will not be contained inside Datable.

**List Properties (**[**Demo Video**](https://youtu.be/Jx4a9UbhWdw)**)**

For a JSON Object, this activity returns a CSV of all the properties in the Object and the number of entries. For a JSON Array, this activity returns a CSV of all the properties from all the rows in the Array and the number of entries.

This JSON Manipulation Package provides activities to manipulate and filter JSON text data.

46e3264e-0e75-41dd-8cec-8deb54eac84f.jpg

DateTime conversions can be a tricky hurdle and can be easily mishandled. This activity package exposes the C# DateTime Library so that conversions are explicit.

  

Common functions are made locally so you can quickly and explicitly convert between TimeZones. This package extends the standard functions available to developers and provides easy access to complex queries.

  

Code samples demonstrating the usage of each activity are available as C# and VB UiPath Project within the .docx guide.

  

**SDS - DateTime Converter helps you:**

*   Convert to TimeZone
*   Convert from a DateTime with a specified TimeZone ID to another specified TimeZone ID
*   Convert DateTime to String
*   Convert to Date to String Specified format
*   Get System TimeZone IDs
*   Get an Array of TimeZone IDs available on your system
*   Local to UTC
*   Convert Local DateTime to UTC
*   UTC to TimeZone
*   Convert UTC Time to a TimeZone
*   String to DateTime
*   Parse Exact String to DateTime format
*   Get Local TimeZone
*   Provide Local TimeZone of the System

A range of useful attributes about the TimeZone can be accessed:

*   BaseUTCOffset
*   DaylightName
*   DisplayName
*   ID
*   SupportDaylightSavingTime

This SDS DateTime Package provides activities to convert DateTime objects to different TimeZones and to string the formats.