How to pass multiple parameters(column name like assignto, resolved by, state etc) to JSON service URL

[mahajanrahuld]

In my application i am getting all service now data in string format and i am taking that data into data table. I want to pass column names as input parameter to JSON service URL. For example Assign TO, Resolved By etc. if i pass this 2 column names as parameter to service then i want only this column data.

Query   should be work like select statment

select column1,column2,column3 from test

How to get selected columns data from service now api.

Thanks

[srinivasthelu]

Hi Rahul

sysparm_fields??

Please check this out Table API retrieve options

Thanks

Srini

[mahajanrahuld]

No not working getting all records

My URL like this

https://community.servicenow.com/incident.do?JSONv2&sysparam_action=getRecords&sysparam_fields=serve...

I want to get only selected column data using above JSON URL. It's urgent,

Thanks

Rahul

[srinivasthelu]

Hi Rahul,

Have you tried this?

https://[InstanceName].service-now.com/api/now/v1/table/incident?sysparm_fields=number,location,loca...

Thanks

Srini

[mahajanrahuld]

yes but not working