MySQL output to IF statement

Questions
1

Hello,
i don’t understand working with json and items. Even with documentation :frowning: Sorry for basic question.

I have output of node MySQL like this

[
{
"Time": "2021-11-15T23:27:20.000Z",
"Price": 63556.6
},
{
"Time": "2021-11-15T23:26:20.000Z",
"Price": 63539.5
},
{
"Time": "2021-11-15T23:25:20.000Z",
"Price": 63535
},
{
"Time": "2021-11-15T23:24:20.000Z",
"Price": 63522.5
},
{
"Time": "2021-11-15T23:23:20.000Z",
"Price": 63515.2
}
]

How can I use that json in my IF node? At final I would like to compare each Price and if all of them are increasing to get phone notification (node Pushover).

My problem is that json data aren’t properly named and that’s why I can’t access them by node Set or Item Lists

Workflow:

workflow
workflow1065×419 23.7 KB

Thank you!

2

might be stupid way to do it, but I guess you could use 2x Item Lists node on the mysql output
in one Item Lists sort by Time, in the other Item Lists sort by Price, if both are increasing the outputs should be identical…
than you could compare these two and decide accordingly?

1 Like
3

Welcome to the community @ShippeR

I put together an example with almost an identical solution to what @Bahadur suggested. To use it, create a new workflow, copy the workflow below and paste it into the new workflow.

Example workflow
4

Thank you both for help! Example workflow helps so much :blush:

1 Like