Pass Through XML in Data Mapper

David Paras

• April 20, 2015 16:11

I have a need to pass through XML formatted data using the data mapper. I can manually edit the XLS to use Copy-of instead of using Value-of and this works in most cases (does not work with map to Context Variable). However, I cannot find any option to use Copy-of in the data mapper interface itself. Can you provide any assistance on how I would add something like:

<xsl:copy-of select="." />

to the data mapper?

0

• 

  David Paras

  • April 20, 2015 16:11

  There's two possible options for you -

  A) Context variable
  - Use a context target to store the web service response in a context variable (parametername)
  - In the data mapper use a dummy source and use context.get (global) function to obtain the context variable containing your xml web service response
  - Map that context.get result to the target field of your database schema

  B) Custom XSL
  - On the target node where you want to map the xml data, right click and select custom XSL before
  - In the window, insert the custom xsl containing your "copy-of"

  i.e.
  
  <firstname>
  <xsl:copy-of select="e:SubmitOrderResponse/e:SubmitOrderResult/*"/>
  </firstname>
  - save it and test it out in the debugger

  0

Post is closed for comments.