API Call on Database View

[stevenm]

I have created a database view which works really well in a report.  Linking together the sc_req_item, sc_item_option_mtom, and sc_item_option tables in an effort to see RITMs and the values entered in their variables.  

I have a request to try to create a web page to report on this database view but I can't get it to work.  My rest call looks like this: <cfhttp method="get" url="https://instance.service-now.com/api/now/table/{databaseviewname}?sysparm_query=sys_updated_by=k9999..." result="theResult" username="xxxx" password="xxxxxxxxx">

You can see I only get a strange sys_id returned without a value field.  The value field is listed in the default list view of the database view. What am I missing?

[stevenm · Accepted solution]

Never mind.  Once I found the REST API Explorer it helped me figure this out.

[amu00001]

Can you please provide the OOB API you have use.