Playwright Typescript how to convert a CSV file in to JSON object and use that data in Script to perform data driven testing

Question

I have a scenario where i have to convert a csv file in to JSON object and use the data in script for performing data driven testing. If the file has multiple rows of data, then script should be executed for multiple iterations.

Csv File

name,description  
CHOne,First Change  
CHTwo,Second Change

Expected JSON format

{
   "name":"CHOne",
   "description":"First Change"
},
{
   "name":"CHTwo",
   "description":"Second Change"
}

It'd be great if you could provide some code examples and actual/expected result. — Yevhen Laichenkov
– Yevhen Laichenkov, Commented Jan 12, 2022 at 12:29

Yevhen Laichenkov · Accepted Answer · 2022-01-12 13:17:42Z

2

You can install a 3d party library to parse CSV to JSON easier and then use a simple for of loop to run test with different objects.

npm i -D csvtojson

Parse from CSV file to JSON array and run test with different data:

const csvFilePath = '<replace it with the path to csv file>'
const csv = require('csvtojson');

csv()
 .fromFile(csvFilePath)
 .then(users => {
    console.log(users) // will print
    /**
     * [
     *  {name:"CHOne", description: "First Change"},
     *  {name:"CHTwo", description: "Second Change"}
     * ]
     */

     // now you can run one test for each user's object
     for (const { name } of users) {
       test(`testing with ${name}`, async () => {
         // ...
       });
     }   
})

answered Jan 12, 2022 at 13:17

Yevhen Laichenkov

8,7922 gold badges34 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Playwright Typescript how to convert a CSV file in to JSON object and use that data in Script to perform data driven testing

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related