Grouping in XML query
Jonathan Lee asked 8 years ago
Normal
0
false
false
false
EN-US
X-NONE
X-NONE
MicrosoftInternetExplorer4
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman",serif;}
I’m getting some unexpected results with my XML maps and I was hoping for someone to shed some light. I have two maps, one that retrieves SQL data (parent/child – sales order/line items) from Dynamics GP and saves to an XML file. The second map has an XML query as its source and updates data in Salesforce. The problem I am having is that the second map is not properly grouping the parent/child elements and returns two lines, one with the parent data and one line item and then the second line item but with the parent rows blank.
I haven’t been able to figure out if this issue is cause by the output formatting of the XML (changing grouping options in the XML destination seems to have no effect on the output) or if I need to be doing something different with the input of the second map (not really any options here). Changing the destination grouping options seems to have little effect.
Gracias, any help is much appreciated.
Johnathan, it’s hard to see what the XML output should be with this and what your expected output would be. Can you add a link to the XML files and a screen shot of your destination mapping?
lorren
Thanks for the response Lorren. I managed to figure this out. It had to do with how the child objects were nested. My initial attempts had a hierarchy of…
Being more explicit with the formatting allowed SmartConnect to properly parse the XML query…
Regards,
-jl-
P.S. I apologize for the extra garbage CSS stuff in my initial post. I was originally preparing this as an email. If there is any way to clean that up, it is much appreciated. Thanks again.