Hello everyone, I'm running into a really strange issue and could really use some help.
I'm using MS Access to make an API Call in order to sync data to a website. The API URL includes a lot of parameters and tends to get very lengthy.
90% of the time, the API Call works fine, and the data gets posted to the website, however there are a handful of times when it fails, and I've only found one way to fix the issue:
When I 'Debug.Print' the URL, it appears as one long, solid string of text, with no line breaks. However, when I copy/paste the URL into another program, such as MS Word or DreamWeaver, there are about 5 or 6 random line breaks, throughout the URL, that shouldn't be there. If I manually delete those line breaks (while in MS Word), and then copy/paste that corrected URL into the address bar on my browser window, the API Call goes through successfully.
I have no idea why these line breaks are being created (they're not a part of the data that I'm trying to post), but I think they are breaking my API Call.
Does anyone have any idea what's going on here?
Thanks in advance!
DJS