tag:blogger.com,1999:blog-34020393.post8559312272752081372..comments2024-03-27T10:59:38.307-07:00Comments on Jim's PeopleSoft Journal: 101 Ways to Process JSON with PeopleCodeJim Marionhttp://www.blogger.com/profile/12995110203807924786noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-34020393.post-47889865039329272492023-06-21T07:19:47.096-07:002023-06-21T07:19:47.096-07:00Hi Jim, I've completed the project. The proces...Hi Jim, I've completed the project. The process was interesting; in fact, I was able to incorporate CI and code's classes and methods. This type of integration was fascinating and has opened up many new opportunities.<br /><br />Thank you for answering, your work "blog" is very good.<br /><br />Best,<br /><br />Victor P. Unda :)Viktorhttps://www.blogger.com/profile/01375709348885368170noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-30458753392556540302023-06-21T07:15:51.772-07:002023-06-21T07:15:51.772-07:00@Viktor, take a look at http://blog.jsmpros.com/20...@Viktor, take a look at http://blog.jsmpros.com/2011/10/rest-like-peoplesoft-services.html and the psnonxml section.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-8135944947215165232023-06-21T07:12:48.740-07:002023-06-21T07:12:48.740-07:00@Anonymous, use JsonParser to parse JSON content, ...@Anonymous, use JsonParser to parse JSON content, and then you may inspect the contents.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-77164757312826067252023-06-08T02:24:30.530-07:002023-06-08T02:24:30.530-07:00Hi Jim,
Is there a way to read dynamic Json docum...Hi Jim,<br /><br />Is there a way to read dynamic Json documents and get the respestive field values like emplid,effdt. i am having multiple Json documents each with different structure and details like one with emplid,effdt,hiredt etc, other document with orderid,refid,etc..,how to load this document and identify the field names and values in peoplecode. PLease help me in understanding a way to do this.Anonymoushttps://www.blogger.com/profile/04501386178256841740noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-71587978067607817332023-05-18T06:08:37.471-07:002023-05-18T06:08:37.471-07:00Hello Jim,
Thank you for your work. I wondered if...Hello Jim,<br /><br />Thank you for your work. I wondered if you have any example(s) how to send back a confirmation message from a message OP (POST) json. Parsing a data in json and using services OP and message POST from a third-party is working but sending back to the third-party a confirmation "success" can't find a good way to do this. The code is in a class and method.<br /><br />Thanks,Viktorhttps://www.blogger.com/profile/01375709348885368170noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-4751402101063181292021-02-16T21:23:52.537-08:002021-02-16T21:23:52.537-08:00@Jie, on 8.51, it is not easy but is possible. I t...@Jie, on 8.51, it is not easy but is possible. I think a Java library would be easiest. I have had great success with the org.json JSON classes and JSON.simple. We documented JSON.simple in our PeopleTools Tips and Techniques book written on PeopleTools 8.49.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-58841969732574924872021-01-22T11:13:59.942-08:002021-01-22T11:13:59.942-08:00Hi, Jim
Thank you so much for sharing. We are on P...Hi, Jim<br />Thank you so much for sharing. We are on PeopleTools 8.51, do you know what is the good way to process JSON? Thank you!<br /><br />JieJiehttps://www.blogger.com/profile/14698819790984310168noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-89320517210250830612020-06-30T21:03:24.767-07:002020-06-30T21:03:24.767-07:00I don't know that you can make the Document dy...I don't know that you can make the Document dynamic, but you can create multiple documents and choose which one to generate. If the Service Operation is attached to an unstructured message, then it works perfectly. This would not work with a Service Operation attached to a Document-based message. Easy fix, though, just change the Service Operation (or create a new version).Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-14209952011979098422020-05-27T00:03:47.190-07:002020-05-27T00:03:47.190-07:00Hi Jim,
We have created a REST web services and r...Hi Jim,<br /><br />We have created a REST web services and response in JSON message. Whether document builder in PeopleSoft can create a dynamic JSON structure? for example document has three collection A, B,C. I have to send only the data in A, C or B,C based on the request. We are in 8.57muthuhttps://www.blogger.com/profile/08953579272341149656noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-52091143323414742342019-09-03T20:52:43.452-07:002019-09-03T20:52:43.452-07:00Yes, absolutely! Every single one of these methods...Yes, absolutely! Every single one of these methods is available in 8.56.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-17331377418595853182019-09-03T14:42:24.321-07:002019-09-03T14:42:24.321-07:00Do you know if this is available in 8.56?Do you know if this is available in 8.56?Anonymoushttps://www.blogger.com/profile/16261499592266785761noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-66587179135627272702019-01-25T14:43:08.890-08:002019-01-25T14:43:08.890-08:00@Sudheer, I don't know that you will be able t...@Sudheer, I don't know that you will be able to use the Documents module or rowset based message to do this. I would be more likely to use an unstructured, non-rowset based message, which will give you a string, and parse the contents using a true JSON parser.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-21439799372652790882019-01-25T14:34:40.365-08:002019-01-25T14:34:40.365-08:00@Nilay are you using the Documents module? It is n...@Nilay are you using the Documents module? It is not flexible. If you start from a JSONArray, however, you will not get JSONObject notation. It looks like you may be starting from JSONObject.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-85241977919221096322019-01-18T15:52:27.177-08:002019-01-18T15:52:27.177-08:00Yes, this is tools specific. I believe the Java cl...Yes, this is tools specific. I believe the Java classes were added to support Elastic Search and therefore may not exist in earlier PeopleTools releases.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-89402194571383265702019-01-03T07:18:57.910-08:002019-01-03T07:18:57.910-08:00Howdy. Tried this but I am getting
Java Excepti...Howdy. Tried this but I am getting <br /><br />Java Exception: java.lang.NoClassDefFoundError: org/json/JSONObject: finding class org.json.JSONObje ct (2,725) <br /><br />Is this specific to a tools version - we are on 8.54<br /><br />ThanksAnonymoushttps://www.blogger.com/profile/17522676786574992938noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-45466843457000852212018-11-14T16:59:17.595-08:002018-11-14T16:59:17.595-08:00@AB, I think the key word there is "dynamic.&...@AB, I think the key word there is "dynamic." There is nothing dynamic about the PeopleTools delivered Fluid Accordion. I actually wonder why they delivered it because you notice Navigation Collections and activity guides don't use it, but use something that looks and works much better. Yes, I would look else where for this functionality, especially since you want it to be dynamic.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-17474156965701394162018-11-14T10:49:46.535-08:002018-11-14T10:49:46.535-08:00This is great feedback and I completely agree! The...This is great feedback and I completely agree! The PeopleSoft apps and tools team are both recognizing the need for good JSON support. We see this with elastic, cloud chatbot service, etc. I fully expect better, documented JSON support, and I definitely do not mean the documents module.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-75534790552032941102018-10-24T09:08:57.545-07:002018-10-24T09:08:57.545-07:00I tried the JSONStringer class in a couple of my s...I tried the JSONStringer class in a couple of my services and it ended up taking twice as long to return the results as my implementation using the undocumented Elastic search classes.<br /><br />I have several services that return 15+ meg json objects and the serialization speed is a huge pain point. I've had to resort to caching results via a clob in the database in order to stream the data to our consuming apps quickly (minutes vs. seconds). I really wish there was a faster way so that I ditch caching.ericdrumhttps://www.blogger.com/profile/13725393500128611879noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-74973380232760589602018-08-07T11:25:50.426-07:002018-08-07T11:25:50.426-07:00Hello Jim,
I get lot of solutions from your blog
...Hello Jim, <br />I get lot of solutions from your blog<br /><br />I have a fluid grid page for Table of contents for out Benefits groups. <br />This is showing all uploaded documents based on the benefit program for the self service employee <br />I would like to have accordion style for sub-topics (example - Medical category has 12 sub <br />category documents and do not want them to be shown until sub-categoty is expanded) <br />I want all categories to be dynamic. I tried with group "Accordion Vertical" for the main group box and "Accordion groupbox" <br />on the fluid tab but I am not getting the results right since they are like master child, in sub page fashion not like accordion (just under the parent category)<br />I can get the things working (accordion style)with basic html/css/java script as standalone but not able to make it work in Peoplesoft environment. I am wondering whether OracleJet library accordion has any different data source for the master and child boxes?<br />I appreciate your input on what could be the approach<br />Regards - AB Krishna<br />AB Krishnahttps://www.blogger.com/profile/16164317145072709294noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-87689366731580204492018-07-19T10:27:13.912-07:002018-07-19T10:27:13.912-07:00Hi Jim, Need some help on PeopleSoft Consuming JSO...Hi Jim, Need some help on PeopleSoft Consuming JSON MQ message. <br /><br />We configured JMSTARGET node and were able to establish the connection between MQ series and PS Local node as per PS documentation. <br /><br />But we are not able to consume the JSON message. We tried to use Non-rowset message (as Peoplesoft don't have the ability to create message out of JSON Schema, we used online tool to convert JSON to XML and then got XSD and used in non-rowset creation). And created Service operation and added Handler code. But, we are not able to consume the message as it throws "Connection manager thrown General Framework Exception" error.<br /><br />Then, we tried to use Document to create the message (Used same JSON Structure) and created the Service operation but when we try to consume message, it says "Unknown JMS message Format" on the error logs.<br /><br />Could you please help me on to how to Consume MQ series JSON message using Document/non-rowset method? Anonymoushttps://www.blogger.com/profile/00213216149689298186noreply@blogger.com