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
  • Configuration of the Data Transform module
  1. Data
  2. Integrations
  3. Flows
  4. Tool Modules

Data Transform Module

PreviousCSV ModuleNextData Balancer Module

Last updated 6 months ago

Definition

The "Data Transform" module, the platform's standard module for use in any flow, was created for data transformation using , thus facilitating the creation of complex operations.

JSONata is a lightweight language designed to query and transform JSON data structures.

The "Data Transform" module consists of a single operation that allows the manipulation of multiple data points and the transformation of these data into the desired format. This module always initializes the data parameter, which enables us, as seen in Object Handling, not only to obtain a data set but also to filter so that only a specific subset is invoked.

"Data Transform" is ideal for more complex data manipulations with an internal response within the flow. For less complex data manipulations, we recommend using an . For more complex data manipulations that require a response to an HTTP request, we recommend using the "Return" module.

Configuration of the Data Transform module

The "Data Transform" module appears in the Tools option when editing a flow. As soon as you click to add it, the modal opens for configuration:

Variable Configuration

In this section, under the "Data Source" tab, you will find the following fields:

  • Key: variable identifier

  • Value: type or drag a variable

  • Type: choose the most appropriate data type. Options are: text, number, boolean, object, and array.

If you prefer, you can fill in the Source JSON

After completing the configurations, click "Next".

Result

On this screen, you can execute and view the data transformation information and manipulate it with JSONata.

To finalize the module configuration, click "Save".

.

Find out about the Module Header here
Definition
Configuration of the Data Transform module
Variable configuration
Result
JSONATA
SMOP