Zapier - Generating Lists from Data Objects

Question

Zapier - Generating Lists from Data Objects

Hey there, I would love to hear your thoughts on this.

Summary

I am seeking advice on how to extract multiple objects from an array using JavaScript and the Code by Zapier app. While I have successfully extracted data from the array's string using the .split() method and output a single object with mapped data, I'm struggling to create multiple objects and compile them into a new array.

The Script

// Here is what my inputData looks like:
inputData = INFO [ 'Name1', 'Surname1', '<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="255d5d5d5d654248444c490b464a48">[email protected]</a>', 'phone1', 'Name2', 'Surname2', '<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="d2abababab92b5bfb3bbbefcb1bdbf">[email protected]</a>', 'phone2', 'Name3', 'Surname3', '<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="2953535353694e44484045074a4644">[email protected]</a>', 'phone3' ]

const participants = inputData.records.split(',')

let i = 0
// Find every fourth item in the array starting at index 0, which represents the participant's First Name
const getName = function(participants, i) {
  for (i; i < participants.length; i += 4 ) {
       let name = participants[i]

         return name
    }
  };
// Find every fourth item in the array starting at index 1, which represents the participant's Last Name
const getSurname = function(participants, i) {
  for ( let i = 1; i < participants.length; i += 4 ) {
       let surname = participants[i]

        return surname
    }
  };
// Find every fourth item in the array starting at index 2, which represents the participant's Email Address
const getEmail = function(participants, i) {
  for ( let i = 2; i < participants.length; i += 4 )  {
       let email = participants[i]

        return email
    }
  };

// Output an object inside an array with the key/value pairs as shown below
output = {participants: [
{
  first_name: getName(participants, i),
  last_name: getSurname(participants, i),
  email: getEmail(participants, i)
}
]};

Example Output:

participants:
   1:
     first_name: Name1
     last_name: Surname1
     email: <a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="b2cacacacaf2d5dfd3dbde9cd1dddf">[email protected]</a>

Upon logging the output, it correctly displays that an object has been created:

{first_name: 'Name1', last_name: 'Surname1', email: '<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="abd3d3d3d3ebccc6cac2c785c8c4c6">[email protected]</a>'}

My Challenge

I am facing difficulty in iterating through the inputData and presenting the records in the following format:

participants:
   1:
     first_name: Name1
     last_name: Surname1
     email: <a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="740c0c0c0c341319151d185a171b19">[email protected]</a>
   2:
     first_name: Name2
     last_name: Surname2
     email: <a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="433a3a3a3a03242e222a2f6d202c2e">[email protected]</a>
   3:
     first_name: Name3
     last_name: Surname3
     email: <a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="c4bebebebe84a3a9a5ada8eaa7aba9">[email protected]</a>

When I use console.log() for each function's output, I get each record from the for loops. However, it does not output a record for each iteration. Why might this be happening?

javascript arrays zapier

Answer 1

Answer №1

After multiple attempts, I finally achieved the desired result in the following manner:

const players = inputData.records.split(',');
const totalPlayers = players.length;

// Setting up an iterator based on the length of the 'players' array
class Sequence {
    constructor( start = 0, end = Infinity, interval = 1 ) {
        this.start = start;
        this.end = end;
        this.interval = interval;
    }
    [Symbol.iterator]() {
        let count = 0;
        let nextIndex = this.start;
        return  {
            next: () => {
                if ( nextIndex <=                     this.end ) {
                    let result = { value: nextIndex,  done: false }
                    nextIndex += this.interval;
                    count++;
                    return result;
                }
                return { value: count, done: true };
            }
        }
    }
};

let rangeOfPlayers = new Sequence(0, totalPlayers - 4, 4);

// Creating an array from the generated Sequence to determine iteration count
const startingPoints = Array.from(rangeOfPlayers)

// Defining a function to generate 'player' objects using a specific formula
const playerData = function(array, index) {
  let firstName = players[index]
  let lastName = players[index+1]
  let email = players[index+2]
  return {name: firstName, surname: lastName, email: email}
};

// Initializing an empty array and populating it with data during each cycle
let playerRecords = []
const playerList = startingPoints.forEach(function(index){
  playerRecords.push(playerData(players, index))
});

                                
output = {playerRecords}

Answer 2

After multiple attempts, I finally achieved the desired result in the following manner:

const players = inputData.records.split(',');
const totalPlayers = players.length;

// Setting up an iterator based on the length of the 'players' array
class Sequence {
    constructor( start = 0, end = Infinity, interval = 1 ) {
        this.start = start;
        this.end = end;
        this.interval = interval;
    }
    [Symbol.iterator]() {
        let count = 0;
        let nextIndex = this.start;
        return  {
            next: () => {
                if ( nextIndex <=                     this.end ) {
                    let result = { value: nextIndex,  done: false }
                    nextIndex += this.interval;
                    count++;
                    return result;
                }
                return { value: count, done: true };
            }
        }
    }
};

let rangeOfPlayers = new Sequence(0, totalPlayers - 4, 4);

// Creating an array from the generated Sequence to determine iteration count
const startingPoints = Array.from(rangeOfPlayers)

// Defining a function to generate 'player' objects using a specific formula
const playerData = function(array, index) {
  let firstName = players[index]
  let lastName = players[index+1]
  let email = players[index+2]
  return {name: firstName, surname: lastName, email: email}
};

// Initializing an empty array and populating it with data during each cycle
let playerRecords = []
const playerList = startingPoints.forEach(function(index){
  playerRecords.push(playerData(players, index))
});

                                
output = {playerRecords}

Zapier - Generating Lists from Data Objects

Summary

The Script

Example Output:

My Challenge

Answer №1

Similar questions

How come CSS styles are not being applied to forms in AngularJS?

Bring in various React components from separate files

The mistake in npm install is when the console logs a bug that is notorious for causing npm to malfunction

Modify the structure of the JSON string

Exploring the method to deactivate and verify a checkbox by searching within an array of values in my TypeScript file

Bidirectional data binding between an Angular component and its parent controller

What process is involved in implementing TCO (Tail Call Optimization) for a recursive anonymous function in ES5?

A comprehensive guide on retrieving data from API across several pages

Easily integrating a JavaScript file into an HTML document when utilizing a NodeJS Express server

Obtain the current time for a specific user

Adjust the values in a list using a "for loop"

Loopback: Unable to access the 'find' property as it is undefined

What is the method for avoiding short-circuit conditions in TypeScript?

Retrieve information from the third section by utilizing ajax

Pikabu's Uphill Battle with Heights

Honing in on JavaScript Media Queries within React

Property that is dynamically populated based on data retrieved from an external API

Execute Javascript after modification of the DOM

Populate an HTML layout with MySQL information and dynamically add the content to the page using JavaScript

Minimizing the frequency of getElementById calls for the same HTML element