IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
Expand all | Collapse all

How to create IS Record from XML..?

  • 1.  How to create IS Record from XML..?

    Posted 04/30/09 10:08 AM

    Hi All,
    we are trying to convert XML into IS Record… (we actually have a select service for our adapter which fetches the data from the database and the user can choose their mode of output(like String, IData…and IS Record)…

    The query returns the result in xml format which needs to be convertes into IS Record.

    We tried using pub.web:stringtoDocument and pub.web:documenttoRecord… but got struck in mapping the output for the second one…

    how to specify the output format for the service…? ie how to map the output to a specified doctype.

    Regards, Aravind


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: How to create IS Record from XML..?

    Posted 04/30/09 04:41 PM

    IData and IS Record are the same thing.

    Accept an input parameter in your adapter service that indicates the IS document type name to use for the pub.xml:xmlNodeToDocument call. The pub.web services are deprecated and should be avoided. Use the pub.xml services instead.

    Another approach is to just return the XML string and let the caller manipulate that as needed.


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: How to create IS Record from XML..?

    Posted 05/03/09 02:10 PM

    Hi Reamon,

    I am not able to execute pub.xml:xmlNodeToDocument successfully. Do i need to map it with any other service…?

    We need to map the XML output to the already existing doctype.

    Regards, Aravind


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 4.  RE: How to create IS Record from XML..?

    Posted 05/04/09 05:24 AM

    What errors are you seeing? Are you passing all the necessary inputs?


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 5.  RE: How to create IS Record from XML..?

    Posted 05/04/09 05:29 AM

    Hi Reamon,

    Iam just passing the documenttype name and it is not giving any errors.

    What inputs i need to pass for that service.

    Regards, Aravind


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 6.  RE: How to create IS Record from XML..?

    Posted 05/04/09 05:32 AM

    Review the Built-in Services Reference for the required inputs. At a minimum you’ll need to pass an xml node object.


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 7.  RE: How to create IS Record from XML..?

    Posted 05/04/09 06:22 AM

    Hi Reamon,

    1. When i execute the xmlNodetoDocument alone…by providing the doctypename…itz jus displaying the same in the output…

    2)For the service pub.xml:xmlNodetoDocument… inorder to provide the xmlnode input … iam using pub.xml:xmlStringtoXMLNode… and

    i have just exported the pipeline locally and pasted the contents below…

    <?xml version="1.0" encoding="UTF-8"?> false test:FirstDoctype VENTANA 18 This yacht 147 is a big ship family yacht. Convenient but slow.
    GULFSTAR 55 1700 480 170 112 84 202 8
    147 yacht147.jpg

    It has no effect on the doctypename which iam passing…even without that the output is same…

    Regards, Aravind


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 8.  RE: How to create IS Record from XML..?

    Posted 05/04/09 04:16 PM

    It appears to me that the conversion to an IS document has worked. All the <value name… tags are the string representation of the IS document.

    What are you not seeing that you’re expecting to see?


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 9.  RE: How to create IS Record from XML..?

    Posted 05/05/09 06:46 AM

    Hi Reamon,

    We just were curious about getting that doctypename in there instead of document in the output.

    When the user wants the output as IS Records, we have an option for the user to select the doctypename… and thus the curiosity… :slight_smile:

    I think this is fine with us. Thanks for all the replies Rob…

    Regards, Aravind


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 10.  RE: How to create IS Record from XML..?

    Posted 09/29/09 08:50 AM

    Hi All,

    When we execute our createDocType service, it creates the new doctype plus an additional schema node.

    if the record name is test, it creates the schema name as schema_test.

    How to remove it…?

    Thanks & Regards, Aravind


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards