Hi Tony,


I did follow all the steps defined above.



Here is the query I am using:





select * from OPENQUERY(SERVICENOW,'select [label],element,dependent_value,[hint],language,cast(sequence as int),sys_id,value from sys_choice order by [label] asc')



I am getting correct data for only 'label' column. All other columns show up as NULL, though they have data in them.