Forum Discussion
Solved
Expand Record from a column
Hello. I am using an API to get the data from a Shelly device: The script is: let
// Define the URL
url = "https://shelly-<xx>-eu.shelly.cloud/device/status",
// Define the reques...
You won't have much of a choice as you have nested records too. You will need to decide which records to keep, which to throw away, and how to flatten the hierarchies. Not really something you can do automatically.
Thank you, everyone.
I ended up adding Custom Columns based on the following formula (adapted for each column):
if
Value.Is ([Value], type record)
then
Record.Field([Value], "connected")
else
""
Resulting in:
Thank you for your support.