Hey folks,
Any suggestions for how to parse the XML payload from ShopperTrak's REST endpoint obtained via the REST API Modular Input?
Link to full payload: https://gist.github.com/yorokobi/2b8...
See more...
Hey folks,
Any suggestions for how to parse the XML payload from ShopperTrak's REST endpoint obtained via the REST API Modular Input?
Link to full payload: https://gist.github.com/yorokobi/2b8f1004be5b6142eaf05a1670bb1b8c (I tried enabling soft wrapping, but it didn't take.)
Pretty (and smaller) sample (use the gist for your own testing):
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<sites>
<site storeID="1319">
<traffic exits="13" enters="25" startTime="201608251030"/>
<traffic exits="15" enters="13" startTime="201608251045"/>
<traffic exits="16" enters="11" startTime="201608251100"/>
</site>
<site storeID="1455">
<traffic exits="14" enters="26" startTime="201608251030"/>
<traffic exits="30" enters="21" startTime="201608251045"/>
<traffic exits="19" enters="17" startTime="201608251100"/>
</site>
<site storeID="2161">
<traffic exits="32" enters="29" startTime="201608251330"/>
<traffic exits="33" enters="35" startTime="201608251345"/>
<traffic code="01" exits="" enters="" startTime="201608251400"/>
</site>
<site storeID="0486">
<traffic exits="16" enters="17" startTime="201608251130"/>
<traffic exits="13" enters="17" startTime="201608251145"/>
<traffic exits="30" enters="21" startTime="201608251200"/>
</site>
<site storeID="2503">
<traffic exits="3" enters="2" startTime="201608251230"/>
<traffic exits="1" enters="4" startTime="201608251245"/>
<traffic exits="4" enters="0" startTime="201608251300"/>
</site>
<site storeID="2162">
<traffic exits="14" enters="18" startTime="201608251330"/>
<traffic exits="19" enters="22" startTime="201608251345"/>
<traffic exits="18" enters="12" startTime="201608251400"/>
</site>
<site storeID="2561">
<traffic exits="5" enters="5" startTime="201608251330"/>
<traffic exits="8" enters="8" startTime="201608251345"/>
<traffic exits="3" enters="3" startTime="201608251400"/>
</site>
<site storeID="1647">
<traffic exits="16" enters="12" startTime="201608251230"/>
<traffic exits="8" enters="9" startTime="201608251245"/>
<traffic code="02" exits="" enters="" startTime="201608251300"/>
</site>
<site storeID="0436">
<traffic exits="20" enters="11" startTime="201608251230"/>
<traffic exits="21" enters="20" startTime="201608251245"/>
<traffic exits="22" enters="23" startTime="201608251300"/>
</site>
<site storeID="1751">
<traffic exits="16" enters="9" startTime="201608251330"/>
<traffic exits="15" enters="5" startTime="201608251345"/>
<traffic exits="7" enters="12" startTime="201608251400"/>
</site>
<site storeID="1438">
<traffic exits="18" enters="13" startTime="201608251330"/>
<traffic exits="14" enters="11" startTime="201608251345"/>
<traffic exits="12" enters="10" startTime="201608251400"/>
</site>
<site storeID="2029">
<traffic exits="15" enters="19" startTime="201608251030"/>
<traffic exits="23" enters="15" startTime="201608251045"/>
<traffic exits="16" enters="18" startTime="201608251100"/>
</site>
<site storeID="0471">
<traffic exits="19" enters="16" startTime="201608251230"/>
<traffic exits="25" enters="15" startTime="201608251245"/>
<traffic code="01" exits="" enters="" startTime="201608251300"/>
</site>
</xml>
I have played with the following props.conf entries with pretty much zero success (not necessarily all at the same time--I haven't kept a running record).
SHOULD_LINEMERGE=false
BREAK_ONLY_BEFORE=<site\s
KV_MODE=xml
LINE_BREAKER=(<\/site>)
My attempts at using |xpath or |rex max_match=0 have likewise yielded less than stellar results.
What I need is a method of correctly tying storeID with exits, enters, startTime, and code when it shows up.
Thanks in advance.