JiwaAPI

dm_exec_sessionsRequest

The following routes are available for this service:
GET	/dm_exec_sessions	Retrieves a results of the query SELECT * FROM sys.dm_exec_sessions

To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

GET /dm_exec_sessions HTTP/1.1 
Host: apitrain.galipo.com.au 
Accept: application/xml

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<ArrayOfdm_exec_sessionsResponse xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel">
  <dm_exec_sessionsResponse>
    <_x003C_client_interface_name_x003E_k__BackingField>String</_x003C_client_interface_name_x003E_k__BackingField>
    <_x003C_client_version_x003E_k__BackingField>0</_x003C_client_version_x003E_k__BackingField>
    <_x003C_host_name_x003E_k__BackingField>String</_x003C_host_name_x003E_k__BackingField>
    <_x003C_host_process_id_x003E_k__BackingField>0</_x003C_host_process_id_x003E_k__BackingField>
    <_x003C_login_name_x003E_k__BackingField>String</_x003C_login_name_x003E_k__BackingField>
    <_x003C_login_time_x003E_k__BackingField>0001-01-01T00:00:00</_x003C_login_time_x003E_k__BackingField>
    <_x003C_nt_domain_x003E_k__BackingField>String</_x003C_nt_domain_x003E_k__BackingField>
    <_x003C_nt_user_name_x003E_k__BackingField>String</_x003C_nt_user_name_x003E_k__BackingField>
    <_x003C_program_name_x003E_k__BackingField>String</_x003C_program_name_x003E_k__BackingField>
    <_x003C_session_id_x003E_k__BackingField>0</_x003C_session_id_x003E_k__BackingField>
    <_x003C_status_x003E_k__BackingField>String</_x003C_status_x003E_k__BackingField>
  </dm_exec_sessionsResponse>
</ArrayOfdm_exec_sessionsResponse>