445b5db1-be56-41d6-82ac-84902d8a8ba0.jpg

UiPath Solution Architect

This package includes the following functionalities:

  

1\. **Create Token**: This activity is used to authenticate a user. This will be the starting point for any action.

  

**Arguments**:

1\. in\_strLoginMode: Standard (1), Anonymous (8), or LDAP (16)

2\. in\_strPWD: User’s Password

3\. in\_strUID: User’s ID

4\. in\_strMSUrl: URL for Microstrategy

5\. out\_strToken: Authorization Token

6\. out\_strJSess: Session Token

  

  

2\. **Get All Projects**: This activity is used to get all the projects which are available to the user.

  

**Arguments**:

1\. in\_strToken: Authorization Token

2\. in\_strJSess: Session Token

3\. in\_strMSUrl: URL for Microstrategy

4\. out\_Json\_Results: A JsonArray Of Response

  

  

3\. **Get All Subscriptions**: This activity is used to get all the subscriptions available to the user.

  

**Arguments**:

1\. in\_strToken: Authorization Token

2\. in\_strJSess: Session Token

3\. in\_strProjectId: Project’s ID

4\. in\_strMSUrl: URL for Microstrategy

5\. out\_Json\_Results: A JsonObject Of Response

  

  

4\. **Get Report Details**: This activity is used to get the details of a report.

  

**Arguments**:

1\. in\_strToken: Authorization Token

2\. in\_strJSess: Session Token

3\. in\_strProjectId: Project’s ID

4\. in\_ReportId: Report’s ID

5\. in\_strMSUrl: URL for Microstrategy

6\. out\_Json\_Results: A JsonObject Of Response

  

  

5\. **Trigger Event**: This activity is used to trigger an event. An event can be linked to subscriptions to trigger reports.

  

**Arguments**:

1\. in\_strToken: Authorization Token

2\. in\_strJSess: Session Token

3\. in\_strProjectId: Project’s ID

4\. in\_Eventid: Event’s ID

5\. in\_strMSUrl: URL for Microstrategy

  

  

6\. **Log Out**: This activity is used to logout a user. This will be the ending point for any flow.

  

**Arguments**:

1\. in\_strToken: Authorization Token

2\. in\_strJSess: Session Token

3\. in\_strMSUrl: URL for Microstrategy

This custom activity can be used to perform actions in the MicroStrategy Application.

The activity requires the following arguments:

  

1\. **in\_str\_Output\_Folder** : Folder where the user wants the text files to be placed.

2\. **in\_str\_Api\_Key** : The Google Vision API Key.

3\. **in\_str\_BagOfWords\_File\_Path** : The path to the Text file which can be used as a DataBank for incorrect words.

4\. **in\_str\_Api\_ServiceKey\_Path** : The path to the Google vision JSON.

5\. **in\_str\_Input\_Folder**: The folder where the images (\*.jpeg,\*.PNG) are placed.

  

  

**To learn how to get the Google API key and JSON file for free you can refer to my blog post:**

**https://www.kartikaydhar.online/post/handwriting-recognition-bot-uipath-ai**

Use this Bot to read text in images (like handwritten notes) and create a DataBank that can be used for future runs to make the recognition more robust and quick. This activity requires Google Vision API.

One of the most asked about feature in business is to calculate the business days between dates to validate if there is any SLA that was missed.

  

There is an easy way to do it currently, especially with a Holiday Calendar.

  

To resolve this, I created this activity that can:

  

1\. Use the Federal Holiday List for US (pulled dynamically for the year required.)

2\. Send a custom list of Dates to be excluded.

  

  

**Arguments**:

1.  **in\_From\_Date**: The From date in DateTime Format.
2.  **in\_To\_Date**: The To date in DateTime Format.
3.  **in\_Country\_Code**: Keep as “US” for US Federal Holidays. If you want to pass custom holidays, leave as Blank.
4.  **in\_Year**: The Year for which you are running the Activity.
5.  **out\_int\_Business\_Days**: Output in Integers for Number of Days.
6.  **optional\_in\_list\_holidays**: If you want to give your own holiday list, please provide in List Format.

Calculate the business days between two dates while excluding weekends and holidays.

About me