The final thing you will want to do here is to convert the JSON data to a table. Do this by clicking on Into Table, then hit Close & Load. You should now see the data from within the JSON file ...

As I noted in an earlier column, JSON is great for moving data around but not so hot when ... salesToDate.currency'); A more common scenario is to convert a JSON array into multiple rows in a related ...

Click the Convert to table button in the ribbon ... Click this to get a list of the columns you can expand the JSON data into, using JSON keys as column names and the values as the data.