Automate tasks like multilingual feedback analysis, content localization and competitor insights with AI-powered automation. Simplify complex processes and improve decision-making across operations.

UiPath Agentic Workflow Templates and Prompts

This collection helps expedite manual operations by integrating automations for personal productivity, cross-team collaboration, project and task management, customer relationship management.

Autopilot for everyone Automations

5bf65208-3184-4d69-8bd2-4d39bb56d468.png

UiPath use case accelerators are automation frameworks which are custom-built for specific use cases. These frameworks use best practices and pre-built components which can be modified, expanded, and 

Solution Accelerators

Step into the world of effortless automation with UiPath Studio Web, your web-based automation canvas.

Studio Web Templates

Embrace Generative AI-powered automations to revolutionize your business operations. Drive strategic insights propelling your organization to new heights of success.

Leverage Generative AI to Amplify Automation

Explore industry-specific Solution Accelerators automating complex data tasks for accuracy and efficiency across sectors.

Enhance Data Extraction with UiPath Document Processing

This collection offers tailored solutions for various industries. Customizable to your needs, these accelerators reduce manual tasks, boosting customer focus.

Let Generative AI Drive Day-to-Day Process Automation

These accelerators tackle claims processing pain points, ensuring faster turnarounds, higher accuracy, and superior customer service.

Accelerate Claims Processing with Intelligent OCR

5ac26976-207d-4570-87af-93679ff1f0d1.png

Discover the power of AI in breaking down language barriers, streamlining repetitive tasks, and automating data extraction.

Artificial Intelligence 

UiPath Integration Service seamlessly combines user interface (UI) and API automation.

UiPath Integration Service Connectors

3fd781a1-c521-43bb-bc29-d01a548f47e4.png

Dive into the world of advanced chatbots and virtual assistants to enhance customer interactions, streamline support, and drive engagement.

Conversational AI

2b43585f-c31b-4fb9-a605-7e94f58c92ae.png

Easily configurable utilities for SAP interaction using BAPI, UiAutomation and SAP Scripting. Whether it's login, registration or grid operations, ensure speed & security with regularly updated packs.

BAPI、UiAutomation、SAP Scripting を使用した SAP 対話用の簡単に構成可能なユーティリティ。ログイン、登録、グリッド操作のいずれであっても、定期的に更新されるパックで速度とセキュリティを確保します。

f894dcd0-fa35-43b6-99a3-4dd1375eeeba.png

UiPath Process Mining provides out-of-the-box application templates for various processes and source systems, serving as a foundation for creating customized process apps to visualize your data.

UiPath Process Mining App Templates

Discover the transformative power of Intelligent Document Processing, an all-inclusive suite of cutting-edge tools, advanced technologies, and AI models seamlessly integrated with UiPath. 

Intelligent Document Processing

75675453-6287-4681-9033-6924c7cd592d.png

Automate scheduling and routine tasks to optimize collaboration and enhance efficiency.

Meeting Management

429d6b08-7b09-406b-bb91-aa8e87e9fb8a.png

Supercharge your Excel workflows by unlocking the power of automation! 

Experience optimized data processing by automating tasks such as filtering, sorting, merging, and aggregating data. Save valuab

Data Automation in Excel

自動化の力を解き放ち、Excel ワークフローを強化しましょう。

データのフィルタリング、並べ替え、結合、集計などのタスクを自動化することで、最適化されたデータ処理を体験してください。貴重な時間を節約し、生産性を向上させ、完璧なデータ精度を簡単に確保します。

ファイル変換を簡単に合理化し、面倒な手動変換に別れを告げます。データを関係者とシームレスに共有し、好みのシステムやアプリケーションに統合

522a48a8-6da0-4664-9ab5-5287724c927f.png

Unlock the unparalleled synergy of advanced technologies and seamless teamwork in the cloud.

Explore the remarkable capabilities of Microsoft Office 365, and empower your team with the comprehensive 

360° Cloud Collaboration

クラウドでの先進テクノロジーとシームレスなチームワークの比類のない相乗効果を解き放ちます。

Microsoft Office 365 の優れた機能を探索し、Office アプリケーションの包括的なスイートでチームを強化し、あらゆるデバイス間での楽なコラボレーション、シームレスなドキュメント共有、および合理化されたコミュニケーションを促進します。

