I have an endpoint that I am pulling home information from. I want to update the record if it already exists or create the record if it doesn’t. See the logic below.
The problem I am having is I don’t know what logic I can use to determine if the Find Existing Home returned results. It seems everything I have tried I get the error
Value error for edge “Home Exists” condition: Value is not a valid boolean or convertible to a boolean.
Here is my current logic:
You have probably tried to check is > [All] > id is an empty text (using 2 single or double quotes)?
What you can do is having a loop node and loop over all the ids. If 0 records were found, the loop will never be executed. If 1 record if found, the loop will be executed once.
Another approach is having a summary node that counts the number of returned records. You can refer to that summary node and check if the value is > 0
Those are 2 potential workarounds. Once the automations has evolved more, there will be a function that can check if something is empty or not.
Thanks @frederikdc ! The summary node worked perfectly. I didn’t think of using it because I assumed it was some AI node. 