Insert Excel Data to Data List

Overview

This custom service imports data from an Excel file into a Yeeflow data list.

What it does

• Reads the input Excel file
• Uses Data List ID to identify which data list to write to
• Uses Mapping JSON to map Excel column names to Yeeflow field names
• Creates items in the target data list
• Returns Added Number as the count of records successfully added

Current input variables

• Excel file: the Excel file to import
• Data List ID: the target Yeeflow data list ID
• Mapping JSON: JSON array defining how Excel columns map to list fields

Current output variable

• Added Number: number of items created

Example Mapping JSON

[
{
"excelColumn": "Employee Name",
"fieldName": "EmployeeName"
},
{
"excelColumn": "Amount",
"fieldName": "Amount"
},
{
"excelColumn": "Request Date",
"fieldName": "RequestDate"
}
]

In short: it is an Excel-to-Data-List import service.