Google Cloud Platform がも

3e9d5444-052e-459f-bb19-907e7e0e4433.png

Seamlessly blend the power of automation with the most popular communication tools of today. Elevate your business efficiency and enhance collaboration with some of the most popular applications avail

Chat and Video Conferencing

自動化の力と、今日最も人気のあるコミュニケーション ツールをシームレスに融合します。 Slack、Zoom、Teams、Kaizala などの最も人気のあるアプリケーションを使用して、ビジネスの効率を高め、コラボレーションを強化します。

日常的なタスクを自動化し、情報を簡単に共有し、チームの生産性を向上させ、グローバルなコラボレーションを促進し、言語の壁を打ち破り、ビデオ会議の包括性を高めます。

cbbc6b4e-f074-4845-bae9-d566ce849604.png

Simplify your email-related tasks with these automations designed to enhance your productivity and efficiency. 

Seamlessly integrate with Microsoft Exchange and unlock a world of possibilities. Maxim

Email Management

生産性と効率性を高めるために設計されたこれらの自動化機能を使用して、電子メール関連のタスクを簡素化します。

Microsoft Exchange とシームレスに統合し、可能性の世界を解き放ちます。電子メールの自動化機能を最大限に活用し、メールボックスを管理し、Exchange サーバーと簡単に対話します。

Outlook エクスペリエンスをコントロールし、メール管理に革命をもたらします。電子メ

b4800617-33aa-4b32-a55b-25e1baebe6e6.png

UiPath’s vision for the “Automation First” era has led to the addition in its market-leading Enterprise RPA Platform of dedicated official out-of-the-box IT Automation capabilities that empower all co

IT Automation

2ce7d800-9fc2-4ae6-8d87-f0cf8e113183.png

The Efficient Operations Management collection offers a carefully curated selection of automations tailored to boost efficiency, minimize manual effort, and guarantee seamless management of essential 

Efficient Operations Management 

Efficient Operations Management コレクションは、効率を高め、手作業を最小限に抑え、重要な運用のシームレスな管理を保証するためにカスタマイズされた自動化の厳選されたセレクションを提供します。

これらの自動化を活用すると、さまざまな可能性が広がります。たとえば、IBM Operational Decision Manager の機能を利用して意思決定プロセスを自動化お

dcb8ac57-00fd-4a07-bb11-46d33a557e4a.png

Enhance your document collaboration and revolutionize your workflows by seamlessly integrating powerful applications such as Microsoft 365, Adobe, and Dropbox to streamline your document management pr

Intelligent Document Collaboration 

Microsoft 365、Adobe、Dropbox などの強力なアプリケーションをシームレスに統合してドキュメント管理プロセスを合理化することで、ドキュメントのコラボレーションを強化し、ワークフローに革命をもたらします。

Excel ファイルから直接ドキュメント作成を自動化することで、貴重な時間と労力を節約します。自動生成の利便性を享受しながら、ドキュメント全体の正確さと一貫性を確保します。

7fd9787d-6676-408b-9f09-24ff7aa06fc1.png

Whether you're a professional, student, or busy individual, this collection offers a range of automations to simplify your everyday tasks.

From automating the creation of presentations and documents 

User-Friendly Automation Toolbox

専門家、学生、または忙しい個人であっても、このコレクションは日常業務を簡素化するためのさまざまな自動化を提供します。

Excel ファイルに基づくプレゼンテーションやドキュメントの作成の自動化から、Mac での通貨サンプルの変換まで、このコレクションは幅広いニーズをカバーします。ドキュメントを簡単に印刷する必要がありますか?ご対応させていただきます。システムのシャットダウンを設定したり、フラッシ

5011f5c1-f0e5-46ce-9d75-fde641620343.png

Get the best of both worlds - the power of UiPath and the expertise of our partners. Our hand-picked partner network offers a wide range of professional services to enhance your automation journey wit

Professional Services

e58153e6-c384-40f1-9a04-b74d92d4b7b2.png

Unlock a world of enhanced capabilities, empowering you to seamlessly interact with PDF forms, extract specific pages, ensure the integrity of your PDF files, compare documents for differences, and ex

PDF Automation

