Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
so after my research i have concluded that httppostlcob must be utilized by passing request parms via the URL - ideally we would like to build an xml request string and pass that instead - are there any systools that will allow for this?
You are correct, the httpPostClob and httpGetClob are the two "services" you should be looking at.
To build the XML request there are the XMLTABLE services that IBM provides, but I don't think that's what you asking form. Those tend to be used to parse received XML not generate it. IBM isn't great and XML or JSON generation. Reading and parseing XML and JSON they are great at doing, but not so much generating it.
In my iQuery product, when OUTPUT(*XML) is selected, we embed the XMLELEMENT and XMLSERIALIZE keywords around the individual column (field) names. So you may want to read up on those two pieces.
But from my experience using httpPostClob, you tend to build your XML template and then populate it with the data, then send it using httpPostClob.
Thank you Bob.
After I posted this, i was unable to get back on your site (seems the server was down a few days), anyhow since then i was able to do the following in my SQLRPGLE (our shop is primarily rpg and i'm bringing some sql to the table, so i set out to do the following)
1.) create a varchar xml string (using a single sql statment)
2.) pass that to the httppostclob, and get my response in a varchar xml string
3.) pass that string to a procedure to parse it with a single sql statement
pure sweetness!
thanks alot for the reply