none
Orchestration RRS feed

  • Question

  • Hi,

      I am receiving the input from sql as schema and i have to assign that schema to multipart message type Account_Update_Input  which will be updated in CRMOD table.

     So can i know how to do this in Message assignment shape.

       

    Friday, April 5, 2013 11:43 AM

Answers


  • create Message using XMLDocument.

    xmlVariable = new XmlDocument();

    xmlVariable.LoadXml("XML of Message");

    AccountMessage.Part = xmlVariable

    code will be written in message assignment shape.

    Regards

    Mohit Gupta

    Friday, April 5, 2013 1:26 PM

All replies

  • you can create message in many ways

    1: in assignment shape use .

    Message.MessagePart = Message_2

    2: you can create using  Map.

    Regards

    Mohit Gupta

    Friday, April 5, 2013 11:50 AM
  • Hi,

      Thanks for Reply.

    But Schema's are already given. I have to use that schema's and I have to create login session.

    But I am Not getting how to take values from staging database and update into CRMOD table.I have generated schema using wcf and in stored procedure i have used select query to retrive values from sql

    Friday, April 5, 2013 12:00 PM
  • Hi

    use Map for convert SQL Message to WCF Schema .

    if it is not answering your question , please give more details

    Regards

    MG.

    Friday, April 5, 2013 12:13 PM
  • Hi,

    To be more clear, I have an xml schema which is generated through WCF adapter which will be the type of input message that is received in an orchestration. Within the orchestration i have to assign this message to Account_Update _Input message type which is a multipart message retrieved from WSDL of a webservice. Is there any way to do the same if not suggest any other way to do the same(without using map).

    Note: All fields in the Account_Query schema is not used.

    Friday, April 5, 2013 12:43 PM

  • create Message using XMLDocument.

    xmlVariable = new XmlDocument();

    xmlVariable.LoadXml("XML of Message");

    AccountMessage.Part = xmlVariable

    code will be written in message assignment shape.

    Regards

    Mohit Gupta

    Friday, April 5, 2013 1:26 PM
  • create Message using XMLDocument.

    xmlVariable = new XmlDocument();

    xmlVariable.LoadXml("XML of Message");

    AccountMessage.Part = xmlVariable

    code will be written in message assignment shape.

    Regards

    Mohit Gupta

    Monday, April 8, 2013 1:38 PM