Decrypting Credit Card in Mapping

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Decrypting Credit Card in Mapping

Viewing 1 reply thread
  • Author
    Posts
    • February 3, 2009 at 9:37 AM #21633
      community-content

        Lets start with a snippet of my source document that I am mapping from:

        – <Payments>
        – <CreditCardPayment ExpirationYear=”2031“
        Status        =”228252532“ ValidationCode=”750“ PaymentType=”CreditCard“
        BillingAddressId        =”bce496d7-a879-4ec3-900e-3c26b67c1284“ DerivedClassName=”CreditCardPayment“
        AuthorizationCode        =”090980“ CustomerNameOnPayment=”James J. Jamison“ CardType=”MasterCard“ OrderGroupId=”a4aeb41f-ffff-4974-9742-27cf138bf63d“ PaymentId=”e623216d-0e72-4b2a-aa38-6213aa96e2ec“ CreditCardIdentifier=”“
        ExpirationMonth        =”4“ Amount=”22.9500“ CreditCardNumber=”“
        OrderFormId        =”340ef0d6-e2a3-4250-9b77-d1b122878403“ PaymentMethodId=”dc85eeba-fd25-4ee5-a763-123b5c9204dc“>
        – <WeaklyTypedProperties>
          <WeaklyTypedProperty Name=”CCNumber“ Value=”tTwAPMzYnSKYzfqTyXyx2e/lU1bic0zn“ Type=”String“ />
          </WeaklyTypedProperties>
          </CreditCardPayment>
          </Payments>
        What I need to do inside my mapping is to extract the Value attribute of the WeaklyTypedProperty named CCNumber and then pass that value into an inline C# Script functoid that will do the decryption and then pass out the credit card number that will be written into my destination map.
        The xpath to select the value I want is //CreditCardPayment/WeaklyTypedProperties/WeaklyTypedProperty[@Name = ‘CCNumber’]/@Value
        I have tried writing this into an inline XSLT like this <xsl:value-of select=//CreditCardPayment/WeaklyTypedProperties/WeaklyTypedProperty[@Name = ‘CCNumber’]/@Value” /> so that I have the value I want to pass into my C# script but it doesn’t seem to allow me to chain script functoids together.
        What is the best way to handle this? I cannot simply do a map of the attribute @Value because there can be any number of weakly typed properties that come in a message and I have to be able to pick out the one that has CCNumber to find the right @Value attribute.
        Thanks for your help
      • February 22, 2009 at 4:28 PM #21781
        community-content

          You need to use the Logical Equals (LEq)  and Value Mapping(Flattening) (VM(f))  functoids

          If logical equals(@NAme) == CCNumber then use the value mapping to pass the value to the scrippting functiod. Do the encription

           

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.