From what I can gather in this case the issue is fairly obvious to the naked eye although Booth has yet to confirm that it is the braces ({}) or other chars.

Sent from my iPad

[] ƕ
On 11 Nov 2016, at 18:29, Pete Helgren <pete@xxxxxxxxxx> wrote:

If you are just checking the format, is a great site to vet and ID any issues. Copy and paste the data onto the site, it will tell you where the issues are.

On very complex JSON, it is a lifesaver and even on simple stuff, it has pointed me to really simple errors I have made....

Pete Helgren
GIAC Secure Software Programmer-Java
LinkedIn -
Twitter - Sys_i_Geek IBM_i_Geek

On 11/11/2016 12:18 PM, Booth Martin wrote:
Thank you Kevin. Danny, Henrik, and Justin.

Clearly, lesson 56 is to be learning about ccsid.

Also, IE. hmmmm Good tip. I tried IE 11 and discovered the data on did not show up with IE either. Apparently it only works in Firefox.

Again, thank you all for the pointers. Very much appreciated.

On 11/11/2016 3:28 AM, Kevin Turner wrote:
It shouldn't have any problem as long as the data is correctly encoded. With JSON the typical mistake is with the braces ({}) especially when hardcoded in RPG source. If your job ccsid is 37 (using the US example) and your source files is ccsid 37 then what you key in will look fine in the source and any file you spew out to the IFS, but that doesn't mean that it actually is correct when converted by Apache to (for example) UTF-8. We never hardcode those characters for that reason. It would be useful to see what Booth gets on the browser and if indeed it is the braces that are screwed.

Sent from my iPad

On 11 Nov 2016, at 09:00, Henrik Rützou<hr@xxxxxxxxxxxx> wrote:

I have had the same problem with IE loading external XML via AJAX into DOM

On Fri, Nov 11, 2016 at 9:30 AM, Kevin Turner<kevin.turner@xxxxxxxxxxxxxxx>

"First, its telling me the file is badly formed and points to row 1,"

What is "it" in this sentence? Your browser? If so what does the JSON
look like when it is downloaded? For example you can use the Google Chrome
developer tools - Network tab to look at it.

Sounds to me like you have a ccsid issue with the file.

This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

The information transmitted herein is intended only for the person or entity to which it is addressed and may contain confidential, proprietary and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.