How to convert JSON to AppleScript properties

applescriptjson

How can I get AppleScript to run this query and save each value (country, city, etc.) as an AppleScript variable?

http://ip-api.com/json/8.8.8.8?fields=country,city,isp,org,as,mobile,proxy,message

I'm trying to get information about IP and domain and set the value of some variables.

I was not sure how to even run the query from AppleScript so I used do shell script to call curl:

set IPAddress to "8.8.8.8"
set link to "http://ip-api.com/json/" & IPAddress & "?fields=country,city,isp,org,as,mobile,proxy,message"
set curl_command to "curl " & link

do shell script curl_command

The result is JSON formatted text. Is AppleScript's text delimiter the only option for parsing the result?

Best Answer

The easiest way is to use JSON Helper app available on the AppStore. Then you simply do something like this:

tell application "JSON Helper"
    set json to fetch JSON from "http://ip-api.com/json/8.8.8.8?fields=country,city,isp,org,as,mobile,proxy,message"
    set countryName to |country| of json
end tell

Result: "United States"

Related Solutions

Applescript – AppleEvent handler failed on set properties {visible messages: }

From comments…

As it would appear that many people across the net are struggling & failing to get set properties to {visible messages:msgList} to work at all, it might be simpler in the long run to just pop up a count of unread/unflagged messages & optionally sort by flagged then unread for easy discovery in the Mail window.

I added in a 'sort by date or flags/unread' option in the dialog, too

tell application "Mail"
    tell the front message viewer
        set unReadMsgs to every message whose read status is false and flagged status is false
        display dialog ("There are " & (count of unReadMsgs) as string) & ¬
            " Unread/Unflagged messages." buttons {"Sort Unread", "Sort Date"} ¬
            default button "Sort Date" giving up after 300
        set theResult to button returned of result as string
        if theResult is "Sort Date" then
            set properties to {sort column:date received column}
        else if theResult is "Sort Unread" then
            set properties to {sort column:flags column}
            set properties to {sort column:message status column}
        end if
    end tell
end tell

AppleScript : Set do script result as variable

You want the brand and the country_name from the JSON data, you can use a JSON parser.

Here is an example of parsing JSON in python

-- Get https://www.binlist.net/json/431940
set cc to the clipboard as string
set finalresult to do shell script "curl https://www.binlist.net/json/" & cc & "  |  /usr/bin/python -c 'import json, sys; obj=json.load(sys.stdin); print obj[\"brand\"],obj[\"country_name\"]' "
display notification "Result is " & finalresult --> "Result is VISA Ireland"

Best Answer

Related Solutions

Applescript – AppleEvent handler failed on set properties {visible messages: }

AppleScript : Set do script result as variable

Related Question