- Data source connected to an API that runs at a specific time. Data coming in cannot be used as is, so I have another excel file attached to it that transforms it so its useful. Then I have a sleep function for 5 minutes then it’s connected to OneDrive so it can delete the file when it’s complete. The issue I’m having is that the sleep function starts every time one payload comes in and pauses each time data comes in. This causes a huge time delay. How can I use the pause function after all the comes in to excel?
As previously discussed, did you manage to use the Make API module to turn off the scenario and then switch it back on once you’ve done processing the data?
2 Likes
Yes I did, thank you. I have that in use for another scenario. I was hoping to have this scenario as one scenario with a built in pause but it seems the sleep module turns on after each data bundle. I have this as 2 separate scenarios now.
Perhaps you could do the same here, in the second module immediately after the trigger module, add a Make module to turn the current scenario off, and turn it back on when it’s done.
2 Likes
I’ll give that a go! thanks.
This works well but ultimately hoping to put all the pieces together into one scenario. Your suggestion has gotten us closer (many thanks). The data that gets uploaded into the 1st spreadsheet is triggered from windows scheduler and it runs a bat file. (It works fine but user has to be logged in - we dont want that) the bat file triggers an http request that runs takes data and creates the “ugly” file and we then parse it so it works with another application. Is there a module we can use to trigger to url process?
Take a look at this answer I wrote on another forum:
I’m not quite sure what you mean - you lost me here. Are you saying you want to replicate this entire process using this scenario you are putting together on Make?
2 Likes
Sorry, maybe a picture will help. GET HTTP request bassically is triggering a process that is connected to a payment gateway.
Do you happen to know if there is a way to remove the contents of an excel spreadhseet without deleting the file? the one listed here is basically a shell that is used to enter data into an ACH creating tool.