2 Replies Latest reply on Dec 15, 2015 12:40 PM by BKBK

    Javascript generated JSON vs CF generated JSON

    WolfShade Level 4

      Hello, all,

       

      I've got a few pages that I'm working on where, after the page loads, I use Javascript to dynamically create a form, then use CF to convert a query object to JSON, insert that into the form, and submit it (as opposed to running the same query twice), and the action page will DeserializeJSON()  to generate an Excel spreadsheet from the query.

       

      These pages are all working flawlessly.

       

      Now, I'm trying to do the same thing, except insead of using CF to convert a query into JSON, I'm creating a Javascript JSON of the data to pass to the form.  But when the page submits, DeserializeJSON() isn't working, even though I'm using the same format that CF uses.

       

      I'm getting the following error:

      JSON parsing failure: Expected ',' or ']' at character 60721:'M' in ... (JSON string)

       

      Well, at almost 100,000 characters, I'm having trouble finding that position (Word is useless for this), so can't view the issue directly.  However, I'm wondering if anyone knows a way to take a Javascript JSON string and format it so that CF can deserialize it.

       

      V/r,

       

      ^_^

        • 1. Re: Javascript generated JSON vs CF generated JSON
          WolfShade Level 4

          Nevermind.. I figured it out.

           

          I copied and pasted the JSON string into a JS variable, created a div and gave it an id="testJSON" attribute, then:

          document.getElementById('testJSON').innerHTML = jsVar.substr(60700,60750);
          

           

          I noticed, now, that someone had used double quotes as part of a cell value, and that was throwing my Javascript generated JSON out of whack.

           

          I applied a .replace(/"/gi,'"') to the values, and that mostly fixed it.  However, the cells where there is a double quote now show up in the Excel spreadsheet as ";

           

          For now, not a big deal.  Although if anyone can help fix it by removing the semi-colon after a " (CF is doing a replacenocase(""",'"') and that isn't removing the ; for some reason.)

           

          V/r,

           

          ^_^

          • 2. Re: Javascript generated JSON vs CF generated JSON
            BKBK Adobe Community Professional & MVP

            Possibly related to my post here.