How to Retrieve all the records for v_ws_editor table or all transform map data?

[rahulj]

Does anyone know how to get all the transform map records by hitting the v_ws_editor.do ...url (https://instance-name.service-now.com/v_ws_editor.do?JSONv2) same like in the case of sys_db_object(https://instance-name.service-now.com/sys_db_object?JSONv2) to get all the records ?Is there any access rights or permissions need to set in order to access all records from v_ws_editor.do ?As right now I am getting only one record using v_ws_editor.do ...Please help!!

[Mike Allen]

The transform map table is sys_transform_map.   It has a structure that is recognizable.   I have never been able to get a list of inbound web services through the v_ws_editor table.   Maybe you can create a separate table and add a business rule that writes to that table after you create an inbound web service.

[rahulj]

Thanks Mike for the information.

Actually Mike,I have a list of inbound web services with transform map,so I have to retreive all.Currently am able to get only the latest one inbound web service on which I clicks in ServiceNow instead of all.As u see in image I clicked on Incident_Table & get that JSON response only not for all IncidentSLA,Incident etc.

Any suggestions ?How it can be possible ? Have a look on the image,Hope it helps.

[Mike Allen]

I think that is the way the system works.   Even in the UI, going to v_ws_editor_list.do shows only a single record.

[rahulj]

Right Mike....While using the sys_db_object_list.do in UI shows the list of all unlike v_ws_editor_list.do showing only one record. Is there any solution or a way to retrieve all or one by one for v_ws_editor_list.do?

Thanks