Excel file read

#1

Has anyone done reading an excel file via HTTP request node in the workflow to get data as a JSON string? please post the code snippet that can help. Appreciated.

0 Likes

#2

The easiest way to accomplish this is to move the HTTP request and Excel parsing to an AWS Lambda function. You can then use the Lambda Node to invoke the function, which can then return the contents of the Excel file back to the workflow for further processing.

I’ve actually done this exact thing before and had good success with the xlsx module to do the Excel parsing.

0 Likes

#3

In the absence of AWA credentials, can’t this be done using javascript function node using XMLHttpRequest call. But, doing so, I get error as XMLHttpRequest not defined

0 Likes

#4

The function node provides a very limited JavaScript sandbox. This is due to security reasons and that your code is being run in our infrastructure. The function node also cannot import other modules, so using the xlsx module will not be possible.

Unfortunately, parsing an Excel file with only a workflow is not possible at this time. Lambda or Google Cloud Functions are our recommended approaches.

0 Likes