This is a little different than my usual email, but just decided to decompress from what I was working on today before heading into the weekend.
I worked on a couple interesting things today:
- A Launcher app using a class object to authenticate and connect to a client’s 365 Sharepoint tenant.
The routine started failing. It was very difficult to get to the debug message because I’m using WinHTTP and XML objects to access the O365 REST API. The difficulty was in the fact that I needed to review the HTML returned from the WinHTTP request and it overflowed my debug window and wouldn’t allow a simple copy/paste from the variable watcher to a notepad. It also cut off the text after a certain number of characters.
Eventually I loaded my library (which wasn’t in this skeleton app to reduce unneeded extra files for the deployment) and used my QuickWrite file function to write the strings to a text file where I could look at them.
I ended up uploading the file to CoPilot along with my code module to get a quick analysis of the issue which was using the legacy login process. So now I’ll be updating it to OAuth2 authentication (unless the client decides they will just disable the policy and allow legacy logins – but who knows how long that would work…) - Another interesting task was working on a combo box rowsource SQL statement and adding multiple categories of items from different tables using lots of UNION ALLs to create labels and join together the different table data. I got the basic query working and now need to finish it off by de-duplicating the unneccessary rows that show up in multiple sections.
What interesting projects have you been working on?