Skyone
Skyone
English
English
  • Home
  • Data
    • Getting Started
      • Create an account
      • Recover Password
      • Quick Platform Guide
      • How to test the platform for free
      • Workspace
        • Creating a new Workspace
        • Find a Workspace
        • Sending an invitation to a Workspace
        • Editing a Workspace
      • Organizations
        • Creating an Organization
        • Organization Overview
        • Organization Management
        • Organization Monitoring
      • Settings and Preferences
        • Profile
        • Notifications
        • Usage and Billing
        • Users and Permissions
    • Modules
      • Module management
        • Creating a Module
        • Importing a Module
          • IAC Files - Integration as Code
        • Editing a module
        • Module Options
      • Settings and Operations
        • Module settings
          • Connectivity: Database
          • Connectivity: Email
          • Connectivity: REST
          • Connectivity: SOAP
          • Connectivity: File
          • Connectivity: RFC
          • Connected Account Management
        • Operations
          • Importing operations into REST Modules
          • Operation Management
        • Flows Using This Module
    • Monitoring
    • API Gateway
    • Terminals & Agent
      • Agent
        • Versions supported by Agent
        • How to Update the Agent Version
        • How to back up Agent files
      • Terminals
    • Data
      • Data Stack
        • Process Control
        • Data Stack Upload
        • File Actions
        • File Jobs
        • Data Job Parameters
        • Data Store
        • Data Share Features
        • ODBC
        • How to use the Data Engine Proxy
    • Integrations
      • Integration Management
        • Create integration
        • Import Integration
        • Edit Integration
        • Integration Options
        • Flows of this integration
      • Flows
        • Flow management
          • Creating a flow
          • Flow options
          • Flow Canva: configuring and editing the flow
            • Flow Canva: overview
            • Exception Handler
              • Exception Handler - Configuration
              • Exception Handler - Cases
            • Multicontext Flows
              • Example: Multicontext with an API Gateway
              • Example: Multicontext with a Time Trigger
            • Flow Settings
        • Triggers of a flow
          • API Gateway Triggers: Adding and Setting
          • AS2 Triggers: Adding and Setting
          • Queue Triggers: Adding and Setting
          • Flow Triggers: Adding and Setting
          • Time Triggers: Adding and Setting
          • Webhook Triggers: Adding and Setting
        • Tool Modules
          • AS2 Module
          • CSV Module
          • Data Transform Module
          • Data Balancer Module
          • EDI Module
          • Flow Call Module
          • IF Module
          • JavaScript Module
          • Log Module
          • Loop Do While Module
          • Loop For Module
          • Return Module
          • XML Module
          • Other Tool Modules
        • Module Header
        • Connecting components of a flow
        • Editing triggers and modules
        • Data Operations
          • Object Handling
            • Practical example: Handling variables
          • SMOP (Small Operations)
          • Parameterization rules
    • How to
      • Insert JSON into databases
      • Flattening: Data transformation using JSONata
      • How to use Form Data
      • Understanding recursion in JSONata
      • REST Module Output Consolidation
      • Isolated in execution: concept and application in variables
      • URL Parameters in API Gateway
      • Use case: API Gateway trigger parameters
      • Use case: Exception Handler in financial transactions
      • Use case: using Groups to manage access to flows
      • How to create a download endpoint and integrate with Power BI
      • Is it possible to use two triggers in a single flow?
      • How to set up WhatsApp in Skyone Studio
    • FAQ
    • GIGS: The complete guide
    • Glossary
  • Support
    • How do I request support?
    • Case Severity Levels
    • SLAs
    • Help & Resources
Powered by GitBook
On this page
  • Definition
  • Configuring the XML module
  1. Data
  2. Integrations
  3. Flows
  4. Tool Modules

XML Module

PreviousReturn ModuleNextOther Tool Modules

Last updated 6 months ago

Definition

The XML tool module, standard module for use in any flow, was created to convert data from the XML file format to JSON and vice versa.

The XML module consists of two operations, Convert XML to JSON and Convert JSON to XML.

Configuring the XML module

The XML module appears in the Tools option when editing a flow. When added to the flow, it offers two operations:

Convert XML to JSON: converts an XML spreadsheet to JSON format.

