B2Win Suite Documentation (Under Construction)
5.4
5.4
  • B2Win Suite Documentation
  • Scripting
    • B2Win Suite Scripting Overview
    • Scripting in B2Data
      • Custom Script Nodes
        • Custom Script
        • Source Script Node (File)
        • Source Script Node (Table)
        • Source Script Node (Object)
        • If-Else Condition
        • Condition Node
      • In DataPrep
      • Properties
      • Workflow Applications
        • Workflow #1
        • Workflow #2
    • Getting Started
    • Language Basics
    • Types & Objects
      • Primitives
      • Objects
        • Instant
        • LocalDateTime
        • LocalDate
        • LocalTime
        • JsonNode
        • ObjectNode
        • File
        • SuiteTable
        • Duration
      • Arrays & Maps
      • Row, Column, StringColumn
    • Utilities
      • Date & Time
        • InstantUtil
        • GeneralDateUtil
        • LocalDateTimeUtil
        • LocalDateUtil
        • LocalTimeUtil
        • Formatting
        • Timezones
      • Math
      • StrictMath
      • NumericUtil
      • DbUtil
      • DbExecutor
      • StateUtil
      • FileUtil
      • JsonUtil
      • HttpUtil
      • NodeInputReader
      • RandomUtil
      • HashingUtil
      • CompressionUtil
      • Logging
    • Properties
    • Context and System
      • Context
      • System
    • Configurations
      • Workflow Configuration
    • Tutorial
    • Feedback
  • B2Data
    • Workflow Settings
      • General Settings
      • Global/All Properties
      • Execution Configuration
        • General
        • Runtime
        • Compiler
        • Storage
        • Clean Up
      • Permissions
    • Nodes
      • Scheduler
    • Services Configuration
      • Power BI
Powered by GitBook
On this page
  1. Scripting
  2. Scripting in B2Data
  3. Custom Script Nodes

Source Script Node (File)

Experimental

PreviousCustom ScriptNextSource Script Node (Table)

Last updated 1 year ago

This node allows you to customize data extraction and manipulation then return as file to the following node.

Example: Read a file (e.g., a CSV file) and return it as a file object.

return FileUtil.readFile("d:\\tmp\\file.csv");

Example: Retrieve data from API and return as File

// Make an HTTP request to get exchange rates from the specified API
var request = HttpUtil.get("https://boi.org.il/PublicApi/GetExchangeRates");

// Parse the response body as JSON
var jsonContent = JsonUtil.parse(request.asString().getBody());

// Convert the exchange rates to a JSON string
var exchanges = JsonUtil.stringify(jsonContent.exchangeRates);

// Create a temporary file and write the exchange rates JSON to it
var tempFile = FileUtil.createTempFile("tmp.json", exchanges);

// Return the path to the created temporary file
return tempFile;
Script Source (File)