csv-writer | Convert objects/arrays into a CSV string or write them into a CSV file | CSV Processing library

While writing data to csv with help of pandas, The output I got doesn't have all values. Because of unequal values present in list.

The code finds the lowest value present in the 3 list and then writes the data with exact number of rows found in the lowest list.

Here's the code:-

The tests in my project were working fine when I first started using them, currently they have stopped working at all.

Whenever I use the test command the following error is thrown:

I want to create a CSV file using csv-writer , and upload that csv to azure blob, I am able to create the csv, store it on local system, and then read from local and upload to blob using azure-storage npm. But I dont want to create/store the CSV on local filesystem (because of some issues that I am running into on Prod), is there any way to create the CSV and directly feed to azure blob storage, without writing the csv to local file system.

Some code for reference

In writeFile fn the records returned by makeCsv function are empty (used await still :/ empty) how to make all the code inside makeCsv blocking such that it i get all entries in records array when i call fn(makeCsv)
Expected Code Flow

1. makeCsv -> reads a csv from local storage and calls function getPubKey
2. getPubKey-> fetches a key against each call for the account name passed by makeCsv by making a request to url and returns that key
3. makeCsv-> appends key property to object pushes it to results array and returns it
4. writeFile -> calls makeCsv and takes array to write new Csv with keys included
   
   Issue : As soon as call to getPubkey function is made end event is triggred resolving promise with empty array and thus writeFile receives empty array because it runs before makeCsv has ended creating all requests and then adding keys to data objects

I have a function that does a lot of things, but among them is that it copies a file to a special directory, does something with it (calls something to interact with that file without using the fs module), and then deletes the copied file once finished.