import zerobounce from "../../zerobounce.app.mjs";
import fs from "fs";
import FormData from "form-data";
import path from "path";
export default {
key: "zerobounce-file-validation",
name: "Validate Emails in File",
description: "Performs email validation on all the addresses contained in a provided file. [See the documentation](https://www.zerobounce.net/docs/email-validation-api-quickstart/)",
version: "0.0.1",
type: "action",
props: {
zerobounce,
filePath: {
type: "string",
label: "File Path",
description: "The path to a csv or txt file in the `/tmp` directory. [See the documentation on working with files](https://pipedream.com/docs/code/nodejs/working-with-files/#writing-a-file-to-tmp)",
},
emailAddressColumn: {
type: "integer",
label: "Email Address Column",
description: "The column index of the email address in the file. Index starts from 1.",
},
firstNameColumn: {
type: "integer",
label: "First Name Column",
description: "The column index of the first name column. Index starts from 1.",
optional: true,
},
lastNameColumn: {
type: "integer",
label: "Last Name Column",
description: "The column index of the last name column. Index starts from 1.",
optional: true,
},
ipAddressColumn: {
type: "integer",
label: "IP Address Column",
description: "The IP Address the email signed up from. Index starts from 1",
optional: true,
},
hasHeaderRow: {
type: "boolean",
label: "Has Header Row",
description: "If the first row from the submitted file is a header row",
optional: true,
},
removeDuplicates: {
type: "boolean",
label: "Remove Duplicates",
description: "If you want the system to remove duplicate emails. Default is `true`. Please note that if we remove more than 50% of the lines because of duplicates (parameter is true), system will return a 400 bad request error as a safety net to let you know that more than 50% of the file has been modified.",
optional: true,
},
returnUrl: {
type: "string",
label: "Return URL",
description: "The URL will be used to call back when the validation is completed",
optional: true,
},
callbackWithRerun: {
type: "boolean",
label: "Callback With Rerun",
description: "Use the `$.flow.rerun` Node.js helper to rerun the step when the validation is completed. Overrides the `rerunUrl` prop. This will increase execution time and credit usage as a result. [See the documentation](https://pipedream.com/docs/code/nodejs/rerun/#flow-rerun)",
optional: true,
},
},
async run({ $ }) {
let response, summary;
const { run } = $.context;
if (run.runs === 1) {
let returnUrl = this.returnUrl;
if (this.callbackWithRerun) {
({ resume_url: returnUrl } = $.flow.rerun(600000, null, 1));
}
const filePath = this.filePath.includes("tmp/")
? this.filePath
: `/tmp/${this.filePath}`;
const fileName = path.basename(filePath);
const fileContent = fs.readFileSync(filePath);
const formData = new FormData();
formData.append("file", fileContent, fileName);
formData.append("email_address_column", this.emailAddressColumn);
formData.append("api_key", this.zerobounce.$auth.api_key);
if (this.firstNameColumn) {
formData.append("first_name_column", this.firstNameColumn);
}
if (this.lastNameColumn) {
formData.append("last_name_column", this.lastNameColumn);
}
if (this.ipAddressColumn) {
formData.append("ip_address_column", this.ipAddressColumn);
}
if (this.hasHeaderRow) {
formData.append("has_header_row", this.hasHeaderRow
? "true"
: "false");
}
if (this.removeDuplicates) {
formData.append("remove_duplicate", this.removeDuplicates
? "true"
: "false");
}
if (returnUrl) {
formData.append("return_url", returnUrl);
}
response = await this.zerobounce.validateEmailsInFile({
$,
data: formData,
headers: {
...formData.getHeaders(),
},
});
summary = "Successfully sent file for validation";
}
if (run.callback_request) {
response = run.callback_request.body;
summary = "Successfully validated emails in file";
}
$.export("$summary", summary);
return response;
},
};
Chase Roberts@chsrbrts@benedictevans If you haven’t used @pipedream yet, then you haven’t lived.
✨Ellie Day✨@heyelliedayEvaluation update: @pipedream has quite literally been a dream to work with! I’m excited to leverage this tool for all the various workflows I need to write. I’m currently at 11k invocations a day from the initial workflows I’ve written in the past couple weeks.
Michael Braedley@MBraedleyUpdate: I got it working properly, and it's working so well that I'm dropping IFTTT. @pipedream can do everything that IFTTT basic can, and most (if not all things) IFTTT pro can for free or at a reasonable price if you need it. I am recommending it for basically any power user.
Thomas Cutting@mrthomascuttingWant quick+dirty integrations for a serverless workflow - @pipedream is my new go-to 😃
Matthew Roberts@mattdotrobertsday 013 - finally hit node js. This is the secret sauce of taking #nocode projects that one step further. Pumped about getting deeper into @pipedream now
Kenneth Auchenberg 💭@auchenbergYahoo Pipes is back! Kinda 😍 @pipedream
Raymond Camden 🥑@raymondcamdenAwesome video by the @pipedream folks showing real time twitter sentiment analysis integrated with Google Sheets. This is where Pipedream *really* shines, connecting systems together in easy workflows.
Nacho Caballero@nachocaballeroI couldn't recommend @pipedream more. It's an amazing service to integrate different APIs. Much more powerful than Zapier and more user-friendly than AWS Lambda. I'm very proud to wear this t-shirt #NoCode
Jason Snow@jyksnwDeveloped a working prototype environmental sensor IoT solution with @particle Photon, @pipedream, and @MongoDB with full graphing and alerting in less than a day! All amazing technology, will def. be exploring these more.
Steven Terrana@steven_terrana@burgwyn you've inspired me to finally set up my own blog. I'll make sure my first blog post explains the tech behind the setup. think @obsdmd + @GatsbyJS + @pipedream.
🚄 James Augeri, PhD@DotDotJamesWant to low-code your back end, need more horsepower than @Bubble / @KnackHQ, or just miss Yahoo! Pipes? Check out @PipeDream
Sébastien Chopin@AtinuxGitHub issues should be like @linear_app for maintainers. Looking forward more integrations with GH actions or tools like @pipedream 👀
Raul@raul_predescuIf you're a dev and not using @pipedream, you're missing out. Been using it for months, daily. FREE for devs. Plenty of integrations and good limits. Absolutely love it.
Bruno Skvorc@bitfallsSo @pipedream is pretty amazing. In 3 minutes I just made a flow which adds @rickastley's Never Gonna Give You Up to my @spotify playlist whenever a new pull request arrives in an old repo of mine.
Zach Lanich@ZachLanichUm, wow 🤯 @pipedream
Steven Bell@bellontechI just used @pipedream to build a Shopify App. Wow, they make small backed tasks easy.
Jay Hack 🎩🇺🇸@_jayhack_Very impressed with this bad boi - it reminds me of a @PalantirTech internal tool, but geared towards integrations instead of data analysis and far more customizable. Great expectations here 🚀🤩
Tree Sturgeon 🔥🚴♂️🌳@philsturgeonFor context this is day 2 of a really challenging and stupid migration from Notion to @airtable with disparate/missing data. It's going better than expected and thanks to @pipedream I don't have to bother the iOS dev to add W3W.