REST: Handle non-ascii character in header

[AJZ]

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.

[williejacobs]

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"
);

[AJZ · Accepted solution]

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

/Adam J.