Parsing JSON from Rest API in alteryx Cloud

[Steve_InterWorks]

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!

[Steve_InterWorks · Accepted solution]

Turns out JSON Parse is in preview which I don't have as I'm on a trial version so this question isn't relevant anymore.