The problem I am trying to solve is to determine if there is a specific word document in a specific folder located in the "Project Documents" library of a SharePoint 2016 site. My site structure would be something like this: //server/sitename/project documents/folderA/. Within the folderA, I need to know if there is a document called "status report." These would all be on Alternate Sites than from where the workflow runs.
Using a "Call Web Service" "sitedata.asmx" method, I am able to see the content on the site "//server/sitename/". The content is stored in a collection variable which I then loop through (for each) to see if there is an item called "Project Documents" and I find one. Then I use a Query List (CAML editor) to retrieve the contents of the Project Documents library. I am able to find the Status Report folder within the Project Documents library, but I am not able to figure out how to get the contents of that specific "Status Report" folder. I have tried a few different Query List options. I am clueless when it comes to Soap, Web Service Calls, etc. I used the documentation (found here) created by Palesa Sikwane as a "template."
Any help would be greatly appreciated as I have been working on this for a couple of days.