topic Re: REST: Handle non-ascii character in header in Connectivity & Data Prep

REST: Handle non-ascii character in header

AJZ — Mon, 06 May 2024 13:49:04 GMT

Hi!

I have a problem with the REST connector where the authorization is set in the query header parameter.

I get the error message Failed to connect to server Request headers must contain only ASCII characters. because there is the character å in the header.

It works in Postman but not in Qlik. I have tried to change å to be html-encoded (both %C3%A5 and %E5) but it doesn't work.

Is there a way around this or should we just change the header parameter to not contain this character?

Best Regrads,
Adam J.

Re: REST: Handle non-ascii character in header

williejacobs — Thu, 16 May 2024 08:40:06 GMT

Hi Adam,

I suggest you run you query with the "With Connection" option and then create your header as a variable.

eg.
Let zHeader = 'somedata'&Chr(229)

apiData:
Select *
FROM JSON (wrap on) "root"
With Connection
(URL "https://api.com",
HTTPHEADER "zHeader"
);

Re: REST: Handle non-ascii character in header

AJZ — Thu, 16 May 2024 10:27:40 GMT

Thanks for your reply, I tried it and it didn't work but we changed the parameter so it's working now!

/Adam J.