
Announcements
Hello
I am trying to write a condition which identifies if a value is in a set of JSON data or not. I have built a custom connector to receive information about some devices. This then loops through each device and inputs the desired information into SQL. One of the devices is missing some of the required peices of information at which point the flow fails.
Is there a way to write a condition maybe to check if that vaule exists. Or is there a way to just say carry on if there is no data for a device?
I have tried the following query but that doesnt seem to work - contains('Parse Chrome Device','activeTimeRanges')
Here is the JSON data
Is is my completed flow
This is the error i have been getting
Hi @adamjohnson42,
You can use the empty() function to check the value of activeTimeRanges, if it is null, it will return a true boolean value.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.