Discover Wiresk’s Tools

• Example: Check if a customer’s order total exceeds $100. 
• Use Case: If the order total is greater than $100, apply a discount; otherwise, proceed without a discount. 

• Example: Assess the type of customer (VIP, Regular, New) and apply corresponding actions. 
• Use Case: Direct VIP customers to a priority support queue, offer discounts to regular customers, and provide onboarding to new customers. 

• Example: Monitor a task’s status until it is marked as complete. 
• Use Case: Automate the follow-up process in a project management tool by repeatedly checking if tasks are completed and sending reminders until they are. 

• Example: Generate an invoice for a completed service order. 
• Use Case: Automatically send an invoice to customers when a service is marked as complete in your CRM. 

• Example: Start individual Flows for each item in a customer’s order list. 
• Use Case: If a customer orders multiple products, each product triggers its own fulfillment process. 

• Example: Deduplicate a list of email addresses and send emails in the order they were received. 
• Use Case: Make sure that a promotional email campaign only sends one email per recipient, ordered by sign-up time. 

• Example: Deduplicate customer feedback entries, processing each unique feedback only once. 
• Use Case: In customer support, make sure that multiple reports of the same issue by the same customer are consolidated into a single ticket. 

• Example: Parse an XML file containing product information. 
• Use Case: Automatically update an inventory system with product details from an XML feed. 

In the Parse CSV tool settings, the Data Type can be set to either File or String:

1 – Data Type: FILE Configuration Table:

The CSV data will be read from a file.

Name*	Customizable name
Data Type*	Specifies the type of input data: File
Use First Row as Header*	Determines whether the first row of the CSV file should be treated as a header (column names). Options: True → First row is used as headers. False → Data is processed without headers.
Delimiter*	Defines the character used to separate values in the CSV. Common delimiters: , (Comma) → Standard CSV format. \t (Tab) → Used in TSV (Tab-Separated Values). Others → Define your own delimiter.
Data Type File Configuration
File Name*	→ The name of the CSV file being processed.
Extension*	→ Expected file extension (e.g., .csv).
Content (base64)*	→ The file content in Base64 encoding. In addition, explore the toBase64 and fromBase64 Functions.

Example Use Case: Parsing a Customer Orders CSV

A business receives order data in CSV format from an external system and needs to extract it for processing.

Example CSV File Content

OrderID, Customer, Item, Quantity, Price
1001, Alice, Laptop, 1, 1200
1002, Bob, Phone, 2, 800
1003, Charlie, Headphones, 1, 150

Convert the CSV file to Base64 encoding.

Wiresk Configuration for Parse CSV

• Data Type: File
• Use First Row as Header: Yes
• File Name: orders.csv
• Extension: .csv
• Content (Base64): Encoded CSV content

Output (Structured Data after Parsing)

[
  {
    "OrderID": "1001",
    "Customer": "Alice",
    "Item": "Laptop",
    "Quantity": "1",
    "Price": "1200"
  },
  {
    "OrderID": "1002",
    "Customer": "Bob",
    "Item": "Phone",
    "Quantity": "2",
    "Price": "800"
  },
  {
    "OrderID": "1003",
    "Customer": "Charlie",
    "Item": "Headphones",
    "Quantity": "1",
    "Price": "150"
  }
]

2 – Data Type: STRING Configuration Table:

the CSV data will be directly provided as a text string instead of a Base64 encoding file.

Name	Customizable name
Data Type*	Specifies the type of input data: String
Use First Row as Header*	Determines whether the first row of the CSV file should be treated as a header (column names). Options: True → First row is used as headers. False → Data is processed without headers.
Data Type String Configuration
Delimiter*	Defines the character used to separate values in the CSV. Common delimiters: , (Comma) → Standard CSV format. \t (Tab) → Used in TSV (Tab-Separated Values). Others → Define your own delimiter.
CSV*	The actual CSV data is provided here as an input string.

Example CSV data type : String

• Use , comma as delimiter and \n for new lines.

column1,column2,column3\nvalue1-1,value1-2,value1-3\nvalue2-1,value2-2,value2-3

Wiresk Configuration

• Data Type: String
• Use First Row as Header: Yes
• Delimiter: Comma
• CSV: String to enter

Output (Structured Data after Parsing)

[
  {
    "column1": "value1-1",
    "column2": "value1-2",
    "column3": "value1-3"
  },
  {
    "column1": "value2-1",
    "column2": "value2-2",
    "column3": "value2-3"
  }
]

You can also add you CSV string from the Data source input:

• Go to Wiresk Trigger settings
• Select Plain Json String
• Enter your you CSV string as a data field, e.g,

Input Json:

{
    "csvString": "column1,column2,column3\nvalue1-1,value1-2,value1-3\nvalue2-1,value2-2,value2-3"
}

• Now, you can use that data to Map your CSV field in Data type : String

• Example: Parse a JSON response from an API. 
• Use Case: Integrate with a third-party service by extracting relevant data from its JSON API responses. 

• Example: Flatten a nested JSON object into a simpler key-value structure. 
• Use Case: Simplify complex data for easier manipulation or integration with other tools. 

• Example: Convert currency values in a dataset from USD to EUR. 
• Use Case: Automatically adjust financial data according to currency exchange rates before generating reports. 

• Example: Host a template file for generating customer reports. 
• Use Case: Use a stored report template to generate customized reports for each customer interaction. 

• Example: Set a variable for the current date to use in multiple steps. 
• Use Case: Use a date variable to time-stamp all records or documents generated within a workflow. 

• Example: Send a follow-up email every 7 days until a customer responds. 
• Use Case: Automate the follow-up process in sales or support until an action is taken by the customer. 

• Example: Extract and save order details from a confirmation email. 
• Use Case: Automatically log order details from emails into a database for tracking and reporting. 

• Example: Extract a verification code from an SMS message. 
• Use Case: Use the extracted code for further validation or to trigger the next step in the Flow, such as confirming a user’s identity.