強化された機能の世界を解放し、PDF フォームのシームレスな操作、特定のページの抽出、PDF ファイルの整合性の確保、ドキュメントの相違点の比較、および多数の PDF 処理タスクの実行を可能にします。

a235052e-07e6-4500-b3a8-049dca38cb98.png

Elevate your UiPath projects, and unlock unparalleled efficiency, scalability, and security. From building intelligent bots to automating document processing and performing advanced text analysis, to 

Popular Demand

UiPath プロジェクトを強化し、比類のない効率、拡張性、セキュリティを解放します。インテリジェントなボットの構築から文書処理の自動化、高度なテキスト分析の実行、自然言語処理と生成の組み込みまで、自動化への取り組みに革命をもたらし、生産性を向上させます。

c0458317-142d-43d2-bbdb-f4a5ccee3aa8.png

Experience blazing-fast document processing, take control of your workflows with seamless task and process management, say goodbye to the struggle of matching invoices and payments, gain comprehensive

New Arrivals

すべて自動化の助けを借りて、超高速のドキュメント処理を体験し、シームレスなタスクとプロセス管理でワークフローを制御し、請求書と支払いを照合する苦労に別れを告げ、ライセンスの使用状況に関する包括的な洞察を得ることができます。

a968734e-736c-4c12-894d-0f60043e2609.png

Tired of spending countless hours manually converting documents between different formats? Whether you need to convert a Word file to PDF, HTML, TXT, or even XML, these automations have got you covere

Document Format Conversion

ドキュメントを異なる形式間で手動で変換するのに膨大な時間を費やすことにうんざりしていませんか? Word ファイルを PDF、HTML、TXT、さらには XML に変換する必要がある場合でも、これらの自動化機能が役に立ちます。コンテンツをコピー＆ペーストしたり、フォーマットの問題に苦労したりして貴重な時間を無駄にする必要はもうありません。希望の出力形式を選択し、あとは自動化に任せるだけです。

cc4e1f9f-ee63-4465-ade4-76e04dcd5f13.png

Simplify and optimize the flow of structured data within your organization with the help of activities like data transformation, validation, comparisons. By automating these tasks, data can be streaml

Structured Data Streamlining

データ変換、検証、比較などのアクティビティを利用して、組織内の構造化データのフローを簡素化し、最適化します。これらのタスクを自動化することで、データを合理化、標準化し、アクセスしやすくすることができ、効率的なデータ分析、レポート作成、意思決定のプロセスにつながります。

自動化ツールと技術を活用して、大量のデータを管理および処理するための体系的なアプローチのメリットを活用します。手動作業を削減して

Simplify your data management processes and unlock new levels of efficiency.

Text-Based Tabular Data Manipulations

Discover automations designed to revolutionize how you monitor and optimize the performance of your processes. 

Utilization Reporting and Monitoring

Transform your data into compelling visual representations, saving time and effort while delivering impactful insights.

Automated Charting and Graphing

Integrate automation into your workflows, and witness the transformative impact on your communication strategies.

Text Message Automation and Management

Unlock unparalleled task optimization and efficiency with our collection designed to streamline your workflow and supercharge productivity.

Task Optimization and Efficiency

Unlock the potential of your file management with this comprehensive collection designed to streamline workflows and optimize organization. 

File Organization and Control

Unlock the boundless potential of image processing and revolutionize your automation workflows with our exceptional collection. 

Image Processing

Experience the power of Automated Testing Frameworks collection, and revolutionize your software testing endeavors.

Automated Testing Frameworks

Revolutionize workflows with an automated suite for optimized processes and efficiency. Innovate password operations, enhance user experience, and streamline access management effortlessly.

Authentication Enhancers

With a focus on streamlining your IT operations and enhancing productivity, this collection offers a range of powerful features to elevate your organization's performance.

Office IT Workflows Automation

Explore the Language Translation collection, designed to expedite and enrich language translation processes.

Language Translation

Whether you're a seasoned globetrotter or planning your dream getaway, this collection will revolutionize the way you organize, plan, and enjoy your travels.

Travel and Vacation Planning

Whether you're looking to automate file transfers, synchronize data across multiple platforms, or manage cloud storage efficiently, this collection has you covered.

Online Storage and Sharing

