Skip to main content
2Charlie
2Charlie
Inspiring
Mar 7, 2016 4:07 PM UTC
Answered

How to open and read JSON file?

Is there a specific way to open and read a json file other than using cfhttp tag?

    This topic is closed to new replies. Start a new post to keep the conversation going.
    BKBK
    BKBKCorrect answer
    Community Expert
    Mar 7, 2016 7:43 PM UTC

    As I've said above, I tried to use the <cfset kogroups = deserializeJSON(fileread(#KOGroups.json#)) /> but I'm not sure how to specify the path. It's unable to find the file. The actual location of the KOGroups.json is located in a shared folder and not on the IIS server. The path is "https://devbox.mysite.com/search/KOGroups.json but I'm not sure how to specify a relative path instead of a absolute path.


    <cfset koGroupsJSON = fileRead("https://devbox.mysite.com/search/KOGroups.json")>

    View reply

    11 replies

    Carl Von Stetten
    Carl Von Stetten
    Legend
    Mar 7, 2016 4:23 PM UTC

    Depends on where the file is located.  If you are pulling it from a remote site, then CFTTP seems reasonable.  If it's on a local drive or a network drive, then CFFILE should work.  And keep in mind there isn't anything special about a "JSON" file.  It's really just a text file, albeit in JavaScript Object Notation format in terms of structure.

    Translate
    2Charlie
    2CharlieAuthor
    Inspiring
    Mar 7, 2016 4:35 PM UTC

    It's a local file. I was afraid that cfhttp would not be as safe as cffile.

    Thanks!

    Translate
    2Charlie
    2CharlieAuthor
    Inspiring
    Mar 7, 2016 4:49 PM UTC

    Okay, so this is what I have in cftthp: <cfhttp url="https://devbox.mysite.com/search/KOGroups.json" method="get" timeout="15" />

    However, when I try the fileread I have this:

    <cfset kogroups = deserializeJSON(fileread(#KOGroups.json#)) />

    My question now is, how do specify the path in the fileread above?

    Translate
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices