We are trying to post an invoice to an AP's customer portal, but first we need to verify that the information on the invoice matches the PO info on the portal. The element that we want to match is the unit price. The portal has a table format, but the information doesn't translate to a collection in a workable way. Because of this we then went to try to read the unit prices one by one by using dynamic HTML paths and introducing a counter. The element is not found when trying to read even though in App modeler is set to dynamic and it highlights. Things we tried:
1. We made sure the counter data item was Text so the path is Text+Text+Text
2. We tried inputting the dynamic path into app modeler itself, but that made the item unidentifiable. We suspect it is because app modeler doesn't recognize the data item as it is not following the script logic.
3. We tried exporting the main table into a collection as mentioned, but the data is not workable in this way.
4. We tried to use the Trim function as well to eliminate any possible spaces.
Trim("/HTML/BODY(1)/DIV(5)/DIV(1)/DIV(3)/DIV(1)/DIV(1)/DIV(1)/DIV(1)/DIV(2)/TABLE(1)/TBODY(1)/TR(1)/TD(1)/FORM(1)/TABLE(1)/TBODY(3)/TR(4)/TD(1)/TABLE(1)/TBODY(1)/TR("&[TR Count]&")/TD(10)")
Any help would be appreciated.
Lourdes Urena
Sr Solutions Engineering
Grainger Panama Services
Panama
