Using Rest connector to extract data from a tool

[rpavan17]

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.

[Peter_Cammaert]

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

[rpavan17]

It looks as above

[Peter_Cammaert]

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

[Peter_Cammaert]

BTW JSON is not xml...

[rpavan17]

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

[Peter_Cammaert]

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

[Peter_Cammaert]

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

[rpavan17]

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..

[rpavan17]

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.