[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: MapXmlData question
Hi Tony.
I don't know if your sample is one file ( or a string Var containing
XML) or is two files.
Why ?
Because it's supouse that xml file are in the format
<tag1>
<tag2>
</tag2>
</tag1>
Therefore you need ONE tag that contains all other tags.
In your sample <agentIdentities> Tag repeats.
Other thing I can't figure out is how yo Parse the XML content, are
you using any CallBack Procedure un MapXmlData ?
Have you tried %xml-into opcode ?
My apologies if I couldn't help, or if I completely wrong.
Best Regards
Nicolas
[1]
Tony.Davis2@xxxxxxx escribió:
This is my first post, and as you will be able to tell, I am
inexperienced with XML and HTTPAPI. So I do not even know enough to
search for a solution first because I am not sure how to refer to the
exact definition of the XML tags. But, here is my issue. I have
successfully parsed the information that I am looking for (using
HTTPAPI of course), specifically, a number of email addresses
associated with one account (the tag is userId). The problem is that I
need to identify another name tag and associate that with each email
address.
So, how do I group information by the header tag (not sure of the
exact reference)?
That is, how do I associate the first <mobileDeviceNumber> with the
first <userId>, and the second <mobileDeviceNumber> with the second
<userId>? I do not see that they are in this same order when I receive
them using MapXmlData.
Here is an example of the XML
<agentIdentities>
<acctGUIDs>d3566f80-39b3-11de-9934-00217095b8ee</acctGUIDs>
<acctNbrHistory>6111027582601</acctNbrHistory>
<agentAccounts>
<acctGUID>d3566f80-39b3-11de-9934-00217095b8ee</acctGUID>
<acctNbr13>6111027582601</acctNbr13>
<agentCustGUIDs>3d2ea160-39ba-11de-b400-00217095b8ee</agentCustGUIDs>
<agentCustGUIDs>b5e93240-39bb-11de-b400-00217095b8ee</agentCustGUIDs>
<agentCustGUIDs>d7a238a0-43e8-11de-bb48-00217095b8ee</agentCustGUIDs>
<agentCustGUIDs>3d652b10-6c99-11de-8db9-0003baa015c2</agentCustGUIDs>
<agentCustGUIDs>fae175e0-8765-11de-85e1-00217095b8ee</agentCustGUIDs>
<companyNbr>61</companyNbr>
<divisionNbr>11</divisionNbr>
<holderCustGUID>d3874380-39b3-11de-9934-00217095b8ee</holderCustGUID>
<icomsAcctNbr>027582601</icomsAcctNbr>
<siteId>131</siteId>
</agentAccounts>
<agentAcctNbrs>6111027582601</agentAcctNbrs>
<custGUID>d7a238a0-43e8-11de-bb48-00217095b8ee</custGUID>
<disabled>false</disabled>
<firstName>Agent3</firstName>
<fullName>Agent3 Geisler</fullName>
<homePhone/>
<idmStatus/>
<lastName>Geisler</lastName>
<marketingOptOutFlag>Y</marketingOptOutFlag>
<mobileDeviceNumber>5559991212</mobileDeviceNumber>
<nickname/>
<passwordNew/>
<pin/>
<preferredContactEmail/>
<secretAnswer/>
<secretQuestion/>
<secretQuestionCode/>
<suppressPinFlag>N</suppressPinFlag>
<userDN/>
<userId>[2]agent3.geisler@xxxxxxxxxxx</userId>
<username>agent3.geisler</username>
<zipCode/>
</agentIdentities>
<agentIdentities>
<acctGUIDs>d3566f80-39b3-11de-9934-00217095b8ee</acctGUIDs>
<acctNbrHistory>6111027582601</acctNbrHistory>
<agentAccounts>
<acctGUID>d3566f80-39b3-11de-9934-00217095b8ee</acctGUID>
<acctNbr13>6111027582601</acctNbr13>
<agentCustGUIDs>3d2ea160-39ba-11de-b400-00217095b8ee</agentCustGUIDs>
<agentCustGUIDs>b5e93240-39bb-11de-b400-00217095b8ee</agentCustGUIDs>
<agentCustGUIDs>d7a238a0-43e8-11de-bb48-00217095b8ee</agentCustGUIDs>
<agentCustGUIDs>3d652b10-6c99-11de-8db9-0003baa015c2</agentCustGUIDs>
<agentCustGUIDs>fae175e0-8765-11de-85e1-00217095b8ee</agentCustGUIDs>
<companyNbr>61</companyNbr>
<divisionNbr>11</divisionNbr>
<holderCustGUID>d3874380-39b3-11de-9934-00217095b8ee</holderCustGUID>
<icomsAcctNbr>027582601</icomsAcctNbr>
<siteId>131</siteId>
</agentAccounts>
<agentAcctNbrs>6111027582601</agentAcctNbrs>
<custGUID>3d652b10-6c99-11de-8db9-0003baa015c2</custGUID>
<disabled>false</disabled>
<firstName>Agent8</firstName>
<fullName>Agent8 Geisler</fullName>
<homePhone/>
<idmStatus/>
<lastName>Geisler</lastName>
<marketingOptOutFlag>Y</marketingOptOutFlag>
<mobileDeviceNumber>1112223333</mobileDeviceNumber>
<nickname/>
<passwordNew/>
<pin/>
<preferredContactEmail/>
<secretAnswer/>
<secretQuestion/>
<secretQuestionCode/>
<suppressPinFlag>N</suppressPinFlag>
<userDN/>
<userId>[3]agent8.geisler@xxxxxxxxxxx</userId>
<username>agent8.geisler</username>
<zipCode/>
</agentIdentities>
_______________________________________________________________________
-----------------------------------------------------------------------
This is the FTPAPI mailing list. To unsubscribe, please go to:
[4]http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------
--
.::.
Nicolas Machado
Metodo Argentina S.A.
_____________________
Tel: 02262 527431
Necochea, Buenos Aires.
References
1. mailto:Tony.Davis2@xxxxxxx
2. mailto:agent3.geisler@xxxxxxxxxxx
3. mailto:agent8.geisler@xxxxxxxxxxx
4. http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------
This is the FTPAPI mailing list. To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------