topic Re: Using Rest connector to extract data from a tool in QlikView

Using Rest connector to extract data from a tool

rpavan17 — Mon, 09 Oct 2017 09:49:33 GMT

Hi,

I would like to use Rest connector to extract data from a tool. An URL was given for extraction. But, on setup i cannot see all fields available. How can i see all fields available on tool using this procedure.

Re: Using Rest connector to extract data from a tool

Peter_Cammaert — Mon, 09 Oct 2017 11:49:25 GMT

What happens when you click on the right arrow, next to the "root" object under "Objects". Does a data hierarchy pop out?

Re: Using Rest connector to extract data from a tool

rpavan17 — Mon, 09 Oct 2017 11:54:09 GMT

It looks as above

Re: Using Rest connector to extract data from a tool

Peter_Cammaert — Mon, 09 Oct 2017 11:55:37 GMT

If you now click on the "issues" object, do you get the fields you need?

Re: Using Rest connector to extract data from a tool

Peter_Cammaert — Mon, 09 Oct 2017 11:57:08 GMT

BTW JSON is not xml...

Re: Using Rest connector to extract data from a tool

rpavan17 — Mon, 09 Oct 2017 11:58:11 GMT

It shows what ever is available in fields(Right side as above picture).. but these are not the fields.

Re: Using Rest connector to extract data from a tool

Peter_Cammaert — Mon, 09 Oct 2017 12:00:42 GMT

Are you sure you can extract data from your tool using JSON and the Rest Connector?

Re: Using Rest connector to extract data from a tool

Peter_Cammaert — Mon, 09 Oct 2017 12:01:58 GMT

If you launch a browser and enter the URL that was given to you in the address bar, then what do you get?

Re: Using Rest connector to extract data from a tool

rpavan17 — Mon, 09 Oct 2017 12:03:06 GMT

Yes, it extracted by giving SQL Query in RestConnector Master table. There are some fields. I am trying to add new fields. But, as per my understanding it should fetch the fields available on the tool using Restconnector..

Re: Using Rest connector to extract data from a tool

rpavan17 — Mon, 09 Oct 2017 12:04:53 GMT

In the above code Load etc.., specifically given the field names from backend and then it extracted the fields respectively. But, i am trying to see all the available fields by using this rest connector.

Re: Using Rest connector to extract data from a tool

Peter_Cammaert — Mon, 09 Oct 2017 12:26:52 GMT

If you launch a browser and enter the URL that was given to you in the address bar, then what do you get?

Re: Using Rest connector to extract data from a tool

rpavan17 — Mon, 09 Oct 2017 13:06:45 GMT

I have tried that earlier, I would get what was there in fields startat,max results...etc..,

As I have told earlier, based on gives criteria the ffields are extracted..

Re: Using Rest connector to extract data from a tool

Peter_Cammaert — Mon, 09 Oct 2017 13:15:23 GMT

Then you have to obtain all criteria and enter them in the respective Query fields before you can request any actual JSON data. Some Web services have an interface that lets you investigate the data structures, but not all of them. There is no Query Assembly wizard like there is in the RDBMS SQL wizard.

Re: Using Rest connector to extract data from a tool

rpavan17 — Tue, 10 Oct 2017 06:51:05 GMT

Hi,

Thanks for the answer.

I am not allowed to see the data structure so it is difficult for me to get the query. Hence, i am trying to see all the fields available. Is there any alternate method available?