Hi, I’m new to Make and not entirely sure about the best way to achieve my goal. I have an HTTP module connected to a Google Sheets module. Occasionally, my HTTP module pulls two sets of data, but it extracts the wrong set into Google Sheets. How can I filter or ensure that I only get the correct set of data from my HTTP module to Google Sheets?
Side note: My HTTP module is connected to my Oura Ring so I would only want to pull the set of data that has the longest sleep duration and omit the data that has the shortest sleep duration value
Edit: I only want to send the second collection under Output->Data->data to the google sheets module
@Zeke_Brown
HI, I thought about this after looking at the screenshot, but have not verified that it works well, so please give it a try.
I only made it after the HTTP Request module.
Briefly, the process is to compare each data with Sleep Duration and keep it as a variable if it is a large value.
Finally, the largest value should be stored in the variable Sleep Duration, so if you pass that value to the Add a Row Module in Spreadsheet, I think you can process what you want to achieve.
If there are only two data and you only need to get the second one, you can use an Iterator to split the data and set a Filter to be executed only when the Order position is number 2.
