JSON Reader "Malformed escape pair" error

KNIME Analytics Platform
1

I’m using JSON reader to get results from an API call. I have it iterate through a number of different calls, and on one of them, I’m getting this error:

ERROR JSON Reader  Execute failed: Malformed escape pair at index 96: http://api.serpstack.com/search?access_key=[secretkey]&query=chicago+intext%3%22Areavibes%22+-inurl%3Areavibes+-%22Bay%20Area%22&engine=google&location=United+States&google_domain=google.com&gl=us&hl=en&page=1&num=100&output=json

When I put the api call directly into Chrome’s browser, it seems to work just fine. Here’s the text file that I get as an output. I’ve copied it from my browser and saved it as a txt file:

API Call with Error.txt (37.2 KB)

Any ideas what’s going wrong here?

2

I figured it out. I was using a string manipulator to convert special characters into a readable URL, and I was converting my colon character to “%3” instead of “%3A”. Once I fixed that, it worked beautifully!

3 Likes
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.