Hello
In desktop designer I've relied on the JSON Parse tool however in cloud that isn't available. I have a JSON response from an API with the following structure, what's the best way to parse the key value pairs from the 'items' array into columns within the alteryx cloud environment? I've failed using the create dataset from SQL option most likely with the wrong logic.
{
"@context" : "value" ,
"items" : [ {
"key1" : "value1" ,
"key2" : "value2" ,
"key3" : "value3"
}
, {
"key1" : "value1" ,
"key2" : "value2" ,
"key3" : "value3"
}
}
Thanks!
