Hello and welcome to our community! Is this your first visit?
Register
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
    Posts
    1
    Thanks
    1
    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.

    Thanks.

  • #2
    Senior Coder rnd me's Avatar
    Join Date
    Jun 2007
    Location
    Urbana
    Posts
    4,296
    Thanks
    10
    Thanked 584 Times in 565 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 13/9/26)
    BROWSER STATS [% share] (2014/5/28) IE7:0.1, IE8:5.3, IE11:8.4, IE9:3.2, IE10:3.2, FF:18.2, CH:46, SF:7.9, NON-MOUSE:32%

  • 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
    •