topic Re: Connector REST API error in Data Movement & Streaming

Connector REST API error

fabiokroker — Wed, 19 Mar 2025 21:46:28 GMT

I have been using the Qlik Cloud Rest Connector to connect to the Brazilian Central Bank PTAX API for some time without issues. However, recently, the connection stopped working unexpectedly, and I am now getting the following error:

HTTP protocol error 400 (Bad Request): { "codigo": 400, "mensagem": "Cannot find EntitySet, Singleton, ActionImport or FunctionImport with name 'v1'." }

Here is the URL request: "https://olinda.bcb.gov.br/olinda/servico/PTAX/versao/v1/odata/CotacaoMoedaPeriodo(moeda=@moeda,dataInicial=@dataInicial,dataFinalCotacao=@dataFinalCotacao)?@moeda='EUR'&@dataInicial='01-01-2025'&@dataFinalCotacao='01-27-2025'&$top=100&$format=json".

I tested the OData Connector in Qlik Cloud, and it successfully connects to the Brazilian Central Bank PTAX API. However, I need to use the REST Connector instead because I require WITH CONNECTION to dynamically modify the URL parameters.

The same API works in Postman, cURL, and the browser, but Qlik Cloud fails.

Re: Connector REST API error

marksouzacosta — Thu, 13 Feb 2025 20:29:24 GMT

Funny thing is, it works on Qlik Sense on-prem but not on Qlik Cloud....

Re: Connector REST API error

fabiokroker — Thu, 13 Feb 2025 20:36:58 GMT

Tried it on Qlik Sense Desktop, Postman, Browser, and everything works, except for Qlik Cloud, which got me even more curious.

Re: Connector REST API error

dmnab1 — Thu, 13 Feb 2025 23:59:42 GMT

Hi, I'm experiencing the same issue. The REST connection that was working fine until yesterday suddenly stopped functioning. I noticed there was a release yesterday, which I believe may be the cause.

https://community.qlik.com/t5/Release-Notes/tkb-p/ReleaseNotes/label-name/saas?labels=saas

I receive the error: 'Please adjust your API-endpoint settings.' However, the same request works perfectly in Postman, Qlik Enterprise on-premise, and cURL.

I hope someone from Qlik can provide some insights on this

Re: Connector REST API error

fabiokroker — Fri, 14 Feb 2025 12:26:58 GMT

I believe the issue is also related to the new version, but I couldn't find anything in the release notes specifically mentioning changes to REST or OData connections. This is quite curious, especially since the same requests work fine in other tools like Postman and Qlik Sense Desktop.
If anyone finds more details or manages to get in touch with Qlik support regarding this, I would greatly appreciate any updates.

Re: Connector REST API error

dmnab1 — Fri, 14 Feb 2025 12:30:22 GMT

Hi Fabio,
Yes, I also think this is an issue related to the last release (Feb 12).
I submitted a ticket in Qlik, I will let you know once I have a reply
Best

Re: Connector REST API error

dmnab1 — Fri, 14 Feb 2025 16:04:09 GMT

Fabio, the Qlik developers fixed this issue and it's working again for me.

Re: Connector REST API error

marksouzacosta — Fri, 14 Feb 2025 16:13:15 GMT

Tested here and it is working on my side too.

Re: Connector REST API error

fabiokroker — Fri, 14 Feb 2025 17:37:00 GMT

Nice, Dmnab1.

Thanks for your support!