Convert JSON to XML: converts a spreadsheet in JSON to XML format

Convert XML to JSON operation

This operation allows you to convert an XML table with different items (products, customers, etc.) into JSON format, so that this information can be used later in the flow.

To use this option, choose "Convert XML to JSON" and then click "Save".

To configure the variables, click on "Edit" in the newly created component.

Where:

  • XML: enter the code in XML format that needs to be converted

  • Attribute symbol: enter the desired symbol for the JSON code; by default, "$" (dollar sign) is used

  • Character symbol: enter the desired symbol for the JSON code; by default, "_" (underline) is used.

  • XML CONVERTED TO JSON: here, after you click on the Validate button, the XML converted to JSON format will be displayed

XML example:

<?xml version="1.0" encoding="UTF-8"?>
<root>
   <element>
      <id>1</id>
      <name>Jaleco</name>
      <description>Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes</description>
      <price>R$ 999,99</price>
      <available>true</available>
   </element>
   <element>
      <id>2</id>
      <name>Avental</name>
      <description>Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes</description>
      <price>R$ 999,99</price>
      <available>true</available>
   </element>
   <element>
      <id>3</id>
      <name>Touca</name>
      <description>Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes</description>
      <price>R$ 999,99</price>
      <available>true</available>
   </element>
   <element>
      <id>4</id>
      <name>Fronha</name>
      <description>Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes</description>
      <price>R$ 999,99</price>
      <available>true</available>
   </element>
   <element>
      <id>5</id>
      <name>Embalagem</name>
      <description>Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes</description>
      <price>R$ 999,99</price>
      <available>true</available>
   </element>
   <element>
      <id>6</id>
      <name>Porta talher</name>
      <description>Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes</description>
      <price>R$ 999,99</price>
      <available>true</available>
   </element>
   <element>
      <id>7</id>
      <name>Porta absorvente</name>
      <description>Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes</description>
      <price>R$ 999,99</price>
      <available>true</available>
   </element>
</root>

Convert JSON to XML operation

This operation allows you to convert a JSON table with different items (products, customers, etc.) into XML format, so that this information can be used later in the flow.

To use this option, choose "Convert JSON to XLM" and then click "Save".

To configure the variables, click on "Edit" in the newly created component.

Where:

  • Attribute symbol: enter the desired symbol for the JSON code; by default, "$" (dollar sign) is used.

  • Character symbol: enter the desired symbol for the JSON code; by default, "_" (underline) is used.

  • JSON: enter the code in JSON format that needs to be converted

  • JSON CONVERTED TO XML: here, after you click on the "Validate" button, the JSON converted to XML format will be displayed.

JSON example:

[
   {
      "id":1,
      "name":"Jaleco",
      "description":"Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes",
      "price":"R$ 999,99",
      "available":true
   },
   {
      "id":2,
      "name":"Avental",
      "description":"Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes",
      "price":"R$ 999,99",
      "available":true
   },
   {
      "id":3,
      "name":"Touca",
      "description":"Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes",
      "price":"R$ 999,99",
      "available":true
   },
   {
      "id":4,
      "name":"Fronha",
      "description":"Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes",
      "price":"R$ 999,99",
      "available":true
   },
   {
      "id":5,
      "name":"Embalagem",
      "description":"Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes",
      "price":"R$ 999,99",
      "available":true
   },
   {
      "id":6,
      "name":"Porta talher",
      "description":"Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes",
      "price":"R$ 999,99",
      "available":true
   },
   {
      "id":7,
      "name":"Porta absorvente",
      "description":"Jaleco de alta qualidade fabricado para atender aos clientes mais exigentes",
      "price":"R$ 999,99",
      "available":true
   }
]

To finish configuring the module, click on "Save".

Parameters

Both parameters will appear on the left-hand side of the configuration modal for each operation in the flow, as long as the operations are all connected by lines in the flow.

Each operation has its own parameter, which corresponds to the product of the conversion: JSON for the Convert XML to JSON operation and XML for the Convert JSON to XML operation. When used, they produce the resulting code, which can later be manipulated by the module or by using a .

.

Data Transformation
SMOP
Find out about the Module Header here
Definition
Configuring the XML module
Convert XML to JSON operation
Convert JSON to XML operation
Parameters