CSV File To Objects with Helper Functions API

Pipedream makes it easy to connect APIs for Helper Functions and 2,400+ other apps remarkably fast.

Trigger workflow on

HTTP requests, schedules and app events

Next, do this

CSV File To Objects with the Helper Functions API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

Create a workflow to CSV File To Objects with the Helper Functions API. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Configure the CSV File To Objects action
1. Connect your Helper Functions account
2. Configure CSV File Path
3. Optional- Configure File Contains Headers
4. Optional- Configure Skip Empty Lines
5. Optional- Configure Skip Records With Empty Values
6. Optional- Configure Skip Records With Error
Select a trigger to run your workflow on HTTP requests, schedules or app events
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Integrations#

CSV File To Objects with Helper Functions API on New Requests (Payload Only) from HTTP / Webhook API

HTTP / Webhook + Helper Functions

Try it

CSV File To Objects with Helper Functions API on New Submission from Typeform API

Typeform + Helper Functions

Try it

CSV File To Objects with Helper Functions API on New Submission (Instant) from Jotform API

Jotform + Helper Functions

Try it

CSV File To Objects with Helper Functions API on New Scheduled Tasks from Pipedream API

Pipedream + Helper Functions

Try it

CSV File To Objects with Helper Functions API on New Download Counts from npm API

npm + Helper Functions

Try it

Details#

This is a pre-built, source-available component from Pipedream's GitHub repo. The component is developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

CSV File To Objects on Helper Functions

Description:Convert a CSV file to an array of objects.

Version:0.0.1

Key:helper_functions-csv-file-to-objects

View on GitHub

Code#

import { readFileSync } from "fs";
import path from "path";
import { parse } from "csv-parse/sync";
import app from "../../helper_functions.app.mjs";

export default {
  key: "helper_functions-csv-file-to-objects",
  name: "CSV File To Objects",
  description: "Convert a CSV file to an array of objects.",
  version: "0.0.1",
  type: "action",
  props: {
    app,
    filePath: {
      type: "string",
      label: "CSV File Path",
      description: "The path to the file saved to the `/tmp` directory (e.g. `/tmp/example.csv`). [See the documentation](https://pipedream.com/docs/workflows/steps/code/nodejs/working-with-files/#the-tmp-directory).",
    },
    hasHeaders: {
      type: "boolean",
      label: "File Contains Headers",
      description: "Set to `true` if the first row of the CSV contains headers. If there are headers in the file, the keys of the objects will be the header values. If there are no headers, each object will be an array of values.",
      optional: true,
      default: false,
    },
    skipEmptyLines: {
      type: "boolean",
      label: "Skip Empty Lines",
      description: "Set to `true` to skip empty lines in the file.",
      optional: true,
      default: true,
    },
    skipRecordsWithEmptyValues: {
      type: "boolean",
      label: "Skip Records With Empty Values",
      description: "Set to `true` to skip records with empty values. Don't generate records for lines containing empty values, empty Buffer or equals to `null` and `undefined` if their value was casted.",
      optional: true,
      default: false,
    },
    skipRecordsWithError: {
      type: "boolean",
      label: "Skip Records With Error",
      description: "Set to `true` to skip records with errors. Tolerates parsing errors. It skips the records containing an error inside and directly go process the next record.",
      optional: true,
      default: false,
    },
  },
  async run({ $ }) {
    const {
      filePath,
      hasHeaders,
      skipEmptyLines,
      skipRecordsWithEmptyValues,
      skipRecordsWithError,
    } = this;

    let fileContent;
    try {
      fileContent = readFileSync(path.resolve(filePath), "utf8");
    } catch (error) {
      console.error("Error reading file:", error);
      throw error;
    }

    try {
      const records = parse(fileContent, {
        columns: hasHeaders,
        skip_empty_lines: skipEmptyLines,
        skip_records_with_empty_values: skipRecordsWithEmptyValues,
        skip_records_with_error: skipRecordsWithError,
      });

      $.export("$summary", `Converted ${records.length} records from CSV to objects.`);
      return records;

    } catch (error) {
      console.error("Error converting CSV to objects:", error);
      throw error;
    }
  },
};

Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
Helper Functions	`app`	`app`	This component uses the Helper Functions app.
CSV File Path	`filePath`	`string`	The path to the file saved to the `/tmp` directory (e.g. `/tmp/example.csv`). See the documentation.
File Contains Headers	`hasHeaders`	`boolean`	Set to `true` if the first row of the CSV contains headers. If there are headers in the file, the keys of the objects will be the header values. If there are no headers, each object will be an array of values.
Skip Empty Lines	`skipEmptyLines`	`boolean`	Set to `true` to skip empty lines in the file.
Skip Records With Empty Values	`skipRecordsWithEmptyValues`	`boolean`	Set to `true` to skip records with empty values. Don't generate records for lines containing empty values, empty Buffer or equals to `null` and `undefined` if their value was casted.
Skip Records With Error	`skipRecordsWithError`	`boolean`	Set to `true` to skip records with errors. Tolerates parsing errors. It skips the records containing an error inside and directly go process the next record.