Sharepoint Noob Sharepoint Web Services (MOSS 2007)
-
My objective is to select all workflow list items that are not "complete", pass the associated Excel workbook to a routine that will edit and post the workbook to an Access database, then update the workflow item with a "completed" status and a string of error messages passed back by the update program. Pretty simple. Wish I could do it without all this programming, but I must respect my client's environment. My client allows programmed access to its Sharepoint sites via Web Services only. I tried using Access 2007 which would have been perfect, but I get a strange intermittent failure. Since the app I need to code will run unattended, intermittent errors aren't tolerable. So, I (a vba programmer) have dived headlong into C# and SP Web Services. Honestly, Web services aren't as much a mystery as is the parsing of XML and use of C#. All the help stuff is in C#, so I need to do that... I used Jennifer Lewis' code to get the list I need to get. Did that successfully. But all she does with it is write it to the console with no formatting. I went to the Stramit CAML viewer and I can see the list I want (see XML) but how do I do what I need to do?