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
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.