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.


#TechXchangePresenter
 View Only

  • 1.  Payload Data

    Posted Wed August 27, 2014 02:57 AM

    Hi Guys

    I need to extract the payload data for a month for a reciver from tnconsole, instead of extracting the data manually can I query the tn database …can you please let me know the table where we can get this payload data.

    WM7x version is being used…quick help is very much appreciated;)

    Regards
    Sandeep


    #Integration-Server-and-ESB
    #webMethods
    #B2B-Integration


  • 2.  RE: Payload Data

    Posted Wed August 27, 2014 09:14 AM

    Try to check in this table: BIZDOCCONTENT

    Let me know if you find something else.


    #Integration-Server-and-ESB
    #B2B-Integration
    #webMethods


  • 3.  RE: Payload Data

    Posted Fri September 26, 2014 06:18 PM

    You can use services in wm.tn.query folder.

    Use the wm.tn.query:createDocumentQuery and give internal ID of receiver
    Then use the wm.tn.query:documentQuery and disable paging. You should be able to see the internal ids. Use the internal id as an input to service getContentPart and you should be able to get the data in pipeline

    Else as Mashesh mentioned below. you need to make a join between tables bizdoc and bizdoccontent to identify the rows for a particular receiver


    #B2B-Integration
    #webMethods
    #Integration-Server-and-ESB


Related Content