$fn.csvToObject(csv)

Converts the specified CSV file data to object format.

Arguments

Name	Type	Description
csv	Buffer	Buffer object in CSV file

CSV File Specifications

Header	Required This is the name of the object’s property. Only single-byte alphanumeric characters are allowed. (Starting with a numeral is not acceptable.) Example）“email”, “name”
Delimiter	,（comma）
Field	If the value contains double quotes,commas, or line breaks, be sure to enclose them.
Newline Character	CRLF or LF
Encoding	UTF-8
BOM	Without BOM or with BOM

Return value

Type	Description
array of object	Converts CSV file data to object format and returns it

Note

• The header name of the CSV file becomes the property name of the object.
• After conversion to object format, each value is returned as a string.
• If the CSV file does not conform to the specifications, an exception message is thrown.

Sample

try {
  /* CSV Contents
   * ----------------------------------------------------------------------------
   * Id,Title,Description,Progress,Category,CreatedBy,CreatedAt
   * 00001,Title 1,"Description 1, Sample 1",100,CATEGORY1,User1,2023-08-01
   * 00002,Title 2," Description 2, Sample 2",80,CATEGORY2,User2,2023-08-10
   * 00003,Title 3," Description 3, Sample 3",20,CATEGORY3,User3,2023-08-12
   * ----------------------------------------------------------------------------
   */
  const file = await $fn.getFile("/path/to/projects.csv");
  const buffer = file.data;
  // Parses CSV files and converts them to objects
  const projects = $fn.csvToObject(buffer);
  // Register data one case at a time
  for (const project of projects) {
    const { Id, Title, Description, Category, Progress, CreatedBy, CreatedAt } = project;
    if (!Id) {
      throw new Error("Please enter ID.");
    }
    const progress = Number(Progress);
    if (isNaN(progress)) {
      throw new Error("Enter the percentage of progress with numeric.");
    }
  /* SQL Function Content
   * ------------------------------------------------------------------------------------
   * insert into Project VALUES  (${param.id},${param.title},${param.description},
   * ${param.progress},${param.category},${param.createdBy},${param.createdAt});
   * ------------------------------------------------------------------------------------
   */
   // Register data in tables with SQL functions
    await insertToProjectTable({
      id: Id,
      title: Title,
      description: Description,
      progress,
      category: Category,
      createdBy: CreatedBy,
      createdAt: CreatedAt
     });
  }
} catch (e) {
  console.error(e);
}