Unlock the full potential of your automation projects today and revolutionize the way you handle string manipulation tasks.

String Manipulation

Experience simplified wage and tax statement processing, enabling swift generation and management of essential documents while adhering to regulatory standards.

Tax and Compliance Processing

Discover the power of automated tabular text manipulation to improve data accuracy, and boost your productivity. Eliminate the hassle of manual extraction, and make your data analysis smoother and more efficient.

Experience the convenience of automated files conversions, files merging, data extractions and manipulations, while ensuring accurate data migration and format preservations, reducing errors and improving data integrity.

This activity is designed to find the list of visible only worksheets from an Excel workbook. It supports one input argument and one output argument.

  

**Input:**

*   WorkbookPath - Type String - Mandatory

**Output:**

*   VisibleSheets - Type list - Optional

**Operation:**

  

Put this activity inside a sequence or flowchart (Excel Application Scope is not required). Pass the absolute path to the Workbook as Input WorkbookPath and assign output VisibleSheets to a variable of type list.

  

You can iterate through list using For Each activity and get the name of all visible sheets.

Get a list of visible only worksheets from an Excel Workbook.

We were founded in 2005 in a tiny apartment in Bucharest, Romania as DeskOver.

Fittingly, it was a customer who, in 2012, first saw the immense possibilities for us in the fledgling RPA market. Our desktop automation product launched in 2013. In 2015, we introduced our enterprise platform along with our new name.

Today, UiPath is the fastest-growing enterprise software company in history with scores of offices, thousands of employees, partnerships with the world’s best consulting and BPO firms, a **500,000-strong developer community**, and **5MM+ robots at work** in over **5,000 global enterprises.**

Our mission is to deliver the leading Robotic Process Automation platform to our clients for an automation first mindset.

We build software robots that automate repetitive processes. Our software robots take on the tedious, mind-numbing work and free people to do the more stimulating, creative work worth doing.

But no matter how much we’ve grown, one thing hasn’t changed. We’re still building a company we love to work for

22ac2b39-8e69-4be8-8c56-879cf6d99177.png

Now UiPath Robots can use Smartsheet, allowing you to create, update, and send envelopes, manage documents and recipients, and call over 180 distinct operations in Smartsheet’s API giving you broad integration capabilities.

  

This **UiPath Official** package includes the following activities:

  

· Smartsheet Scope (provides authentication for all Smartsheet activities)

· Invoke Method (allows you to call any Smartsheet API method)

· Import Sheet (from CSV/XSLX)

· Search

· Share Object

· Attachments: Attach File or Url, List, Get, and Delete

· Comments: Add, Get, Delete

· Folders: Create, Copy, Delete, Get and List

· Reports: Get and List

· Rows: Add, Delete, Get, List, Copy, Move, Update, and Add Discussion to a Row

· Sheets: Create, Create from Template, Copy, Get, Download, List, and Update a Sheet

  

Full documentation is available at  http://docs.uipath.com/activities/docs/smartsheet-about.

Simplify automating processes that use Smartsheet by replacing UI operations with background API calls.

Now UiPath Robots can use Smartsheet, allowing you to create, update, and send envelopes, manage documents and recipients, and call over 180 distinct operations in Smartsheet’s API giving you broad integration capabilities.

  

This **UiPath Official** package includes the following activities:

  

· Smartsheet Scope (provides authentication for all Smartsheet activities)

· Invoke Method (allows you to call any Smartsheet API method)

· Import Sheet (from CSV/XSLX)

· Search

· Share Object

· Attachments: Attach File or Url, List, Get, and Delete

· Comments: Add, Get, Delete

· Folders: Create, Copy, Delete, Get and List

· Reports: Get and List

· Rows: Add, Delete, Get, List, Copy, Move, Update, and Add Discussion to a Row

· Sheets: Create, Create from Template, Copy, Get, Download, List, and Update a Sheet

  

Full documentation is available at http://docs.uipath.com/activities/docs/smartsheet-about.

Introduction to Smartsheet's Cloud-Based Work Execution Platform
----------------------------------------------------------------

Smartsheet offers a cloud-based work execution platform designed to empower teams in planning, capturing, managing, automating, and reporting on work at a large scale. The platform offers a range of services, including streamlined facilities management, customer experience management, budget and planning management, and related solutions.

