Hi, I’m completely new to make and I’m struggling to test a client scenario.
They have a sFTP where a new file (excel sheet) is added every single hour.
I need to get that file and transform the data into json.
So I need to watch files in a folder and every time a new file was uploaded I need to get the content and create a json.
So far I just managed the first step - to watch the ftp. But now I have no glue to access the data of the file.
In the end I need a json that look like this
{
“name”:“John”,
“training”:“Training 1”,
“completion date”:“27.10.2022”
}
{
“name”:“Sylvia”,
“training”:“Training 2”,
“completion date”:“30.10.2022”
}
Thanks in advance!
Use the parse csv and the transform json modules.
Thanks for the hint. My biggest problem is the step between watching the file and parse it. I need to watch for new files but then I need any kind of operator to be able to actually access the data of the file to work with it. I guess as soon as I get the data out of the file, it will be easier to play around.
Hello, My name is Alex Sirota and I am the founder of NewPath Consulting. We are a 4-year old Make.com partner. We offer a one hour video call where we explain and show how Make can help your organization. We even build some scenarios and share them with you so get more value than a usual exploratory discussion. Book some time with me at Make.com Hero - NewPath Consulting I look forward to talking to you and your team should they join us.