Topic Options
#57679 - 09/15/20 01:20 PM Looking for the total number of XML records
ricks Offline
OL User

Registered: 04/17/10
Posts: 100
Loc: Seattle
Is there a way while in Design to know how many XML records are in the file being processed by Watch?

Ideally, we would not need to capture this in a Watch process and then use it in the Design, but that could be done. We do near zero stuff with Metadata so that would be possible with help in setting it up, but again it would add a Metadata step to the Workflow which is not ideal.

Our XML structure looks similar to this:

<TABLE>
<INVOICE>
<PP_DIR_OUTPUT>\\PPWATCH1\P\STMT\DAILYNOTICES\0908</PP_DIR_OUTPUT>
<PP_DOCUMENT>DAILYNOTICES</PP_DOCUMENT>
<PP_BRANCH>MICR</PP_BRANCH>
<PP_NUP>1</PP_NUP>
<O_TYPE>C</O_TYPE>
<O_PATH>p:\\stmt\dailynotices\0908\</O_PATH>
<O_PDF>CHECKS_090820.PDF</O_PDF>
<O_TOTPDFS>46</O_TOTPDFS>
<O_PDF_PGNO>6</O_PDF_PGNO>
<ACCTNO>00006778</ACCTNO>
<CHECKNO>000</CHECKNO>
<NEWPDFNAME>DN-Chk_01082B5MNN8GSD9.pdf</NEWPDFNAME>
<PKGBM></PKGBM>
<CTNBM></CTNBM>
<IMBTRACK>85793208</IMBTRACK>
</INVOICE>
</TABLE>


I want the count of the <INVOICE> tags.

Thoughts?

Top
#57680 - 09/15/20 02:44 PM Re: Looking for the total number of XML records [Re: ricks]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 650
Loc: Québec, Canada
I've quickly looked on the web and found this.

You could then pass that variable to the form in Workflow.
_________________________
♪♫♪♫
99 frigging bugs in my code
99 frigging bugs
Take one down
Code around
127 frigging bugs in my code
♪♫♪♫

Top
#57682 - 09/15/20 04:57 PM Re: Looking for the total number of XML records [Re: Jean-Cédric]
ricks Offline
OL User

Registered: 04/17/10
Posts: 100
Loc: Seattle
Thanks for that idea.

If we are willing to do it with Metadata- can that accomplish this and if so, what would we do to get that value?D7y8

Top