René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"XML Special Character errors/handling","articleBody":"\u003c!--\r\nThank you for taking the time to report a bug! Please make sure to fill in the\r\nrequired information so that we can best address your report. \r\n\r\nNote that anything between the angle brackets (like this text here!) is a\r\ncomment and won't show up in the report. Feel free to remove them while you're\r\nfilling out the report, but do not remove other fields.\r\n--\u003e\r\n\r\n\u003c!-- The below command examples use the generic \"python\" and \"pip commands\r\n     Be sure to substitute with the commands you're actually using\r\n     eg. python3, pip3, pip3.6, etc... \r\n--\u003e\r\n* **itoolkit version**: \u003c!-- output from `pip show itoolkit` --\u003e 1.7.2 \r\n* **Python version**: \u003c!-- `python -V` --\u003e 3.8.10\r\n* **OS Name and Version**: \u003c!-- The OS you're running itoolkit --\u003e Ubuntu 20.04.6\r\n* **IBM i version**: \u003c!-- the IBM i version you're connecting to --\u003e V7R4M0\r\n* **XMLSERVICE version**: \u003c!-- output of `qsh cmd('/qsys.lib/qxmlserv.lib/xmlver.pgm')` --\u003e \r\n\r\n**Describe the bug**\r\n\u003c!-- \r\nPlease provide a clear and concise description of what the problem is.\r\n\r\nGiving examples usually help. If you have a small amount of code, pasting it\r\ninline should be fine. For more info on formatting code block, see\r\nhttps://help.github.com/en/github/writing-on-github/creating-and-highlighting-code-blocks\r\nIf you have a larger example, please create a gist instead: https://gist.github.com/\r\n--\u003e\r\n\r\nHow does itoolkit handle special character's for xml? The example below returns *BADPARSE. Our understanding is that CDATA should allow for the use of special characters. I think in this case it's a period (.)\r\n\r\n`3e3c215b43444154415b4b796c651a73 \u003e\u003c![CDATA[Kyle.s2076616e5d5d3e3c2f646174613e0a3c  van]]\u003e\u003c/data\u003e.\u003c\r\n`\r\n\r\n```\r\n#install packages\r\n# itoolkit\r\n# pyodbc\r\n\r\n\r\nfrom itoolkit import iToolKit, iCmd, iData, iPgm\r\nfrom itoolkit.transport import DatabaseTransport\r\n\r\ntext_key = 12021270\r\niseries_connection =  pyodbc.connect(settings.ISERIES_CONNECTION_DSN, timeout=1)\r\n\r\nitransport = DatabaseTransport(iseries_connection)\r\nitool = iToolKit()\r\n\r\nitool.add(iCmd('chglibl',\r\n               'CHGLIBL LIBL(DD1492BFDD DD1492BS XX1492BP DD1492BP U492BP U492AP U491AP U490AP)'))\r\n\r\n\r\n#10a, 10a, 15p0, 3a, 10a, 7000a, 2a\r\nitool.add(iPgm('CSBR926B', 'CSBR926B')\r\n          .addParm((iData('IN_TextType', '10a', '*SALORDLIN')))\r\n          .addParm(iData('IN_DocumentType', '10a', '*ALL'))\r\n          .addParm(iData('IN_TextKey', '15p0', text_key))\r\n          .addParm(iData('IN_Empty', '3a', \"\"))\r\n          .addParm(iData('IN_User', '10a', \"james\"))\r\n          .addParm(iData('OUT_TEXT', '7000a', \"\"))\r\n          .addParm(iData('OUT_Error', '2a', \"\"))\r\n          )\r\nitool.call(itransport)\r\n\r\nresults = itool.dict_out('CSBR926B')\r\nprint(results)\r\n\r\n```\r\n\r\n\r\nXML_IN:\r\n```\r\n\u003c?xml version='1.0'?\u003e\r\n\u003cxmlservice\u003e\u003ccmd exec=\"cmd\" error=\"fast\" var=\"chglibl\"\u003e\u003c![CDATA[CHGLIBL LIBL(DD1492BFDD DD1492BS XX1492BP DD1492BP U492BP U492AP U491AP U490AP)]]\u003e\u003c/cmd\u003e\u003cpgm name=\"CSBR926B\" error=\"fast\" var=\"CSBR926B\"\u003e\u003cparm io=\"both\" var=\"p1\"\u003e\u003cdata type=\"10a\" var=\"IN_TextType\"\u003e\u003c![CDATA[*SALORDLIN]]\u003e\u003c/data\u003e\u003c/parm\u003e\u003cparm io=\"both\" var=\"p2\"\u003e\u003cdata type=\"10a\" var=\"IN_DocumentType\"\u003e\u003c![CDATA[*ALL]]\u003e\u003c/data\u003e\u003c/parm\u003e\u003cparm io=\"both\" var=\"p3\"\u003e\u003cdata type=\"15p0\" var=\"IN_TextKey\"\u003e\u003c![CDATA[12021270]]\u003e\u003c/data\u003e\u003c/parm\u003e\u003cparm io=\"both\" var=\"p4\"\u003e\u003cdata type=\"3a\" var=\"IN_Empty\"/\u003e\u003c/parm\u003e\u003cparm io=\"both\" var=\"p5\"\u003e\u003cdata type=\"10a\" var=\"IN_User\"\u003e\u003c![CDATA[james]]\u003e\u003c/data\u003e\u003c/parm\u003e\u003cparm io=\"both\" var=\"p6\"\u003e\u003cdata type=\"7000a\" var=\"OUT_TEXT\"/\u003e\u003c/parm\u003e\u003cparm io=\"both\" var=\"p7\"\u003e\u003cdata type=\"2a\" var=\"OUT_Error\"/\u003e\u003c/parm\u003e\u003c/pgm\u003e\u003c/xmlservice\u003e\r\n```\r\n\r\nXML_OUT:\r\n```\r\n\u003c?xml version=\"1.0\" ?\u003e\u003cxmlservice\u003e\r\n\u003cerror\u003e*BADPARSE\u003c/error\u003e\r\n\u003cerror\u003e\r\n\r\n\u003c![CDATA[ ?xml version='1.0'? xmlservice cmd exec=\"cmd\" error=\"fast\" var=\"chglibl\" success \r\n\r\n![CDATA[+++ success CHGLIBL LIBL(DD1492BFDD DD1492BS XX1492BP DD1492BP U492BP U492AP U491AP U490AP)]] /success /cmd pgm name=\"CSBR926B\" error=\"fast\" var=\"CSBR926B\" parm io=\"both\" var=\"p1\" data type=\"10a\" var=\"IN_TextType\" \r\n\r\n![CDATA[*SALORDLIN]] /data /parm parm io=\"both\" var=\"p2\" data type=\"10a\" var=\"IN_DocumentType\" \r\n\r\n![CDATA[*ALL]] /data /parm parm io=\"both\" var=\"p3\" data type=\"15p0\" var=\"IN_TextKey\" \r\n\r\n![CDATA[12021270]] /data /parm parm io=\"both\" var=\"p4\" data type=\"3a\" var=\"IN_Empty\" \r\n\r\n![CDATA[]] /data /parm parm io=\"both\" var=\"p5\" data type=\"10a\" var=\"IN_User\" \r\n\r\n![CDATA[james]] /data /parm parm io=\"both\" var=\"p6\" data type=\"7000a\" var=\"OUT_TEXT\" \r\n![CDATA[Kyle s van]] /data /parm parm io=\"both\" var=\"p7\" data type=\"2a\" var=\"OUT_Error\" \r\n\r\n![CDATA[]] /data /parm success \r\n\r\n![CDATA[+++ success CSBR926B]] /success /pgm /xmlservice ]]\u003e\u003c/error\u003e\r\n\u003c/xmlservice\u003e\r\n```\r\n\r\n\r\n\r\nTrace\r\n\r\n```\r\ncontrol Thu Jul 20 12:54:52 2023\r\n ipc(*na) ctl(*here *cdata) proc(QXMLSERV.iPLUGR512K)\r\ninput Thu Jul 20 12:54:52 2023\r\n\u003c?xml version='1.0'?\u003e\r\n\u003cxmlservice\u003e\u003ccmd exec=\"cmd\" error=\"fast\" var=\"chglibl\"\u003e\u003c![CDATA[CHGLIBL LIBL(DD1492BFDD DD1492BS XX1492BP DD1492BP U492BP U492AP U491AP U490AP)]]\u003e\u003c/cmd\u003e\u003cpgm name=\"CSBR926B\" error=\"fast\" var=\"CSBR926B\"\u003e\u003cparm io=\"both\" var=\"p1\"\u003e\u003cdata type=\"10a\" var=\"IN_TextType\"\u003e\u003c![CDATA[*SALORDLIN]]\u003e\u003c/data\u003e\u003c/parm\u003e\u003cparm io=\"both\" var=\"p2\"\u003e\u003cdata type=\"10a\" var=\"IN_DocumentType\"\u003e\u003c![CDATA[*ALL]]\u003e\u003c/data\u003e\u003c/parm\u003e\u003cparm io=\"both\" var=\"p3\"\u003e\u003cdata type=\"15p0\" var=\"IN_TextKey\"\u003e\u003c![CDATA[12021270]]\u003e\u003c/data\u003e\u003c/parm\u003e\u003cparm io=\"both\" var=\"p4\"\u003e\u003cdata type=\"3a\" var=\"IN_Empty\"/\u003e\u003c/parm\u003e\u003cparm io=\"both\" var=\"p5\"\u003e\u003cdata type=\"10a\" var=\"IN_User\"\u003e\u003c![CDATA[james]]\u003e\u003c/data\u003e\u003c/parm\u003e\u003cparm io=\"both\" var=\"p6\"\u003e\u003cdata type=\"7000a\" var=\"OUT_TEXT\"/\u003e\u003c/parm\u003e\u003cparm io=\"both\" var=\"p7\"\u003e\u003cdata type=\"2a\" var=\"OUT_Error\"/\u003e\u003c/parm\u003e\u003c/pgm\u003e\u003c/xmlservice\u003e\r\n\r\nparse (fail) Thu Jul 20 12:54:52 2023\r\n3c3f786d6c2076657273696f6e3d2731 \u003c?xml version='1\r\n2e30273f3e0a3c786d6c736572766963 .0'?\u003e.\u003cxmlservic\r\n653e3c636d6420657865633d22636d64 e\u003e\u003ccmd exec=\"cmd\r\n22206572726f723d2266617374222076 \" error=\"fast\" v\r\n61723d226368676c69626c223e3c7375 ar=\"chglibl\"\u003e\u003csu\r\n63636573733e3c215b43444154415b2b ccess\u003e\u003c![CDATA[+\r\n2b2b2073756363657373204348474c49 ++ success CHGLI\r\n424c204c49424c284444313439324246 BL LIBL(DD1492BF\r\n44442044443134393242532058583134 DD DD1492BS XX14\r\n39324250204444313439324250205534 92BP DD1492BP U4\r\n39324250205534393241502055343931 92BP U492AP U491\r\n415020553439304150295d5d3e3c2f73 AP U490AP)]]\u003e\u003c/s\r\n7563636573733e0a3c2f636d643e0a3c uccess\u003e.\u003c/cmd\u003e.\u003c\r\n70676d206e616d653d22435342523932 pgm name=\"CSBR92\r\n364222206572726f723d226661737422 6B\" error=\"fast\"\r\n207661723d224353425239323642223e  var=\"CSBR926B\"\u003e\r\n0a3c7061726d20696f3d22626f746822 .\u003cparm io=\"both\"\r\n207661723d227031223e0a3c64617461  var=\"p1\"\u003e.\u003cdata\r\n20747970653d2231306122207661723d  type=\"10a\" var=\r\n22494e5f5465787454797065223e3c21 \"IN_TextType\"\u003e\u003c!\r\n5b43444154415b2a53414c4f52444c49 [CDATA[*SALORDLI\r\n4e5d5d3e3c2f646174613e0a3c2f7061 N]]\u003e\u003c/data\u003e.\u003c/pa\r\n726d3e0a3c7061726d20696f3d22626f rm\u003e.\u003cparm io=\"bo\r\n746822207661723d227032223e0a3c64 th\" var=\"p2\"\u003e.\u003cd\r\n61746120747970653d22313061222076 ata type=\"10a\" v\r\n61723d22494e5f446f63756d656e7454 ar=\"IN_DocumentT\r\n797065223e3c215b43444154415b2a41 ype\"\u003e\u003c![CDATA[*A\r\n4c4c5d5d3e3c2f646174613e0a3c2f70 LL]]\u003e\u003c/data\u003e.\u003c/p\r\n61726d3e0a3c7061726d20696f3d2262 arm\u003e.\u003cparm io=\"b\r\n6f746822207661723d227033223e0a3c oth\" var=\"p3\"\u003e.\u003c\r\n6461746120747970653d223135703022 data type=\"15p0\"\r\n207661723d22494e5f546578744b6579  var=\"IN_TextKey\r\n223e3c215b43444154415b3132303231 \"\u003e\u003c![CDATA[12021\r\n3237305d5d3e3c2f646174613e0a3c2f 270]]\u003e\u003c/data\u003e.\u003c/\r\n7061726d3e0a3c7061726d20696f3d22 parm\u003e.\u003cparm io=\"\r\n626f746822207661723d227034223e0a both\" var=\"p4\"\u003e.\r\n3c6461746120747970653d2233612220 \u003cdata type=\"3a\" \r\n7661723d22494e5f456d707479223e3c var=\"IN_Empty\"\u003e\u003c\r\n215b43444154415b5d5d3e3c2f646174 ![CDATA[]]\u003e\u003c/dat\r\n613e0a3c2f7061726d3e0a3c7061726d a\u003e.\u003c/parm\u003e.\u003cparm\r\n20696f3d22626f746822207661723d22  io=\"both\" var=\"\r\n7035223e0a3c6461746120747970653d p5\"\u003e.\u003cdata type=\r\n2231306122207661723d22494e5f5573 \"10a\" var=\"IN_Us\r\n6572223e3c215b43444154415b6a616d er\"\u003e\u003c![CDATA[jam\r\n65735d5d3e3c2f646174613e0a3c2f70 es]]\u003e\u003c/data\u003e.\u003c/p\r\n61726d3e0a3c7061726d20696f3d2262 arm\u003e.\u003cparm io=\"b\r\n6f746822207661723d227036223e0a3c oth\" var=\"p6\"\u003e.\u003c\r\n6461746120747970653d223730303061 data type=\"7000a\r\n22207661723d224f55545f5445585422 \" var=\"OUT_TEXT\"\r\n3e3c215b43444154415b4b796c651a73 \u003e\u003c![CDATA[Kyle.s\r\n2076616e5d5d3e3c2f646174613e0a3c  van]]\u003e\u003c/data\u003e.\u003c\r\n2f7061726d3e0a3c7061726d20696f3d /parm\u003e.\u003cparm io=\r\n22626f746822207661723d227037223e \"both\" var=\"p7\"\u003e\r\n0a3c6461746120747970653d22326122 .\u003cdata type=\"2a\"\r\n207661723d224f55545f4572726f7222  var=\"OUT_Error\"\r\n3e3c215b43444154415b5d5d3e3c2f64 \u003e\u003c![CDATA[]]\u003e\u003c/d\r\n6174613e0a3c2f7061726d3e0a3c7375 ata\u003e.\u003c/parm\u003e.\u003csu\r\n63636573733e3c215b43444154415b2b ccess\u003e\u003c![CDATA[+\r\n2b2b2073756363657373202043534252 ++ success  CSBR\r\n393236425d5d3e3c2f73756363657373 926B]]\u003e\u003c/success\r\n3e0a3c2f70676d3e0a3c2f786d6c7365 \u003e.\u003c/pgm\u003e.\u003c/xmlse\r\n72766963653e rvice\u003e\r\nparse step: 2 (1-ok, 2-*BADPARSE, 3-*NOPARSE)\r\n{'error': {'error': '*BADPARSE', 'error1': ' ?xml version=\\'1.0\\'? xmlservice cmd exec=\"cmd\" error=\"fast\" var=\"chglibl\" success ![CDATA[+++ success CHGLIBL LIBL(DD1492BFDD DD1492BS XX1492BP DD1492BP U492BP U492AP U491AP U490AP)]] /success /cmd pgm name=\"CSBR926B\" error=\"fast\" var=\"CSBR926B\" parm io=\"both\" var=\"p1\" data type=\"10a\" var=\"IN_TextType\" ![CDATA[*SALORDLIN]] /data /parm parm io=\"both\" var=\"p2\" data type=\"10a\" var=\"IN_DocumentType\" ![CDATA[*ALL]] /data /parm parm io=\"both\" var=\"p3\" data type=\"15p0\" var=\"IN_TextKey\" ![CDATA[12021270]] /data /parm parm io=\"both\" var=\"p4\" data type=\"3a\" var=\"IN_Empty\" ![CDATA[]] /data /parm parm io=\"both\" var=\"p5\" data type=\"10a\" var=\"IN_User\" ![CDATA[james]] /data /parm parm io=\"both\" var=\"p6\" data type=\"7000a\" var=\"OUT_TEXT\" ![CDATA[Kyle s van]] /data /parm parm io=\"both\" var=\"p7\" data type=\"2a\" var=\"OUT_Error\" ![CDATA[]] /data /parm success ![CDATA[+++ success CSBR926B]] /success /pgm /xmlservice ', 'CSBR926B': {...}}}\r\n```\r\n\r\n","author":{"url":"https://github.com/deydist","@type":"Person","name":"deydist"},"datePublished":"2023-07-20T18:34:29.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/82/python-itoolkit/issues/82"}