Hi there!
I'm trying to write a basic CSV to our Azure Data Lake using NodeRed. I do a SQL read, then transform the data into a CSV, and use a function to covnert it into the correct format.
So my flow runs:
Inject -> SQL Read (works fine) -> CSV conversion (works) -> Function -> Azure File Append
Here is the code in my function:
data = msg.payload;
var today = new Date();
var dd = String(today.getDate()).padStart(2, '0');
var mm = String(today.getMonth() + 1).padStart(2, '0'); //January is 0!
var yyyy = today.getFullYear();
today = dd + '_' + mm + '_' + yyyy;
file = today;
msg.payload = {"filePath": file+"_InventoryMovements"};
msg.payload.content = data;
return msg;
I am, however, getting the following data and I'm not sure what it means:
RestError: The uploaded data is not contiguous or the position query parameter value is not equal to the length of the file after appending the uploaded data.
Can someone point me in the right direction?