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.
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.
Unfortunately, parsing an Excel file with only a workflow is not possible at this time. Lambda or Google Cloud Functions are our recommended approaches.