fc09861a-a4a0-4901-9c35-c655093f57a6.jpg

a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

このパッケージに含まれるアクティビティは、以下のとおりです。

*   Get next run time (次回の実行時刻を取得) - cron の次回の実行時刻を取得するための簡単なアクティビティ。[Quartz.net](http://quartz.net/) ライブラリからのGetTimeAfter メソッドを使用します。
*   Get next run times (以降の複数回の実行時刻を取得) -次の n 回のcron の実行時刻を取得します。同様の GetTimeAfter メソッドをループで使用します。
*   Get all runs in interval (特定期間のすべての実行を取得) – 次の実行を特定の時間範囲で取得します。たとえば、これから 10 日間にスケジュールされている実行をすべて取得するといったことができます。

パッケージに含まれるサードパーティライブラリ Quartz.dll ([https://www.quartz-scheduler.net/](https://www.quartz-scheduler.net/)) を使用してください。このサードパーティライブラリは参照用ではなく、[Quartz.net](http://quartz.net/) ライブラリのすべての type と public メソッドを利用できるように、このパッケージに含まれています。

Orchestrator のスケジュールされたジョブのカレンダーを取得するために使用できます。このために使用できるスニペット ([Export Schedules Calendar for Orchestrator](https://go.uipath.com/component/export-schedules-calendar-for-orchestrator)) も用意されています。Orchestrator API は、特定のスケジュールに対する cron のみを提供し、cron に基づく以降の実行時刻は提供しないので、このパッケージで提供されているメソッドを使用して、スケジュールに基づく実行時刻を取得できます。

注: カスタムアクティビティのインストールのガイドラインは、[こちら](https://dmtyylqvwgyxw.cloudfront.net/instances/214/assets/help-guides/UiPath-Go-Installation-Guide-Custom-Activities.pdf)で参照できます。

cron の次回の実行時刻、または特定の時間範囲内のすべての実行時刻を取得するアクティビティ。サードパーティライブラリ Quartz.net を使用します。

Activities in this package:

*   Get next run time - Simple activity to get the next run time for a cron expression. It uses the GetTimeAfter method from Quartz.net lbrary.
*   Get next run times - Get next "n" run times for a cron expression. Using the same GetTimeAfter method in a loop.
*   Get all runs in interval - Get next runs for a given time range, for example I want all scheduled runs for the next 10 days.

Uses 3rd party library Quartz.dll ([https://www.quartz-scheduler.net/](https://www.quartz-scheduler.net/)), included in the package. The 3rd party library was included in the package, not just added as reference, because this way we can use all types and public methods from the Quartz.net library.

Can be used to get "a calendar" of scheduled jobs in Orchestrator, there is also snippet available for this - [Export Schedules Calendar for Orchestrator](https://go.uipath.com/component/export-schedules-calendar-for-orchestrator). The Orchestrator API provides only the cron expression for a given schedule, not the next run times according to the cron expression, so we can use the methods provided in this package to get the run times according to schedule.

**NOTE**: Installation Guidelines for **Custom Activities** can be found [**here**](https://dmtyylqvwgyxw.cloudfront.net/instances/214/assets/help-guides/UiPath-Go-Installation-Guide-Custom-Activities.pdf)**.**

Activities to get next run time(s) for a cron expression, or all run times in a given time range. Uses 3rd party library Quartz.net

Activities in this package:

*   **Get next run time** - Simple activity to get the next run time for a cron expression. It uses the GetTimeAfter method from Quartz.net lbrary.
*   **Get next run times** - Get next "n" run times for a cron expression. Using the same GetTimeAfter method in a loop.
*   **Get all runs in interval** - Get next runs for a given time range, for example I want all scheduled runs for the next 10 days.

The activities use 3rd party library Quartz.dll ([https://www.quartz-scheduler.net/](https://www.quartz-scheduler.net/)). The 3rd party library was included in the package, not just added as reference, because this way we can use all types and public methods from the Quartz.net library.

Can be used to get "a calendar" of scheduled jobs in Orchestrator, there is also snippet available for this - [Export Schedules Calendar for Orchestrator](https://go.uipath.com/component/export-schedules-calendar-for-orchestrator). The Orchestrator API provides only the cron expression for a given schedule, not the next run times according to the cron expression, so we can use the methods provided in this package to get the run times according to schedule.

  

**Cross Platform Release 2.0**: Listing is upgraded to work on Cross Platform, .NET 6 (Windows Projects), and .NET Framework 4.6.1 (Windows-Legacy).

Activities to get next run time(s) for a cron expression, or all run times in a given time range.

This listing interacts with Google Spreadsheet by calling Google API.

Interacts with Google Spreadsheet by calling Google API.

This listing interacts with Google Spreadsheet by calling Google API.

  

**Cross Platform Release**

  

The activity is upgraded to work on Cross Platform, .NET 6 (Windows Projects), and .NET Framework 4.6.1 (Windows-Legacy).

Extended PDF App Integration with useful new activities: merging, splitting, watermarking.

**NOTE**: Installation Guidelines for Custom Activities can be found [here](https://dmtyylqvwgyxw.cloudfront.net/instances/214/assets/help-guides/UiPath-Go-Installation-Guide-Custom-Activities.pdf)

Developed together with [Lavinia Nastase](https://go.uipath.com/profile/lavinia-nastase-227655)

Extended PDF activities using the PDFSharp library

The criteria for generating the password are

*   minimum and maximum length
*   required number of lowercase and uppercase letters
*   required number of digits
*   required number of special characters

All length requirements have to be below 1000 characters. It utilizes **System.Security.Cryptography.RNGCryptoServiceProvider** for generating the random passwords with a 4 Byte seed.

  

Robots utilize service accounts to access a certain application, but due to security policies the passwords have to be updated after a specific time. A new password will have to be generated with the specific criteria for the respective application. The password will then have to be updated on the Orchestrator for the respective Robot machine. This allows the Robot to maintain its password without involving the human factor.

  

  

**Note:** The functionalities are offered to allow robots to interact directly with existing business processes. They are not designed to provide new information security paradigms, but instead a means to allow the robot to interact with the existing security that is being deployed within a business.

An activity that generates a random password with various user given criteria.

**Release 2.0:**

*   Listing is upgraded to work on Cross Platform, .NET 6 (Windows Projects) and also .NET 4.5.1 (Windows-Legacy)

  

The criteria for generating the password are:

*   minimum and maximum length.
*   required number of lowercase and uppercase letters.
*   required number of digits.
*   required number of special characters.

All length requirements have to be below 1000 characters. It utilizes **System.Security.Cryptography.RNGCryptoServiceProvider** for generating the random passwords with a 4 Byte seed.

  

Robots utilize service accounts to access a certain application, but due to security policies, the passwords have to be updated after a specific time. A new password will have to be generated with the specific criteria for the respective application. The password will then have to be updated on the Orchestrator for the respective Robot machine. This allows the Robot to maintain its password without involving the human factor.

  

  

**Note:** The functionalities are offered to allow robots to interact directly with existing business processes. They are not designed to provide new information security paradigms, but instead a means to allow the robot to interact with the existing security that is being deployed within a business.

The criteria for generating the password are:

*   minimum and maximum length.
*   required number of lowercase and uppercase letters.
*   required number of digits.
*   required number of special characters.

All length requirements have to be below 1000 characters. It utilizes **System.Security.Cryptography.RNGCryptoServiceProvider** for generating the random passwords with a 4 Byte seed.

  

Robots utilize service accounts to access a certain application, but due to security policies, the passwords have to be updated after a specific time. A new password will have to be generated with the specific criteria for the respective application. The password will then have to be updated on the Orchestrator for the respective Robot machine. This allows the Robot to maintain its password without involving the human factor.

  

  

**Note:** The functionalities are offered to allow robots to interact directly with existing business processes. They are not designed to provide new information security paradigms, but instead a means to allow the robot to interact with the existing security that is being deployed within a business.

  

**Release 2.0:**

*   Listing is upgraded to work on Cross Platform, .NET 6 (Windows Projects) and also .NET 4.5.1 (Windows-Legacy).

The latest version comes with 2 brand new Authentication Methods: **AppOnly** and **AzureApp**. (full details for these 2 can be found in the PDF documentation in the resources Tab)

  

**AzureApp** is a login mode that will use an Azure App to impersonate a specific user and perform actions on their behalf. It uses the AzureApplicationID, AzureAppPermissions, Username and Password/SecurePassword properties. T**his login mode is only available for SharePoint Online instances only.**

  

You should use **AppOnly** for SharePoint sites for which you are able to create an app-principal. When you create a SharePoint app-principal you will obtain a  Client Id and a Client Secret  and you will use the two codes for logging in and the credentials are no longer required!

**This is an indepth guide on how an app-principal can be created:** https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azureacs

**This cheatsheet can be used to assign permissions to an Appp-Principal:** https://medium.com/ng-sp/sharepoint-add-in-permission-xml-cheat-sheet-64b87d8d7600

  

The **WebLogin** Authentication Mode (found under the SharePoint Instance Type property) which can  potentially authenticate the robot even if the SharePoint instance is using 3rd party identity providers or if only multi factor authentication is possible. This happens by prompting the user to insert their credentials the first time the workflow is executed, afterwards which the robot stays authenticated. **Given that this mode requires human input, it is recommended that this authentication mode is used only for attended automation**

  

**Activities**

1.**SharePoint Activity Scope**

**2.SharePoint.Activities.Lists**

· AddListItem

· GetListItems

· DeleteListItems

· UpdateListItems

· AddListItemAttachments

· GetListItemAttachments

· DeleteListItemAttachments

**3.SharePoint.Activities.Libraries**

· CreateFolder

· Delete

· GetChildrenNames

· GetFile

· UploadFile

· UploadLargeFile

· MoveItem

· RenameItem

· Check In File

· Check Out File

· Discard check out

**4.SharePoint.Activities.Users**

· AddUsersToGroup

· CreateUserGroup

· RemoveGroup

· RemoveUserFromGroup

· GetUser

· GetAllUsersInsideGroup

**5.SharePoint.Activities.Permissions**

· AddPermission

· RemovePermission

· GetAllPermissionsFromGroup

6\. Sign Out

7\. Get Web Login User

8\. GetTimezone

  

**Prerequisites**

· Have access to an instance of SharePoint and an account with all the necessary permissions. **You will not be able to use this package using your credentials to do any operations that you couldn't do on your SharePoint environment in the browser.**

· **This solution might not work if your SharePoint instance is using a 3rd party Identity Provider.**

  

**Please find more details on how to use each of the activities on the package in the attached documentation!**

A custom activities package that allows the management of List Items, Library Files and Folders, Users, Groups and Permissions. New activities and 2 new authentication modes have been added in v1.7.0

The latest version comes with 2 brand new Authentication Methods: **AppOnly** and **AzureApp** (full details for these 2 can be found in the PDF documentation in the Resources section).

  

**AzureApp** is a login mode that will use an Azure App to impersonate a specific user and perform actions on their behalf. It uses the AzureApplicationID, AzureAppPermissions, Username and Password/SecurePassword properties. **This login mode is only available for SharePoint Online instances only.**

  

You should use **AppOnly** for SharePoint sites for which you are able to create an app-principal. When you create a SharePoint app-principal you will obtain a Client Id and a Client Secret. You will use the two codes for logging in and the credentials are no longer required!

  

**This is an indepth guide on how an app-principal can be created:** https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azureacs.

  

**This cheatsheet can be used to assign permissions to an App-Principal:** https://medium.com/ng-sp/sharepoint-add-in-permission-xml-cheat-sheet-64b87d8d7600.

  

The **WebLogin** Authentication Mode (found under the SharePoint Instance Type property) can potentially authenticate the robot even if the SharePoint instance is using 3rd party identity providers or if only multi-factor authentication is possible. This happens by prompting the user to insert their credentials the first time when the workflow is executed, afterwards the robot stays authenticated. **Given that this mode requires human input, it is recommended that this authentication mode is used only for attended automation.**

  

**Activities**

  

**1\. SharePoint Activity Scope**

**2\. SharePoint.Activities.Lists**

· AddListItem

· GetListItems

· DeleteListItems

· UpdateListItems

· AddListItemAttachments

· GetListItemAttachments

· DeleteListItemAttachments

**3\. SharePoint.Activities.Libraries**

· CreateFolder

· Delete

· GetChildrenNames

· GetFile

· UploadFile

· UploadLargeFile

· MoveItem

· RenameItem

· Check In File

· Check Out File

· Discard check out

**4\. SharePoint.Activities.Users**

· AddUsersToGroup

· CreateUserGroup

· RemoveGroup

· RemoveUserFromGroup

· GetUser

· GetAllUsersInsideGroup

**5\. SharePoint.Activities.Permissions**

· AddPermission

· RemovePermission

· GetAllPermissionsFromGroup

**6\. Sign Out**

**7\. Get Web Login User**

**8\. GetTimezone**

  

**Prerequisites**

  

· Have access to an instance of SharePoint and an account with all the necessary permissions. **You will not be able to use this package using your credentials to do any operations that you couldn't do on your SharePoint environment in the browser.**

· **This solution might not work if your SharePoint instance is using a 3rd party Identity Provider.**

  

**Please find more details on how to use each of the activities on the package in the attached documentation!**

The latest version comes with 2 brand new Authentication Methods: **AppOnly** and **AzureApp** (full details for these 2 can be found in the PDF documentation in the Resources section).

**AzureApp** is a login mode that will use an Azure App to impersonate a specific user and perform actions on their behalf. It uses the AzureApplicationID, AzureAppPermissions, Username and Password/SecurePassword properties. **This login mode is only available for SharePoint Online instances only.**

You should use **AppOnly** for SharePoint sites for which you are able to create an app-principal. When you create a SharePoint app-principal you will obtain a Client Id and a Client Secret. You will use the two codes for logging in and the credentials are no longer required!

**This is an in depth guide on how an app-principal can be created:** https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azureacs.

**This cheatsheet can be used to assign permissions to an App-Principal:** https://medium.com/ng-sp/sharepoint-add-in-permission-xml-cheat-sheet-64b87d8d7600.

The **WebLogin** Authentication Mode (found under the SharePoint Instance Type property) can potentially authenticate the robot even if the SharePoint instance is using 3rd party identity providers or if only multi-factor authentication is possible. This happens by prompting the user to insert their credentials the first time when the workflow is executed, afterwards the robot stays authenticated. **Given that this mode requires human input, it is recommended that this authentication mode is used only for attended automation.**

### **Activities**

**1. SharePoint Activity Scope**

**2. SharePoint.Activities.Lists**

- AddListItem
- GetListItems
- DeleteListItems
- UpdateListItems
- AddListItemAttachments
- GetListItemAttachments
- DeleteListItemAttachments

**3. SharePoint.Activities.Libraries**

- CreateFolder
- Delete
- GetChildrenNames
- GetFile
- UploadFile
- UploadLargeFile
- MoveItem
- RenameItem
- Check In File
- Check Out File
- Discard check out

**4. SharePoint.Activities.Users**

- AddUsersToGroup
- CreateUserGroup
- RemoveGroup
- RemoveUserFromGroup
- GetUser
- GetAllUsersInsideGroup

**5. SharePoint.Activities.Permissions**

- AddPermission
- RemovePermission
- GetAllPermissionsFromGroup

**6. Sign Out**

**7. Get Web Login User**

**8. GetTimezone**

### **Prerequisites**

- Access to an instance of SharePoint and an account with all the necessary permissions. **You will not be able to use this package using your credentials to do any operations that you couldn't do on your SharePoint environment in the browser.**
- **This solution might not work if your SharePoint instance is using a 3rd party Identity Provider.**

**Please find more details on how to use each of the activities included in the package in the attached documentation!**

A custom activities package that allows the management of List Items, Library Files and Folders, Users, Groups and Permissions.

The solution provides a visual notifications system for attended robots. It's based on a stop light kind of color code, red statuses would signify interrupts for the human user who shares the machine with the attended robot, green light would signify Go and there's a yellow info only message color that would be the default (and would be used for informational purposes).

Stop Light style notifications for attended robots, to get notifications about the process activity.

The activity provides a visual notifications system for attended robots. It's based on a stop light kind of color code:

*   red statuses signify interrupts for the human user who shares the machine with the attended robot.
*   green light signifies Go.
*   yellow info only message color that is the default (and can be used for informational purposes).

  

**Release 2.0:**

Listing is upgraded to work on both Windows Projects (.NET 6) and Windows-Legacy projects (.NET Framework 4.6.1).

This activity returns an array of Color objects. Each Color in the array corresponds to the color of a pixel from the input image. 

The input can be either an Image object, or the path to an image file as a String. If a UI element in a Citrix environment is color coded (a button that changes color when a file is ready for download, red/black text designating credits/debits, etc.), this activity can be used to iterate through on screen pixels and detect that color by passing a screenshot of the current display as input.

Returns an array of System.Drawing.Color objects corresponding to pixels from an Image object.

This activity takes input a HTML Code as string. We can specify in the Boolean flag whether or not we want to add header. i.e. to treat first row as Header in case  is not present.

  

**Note:** TH will always be treated as header even if we specify Add Header as false.

  

The Output is an array of DataTable.

  

**Use cases:**

1.  Extract tables from HTML Mail body.
2.  Extract tables from files which contains HTML formatted data.

A custom activity which takes HTML as input and returns a DataTable in case you have TR and TD in your HTML.

Unofficial library of DevOps PowerShell scripts to support customers to integrate CI/CD into their workflows and allow them to package, deploy and run automations and tests.

Test Suite team are offering our customers CI plugins for Jenkins and Azure Devops. Now more and more customers are requesting integrations to other platforms like GitLab and Circle CI and UiPath is not able to create native plugins for all of them.

Until a generic solution is officially released, this unofficial library of can be used.

  

PowerShell Scripts

[UiPathPack](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathPack.md): Pack one or more projects into a package. 

[UiPathDeploy](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathDeploy.md): Deploy packages to an Orchestrator instance, optionally publishing them to a set of environments. 

[UiPathJobRun](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathJobRun.md): Trigger a job on Orchestrator. 

[UiPathRunTest](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathRunTest.md): Tests a given package or runs a test set. 

[UiPathManageAssets](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathManageAssets.md): Manage UiPath Orchestrator assets.

Unofficial library of DevOps PowerShell scripts to support customers to integrate CI/CD into their workflows and allow them to package, deploy and run automations and tests.

Test Suite team are offering our customers CI plugins for Jenkins and Azure Devops. Now more and more customers are requesting integrations to other platforms like GitLab and Circle CI and UiPath is not able to create native plugins for all of them.

Until a generic solution is officially released, this unofficial library of can be used.

  

PowerShell Scripts

[UiPathPack](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathPack.md): Pack one or more projects into a package. 

[UiPathDeploy](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathDeploy.md): Deploy packages to an Orchestrator instance, optionally publishing them to a set of environments. 

[UiPathJobRun](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathJobRun.md): Trigger a job on Orchestrator. 

[UiPathRunTest](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathRunTest.md): Tests a given package or runs a test set. 

[UiPathManageAssets](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathManageAssets.md): Manage UiPath Orchestrator assets.

[UiPathAnalyzeProject](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathAnalyzeProject.md): Check project(s) for workflow analyzer violations

[UiPathCLIGeneric](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathCLIGeneric.md): This script is designed for those who know how to work with uipcli.exe and would like to call the cli directly. This script will pass the provided parameters as is directly to uipcli.exe.

  

**New Features:**

\- scripts updated to use External App authentication

\- [UiPathAnalyzeProject](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathAnalyzeProject.md)

\- [UiPathCLIGeneric](https://github.com/UiPath-Services/UiPath-DevOps-Scripts/blob/main/docs/UiPathCLIGeneric.md)

\- Bug fixes

About me