We're looking around at various solutions that would help us automate data entry into a desktop point of sale (POS) application on Windows. Before I go too deeply down the rabbit hole, I wanted to ask the community for a quick sanity check whether what we'd like to do is even feasible.
We have a SharePoint list with each row containing fields that need to be entered into a form in our POS application.
We were wondering if we could use PAD to iterate over each row of the SP list directly, to grab the field values and enter them into our POS app? I can't seem to find any examples of iterating over a native SharePoint list - I see lots of examples using Excel though.
Am I SOL? Or do we have to rely on some awful scraping strategy to grab the data out of the SharePoint list table html?
Any suggestions or advice appreciated, thanks!
Bob