Tag Archives for " #JSON "

Jun 03

RPG Example reading JSON using JSON_TABLE from IFS

IBM i , Programming , RPG , Webservice

Decode JSON webservice reply data (already stored in IFS) using JSON_TABLE This reads the JSON from the IFS – decodes it using JSON_TABLE and reports on time taken to perform decode. In this case the JSON data is a simple layout that looks like this: {“users”:[{“userID”:”@123″,”firstName”:”Billy”,”lastName”:”Bob”,”initials”:”123″,”company”:110,”division”:30,”department”:325,”secProfile”:””},{“userID”:”AAATEMP”,”firstName”:”Albert”,”lastName”:”Smith”,”initials”:”AAA”,”company”:110,”division”:1,”department”:1,”secProfile”:””},{“userID”:”AAATEST”,”firstName”:”Andy”,”lastName”:”Tester”,”initials”:”AAA”,”company”:110,”division”:1,”department”:530,”secProfile”:”AAT”},{“userID”:”AAA3″,”firstName”:”Fred”,”lastName”:”Blogs”,”initials”:”AA3″,”company”:110,”division”:1,”department”:1,”secProfile”:”AAA”},{“userID”:”AATEST”,”firstName”:”AA”,”lastName”:”TEST”,”initials”:”AAT”,”company”:110,”division”:1,”department”:1,”secProfile”:””},{“userID”:”ABB”,”firstName”:”Abba”,”lastName”:”Dancing Queen”,”initials”:””,”company”:110,”division”:1,”department”:1,”secProfile”:””},{“userID”:”BINGBONG”,”firstName”:”Bing”,”lastName”:”Bong”,”initials”:”BB”,”company”:110,”division”:2,”department”:2,”secProfile”:””},{“userID”:”LITTENN”,”firstName”:”Nick”,”lastName”:”Litten”,”initials”:”NJL”,”company”:001,”division”:1,”department”:123,”secProfile”:”Secret Squirrel”}]} This JSON example contains the values: USERID […]

More Waffle
Jul 27

JSON Plugin for RDI

IBM i , Programming , RPG , Webservice

Ever wanted to validate or syntax check JSON from within RDi? It’s easy using the free JSON editor from the Eclipse marketplace. This JSON Plugin for RDI will validate, syntax check and polish your JSON layouts with ease. To start you have to go into RDI and get into Eclipse’s Market Place. That will bring up […]

More Waffle
Dec 03

Web Services for Dummies

IBM i , Programming , Webservice

What are webservices? Broadly speaking “Web Services” are programs that let one computer system talk to another computer system over the internet. For example, you might want to enter customer details into a office computer system and have those customer details be checked on an online ‘address checking’ website or something similar. Today, Web Services […]

More Waffle
Jul 01

An introduction to iSeries webservices

Webservice , IBM i , Programming

Web Services With Cobol Or RPG on IBM ISeries – Restful Php Web Services 1. Introduction Web Services and SOAP (or REST) are rapidly becoming state-of-art architectural approaches to allow the access of multiplatform and multilanguage systems, Many companies have legacy applications which represent a high investment and Web Services promise to allow their access […]

More Waffle