Skip to main content

XML/C$XML and APIs

  • July 7, 2015
  • 18 replies
  • 0 views
D

Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

Thanks

    18 replies

    D

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    check request file xsl

    <xsl:stylesheet version="1.0" xmlns:xsl="www.w3.org/.../Transform&quot;>

    <xsl:output method="xml" encoding="UTF-8" indent="yes"/>

    <xsl:template match="/">

    <soap:Envelope xmlns:soap="www.w3.org/.../soap-envelope&quot;

                                xmlns:web="www.w3schools.com/.../&quot;>

    <soap:Body>

    <web:FahrenheitToCelsius>

    <web:Fahrenheit>

    <xsl:value-of select="fahrenheit-to-celsius/fahrenheit"/>

    </web:Fahrenheit>

    </web:FahrenheitToCelsius>

    </soap:Body>

    </soap:Envelope>

    </xsl:template>

    </xsl:stylesheet>

    And response xsl file

    <xsl:stylesheet version="1.0" xmlns:xsl="www.w3.org/.../Transform&quot;

        xmlns:soap="schemas.xmlsoap.org/.../envelope&quot;

    xmlns:a="www.w3schools.com/.../&quot;>

    <xsl:output method="html" encoding="UTF-8" indent="yes"/>

    <xsl:template match="/">

      <Fahrenheit-To-Celsius-Response xmlns="www.w3schools.com/.../&quot;>

         <Fahrenheit-To-Celsius-Result>

        <xsl:value-of select="soap:Envelope/soap:Body/a:FahrenheitToCelsiusResponse/a:FahrenheitToCelsiusResult"/>

         </Fahrenheit-To-Celsius-Result>

      </Fahrenheit-To-Celsius-Response>

    </xsl:template>

    </xsl:stylesheet>

    the webservice change

    D

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    I have very little knowledge of XML and am having trouble seeing what you are offering as a solution to the issue?

    Stephen Hjerpe
    • Stephen Hjerpe
    • Participating Frequently
    • July 8, 2015

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    I believe what luispaul was saying is that the TempConvertRequestF2C.xlst file seems incomplete

    request.txt

    Thomas Morrison
    • Thomas Morrison
    • Participating Frequently
    • July 8, 2015

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    The exact problem is that the namespace declaration for the soap alias does not match between the XSLT and the response.

    In the original XSL file, the soap alias was declared:
         xmlns:soap=http://schemas.xmlsoap.org/soap/envelope"

    However, in the web service response it was declared:
      xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/

    Steve, I am not sure how this error crept in.  In my installed RM/COBOL development system, the last slash character is in the namespace declaration contained in the XSLT.  I don't think this web service has changed on w3schools.  Anyway, that's the problem.

    Tom Morrison
    HCSS

    Tom Morrison, Consultant, South Carolina, USA
    D

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    The problem is that the program is outdated.

    What really changes is the webservice request and response are different from those that are published in the micro focus server.

    For this reason we must change the xsl file so you can correctly interpret the response of the webservice.

    I do not speak English so my answers are so short (like my English).

    You can download the updated instance the link below.

    The last test I did was in the month of March this year.

    There is also a manual in Spanish with more information written in English, a translation itself to help me understand it.

    Excuse my English is google translator.

    Regards.

    dl.dropboxusercontent.com/.../rmnet.zip

    D

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    I am reviving this message thread in hopes of getting more help on this topic.  Sadly I had a hard drive die that had the solution that worked based on the help in this forum message.  I am again trying to get this simple API call to work but can't seem to get the external XLS files to work.  Can I please get some help in looking at the files in the Object folder to tell me what is wrong with them.  I appreciate all the help again and if I get this working this time I will put the project on an external drive!

    1 Attachments
    D

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    Sorry to reopen this old thread but I lost my laptop harddrive along with the solution that worked.  Can someone please look at the attached project and let me know what is wrong.  I am sure it is in the XML files somehow but I am not able to make it work.   Thanks for any help.ABC_2D00_LOOK2.zip

    Thomas Morrison
    • Thomas Morrison
    • Participating Frequently
    • September 7, 2016

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    Read the response from luispaul above.  The web service changed after the example was published.

    You can obtain the expected request and response payloads in the SOAP 1.1 versions of the operations described here:

    www.w3schools.com/.../tempconvert.asmx

    and here:

    www.w3schools.com/.../tempconvert.asmx

    Change the XSL so that they export requests and import responses of the correct structure.

    Tom Morrison, Consultant, South Carolina, USA
    D

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    Try this (see attachment). I made the following changes and it works for me:

    • Changed the Working-Storage entries for Desired-SOAP-Action and Post-Address to match the current w3schools service;
    • Tweaked some of the C$XML code to go 1 level deeper into the response document (and changed CXML-GET-ATTRIBUTE to CXML-GET-DATA);
    • Changed the <xsl value-of select="fahrenheit-to-celsius"> in the .xsl file to use the lower-case value* of the element (was "Fahrenheit-To-Celsius").

    *because in the XML symbol table that's stored in the object file, all the data names are converted to lower-case

    1 Attachments
    D

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    Thanks for the links, I have tried to make those work in my project but still have no luck.  I am pretty sure that my lack of ability/understanding is the issue.  I get a clean compile but then when i run the project I have issues on the line <Fahrenheit>string</Fahrenheit>.  I did get a response from Chuck E via email but the attachment was not included so I am not able to see what was done.  Again I appreciate all the help.

    Thomas Morrison
    • Thomas Morrison
    • Participating Frequently
    • September 8, 2016

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    'Clean compile' suggests that you are not focused on the XSL, which is where the change needs to be made.  Look at the XML payloads required for the web service (using the links above), and then modify the XSL files to (1) export the correct XML, and (2) import the expected XML.  Note that you should probably go back to the original files in the example.

    Tom Morrison, Consultant, South Carolina, USA
    D

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    I tried to post here yesterday, including your project that I modified to work. For some reason, my post was blocked (maybe due to the attachment?). So I'll just describe my changes here:

    • in Working-Storage, change the value of the 3rd filler under Desired-SOAP-Action to:
      • '"http://www.w3schools.com/xml/FahrenheitToCelsius"' (with double-quotes enclosed in single-quotes, like you had on the old value)

    • then change the value of Post-Address to:
      • "www.w3schools.com/.../tempconvert.asmx"
    • in the Event Editor code (Procedure Division code), remove the sets of lines that call C$XML using
      • CXML-GET-ATTRIBUTE-COUNT
      • CXML-GET-ATTRIBUTE
    • in their place, add two new calls to C$XML:

      • call "C$XML" using CXML-GET-FIRST-CHILD
        ELE-2-HANDLE.
        move return-code to ele-3-handle.

        call "C$XML" using CXML-GET-DATA
        ELE-3-HANDLE
        throw-away
        fahrenheit-to-celsius-result
        0.

    • Finally, edit the XSL stylesheet (TempConvertRequestF2C.xsl).  Find the tag with:
      • <xsl:value-of select="Fahrenheit-To-Celsius"/>
      • change the value to all lower-case:
      • <xsl:value-of select="fahrenheit-to-celsius"/>

    I think those are all the changes I had to make to get this working. Give it a try and let us know how it works!

    D

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    Thank you for all the detailed help, when I make your changes I get the following error:

    Thomas Morrison
    • Thomas Morrison
    • Participating Frequently
    • September 9, 2016

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    In the <xsl:stylesheet> element, you are missing the declaration (attribute) for xmlns:xsl.  

    You should be able to see an example on just about any XSL.

    Tom Morrison, Consultant, South Carolina, USA
    D

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    Progress has been made!  I no longer get the error above but now the result that is sent back to me is 'error'.  Attached are the xsl and xml files that the process is creating.

    files.zip

    D

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    Here (below) is what I have in my working "request" xsl stylesheet (TempConvertRequestF2C.xsl). Your program doesn't use or reference the "response" stylesheet (TempConvertResponseF2C.xsl), and the request/response xml docs (containing the SOAP request/response envelopes) will be generated on a successful run, so they don't need to pre-exist.

    If you use a browser to visit the service endpoint URL (http://www.w3schools.com/xml/tempconvert.asmx), then click on the link for the FahrenheitToCelcius operation, it will show you sample SOAP message formats you can use to access the service.

    You can also use the very useful SoapUI tool (free to download from https://www.soapui.org/) to load the WSDL and generate sample requests.

    <?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet	version="1.0" xmlns:xsl="www.w3.org/.../Transform">
<xsl:output method="xml" encoding="UTF-8" indent="yes"/>
<xsl:template match="/">
<soap:Envelope xmlns:xsi="www.w3.org/.../XMLSchema-instance" 
               xmlns:xsd="www.w3.org/.../XMLSchema" 
               xmlns:soap="schemas.xmlsoap.org/.../">
  <soap:Body>
    <FahrenheitToCelsius xmlns="www.w3schools.com/.../">
      <Fahrenheit><xsl:value-of select="fahrenheit-to-celsius"/></Fahrenheit>
    </FahrenheitToCelsius>
  </soap:Body>
</soap:Envelope>
</xsl:template>
</xsl:stylesheet>
    D

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    SUCCESS!!!!!  Thanks all for the help with this.  I know it was basically a training session for me to learn what to do and it was/is much appreciated.

    D

    Attached you will find parts of a bench project from version 9.2.3 (could not load all for file size issue .acu and AcuBenchPrint.dll were removed from Object folder) that is my attempt to get the RMNet Tutorial stuff that floats around the forum running.   I have been successful in getting it to do all but show the results on the screen.   Can someone that is familiar with reading XML data with AcuCobol please check out the code and see what I am doing wrong.  You will notice in the project I had started with the logic in the sample program (XML IMPORT TEXT) but could not get that to work so I commented it out and moved on to try my luck with C$XML stuff.  

    I do appreciate anyone that can help me as this will be a big win for our company to get this type of API logic up and running.

    Thanks

    Great news - glad it's worked out! Now, from here you might want to consider using XML Extensions (XML IMPORT FILE or XML IMPORT TEXT) to retrieve the data from the response, instead of the low-level C$XML routines. It's likely to be more robust, especially if the structure of the response data ever changes. Plus, if you use XML IMPORT TEXT you can probably perform all of this in memory, rather than having to store a temporary response file that's needed in order to parse with C$XML.

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement