Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Apr 2012
    Thanked 0 Times in 0 Posts

    complete JSON newb, download and read file

    I am working with APIs and sending information via a URL. For this one new client, the response they send us uses JSON, which I've never used before.

    I can send the data ok, but the response comes in the form of a file. It doesn't even seem to have an extension but I can open it manually in notepad. I need to know how to read this file programatically so I can use the data. If I can read this data back into SQL Server, I'll be ok from there.

    Any assistance much appreciated.


  • #2
    Senior Coder rnd me's Avatar
    Join Date
    Jun 2007
    Thanked 613 Times in 593 Posts
    im guessing you run php, so just use json_decode to turn json into a php array...

    in js, you usually use a jsonp technique, or JSON.parse() in conjunction with ajax to grab the file.
    my site (updated 2014/10/20)
    BROWSER STATS [% share] (2014/9/03) IE7:0.1, IE8:4.3, IE11:9.2, IE9:2.7, IE10:2.6, FF:16.8, CH:47.5, SF:7.8, NON-MOUSE:37%

  • Users who have thanked rnd me for this post:

    theboyholty (04-13-2012)


    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts