REST Connector: How can I make GET request with the similar names of parameters?

[Anonymous]

Hi, guys.

I should tune connector for making GET request with the similar parameters. For ex, url:

https://example.com/GetCases?ExportFields=CaseType&ExportFields=CaseID&ExportFields=Status

But connector can not do it. He simplify url and delete extra 'ExportFields' names.

Please, help me to resolve this issue.

--

Regards,

Anton I.

[Anonymous]

Hello Anton,

Can you try to define variable and set it inside your URL. I hope it helps you.

some thing like $(ExportFields) or Let vExportFields=....

[Anonymous]

Hi, Sandeep Roy.

Thank you for the answer.

I tried to do the following:

Let vExportFields="ExpostFields=CaseID&ExportFields=Position";

WITH CONNECTION(Url "https://example.com/GetCases?$(ExportFields)");

but I did not reach my goal. Connector still doesn't want to make request with the similar names of fields.

Maybe you know other way for doing it?

[Anonymous]

Hi Anton,

Then I can suggest only to check with your API or URL description.

If you are passing single parameters with many values then it better send to send like this which I tried. Upto CaseID it is taking...

https://example.com/GetCases?ExportFields=CaseType,CaseID

[t_chetirbok]

I agree with Sandeep.

Usually when we use an API call and want to write the list of fields for displaying, we have it like ExportFields=CaseType, CaseId.

But definitely you should check your API.

For example, I used parameter sysparm_fields=sys_id%2Cservice%2Csys_created_on

As you can see instead of comma (,) I have to use %2C

​Hope it'll help.

[Anonymous]

Hi, Roy.

No, it does not work.

GET request allows to send array of values in the same way as I do, but connector of Qlik does not support it.

[Anonymous]

Hi, Tatsiana.

Thank you for the your comment, but our API does not support such syntaxis. It will not help me.

[t_chetirbok]

As I know it doesn't depend on qlik rest connector.

Does your url work not in qlik? Let say in powershell?

Do you use qvrestconnector?

[Anonymous]

))) Yes, It depends on qlik rest connector.

Our URL works greate everywere except QV.

We do not use powershell. Usually our clients make request to API from code, and it is work greate. Also we use Fiddler program for checking API, and also it works perfect. But QV modifies outgoing URL and makes situation when it is not possible to make request. It is very big problem for QW, because specification of GET requests allows to make requests with the similar parameters