Have you ever needed a way to debug a KingswaySoft object via Visual Studio when dealing with obscure errors from objects that interact with third party cloud services such as Box.com, HubSpot, Dynamics 365, and many others currently in KingswaySoft’s Ultimate Edition catalog? Well, you are in luck as I just had to setup that exact scenario when debugging 500, 501, 502, and 503 errors from Box’s API. So I’ll quickly walk you through how to setup Fiddler in order to monitor HTTPS traffic sent from KingswaySoft’s various Connection Manager objects used in SQL Server Data Tools (SSDT) for Visual Studio 2017/2019.
Tools:
- Microsoft Visual Studio 2017/2019
- SQL Server Data Tools (SSDT) for Visual Studio (Latest Version)
- KingswaySoft SSIS Ultimate Toolkit (Latest Version)
- Fiddler (Latest Version)
Fiddler Installation and Configuration
First you’ll need to download and install the latest version of Fiddler. Once you have done that you’ll need to open up Fiddler and configure the HTTPS traffic. Make sure and check Decrypt HTTPS Traffic in Fiddler’s options menu. You’ll also need to export and trust the root certificate in order to capture HTTPS traffic. Finally, go to the file menu and make sure the Capture Traffic is unchecked.
- Configure Fiddler to Decrypt HTTPS Traffic (Telerik Docs)
- Configure Windows Client to trust Fiddler Root Certificate (Telerik Docs)
SQL Server Data Tools (SSDT) for Visual Studio and KingswaySoft
Once you have created your Visual Studio 2017/2019 SSDT project and have included a KingswaySoft Connection Manager object that plugs into a third party online API such as HubSpot, Box.com, Dropbox, Google Drive, Microsoft Dynamics 365, to name a few, then open the Connection Manager that you would like to monitor using Fiddler and select the Advanced Settings (if available), followed by selecting Manual for the Proxy Mode. Then type in the IP 127.0.0.1 with a port of 8888 and click OK. An example KingswaySoft Connection Manager object is shown below.
After that you can run your SQL Server Data Tools (SSDT) for Visual Studio project and watch Fiddler capture all the communication traffic.
Fiddler Input Example
GET https://api.box.com/2.0/folders/[SOME_FOLDER]?limit=250&filter=name,type,id&fields=name,id,type,item_collection,description,item_status,owned_by,parent,tags HTTP/1.1 Accept: application/json Content-Type: application/json Authorization: Bearer [THE_TOKEN] Host: api.box.com Accept-Encoding: gzip, deflate
Fiddler Output Error Example
HTTP/1.1 503 Service Unavailable Date: Fri, 1 Nov 2019 18:16:33 GMT Content-Type: text/html Connection: keep-alive Cache-Control: no-cache Strict-Transport-Security: max-age=31536000 Content-Length: 107 <html><body> <h1>503 Service Unavailable</h1> No server is available to handle this request. </body></html>
Hope that helps!
Therapy in Code 