Automation Capabilities with UiPath Smartsheet Activities
---------------------------------------------------------

The UiPath Smartsheet Activities facilitate the automation of interactions within the Smartsheet application. Through the [Smartsheet API](https://smartsheet-platform.github.io/api-docs/), this activities package equips UiPath robots with the capability to execute functions and actions seamlessly across the entire Smartsheet platform.

  

Before the scope activity can be used to establish a connection, you must complete the steps outlined in the [Setup](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-setup) guide. After you complete the **Setup** steps, you can begin building your automation projects.

Key Activities in the UiPath Smartsheet Package
-----------------------------------------------

The Smartsheet Activities package includes the following activities:

*   [Smartsheet Scope](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-scope) - Establishes an authenticated connection between UiPath and your Smartsheet resources.
*   [Invoke Smartsheet Operation](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-invoke-smartsheet-operation) - Allows you to specify any public [Smartsheet](https://smartsheet-platform.github.io/api-docs/) API operation and its relevant properties.
*   [Search Activity](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-search) - Allows you to search for items anywhere in Smartsheet or your personal workspace.
*   [Send via Email](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-send-via-email) - Allows you to send a sheet, rows, or report via email natively from within Smartsheet.
*   [Share Object](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-share-object) - Allows you to share a sheet with other Smartsheet users or groups.

### **Attachments**

*   [Attach File](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-attach-file) - Attaches a file to a row, comment, or sheet via local folder.
*   [Attach URL](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-attach-url) - Attaches a file to a row, comment, or sheet via URLs.
*   [Delete Attachment](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-delete-attachment) - Deletes an attachment.
*   [Get Attachment](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-get-attachment) - Retrieves an attachment and optionally downloads it to a folder of your choosing.
*   [List Attachments](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-list-attachments) - Allows you to retrieve a list of all the attachments for a sheet, row, or discussion.

### **Comments**

*   [Add Comment](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-add-comment) - Allows you to add a comment a discussion.
*   [Delete Comment](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-delete-comment) - Deletes a specific comment.
*   [Get Comment](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-get-comment) - Allows you retrieve a comment and to download it to a folder you choose.

### **Rows**

*   [Add Rows](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-add-rows) - Adds rows to a sheet.
*   [Copy Rows](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-copy-rows) - Copies rows from the sheet specified in the URL to (the bottom of) another sheet.
*   [Delete Rows](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-delete-rows) - Deletes one or more rows.
*   [Get Row](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-get-row) - Retrieves a specific row and returns it as a Row object.
*   [List Rows](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-list-rows) - Retrieves one or more rows from a sheet and returns it as a Row array.
*   [Move Rows](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-move-rows) - Moves rows from the sheet specified in the URL to (the bottom of) another sheet.
*   [Update Rows](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-update-rows) - Inserts one or more rows into the sheet.
*   [List Discussions](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-list-discussions) - Gets a list of discussions from a sheet or a row.

### **Sheets**

*   [Copy Sheet](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-copy-sheet) - Copies an existing sheet to a new location.
*   [Create Sheet](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-create-sheet) - Creates a new sheet in a specified location.
*   [Create Sheet From Template](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-create-sheet-from-template) - Creates a new sheet from a template you specify.
*   [Download Sheet](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-download-sheet) - Downloads a sheet you specify to a local folder.
*   [Get Sheet](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-get-sheet) - Retrieves a specific sheet and allows you to set various options on which data is retrieved.
*   [List Sheets](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-list-sheets) - Retrieves a set of sheets based on filters you set.
*   [Update Sheet](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-update-sheet) - Updates an existing sheet based on criteria you specify.
*   [Import Sheet from CSV / XLSX](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-import-sheet) - Imports CSV or XLSX data into a new sheet in the top-level "sheets" folder.

### **Users**

*   [Add User](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-add-user) - Allows you to add a new user to Smartsheet.
*   [Get User](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-get-user) - Retrieves a user by User ID or email address.
*   [List Users](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-list-users) - Retrieves a list of users.
*   [Remove User](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-remove-user) - Removes a user by User ID or email address and has the option to re-assign their assets to another user.

### **Workspaces**

*   [Copy Workspace](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-copy-workspace) - Copies an existing workspace.
*   [Create Workspace](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-create-workspace) - Creates a new workspace and returns the newly created Workspace object as an output.
*   [List Workspaces](https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-list-workspaces) - Retrieves a list of workspaces based on filters you set.

This activity converts the CSV file to an excel file. The activity has the options \[Input-format\]. It helps to convert the column which the user desires. While doing the conversion, the user will face zero omission issues when converting to string. Date format can be fixed by user. It was especially developed for a forum [user](https://forum.uipath.com/t/exce-file-in-one-column-to-multiple-columns/75484?u=balupad14) and it has been changed for generic usage.

Convert CSV to Excel file with specifying the column format

This activity converts a CSV file into an Excel file. 

  

The activity has the options \[Input-format\]. It helps to convert the column which the user desires. While doing the conversion, the user will face zero omission issues when converting to string. Date format can be fixed by user.

Convert CSV to Excel file with specifying the column format.

The world we live in is changing at a rapid pace and this change, in turn, is creating huge demands for better technology solutions using the second machine age era of technologies such as Robotic Process Automation, Artificial Intelligence, OCR, IoT, etc.

  

Feat systems offer world-class end-to-end automation

solutions and services to give your business a significant boost and help you forge ahead in a highly competitive world.

  

Our experts use diverse technologies to create agile, responsive, feature-rich, and interactive automation solutions, helping you boost efficiencies and increase productivity along with enhancing your image.

c3875ed2-6882-425a-a570-331d16275c54.png

MergeMultipleDelimitedFilesAndCreateCSV activity changes the delimitation to comma and merges CSV files into a single one. 

  

It supports the following symbols that delimite the data: 

1\. Semi- Colon";"

2\. Pipe"|"

3\. Comma","

4\. Tab"\\t"

5\. Caret"^" 

  

The output is a CSV file separated by comma.

This activity changes delimitation to comma and merges multiple CSV files into a single one.

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

The package contains 3 custom activities for converting XML files to other data formats:

  

1\.     **XML to DataTable**

2\.     **XML to JSON**

3\.     **XML to CSV**

  

These activities can handle all types of complex and nested XMLs either in a text file (specified in the input property InputXmlFilePath) with valid XML in it, or accept XML strings directly (specified in the input property InputXmlString). The output will be a CSV or JSON file, at user's designated path (specified in the input property OutputCSV/JSONFilepath), or a DataTable from the input XML.

*   **XML to CSV:** To view the data in tabular format, the output CSV file can be opened using Excel. The first row in Excel will be the header generated from all the tag names in the XML file. In case of multi-level nested XML, it retains the complete path of each element, separated by slash '/'.
*   **XML to JSON:** This activity converts XML in JSON format without any data loss. In case of Array, element tags are added for each array element. In case of non-array objects, XML keys are converted to JSON tags and XML values are converted to JSON inner text. The output of this activity is a .json file.
*   **XML to DataTable****:** It converts input XML to DataTable and provides the flexibility of directly applying all DataTable functions like filtering the XML Data. In case of Array, each Data row is converted to Excel Row Item. In case of non Array structure, all the tags generate headers and in case of multi-level nested XML, it retains the complete path of each element, separated by slash '/' to prevent any data loss.

The time required for this conversion is proportional to the level of nested data structure of the XML (between milliseconds to a few seconds).

  

**Input Properties**

*   InputXmlFilepath - Takes the path of the text file which contains the valid XML.
*   InputXmlString (optional, if InputXmlFilepath is not passed) - Takes as input the XML string. Use Read Text file &gt; Deserialize XML &gt; pass the generated XML with tag name.
*   OutputCSV/JSONLFilePath - Takes the path of the CSV or JSON file in which the output will be generated. The CSV/JSON file will be generated at this path even if it is not present.

**Output Properties**

  

Output DataTable – It generates a DataTable from the input XML and provides an option of saving it in a DataTable type of variable.

  

**Notes**

  

Among InputXmlFilepath and InputXlString properties, only 1 input is allowed to be passed for all these activities and it is a mandatory input property. Output XmlFilePath and Output DataTable are mandatory output fields.

A package of 3 custom activities that accept any complex XML file as input and converts it into DataTable, JSON and CSV files.