B2Win Suite Documentation (Under Construction)
ContactB2Data
5.6
5.6
  • 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
        • Switch case
        • 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
        • Period
      • 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
      • ShellUtil
      • CompressionUtil
      • Logging
    • Properties
    • Context and System
      • Context
      • System
    • Configurations
      • Workflow Configuration
    • Tutorial
    • Feedback
  • B2Data
    • Tutorials
      • Infor DataFabric to On-Premise Database Replication
      • API (DB replication, Email)
    • Workflow Settings
      • General Settings
      • Global/All Properties
      • Execution Configuration
        • General
        • Runtime
        • Compiler
        • Storage
        • Clean Up
      • Permissions
    • Nodes
      • Scheduler
    • Services Configuration
      • Microsoft Graph
Powered by GitBook
On this page

Was this helpful?

  1. Scripting
  2. Scripting in B2Data
  3. Custom Script Nodes

Source Script Node (File)

Experimental

PreviousCustom ScriptNextSource Script Node (Table)

Was this helpful?

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)