Import Json into Numbers

When I used =ImportJson in Google sheets the data looked like this:

I adjusted my script once more and got some actual results to work (sort of) It just appeared very different in Numbers compared to how it did in Sheets. I was going to pull only the columns I need in a helper table. Picture below updated Applescript

set tgtTable to "Copy/Paste" -- change if needed to match table name

set pasteCell to "a1" -- upper left cell of range to place values

tell application "JSON Helper"

set myRecord to fetch JSON from "http://www.nfl.com/liveupdate/scores/scores.json"

set the clipboard to (make JSON frommyRecord)

end tell

tell application "Numbers"

tell front document'sactive sheet'stabletgtTable to set selection range to rangepasteCell

activate

delay 0.2 -- vary this if needed

end tell

tell application "System Events" to keystroke "v" using {option down, shift down, command down}

to getVal(t, valTag)

set text item delimiters to valTag

set item2 to t's text item 2

set text item delimiters to "\" "

set val to item2's first text item

end getVal

W

I was just pointed towards using Json helper, and I was able to see the data in script editor, but I'm not sure where to add this to the above script to have it paste into numbers as I had it doing.

tell application "JSON Helper"

set forceDetails to fetch JSON from "http://www.nfl.com/liveupdate/scores/scores.json"

end tell

Hi,

I adjusted my script and was going to post a new question as I'm running into an error still. I see my results in AppleScript bottom portion "Results" but I still can't get the data to post into Numbers.

set tgtTable to "Copy/Paste" -- change if needed to match table name

set pasteCell to "a1" -- upper left cell of range to place values

tell application "JSON Helper"

set myRecord to fetch JSON from "http://www.nfl.com/liveupdate/scores/scores.json"

return myRecord

end tell

tell application "Numbers"

tell front document'sactive sheet'stabletgtTable to set selection range to rangepasteCell

activate

delay 0.2 -- vary this if needed

end tell

tell application "System Events" to keystroke "v" using {option down, shift down, command down}

to getVal(t, valTag)

set text item delimiters to valTag

set item2 to t's text item 2

set text item delimiters to "\" "

set val to item2's first text item

end getVal