ManagedEngine ServiceDesk Plus (Zoho) Connector
ManagedEngine ServiceDesk Plus (Zoho) Connector Help
Version 1
ZappySys Logo File Version: v1
Supported Engine: 4

ManagedEngine ServiceDesk Plus (Zoho) Connector - Source Code


<?xml version="1.0" encoding="utf-8"?>
<ApiConfig Name="ManagedEngine ServiceDesk Plus (Zoho)"
  EngineVersion="4"
  Version="1"
  Id="127BCF33-ED5C-43F1-ABC7-3528E70EA13A"
	Slug="zoho-managedengine-service-desk-plus-connector"
	Desc="ManagedEngine (Zoho) ServiceDesk Plus Connector can be used to integrate ServiceDesk Plus data in your App / BI Tools. You can read/write Requests, Tasks, Comments, Worklogs and many other items."
	HelpLink="https://www.manageengine.com/products/service-desk/sdpod-v3-api/index.html"
  Logo="data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEAYABgAAD/4QB2RXhpZgAATU0AKgAAAAgABgExAAIAAAAQAAAAVgMBAAUAAAABAAAAZgMDAAEAAAABAAAAAFEQAAEAAAABAQAAAFERAAQAAAABAAAOw1ESAAQAAAABAAAOwwAAAABwYWludC5uZXQgNC4xLjYAAAGGoAAAsY//2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACWAJYDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iiigAooooAKgurlrdMpbT3DnpHEBk/ixCj8SKW5urezhM11PFBEOryOFH5muYv/AIj+HbJyiXEt0wOD9njyB+JwD+BNHMluZVa1OmvfkkW7zVvEhUjT/DXJHDXV5GuP+AqTn8xXPXmrfElAxXQ7NVHeIq5/LzM/pSyfFrTh/qtNum/3mVf8aSP4taeT+90y6X/dZW/wrWGJhH7K/H/M8+eKw8n/ABmv69DnL3xv4508F72BrZAeslntX8yKjh+K/iBPvxWMv1iYfyau7sviR4cvW8uWaW1LcYuIuD+IyB+OKfe+EPCvie3M9vHArZx9osXUc++PlP4iuuni8NLSdNfIy9lVmr4evzfM57T/AIvwMAupaXIh7vbuGB/4C2Mfma7XR/FOi66FFhfRvKR/qW+WQevynn8uK8l8R/DnVtED3Fr/AKdZjnfGvzoP9pf6jP4VxysVZXRiGByrA8g+tdX1LD1o81J2MP7QxWHly1lc+o6AQRkcg14t4Z+JmoaWyW2q776z6byf3qfifvD2PPv2r1W0vYNVsk1DR7qOVH7fwse4I6q36+teVi6FXDauN15Hs4XFUsSvddn2ZqUVUtdQjuWMTAxTrw0bdfw9at1zUq0Kseam7o6pRcXZhRRRWhIUUUUAFFFQXl5b6fZy3d3KsUES7ndugH+e1Am0ldkskiRRtJI6pGgLMzHAAHUk15v4k+J6xM9roSK7DIN1IPl/4Cvf6nj2NQ3Q174jXG23VrDQVb5Xk/5aYPUj+I98dB655rqNH8A6FpK5a2F5N3kuQG/Jeg/LPvWbcpbHm1KmIxOlD3Y/zPr6HkLrrviSY3DR3uoOCRvCM4X2GOB9BVyHwL4mnUMmkSgH+/IiH8mYV7lc3dnp1t5t1cQW0C8bpHCKPbmueu/iN4Us22vq6SN/0xjeQfmoI/WpcEt2Klw9Ks7+9J+S/wCHPLpvAvieBSz6RKQP7kiOfyVjWVd6TqNgm+8sLmBf70sTKPzIr1gfFfwqWwbi6A/vG2fH8q0bT4g+FL47Y9YhQ9CJ0aL/ANDAFLlj0ZpV4WqxV1GS+V/0R4VVizvrvT5/Ps7mW3l/vRsVJ9j6ivbrzwn4Z8Q23nR29vh+VuLNguffK8H8c1wOvfDTUtODz6a/263HOwDEqj6dG/Dn2ocGjxK+V4mg+aOtu25peHvii6stvr0YZOB9qiXke7KOv4flV/xT4EsPEVqdX0B4RdON+2Nh5Vx689A3v09fWvJ2VkdkdSrKcMpGCD6VveF/Fd74au8xky2bt++tyeD7j0bHf861oYmdGXNFjo49TXssVqu/VHNTQyW8zwzRtHLGxV0YYKkdQRWv4b8TX3hnUBcWrF4WOJrdj8sg/ofQ/wBMivRvFnh+y8aaKmv6IQ94qZIUcygDlGH98dvy9MeQEEEgggjqDX01CtTxVPX5ozrUp4WopRem6Z9CRXFn4m0mLVNMky+OOzAjqrehH+eDVjTdV8xhb3RxJ0Vj39j71414H8Uv4b1hRK5/s+4IW4Xsvo49x/LPtXrms2ifLeQ4aOTG4ryOeh/H/PWvis7wVXLqv1vD7faXRr/Nd/n3PrcrxkMbS9nU3X4f8BnQUVkaRqRmAt5mzIB8jH+If41r10YXFU8VSVWnt+Xka1KcqcuWQUUUV0mYhIVSzEAAZJPauXbT28XXsd3ehhokDbrW3P8Ay9N/z1b/AGP7o7jnocHoLy2+2R/Z5P8AUN/rR/fH936Hv7cd6h1nWLLQdLm1C+kCQxjgDq57Ko7k0n5kOi60lC1/LuPvb+w0XT2ubyaK1tIVxk8ADsAB19gK8n8R/Fu8ume30GL7LBjH2mVQZG9wOi/jk/SuQ8UeKr/xTqJuLpikCH9xbKfljH9W9T/TineH/But+JCGsbXbbnrczHZH+B/i/AH3rCVRydon2GEymhhYe1xTV/PZf5mPd3lzf3H2i8uJribGPMmcu35moa9l0n4PabDGjatez3UvVkh/dp9O7H65FdZaeC/DVlGqQ6JZEDoZYxI35tkmkqUnua1c9wtP3aab9NF/XyPm0soOCwH1NAIPIIP0r6ki0jTYF2w6daRr6JAoH8qim8P6NcnM+k2Eh6Ze3Qn+VP2L7mH+scL/AMN/f/wD5rsNRvdLnM1hdzWsp6tC5XP1x1/GvRvDnxduInW38QwiWPgfaoEww92QcH/gOPoa7PUfht4X1EE/2d9lkPR7VzHj/gP3fzFcTrXwevIA0ui3q3KgZ8i4wj/QMOD+IFHJOOxUsdl2OXLWVn3f+a/U7bWfDWieNNPW/s5YvPdcxXkGDu7Yb16d+RjtXj+saNfaFftZ38JSQcqw5Vx6qe4/yafomu654C1kxywTRAnM9lPlRIOm4e/HDDP4ivZZItG+IHhpJUbfG4yj4/eQSdwfQjuO/wCVNWn6nyGfcOcn72nqns+/k/8AM8v8FeKZPDuqBJnJ0+dgJ07L6OPcd/UfhWh8TPDSWV4muWQU2l4373YeBIRncPZhz9c+tcvrOj3ehanLYXiYkTlWHR17MPY//Wr0bwVdxeKfB954dv5A0kKbFJGT5Z+4w9SpH6LXTgsQ6FVPofMYVurGWDq79PJ9jyGvZvhrrQ1nw7LpF0+6azGxc9TEfun8On4CvILy0lsL2e0nAE0EjRuB0yDg1veA9VbSfF9k+f3Vw32eQeobgfk20/hX0GNoRr0HF6kYCvKhiF9zPTXV7a4ZM4kjbqPUd66mwuxeWqydHHDj0NY+uwbLpJgOJFwfqP8A62PyqLSLn7PehCfkl+U/Xt/n3r8rwVV5dj5YeT91u3+TP0GrFV6Kmt/6udNRRRX2R5QV4F8Q/FEniPxAbS2ZmsLRzFCinPmvnBfA65PA68fU16r8QdcbQvCN1LExW5uP9HhIOCGbqc9sKGP1ArlPhd4KSOCPxBqMIMjjNnE68Iv/AD0+p7eg57jGVS8nyo9zLPZ4alLGVemkV5/1+ongv4XxrHHqXiKLfIcNHZHovvJ6n/Z6DvnoPUkRIo1jjVURQFVVGAAOgAp1FXGKitDzcVi6uKnz1H8uiCiiiqOUKKKKACiiigDO1nQ9O1+yNrqVsk0fO1jwyH1U9Qa83t7DUfhd4gW4aV7nw3duI5pcf6rPCswHRh6jgjPQ4A9ZqK5toby2ktriJZYZVKujjIYHtUyjfVbnZhsZKlF05awe6/Vdmc94y8NxeJdELQBTeQr5ltIMfN/s59D/ADwa8u8D6i+keMLQOGVZn+zSqRgjdwPphsflXsehWM2lWZ013MsFsdtrIevlfwq3uvK+4APU15h8R9GbRvEMWq2ilI7o+YCOizLyfz4P1zUTX2j5zNcOqVRYmn9l6+a6MZ8V9JFp4gh1GNMR3sfzEd3TAP6FfyNcErMjBkYqynIYdQa9q+JFuuq+BVv4uRC8dwvGSVb5f/Zs/hXilfT4Cpz0FfpoeZmVPkxDa66n0PcXH9p+GbS/wAZI45iB23AZH61jcg5BII6EVb8Jzfa/hxZMecWzJ/3wSv8A7LVSvy3iaiqeMuuq/Js+8yypz0E/61R2FrN9otYpe7KCceveiqOhSFrFkJ+45x+PP+NFfTYKs62HhUe7X49Thqw5JuJyHjKxk8UeO9F8Pkf6HbxG8uueqlsY/wDHcf8AA/avQURY0VEUKijCqowAPQViaTaBvEuu6k65dpIrWJiP+WaRqxx/wN2z9B6Vu10RW7N8TVvGFJbRX4vV/wCXyCiiiqOQKKKKACiiigAooooAKKKKACua8e6WNT8I3eB+8th9ojP+71/8d3Culpk0STwyQyqGjkUqynuDwaTV1Yzq01UpuD6nOGE3nw08rG4vpQAHv5fFeA19L6bZG10S0sZiGaK3SFyOhIUA18zr9wfSvZyl+7Jeh4WbQsqbfb/I918Agn4bWgPdJ/8A0Y9Q1o+Frf7H8PrFMYzaGT8Wy39azq/PuK2niU15/mfXZQmsOk+y/I2vD7fNcL7Kf50U3w//AK+f/dH86K9PI23gYfP82Z4z+MzahhWBCqdC7OfqSSf51JRRXrHM3cKKKKACiiigAooooAKKKKACiiigAooooAQkKCScAcmvmG0t5b66gt4uZp3VFz/eY4H86+jtfuTZ+HdSuAcNHbSMD77Tj9a8f+GWjjUvFSXLqTDYr5x443nhB+eT/wABr1MBL2dKpUZ42Zw9rWpUl1v+h6/dxx6foP2aLiOONYUB9OB/Kubrd1+UCKGHuzbj+HH9awq/NOIK3tMZy/ypL9f1PsMDDlpepueH0+W4k9Sqj8M/40VZ0WIx6crHrIxb+n9KK+nyqn7PB04vtf79f1PPxMuarJmjRRRXoGAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQBxPxR1L7H4SNqrYkvJVj687R8x/kB+NX/Anh86B4biSVSLu4/fT5GCpI4X8B+uao/2f/wlXjf7fMpOl6OTDCCeJbgHLEeykAH1KjrzXValdfZLNmB+dvlT61tisRHD4a0tlq/8v66nLQouriHV+S/VmBqlx9ov5CPup8i/h/8AXzVVEaWRY1+8xAH402tbQ7XfO1yw+WPhfr/+r+dfmlGnPH4uz3k7v06n08mqNL0N2KMRRJGv3UUKKKfRX6IkkrI8Ju4UUUUwCiiigAooooAKKKKACiiigAooooAKgu0mlt2igkMTSfKZB1QdyPf096nooTsDVyC1tbews47a3QRQRLtVc9B9T1+prnNSvPtl0Sp/dpwn+NXtY1HO61hbjpIw/l/jWMqs7BFBZmOAB3r5DPcx9tL6tSd0t/N9v66np4PD8i55fIfBC9xMsUYyzH8veutt4EtoEhT7qj8/eq2m6eLKLc2DMw+Y+nsKvV6uTZa8LT9pUXvy/Bdv8znxVf2kuWOyCiiivaOQKKKKACiiigAooooAKKKKACiiigAooqpdajbWuQ75f+4vJ/8ArVnVq06Ueao7LzKjGUnaKLdYmpavw0Nq3s0g/p/jVW4v7vUWMUSMI+6IM5+pqa10KR8NctsX+6pyfz6V8/icwxGN/dYGLt1lt93b8ztp0IUverPXsZkEElxII4kLMf0+tdJp+mx2S72w8xHLensKtQW8VvHshQKvt3qSurLsmp4V+0qe9P8ABen+ZnXxUqnux0QUUUV7RyBRRRQAUUUUAFFFFABRRRQAUUUUAFNYMR8rAfUZoopNXArS2Tzn95dzhf7qEKP5U2LSbKLkQ7j6uc/p0oorneDoOXPKKb89fzNPazSsmXFRUUKihVHQAYFLRRXQkkrIzCiiimAUUUUAFFFFAH//2Q=="
	>
	<VersionHistory>
		<Change Date="2022-05-19">Initial version</Change>
	</VersionHistory>

	<ServiceUrls>
		<ServiceUrl Url="https://sdpondemand.manageengine.com/api/v3"/>
	</ServiceUrls>

	<!-- https://www.zoho.com/crm/developer/docs/api/access-refresh.html -->
	<Auths>
		<Auth Type="OAuth" Desc="OAuth Connection for ManageEngine ServiceDesk Plus API" 
		  HelpLink="https://zappysys.com/links/?id=10123"
          ConnStr="Provider=Custom;OAuthVersion=OAuth2;ScopeSeparator={space};ReturnUrl=[$RedirectUrl$];ExtraAttributesForAuthRequest=access_type=offline&amp;prompt=consent;AuthUrl=[$AccountUrl$]/oauth/v2/auth;TokenUrl=[$AccountUrl$]/oauth/v2/token;ClientId=[$ClientId$];ClientSecret=[$ClientSecret$];Scope=[$Permissions$];ExpiresInAttribute=expires_in_sec;" 
		  TestEndPoint="get_testdata">
			<Params>
				<Param Name="ClientId" />
				<Param Name="ClientSecret" Secret="True" />
				<Param Name="Permissions" 
			   Value="SDPOnDemand.requests.ALL" 
               MultiSelect="True" 
			   MultiSelectSeparator=" " 
			   Options="SDPOnDemand.requests.ALL;SDPOnDemand.requests.CREATE;SDPOnDemand.requests.READ;SDPOnDemand.requests.UPDATE;SDPOnDemand.requests.DELETE;SDPOnDemand.problems.ALL;SDPOnDemand.problems.CREATE;SDPOnDemand.problems.READ;SDPOnDemand.problems.UPDATE;SDPOnDemand.problems.DELETE;SDPOnDemand.changes.ALL;SDPOnDemand.changes.CREATE;SDPOnDemand.changes.READ;SDPOnDemand.changes.UPDATE;SDPOnDemand.changes.DELETE;SDPOnDemand.projects.ALL;SDPOnDemand.projects.CREATE;SDPOnDemand.projects.READ;SDPOnDemand.projects.UPDATE;SDPOnDemand.projects.DELETE;SDPOnDemand.assets.ALL;SDPOnDemand.assets.CREATE;SDPOnDemand.assets.READ;SDPOnDemand.assets.UPDATE;SDPOnDemand.assets.DELETE;SDPOnDemand.cmdb.ALL;SDPOnDemand.cmdb.CREATE;SDPOnDemand.cmdb.READ;SDPOnDemand.cmdb.UPDATE;SDPOnDemand.cmdb.DELETE;SDPOnDemand.custommodule.ALL;SDPOnDemand.custommodule.CREATE;SDPOnDemand.custommodule.READ;SDPOnDemand.custommodule.UPDATE;SDPOnDemand.custommodule.DELETE;SDPOnDemand.setup.ALL;SDPOnDemand.setup.CREATE;SDPOnDemand.setup.READ;SDPOnDemand.setup.UPDATE;SDPOnDemand.setup.DELETE;SDPOnDemand.general.ALL;SDPOnDemand.general.CREATE;SDPOnDemand.general.READ;SDPOnDemand.general.UPDATE;SDPOnDemand.general.DELETE;" 
			   HelpLink="https://www.manageengine.com/products/service-desk/sdpod-v3-api/getting-started/oauth-2.0.html#scopes"/>
				<Param Name="AccountUrl" Value="https://accounts.zoho.com"
               Options="US Domain=https://accounts.zoho.com;EU Domain=https://accounts.zoho.eu;AU Domain=https://accounts.zoho.au;IN Domain=https://accounts.zoho.in;CN Domain=https://accounts.zoho.com.cn;" />
				<Param Name="RedirectUrl" Value="https://zappysys.com/oauth" Desc="This is the redirect URL you entered when you created app in Zoho Portal. URL must match exactly including trailing slash" />

				<!--below not exposed as root level property in HTTP Connection so use as placeholder-->
				<Param Name="RetryMode" Value="RetryWhenStatusCodeMatch" Options="None;RetryAny;RetryWhenStatusCodeMatch;" Hidden="True" HelpLink="https://www.zoho.com/crm/developer/docs/api/v2/status-codes.html" />
				<Param Name="RetryStatusCodeList" Value="429" Hidden="True" />
				<Param Name="RetryCountMax" Value="5" Hidden="True" />
				<Param Name="RetryMultiplyWaitTime" Value="True" Hidden="True" />

			</Params>
			<Notes>
				<![CDATA[To register custom App, perform the following steps (Detailed steps found in the help link at the end)
<ol>
  <li>Go to <a target="_blank" href="https://api-console.zoho.com/">Zoho API Console</a>
  <li>Click <b>Add Client</b> link
  <li>Select <b>Server-based Applications</b> option
  <li>Enter desired client name (Display purpose only)</b>
  <li>Enter some URL for Company homepage</b>
  <li>For Authorized Redirect URI enter https://zappysys.com/oauth (Or enter your own but we recommend using ZappySys one if possible). This URL must match on Zoho Connector UI.
  <li>Click <b>CREATE</b>.
  <li>Copy Client ID and Secret and paste on Zoho Connector UI.
</ol>
]]>
			</Notes>
		</Auth>
	</Auths>
	<Template>
		<EndPoint Name="Paginated" >
			<Params>
				<Param Name="PagingMode" Type="Property" Value="ByUrlPath" />
				<Param Name="PagingByUrlAttributeName" Type="Property" Value="[$page$]" />
				<Param Name="RowsPerPage" Type="Property" Value="100" />
				<Param Name="PagingIncrementBy" Type="Property" Value="100" ValueTemplate="[$RowsPerPage$]" />
				<Param Name="NextUrlEndIndicator" Type="Property" Value="false" />
				<Param Name="StopIndicatorAttributeOrExpr" Type="Property" Value="$.list_info.has_more_rows" />
			</Params>
		</EndPoint>
		      
    <EndPoint Name="RequestTemplate" >
			<OutputColumns>
				<Column Name="id" DataType="DT_WSTR" Length="180" Key="True"  />
				<Column Name="subject" DataType="DT_WSTR" Length="1000" />
				<Column Name="description" DataType="DT_NTEXT" />        				
        <Column Name="email_to" DataType="DT_WSTR" Length="255" />
				<Column Name="status.color" Label="status_color" DataType="DT_WSTR" Length="70" />
				<Column Name="status.name" Label="status_name" DataType="DT_WSTR" Length="40" />
				<Column Name="status.id" Label="status_id" DataType="DT_WSTR" Length="180" />
        <Column Name="status.in_progress" Label="status_in_progress" DataType="DT_BOOL" />
        <Column Name="status.internal_name" Label="status_internal_name" DataType="DT_WSTR" Length="40" />
        <Column Name="status.stop_timer" Label="status_stop_timer" DataType="DT_BOOL" />
        
        <Column Name="resolution.content" Label="resolution_content" DataType="DT_NTEXT" />
        <Column Name="resolution.submitted_by" Label="resolution_submitted_by" DataType="DT_WSTR" Length="255"  />
        
        <Column Name="update_reason" DataType="DT_WSTR" Length="4000"   />
        
        <Column Name="requester.email_id" Label="requester_email_id" DataType="DT_WSTR" Length="255" />
				<Column Name="requester.is_technician" Label="requester_is_technician" DataType="DT_BOOL" />
				<Column Name="requester.sms_mail" Label="requester_sms_mail" DataType="DT_WSTR" Length="255" />
				<Column Name="requester.mobile" Label="requester_mobile" DataType="DT_WSTR" Length="255" />
				<Column Name="requester.last_name" Label="requester_last_name" DataType="DT_WSTR" Length="255" />
				<Column Name="requester.user_scope" Label="requester_user_scope" DataType="DT_WSTR" Length="255" />
				<Column Name="requester.phone" Label="requester_phone" DataType="DT_WSTR" Length="255" />
				<Column Name="requester.name" Label="requester_name" DataType="DT_WSTR" Length="255" />
				<Column Name="requester.id" Label="requester_id" DataType="DT_WSTR" Length="180" />
				<Column Name="requester.photo_url" Label="requester_photo_url" DataType="DT_WSTR" Length="750" />
				<Column Name="requester.is_vip_user" Label="requester_is_vip_user" DataType="DT_BOOL" />
				<Column Name="requester.department" Label="requester_department" DataType="DT_WSTR" Length="2550" />
				<Column Name="requester.first_name" Label="requester_first_name" DataType="DT_WSTR" Length="255" />
				<Column Name="requester.job_title" Label="requester_job_title" DataType="DT_WSTR" Length="2550" />
        
				<Column Name="project" DataType="DT_WSTR" Length="1000" />
				<Column Name="resolution" DataType="DT_WSTR" Length="4000" />
				<Column Name="linked_to_request" DataType="DT_WSTR" Length="2550" />
        
				<Column Name="mode.name" Label="mode_name" DataType="DT_WSTR" Length="255" />
				<Column Name="mode.id" Label="mode_id" DataType="DT_WSTR" Length="180" />
        
				<Column Name="lifecycle" DataType="DT_WSTR" Length="2550" />
				
				<Column Name="assets" DataType="DT_WSTR" Length="400" />
				<Column Name="cancellation_requested" DataType="DT_BOOL" />
				<Column Name="is_trashed" DataType="DT_BOOL" />
				<Column Name="has_change_initiated_request" DataType="DT_BOOL" />
				
				<Column Name="group.name" Label="group_name"  DataType="DT_WSTR" Length="255" />
        <Column Name="group.id" Label="group_id"  DataType="DT_WSTR" Length="255" />

        <Column Name="on_behalf_of.email_id" Label="on_behalf_of_email_id" DataType="DT_WSTR" Length="180" />
        <Column Name="on_behalf_of.is_technician" Label="on_behalf_of_is_technician" DataType="DT_BOOL" />
        <Column Name="on_behalf_of.sms_mail" Label="on_behalf_of_sms_mail" DataType="DT_WSTR" Length="2550" />
        <Column Name="on_behalf_of.mobile" Label="on_behalf_of_mobile" DataType="DT_WSTR" Length="200" />
        <Column Name="on_behalf_of.last_name" Label="on_behalf_of_last_name" DataType="DT_WSTR" Length="40" />
        <Column Name="on_behalf_of.user_scope" Label="on_behalf_of_user_scope" DataType="DT_WSTR" Length="200" />
        <Column Name="on_behalf_of.phone" Label="on_behalf_of_phone" DataType="DT_WSTR" Length="120" />
        <Column Name="on_behalf_of.name" Label="on_behalf_of_name" DataType="DT_WSTR" Length="130" />
        <Column Name="on_behalf_of.id" Label="on_behalf_of_id" DataType="DT_WSTR" Length="180" />				
        
				<Column Name="created_time.display_value" Label="created_time_display_value" DataType="DT_WSTR" Length="210" />
				<Column Name="created_time.value" Label="created_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>

        <Column Name="responded_time.display_value" Label="responded_time_display_value" DataType="DT_WSTR" Length="210" />
        <Column Name="responded_time.value" Label="responded_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>
        
        <Column Name="last_updated_time.display_value" Label="last_updated_time_display_value" DataType="DT_WSTR" Length="210" />
				<Column Name="last_updated_time.value" Label="last_updated_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>
				
        <Column Name="completed_time.display_value" Label="completed_time_display_value" DataType="DT_WSTR" Length="210" />
				<Column Name="completed_time.value" Label="completed_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>

        <Column Name="assigned_time.display_value" Label="assigned_time_display_value" DataType="DT_WSTR" Length="210" />
				<Column Name="assigned_time.value" Label="assigned_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>

        <Column Name="resolved_time.display_value" Label="resolved_time_display_value" DataType="DT_WSTR" Length="210" />
				<Column Name="resolved_time.value" Label="resolved_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>

        <Column Name="scheduled_start_time.display_value" Label="scheduled_start_time_display_value" DataType="DT_WSTR" Length="210" />
        <Column Name="scheduled_start_time.value" Label="scheduled_start_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>

        <Column Name="scheduled_end_time.display_value" Label="scheduled_end_time_display_value" DataType="DT_WSTR" Length="210" />
        <Column Name="scheduled_end_time.value" Label="scheduled_end_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>

        <Column Name="first_response_due_by_time.display_value" Label="first_response_due_by_time_display_value" DataType="DT_WSTR" Length="210" />
        <Column Name="first_response_due_by_time.value" Label="first_response_due_by_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>


        <Column Name="deleted_time.display_value" Label="deleted_time_display_value" DataType="DT_WSTR" Length="210" />
        <Column Name="deleted_time.value" Label="deleted_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>

        <Column Name="due_by_time.display_value" Label="due_by_time_display_value" DataType="DT_WSTR" Length="210" />
        <Column Name="due_by_time.value" Label="due_by_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>

        <Column Name="item.name" Label="item_name" DataType="DT_WSTR" Length="4000" />
        <Column Name="item.id" Label="item_id" DataType="DT_WSTR" Length="255" />

				<Column Name="cancel_flag_comments.name" Label="cancel_flag_comments_name" DataType="DT_WSTR" Length="400" />
        <Column Name="cancel_flag_comments.comment" Label="cancel_flag_comment" DataType="DT_NTEXT" />
        <Column Name="cancel_flag_comments.id" Label="cancel_flag_comments_id" DataType="DT_WSTR" Length="400" />
        
        <Column Name="level.name" Label="level_name" DataType="DT_WSTR" Length="400" />
        <Column Name="level.id" Label="level_id" DataType="DT_WSTR" Length="255" />
        
        <Column Name="impact.name" Label="impact_name" DataType="DT_WSTR" Length="400" />
        <Column Name="impact.id" Label="impact_id" DataType="DT_WSTR" Length="255" />
        
        <Column Name="sla.name" Label="sla_name" DataType="DT_WSTR" Length="400" />
        <Column Name="sla.id" Label="sla_id" DataType="DT_WSTR" Length="255" />
        
        <Column Name="approval_status.name" Label="approval_status_name" DataType="DT_WSTR" Length="400" />
        <Column Name="approval_status.id" Label="approval_status_id" DataType="DT_WSTR" Length="255" />
        
        <Column Name="priority.name" Label="priority_name" DataType="DT_WSTR" Length="400" />
        <Column Name="priority.id" Label="priority_id" DataType="DT_WSTR" Length="255" />        

				<Column Name="created_by.email_id" Label="created_by_email_id" DataType="DT_WSTR" Length="180" />
				<Column Name="created_by.is_technician" Label="created_by_is_technician" DataType="DT_BOOL" />
				<Column Name="created_by.sms_mail" Label="created_by_sms_mail" DataType="DT_WSTR" Length="2550" />
				<Column Name="created_by.mobile" Label="created_by_mobile" DataType="DT_WSTR" Length="200" />
				<Column Name="created_by.last_name" Label="created_by_last_name" DataType="DT_WSTR" Length="40" />
				<Column Name="created_by.user_scope" Label="created_by_user_scope" DataType="DT_WSTR" Length="200" />
				<Column Name="created_by.phone" Label="created_by_phone" DataType="DT_WSTR" Length="120" />
				<Column Name="created_by.name" Label="created_by_name" DataType="DT_WSTR" Length="130" />
				<Column Name="created_by.id" Label="created_by_id" DataType="DT_WSTR" Length="180" />
				<Column Name="created_by.photo_url" Label="created_by_photo_url" DataType="DT_WSTR" Length="750" />
				<Column Name="created_by.is_vip_user" Label="created_by_is_vip_user" DataType="DT_BOOL" />
				<Column Name="created_by.department" Label="created_by_department" DataType="DT_WSTR" Length="2550" />
				<Column Name="created_by.first_name" Label="created_by_first_name" DataType="DT_WSTR" Length="80" />
				<Column Name="created_by.job_title" Label="created_by_job_title" DataType="DT_WSTR" Length="2550" />
				

				<Column Name="has_notes" DataType="DT_BOOL" />
				<!-- Example Custom Fields 
		<Column Name="udf_fields.udf_date1.display_value" Label="udf_fields_udf_date1_display_value" DataType="DT_WSTR" Length="210" />
		<Column Name="udf_fields.udf_date1.value" Label="udf_fields_udf_date1" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>
		<Column Name="udf_fields.udf_char2" Label="udf_fields_udf_char2" DataType="DT_WSTR" Length="240" />
		-->
				<Column Name="impact_details" DataType="DT_WSTR" Length="400" />
        
				<Column Name="email_cc" DataType="DT_WSTR" Length="4000" />
        <Column Name="email_bcc" DataType="DT_WSTR" Length="4000" />
        
        <Column Name="subcategory.name" Label="subcategory_name" DataType="DT_WSTR" Length="150" />
        <Column Name="subcategory.id" Label="subcategory_id" DataType="DT_WSTR" Length="180" />

        <Column Name="template.name" Label="template_name" DataType="DT_WSTR" Length="150" />
				<Column Name="template.id" Label="template_id" DataType="DT_WSTR" Length="180" />
				
        <Column Name="email_ids_to_notify" DataType="DT_WSTR" Length="4000" />
				<Column Name="attachments" DataType="DT_WSTR" Length="4000" />
				<Column Name="completed_by_denial" DataType="DT_BOOL" />
				<Column Name="display_id" DataType="DT_WSTR" Length="100" />
				<Column Name="time_elapsed" DataType="DT_WSTR" Length="100" />
				<Column Name="notification_status" DataType="DT_WSTR" Length="2550" />

        <Column Name="service_cost" DataType="DT_R4" />
        <Column Name="total_cost" DataType="DT_R4" />
        
				
        <Column Name="urgency.name" Label="urgency_name" DataType="DT_WSTR" Length="400" />
        <Column Name="urgency.id" Label="urgency_id" DataType="DT_WSTR" Length="255" />
        
				<Column Name="has_request_initiated_change" DataType="DT_BOOL" />
				<Column Name="request_template_task_ids" DataType="DT_WSTR" Length="1000" />
				
        <Column Name="department.name" Label="department_name" DataType="DT_WSTR" Length="400" />
        <Column Name="department.id" Label="department_id" DataType="DT_WSTR" Length="255" />

        <Column Name="is_service_request" DataType="DT_BOOL" />
        <Column Name="is_reopened" DataType="DT_BOOL" />
				<Column Name="is_overdue" DataType="DT_BOOL" />
        <Column Name="is_escalated" DataType="DT_BOOL" />
        <Column Name="is_read" DataType="DT_BOOL" />
        <Column Name="is_fcr" DataType="DT_BOOL" />

        <Column Name="has_problem" DataType="DT_BOOL" />
				<Column Name="has_project" DataType="DT_BOOL" />
        <Column Name="has_draft" DataType="DT_BOOL" />
        <Column Name="has_attachments" DataType="DT_BOOL" />
        <Column Name="has_linked_requests" DataType="DT_BOOL" />
        
        <Column Name="site.name" Label="site_name" DataType="DT_WSTR" Length="400" />
        <Column Name="site.id" Label="site_id" DataType="DT_WSTR" Length="255" />

        <Column Name="is_first_response_overdue" DataType="DT_BOOL" />

				<Column Name="technician.email_id" Label="technician_email_id" DataType="DT_WSTR" Length="180" />
				<Column Name="technician.is_technician" Label="technician_is_technician" DataType="DT_BOOL" />
				<Column Name="technician.sms_mail" Label="technician_sms_mail" DataType="DT_WSTR" Length="2550" />
				<Column Name="technician.mobile" Label="technician_mobile" DataType="DT_WSTR" Length="200" />
				<Column Name="technician.last_name" Label="technician_last_name" DataType="DT_WSTR" Length="40" />
				<Column Name="technician.user_scope" Label="technician_user_scope" DataType="DT_WSTR" Length="200" />
				<Column Name="technician.phone" Label="technician_phone" DataType="DT_WSTR" Length="120" />
				<Column Name="technician.name" Label="technician_name" DataType="DT_WSTR" Length="130" />
				<Column Name="technician.id" Label="technician_id" DataType="DT_WSTR" Length="180" />
				<Column Name="technician.photo_url" Label="technician_photo_url" DataType="DT_WSTR" Length="750" />
				<Column Name="technician.is_vip_user" Label="technician_is_vip_user" DataType="DT_BOOL" />
				<Column Name="technician.department" Label="technician_department" DataType="DT_WSTR" Length="2550" />
				<Column Name="technician.first_name" Label="technician_first_name" DataType="DT_WSTR" Length="80" />
				<Column Name="technician.job_title" Label="technician_job_title" DataType="DT_WSTR" Length="2550" />
        
				<Column Name="unreplied_count" DataType="DT_I4" />
        
				<Column Name="status_code" DataType="DT_I8" />
				<Column Name="status" DataType="DT_WSTR" Length="70" />
        
        <Column Name="category.name" Label="category_name" DataType="DT_WSTR" Length="400" />
        <Column Name="category.id" Label="category_id" DataType="DT_WSTR" Length="255" />
        
        <Column Name="maintenance.name" Label="maintenance_name" DataType="DT_WSTR" Length="400" />
        <Column Name="maintenance.id" Label="maintenance_id" DataType="DT_WSTR" Length="255" />

				<Column Name="request_type.name" Label="request_type_name" DataType="DT_WSTR" Length="80" />
				<Column Name="request_type.id" Label="request_type_id" DataType="DT_WSTR" Length="180" />
      
			</OutputColumns>      
    </EndPoint>

    <EndPoint Name="RequestTaskTemplate" >
      <OutputColumns>
        <Column Name="id" DataType="DT_WSTR" Length="180" Key="True" />
        <Column Name="title" DataType="DT_WSTR" Length="500" />
        <Column Name="description" DataType="DT_WSTR" Length="4000" />
        <Column Name="percentage_completion" DataType="DT_WSTR" Length="20" />
        <Column Name="request.id" Label="request_id" DataType="DT_WSTR" Length="64" />
        <Column Name="additional_cost" DataType="DT_WSTR" Length="20" />
        <Column Name="estimated_effort_hours" DataType="DT_WSTR" Length="20" />
        <Column Name="attachments" DataType="DT_WSTR" Length="4000" />
        <Column Name="email_before" DataType="DT_WSTR" Length="28" />
        <Column Name="marked_technician.email_id" Label="marked_technician_email_id" DataType="DT_WSTR" Length="255" />
        <Column Name="marked_technician.is_technician" Label="marked_technician_is_technician" DataType="DT_BOOL" />
        <Column Name="marked_technician.sms_mail" Label="marked_technician_sms_mail" DataType="DT_WSTR" Length="255" />
        <Column Name="marked_technician.phone" Label="marked_technician_phone" DataType="DT_WSTR" Length="255" />
        <Column Name="marked_technician.name" Label="marked_technician_name" DataType="DT_WSTR" Length="255" />
        <Column Name="marked_technician.mobile" Label="marked_technician_mobile" DataType="DT_WSTR" Length="255" />
        <Column Name="marked_technician.id" Label="marked_technician_id" DataType="DT_WSTR" Length="255" />
        <Column Name="marked_technician.photo_url" Label="marked_technician_photo_url" DataType="DT_WSTR" Length="500" />
        <Column Name="marked_technician.is_vip_user" Label="marked_technician_is_vip_user" DataType="DT_BOOL" />
        <Column Name="marked_technician.department" Label="marked_technician_department" DataType="DT_WSTR" Length="255" />
        <Column Name="overdue" DataType="DT_BOOL" />

        <Column Name="actual_end_time.display_value" Label="actual_end_time_display_value" DataType="DT_WSTR" Length="255" />
        <Column Name="actual_end_time.value" Label="actual_end_time_value" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />

        <Column Name="actual_start_time.display_value" Label="actual_start_time_display_value" DataType="DT_WSTR" Length="255" />
        <Column Name="actual_start_time.value" Label="actual_start_time_value" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />
        <Column Name="owner.email_id" Label="owner_email_id" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.is_technician" Label="owner_is_technician" DataType="DT_BOOL" />
        <Column Name="owner.sms_mail" Label="owner_sms_mail" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.phone" Label="owner_phone" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.name" Label="owner_name" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.mobile" Label="owner_mobile" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.id" Label="owner_id" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.photo_url" Label="owner_photo_url" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.is_vip_user" Label="owner_is_vip_user" DataType="DT_BOOL" />
        <Column Name="owner.department" Label="owner_department" DataType="DT_WSTR" Length="255" />
        <Column Name="associated_entity" DataType="DT_WSTR" Length="255" />
        <Column Name="module" DataType="DT_WSTR" Length="255" />
        <Column Name="priority.color" Label="priority_color" DataType="DT_WSTR" Length="255" />
        <Column Name="priority.name" Label="priority_name" DataType="DT_WSTR" Length="255" />
        <Column Name="priority.id" Label="priority_id" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.email_id" Label="created_by_email_id" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.is_technician" Label="created_by_is_technician" DataType="DT_BOOL" />
        <Column Name="created_by.sms_mail" Label="created_by_sms_mail" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.phone" Label="created_by_phone" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.name" Label="created_by_name" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.mobile" Label="created_by_mobile" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.id" Label="created_by_id" DataType="DT_WSTR" Length="64" />
        <Column Name="created_by.photo_url" Label="created_by_photo_url" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.is_vip_user" Label="created_by_is_vip_user" DataType="DT_BOOL" />
        <Column Name="created_by.department" Label="created_by_department" DataType="DT_WSTR" Length="255" />
        <Column Name="scheduled_end_time.display_value" Label="scheduled_end_time_display_value" DataType="DT_WSTR" Length="255" />
        <Column Name="scheduled_end_time.value" Label="scheduled_end_time_value" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />
        <Column Name="estimated_effort_minutes" DataType="DT_WSTR" Length="20" />
        <Column Name="deleted" DataType="DT_BOOL" />
        <Column Name="estimated_effort" DataType="DT_WSTR" Length="20" />
        <Column Name="created_date.display_value" Label="created_date_display_value" DataType="DT_WSTR" Length="255" />
        <Column Name="created_date.value" Label="created_date_value" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />
        <Column Name="estimated_effort_days" DataType="DT_WSTR" Length="20" />
        <Column Name="task_type.color" Label="task_type_color" DataType="DT_WSTR" Length="255" />
        <Column Name="task_type.name" Label="task_type_name" DataType="DT_WSTR" Length="255" />
        <Column Name="task_type.id" Label="task_type_id" DataType="DT_WSTR" Length="255" />
        <Column Name="scheduled_start_time.display_value" Label="scheduled_start_time_display_value" DataType="DT_WSTR" Length="255" />
        <Column Name="scheduled_start_time.value" Label="scheduled_start_time_value" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />
        <Column Name="status.in_progress" Label="status_in_progress" DataType="DT_BOOL" />
        <Column Name="status.internal_name" Label="status_internal_name" DataType="DT_WSTR" Length="255" />
        <Column Name="status.stop_timer" Label="status_stop_timer" DataType="DT_BOOL" />
        <Column Name="status.color" Label="status_color" DataType="DT_WSTR" Length="255" />
        <Column Name="status.name" Label="status_name" DataType="DT_WSTR" Length="255" />
        <Column Name="status.id" Label="status_id" DataType="DT_WSTR" Length="255" />
      </OutputColumns>      
    </EndPoint>

    <EndPoint Name="RequestTaskCommentTemplate" >
      <OutputColumns>
        <Column Name="id" DataType="DT_WSTR" Length="180" />
        <Column Name="task.id" Label="task_id" DataType="DT_WSTR" Length="64" />
        <Column Name="task.title" Label="task_title" DataType="DT_WSTR" Length="255" />
        <Column Name="comment" DataType="DT_WSTR" Length="4000" />
        <Column Name="parent_comment.comment" Label="parent_comment"  DataType="DT_WSTR" Length="4000" />
        <Column Name="parent_comment.id" Label="parent_comment_id"  DataType="DT_WSTR" Length="180" />
        <Column Name="created_time.display_value" Label="created_time_display_value" DataType="DT_WSTR" Length="84" />
        <Column Name="created_time.value" Label="created_time_value" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />

        <Column Name="last_updated_time.display_value" Label="last_updated_time_display_value" DataType="DT_WSTR" Length="210" />
        <Column Name="last_updated_time.value" Label="last_updated_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>

        <Column Name="created_by.email_id" Label="created_by_email_id" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.is_technician" Label="created_by_is_technician" DataType="DT_BOOL" />
        <Column Name="created_by.sms_mail" Label="created_by_sms_mail" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.mobile" Label="created_by_mobile" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.last_name" Label="created_by_last_name" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.user_scope" Label="created_by_user_scope" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.sms_mail_id" Label="created_by_sms_mail_id" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.phone" Label="created_by_phone" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.name" Label="created_by_name" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.id" Label="created_by_id" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.photo_url" Label="created_by_photo_url" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.is_vip_user" Label="created_by_is_vip_user" DataType="DT_BOOL" />
        <Column Name="created_by.department" Label="created_by_department" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.first_name" Label="created_by_first_name" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.job_title" Label="created_by_job_title" DataType="DT_WSTR" Length="255" />
      </OutputColumns>
    </EndPoint>

    <EndPoint Name="RequestNoteTemplate" >
      <OutputColumns>
        <Column Name="id" DataType="DT_WSTR" Length="180" Key="True"/>
        <Column Name="description" DataType="DT_WSTR" Length="4000" />
        <Column Name="mark_first_response" DataType="DT_BOOL" />
        <Column Name="request.id" Label="request_id" DataType="DT_WSTR" Length="64" />
        <Column Name="created_time.display_value" Label="created_time_display_value" DataType="DT_WSTR" Length="255" />
        <Column Name="created_time.value" Label="created_time_value" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />
        <Column Name="add_to_linked_requests" DataType="DT_BOOL" />
        <Column Name="request.display_id" Label="request_display_id" DataType="DT_WSTR" Length="20" />
        <Column Name="request.subject" Label="request_subject" DataType="DT_WSTR" Length="255" />
        <Column Name="notify_technician" DataType="DT_BOOL" />
        <Column Name="show_to_requester" DataType="DT_BOOL" />
        <Column Name="created_by.email_id" Label="created_by_email_id" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.is_technician" Label="created_by_is_technician" DataType="DT_BOOL" />
        <Column Name="created_by.sms_mail" Label="created_by_sms_mail" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.phone" Label="created_by_phone" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.name" Label="created_by_name" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.mobile" Label="created_by_mobile" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.id" Label="created_by_id" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.photo_url" Label="created_by_photo_url" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.is_vip_user" Label="created_by_is_vip_user" DataType="DT_BOOL" />
      </OutputColumns>
    </EndPoint>

    <EndPoint Name="RequestWorklogTemplate" >
      <OutputColumns>
        <Column Name="id" DataType="DT_WSTR" Length="180" Key="True" />
        <Column Name="description" DataType="DT_WSTR" Length="64" />
        <Column Name="other_charge" DataType="DT_R8" />
        <Column Name="total_charge" DataType="DT_R8" />
        <Column Name="tech_charge" DataType="DT_R8" />

        <Column Name="time_spent.hours" Label="time_spent_hours" DataType="DT_I8" />
        <Column Name="time_spent.minutes" Label="time_spent_minutes" DataType="DT_I8" />
        <Column Name="start_time.display_value" Label="start_time_display_value" DataType="DT_WSTR" Length="84" />
        <Column Name="start_time.value" Label="start_time_value" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />

        <Column Name="end_time.display_value" Label="end_time_display_value" DataType="DT_WSTR" Length="84" />
        <Column Name="end_time.value" Label="end_time_value" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />

        <Column Name="worklog_type.name" Label="worklog_type_name" DataType="DT_WSTR" Length="36" />
        <Column Name="worklog_type.id" Label="worklog_type_id" DataType="DT_WSTR" Length="64" />

        <Column Name="recorded_time.display_value" Label="recorded_time_display_value" DataType="DT_WSTR" Length="84" />
        <Column Name="recorded_time.value" Label="recorded_time_value" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />

        <Column Name="owner.email_id" Label="owner_email_id" DataType="DT_WSTR" Length="68" />
        <Column Name="owner.is_technician" Label="owner_is_technician" DataType="DT_BOOL" />
        <Column Name="owner.sms_mail" Label="owner_sms_mail" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.phone" Label="owner_phone" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.name" Label="owner_name" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.mobile" Label="owner_mobile" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.id" Label="owner_id" DataType="DT_WSTR" Length="64" />
        <Column Name="owner.photo_url" Label="owner_photo_url" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.is_vip_user" Label="owner_is_vip_user" DataType="DT_BOOL" />
        <Column Name="include_nonoperational_hours" DataType="DT_BOOL" />

        <Column Name="created_by.email_id" Label="created_by_email_id" DataType="DT_WSTR" Length="68" />
        <Column Name="created_by.is_technician" Label="created_by_is_technician" DataType="DT_BOOL" />
        <Column Name="created_by.sms_mail" Label="created_by_sms_mail" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.phone" Label="created_by_phone" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.name" Label="created_by_name" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.mobile" Label="created_by_mobile" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.id" Label="created_by_id" DataType="DT_WSTR" Length="64" />
        <Column Name="created_by.photo_url" Label="created_by_photo_url" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.is_vip_user" Label="created_by_is_vip_user" DataType="DT_BOOL" />

        <Column Name="mark_first_response" DataType="DT_BOOL" />
      </OutputColumns>
    </EndPoint>

    <EndPoint Name="RequestTaskWorklogTemplate" >
      <OutputColumns>
        <Column Name="id" DataType="DT_WSTR" Length="180" Key="True" />
        <Column Name="description" DataType="DT_WSTR" Length="64" />
        <Column Name="other_charge" DataType="DT_R8" />
        <Column Name="total_charge" DataType="DT_R8" />
        <Column Name="tech_charge" DataType="DT_R8" />

        <Column Name="time_spent.hours" Label="time_spent_hours" DataType="DT_I8" />
        <Column Name="time_spent.minutes" Label="time_spent_minutes" DataType="DT_I8" />
        <Column Name="start_time.display_value" Label="start_time_display_value" DataType="DT_WSTR" Length="84" />
        <Column Name="start_time.value" Label="start_time_value" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />

        <Column Name="end_time.display_value" Label="end_time_display_value" DataType="DT_WSTR" Length="84" />
        <Column Name="end_time.value" Label="end_time_value" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />

        <Column Name="worklog_type.name" Label="worklog_type_name" DataType="DT_WSTR" Length="36" />
        <Column Name="worklog_type.id" Label="worklog_type_id" DataType="DT_WSTR" Length="64" />

        <Column Name="recorded_time.display_value" Label="recorded_time_display_value" DataType="DT_WSTR" Length="84" />
        <Column Name="recorded_time.value" Label="recorded_time_value" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />

        <Column Name="owner.email_id" Label="owner_email_id" DataType="DT_WSTR" Length="68" />
        <Column Name="owner.is_technician" Label="owner_is_technician" DataType="DT_BOOL" />
        <Column Name="owner.sms_mail" Label="owner_sms_mail" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.phone" Label="owner_phone" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.name" Label="owner_name" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.mobile" Label="owner_mobile" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.id" Label="owner_id" DataType="DT_WSTR" Length="64" />
        <Column Name="owner.photo_url" Label="owner_photo_url" DataType="DT_WSTR" Length="255" />
        <Column Name="owner.is_vip_user" Label="owner_is_vip_user" DataType="DT_BOOL" />
        <Column Name="include_nonoperational_hours" DataType="DT_BOOL" />

        <Column Name="created_by.email_id" Label="created_by_email_id" DataType="DT_WSTR" Length="68" />
        <Column Name="created_by.is_technician" Label="created_by_is_technician" DataType="DT_BOOL" />
        <Column Name="created_by.sms_mail" Label="created_by_sms_mail" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.phone" Label="created_by_phone" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.name" Label="created_by_name" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.mobile" Label="created_by_mobile" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.id" Label="created_by_id" DataType="DT_WSTR" Length="64" />
        <Column Name="created_by.photo_url" Label="created_by_photo_url" DataType="DT_WSTR" Length="255" />
        <Column Name="created_by.is_vip_user" Label="created_by_is_vip_user" DataType="DT_BOOL" />

        <Column Name="mark_first_response" DataType="DT_BOOL" />
      </OutputColumns>
    </EndPoint>
    
    <EndPoint Name="PaginatedRequestTemplate" Template="RequestTemplate" >
      <Params>
        <Param Name="PagingMode" Type="Property" Value="ByUrlPath" />
        <Param Name="PagingByUrlAttributeName" Type="Property" Value="[$page$]" />
        <Param Name="RowsPerPage" Type="Property" Value="100" />
        <Param Name="PagingIncrementBy" Type="Property" Value="100" ValueTemplate="[$RowsPerPage$]" />
        <Param Name="NextUrlEndIndicator" Type="Property" Value="false" />
        <Param Name="StopIndicatorAttributeOrExpr" Type="Property" Value="$.list_info.has_more_rows" />
      </Params>
    </EndPoint>

    <EndPoint Name="PaginatedRequestTaskTemplate" Template="RequestTaskTemplate" >
      <Params>
        <Param Name="PagingMode" Type="Property" Value="ByUrlPath" />
        <Param Name="PagingByUrlAttributeName" Type="Property" Value="[$page$]" />
        <Param Name="RowsPerPage" Type="Property" Value="100" />
        <Param Name="PagingIncrementBy" Type="Property" Value="100" ValueTemplate="[$RowsPerPage$]" />
        <Param Name="NextUrlEndIndicator" Type="Property" Value="false" />
        <Param Name="StopIndicatorAttributeOrExpr" Type="Property" Value="$.list_info.has_more_rows" />
      </Params>
    </EndPoint>

    <EndPoint Name="PaginatedRequestTaskCommentTemplate" Template="RequestTaskCommentTemplate" >
      <Params>
        <Param Name="PagingMode" Type="Property" Value="ByUrlPath" />
        <Param Name="PagingByUrlAttributeName" Type="Property" Value="[$page$]" />
        <Param Name="RowsPerPage" Type="Property" Value="100" />
        <Param Name="PagingIncrementBy" Type="Property" Value="100" ValueTemplate="[$RowsPerPage$]" />
        <Param Name="NextUrlEndIndicator" Type="Property" Value="false" />
        <Param Name="StopIndicatorAttributeOrExpr" Type="Property" Value="$.list_info.has_more_rows" />
      </Params>
    </EndPoint>

    <EndPoint Name="PaginatedRequestWorklogTemplate" Template="RequestWorklogTemplate" >
      <Params>
        <Param Name="PagingMode" Type="Property" Value="ByUrlPath" />
        <Param Name="PagingByUrlAttributeName" Type="Property" Value="[$page$]" />
        <Param Name="RowsPerPage" Type="Property" Value="100" />
        <Param Name="PagingIncrementBy" Type="Property" Value="100" ValueTemplate="[$RowsPerPage$]" />
        <Param Name="NextUrlEndIndicator" Type="Property" Value="false" />
        <Param Name="StopIndicatorAttributeOrExpr" Type="Property" Value="$.list_info.has_more_rows" />
      </Params>
    </EndPoint>

    <EndPoint Name="PaginatedRequestNoteTemplate" Template="RequestNoteTemplate" >
      <Params>
        <Param Name="PagingMode" Type="Property" Value="ByUrlPath" />
        <Param Name="PagingByUrlAttributeName" Type="Property" Value="[$page$]" />
        <Param Name="RowsPerPage" Type="Property" Value="100" />
        <Param Name="PagingIncrementBy" Type="Property" Value="100" ValueTemplate="[$RowsPerPage$]" />
        <Param Name="NextUrlEndIndicator" Type="Property" Value="false" />
        <Param Name="StopIndicatorAttributeOrExpr" Type="Property" Value="$.list_info.has_more_rows" />
      </Params>
    </EndPoint>
    
    <EndPoint Name="PaginatedRequestTaskWorklogTemplate" Template="RequestTaskWorklogTemplate" >
      <Params>
        <Param Name="PagingMode" Type="Property" Value="ByUrlPath" />
        <Param Name="PagingByUrlAttributeName" Type="Property" Value="[$page$]" />
        <Param Name="RowsPerPage" Type="Property" Value="100" />
        <Param Name="PagingIncrementBy" Type="Property" Value="100" ValueTemplate="[$RowsPerPage$]" />
        <Param Name="NextUrlEndIndicator" Type="Property" Value="false" />
        <Param Name="StopIndicatorAttributeOrExpr" Type="Property" Value="$.list_info.has_more_rows" />
      </Params>
    </EndPoint>    
  </Template>
	
  <EndPoints>
		<EndPoint Name="get_requests" Label="Get Requests" Template="PaginatedRequestTemplate"
		Url="/requests?input_data=%7B%22list_info%22%3A%7B%22start_index%22%3A%22[$page$]%22%2C%22row_count%22%3A[$RowsPerPage$]%2C%22sort_field%22%3A%22id%22%2C%22sort_order%22%3A%22asc%22%2C%22fields_required%22%20%3A%20%5B%22responded_time%22%2C%22completed_time%22%2C%22sla%22%2C%22mode%22%2C%22due_by_time%22%2C%22impact%22%2C%22id%22%2C%22department%22%2C%22subject%22%2C%22description%22%2C%22resolution%22%2C%22time_elapsed%22%2C%22site%22%2C%22update_reason%22%2C%22status%22%2C%22template%22%2C%22is_overdue%22%2C%22is_first_response_overdue%22%2C%22is_escalated%22%2C%22is_fcr%22%2C%22resolved_time%22%2C%22last_updated_time%22%2C%22service_cost%22%2C%22first_response_due_by_time%22%2C%22is_service_request%22%2C%22item%22%2C%22urgency%22%2C%22request_type%22%2C%22assets%22%2C%22has_attachments%22%2C%22has_notes%22%2C%22has_project%22%2C%22has_problem%22%2C%22has_request_initiated_change%22%2C%22has_change_initiated_request%22%2C%22is_reopened%22%2C%22status_change_comments%22%2C%22on_behalf_of%22%2C%22notification_status%22%2C%22approval_status%22%2C%22assigned_time%22%2C%22unreplied_count%22%2C%22created_by%22%2C%22scheduled_start_time%22%2C%22scheduled_end_time%22%2C%22group%22%2C%22technician%22%2C%22priority%22%2C%22category%22%2C%22subcategory%22%2C%22total_cost%22%2C%22deleted_time%22%2C%22display_id%22%2C%22requester%22%2C%22created_time%22%5D%2C%22get_total_count%22%3Atrue%7D%7D" 
		Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json" 
		Filter="$.requests[*]">
			<Params>
				<Param Name="MetaDetectionOrder" Type="Property" Value="Default" Hidden="True" />
			</Params>
		</EndPoint>
		
    <EndPoint Name="get_request_details" Label="Get Request Details" Template="RequestTemplate" Url="/requests/[$RequestId$]" 
		Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json" Filter="$.request" IncludeParentColumns="True">
			<Params>
				<Param Name="RequestId" Required="True" IsKey="True" ReadAs="id" />
				<Param Name="MetaDetectionOrder" Type="Property" Value="Default" Hidden="True" />
        <Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
			</Params>
		
		</EndPoint>
    
		<EndPoint Name="delete_request" Label="Delete Request" Url="/requests/[$RequestId$]" 
		Method="DELETE" Headers="Accept:application/vnd.manageengine.sdp.v3+json" Filter="$.response_status" IncludeParentColumns="True">
			<Params>
				<Param Name="RequestId" Required="True" IsKey="True" ReadAs="id" />
				<Param Name="MetaDetectionOrder" Type="Property" Value="Default" Hidden="True" />
        <Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
			</Params>
      <OutputColumns>
				<Column Name="status_code" DataType="DT_I4"/>
				<Column Name="status" DataType="DT_WSTR" Length="180" />
      </OutputColumns>
    </EndPoint>
    
		<EndPoint Name="get_testdata" Label="Test Connection" 
		Url="/requests" 
		Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json" 
		Filter="$.requests[*]">
			<Params>
			</Params>
		</EndPoint>
		
		<EndPoint Name="get_request_tasks" Label="Get Request Tasks"  Template="PaginatedRequestTaskTemplate"
		Url="/requests/[$RequestId$]/tasks?input_data=%7B%22list_info%22:%7B%22row_count%22:[$RowsPerPage$],%22start_index%22:[$page$]%7D%7D" 
		Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json" 
		Filter="$.tasks[*]">
			<Params>
				<Param Name="RequestId" Required="True" ReadAs="request_id" />
        <Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
			</Params>
			
		</EndPoint>
		<EndPoint Name="get_request_task_details" Label="Get Request Task Details"  Template="RequestTaskTemplate"
		Url="/requests/[$RequestId$]/tasks/[$TaskId$]" 
		Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json" 
		Filter="$.task" IncludeParentColumns="True">
			<Params>
				<Param Name="RequestId" Required="True" IsKey="True" ReadAs="request_id" />
				<Param Name="TaskId" Required="True" IsKey="True" ReadAs="id" />
        <Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
			</Params>
		</EndPoint>
		
		<EndPoint Name="get_request_task_comments" Label="Get Request Task Comments"   Template="PaginatedRequestTaskCommentTemplate"
		Url="/requests/[$RequestId$]/tasks/[$TaskId$]/comments?input_data=%7B%22list_info%22:%7B%22row_count%22:[$RowsPerPage$],%22start_index%22:[$page$]%7D%7D" 
		Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json" 
		Filter="$.comments[*]">
			<Params>
				<Param Name="RequestId" Required="True" IsKey="True" ReadAs="request_id" />
				<Param Name="TaskId" Required="True" IsKey="True" ReadAs="task_id" />
        <Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
			</Params>
		</EndPoint>
    
		<EndPoint Name="get_request_task_comment_details" Label="Get Request Task Comment Details" Template="RequestTaskCommentTemplate" 
		Url="/requests/[$RequestId$]/tasks/[$TaskId$]/comments/[$CommentId$]" 
		Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json" 
		Filter="$.task_comment" IncludeParentColumns="True">
			<Params>
				<Param Name="RequestId" Required="True" IsKey="True" ReadAs="request_id" />
				<Param Name="TaskId" Required="True" IsKey="True" ReadAs="task_id" />
				<Param Name="CommentId" Required="True" IsKey="True" ReadAs="id" />
        <Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
			</Params>
		</EndPoint>
    
    <EndPoint Name="get_request_notes" Label="Get Request Notes"  Template="PaginatedRequestNoteTemplate"
		Url="/requests/[$RequestId$]/notes?input_data=%7B%22list_info%22:%7B%22row_count%22:[$RowsPerPage$],%22start_index%22:[$page$]%7D%7D"
		Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
		Filter="$.notes[*]">
      <Params>
        <Param Name="RequestId" Required="True" IsKey="True" ReadAs="request_id" />
        <Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
      </Params>

    </EndPoint>
    
    <EndPoint Name="get_request_note_details" Label="Get Request Note Details"  Template="RequestNoteTemplate"
		Url="/requests/[$RequestId$]/notes/[$NoteId$]"
		Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
		Filter="$.note" IncludeParentColumns="True">
      <Params>
        <Param Name="RequestId" Required="True" IsKey="True" ReadAs="request_id" />
        <Param Name="NoteId" Required="True" IsKey="True" ReadAs="id" />
        <Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
      </Params>
    </EndPoint>

    <EndPoint Name="get_request_worklogs" Label="Get Request Worklogs"  Template="PaginatedRequestWorklogTemplate"
		Url="/requests/[$RequestId$]/worklogs?input_data=%7B%22list_info%22:%7B%22row_count%22:[$RowsPerPage$],%22start_index%22:[$page$]%7D%7D"
		Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
		Filter="$.worklogs[*]">
      <Params>
        <Param Name="RequestId" Required="True" IsKey="True" ReadAs="request_id" />
        <Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
      </Params>
    </EndPoint>

    <EndPoint Name="get_request_worklog_details" Label="Get Request Worklog Details"  Template="RequestWorklogTemplate"
		Url="/requests/[$RequestId$]/worklogs/[$WorklogId$]"
		Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
		Filter="$.worklog" IncludeParentColumns="True">
      <Params>
        <Param Name="RequestId" Required="True" IsKey="True" ReadAs="request_id" />
        <Param Name="WorklogId" Required="True" IsKey="True" ReadAs="id" />
        <Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
      </Params>
    </EndPoint>

    <EndPoint Name="get_request_task_worklogs" Label="Get Request Task Worklogs"  Template="PaginatedRequestTaskWorklogTemplate"
		Url="/requests/[$RequestId$]/tasks/[$TaskId$]/worklogs?input_data=%7B%22list_info%22:%7B%22row_count%22:[$RowsPerPage$],%22start_index%22:[$page$]%7D%7D"
		Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
		Filter="$.worklogs[*]">
      <Params>
        <Param Name="RequestId" Required="True" />
        <Param Name="TaskId" Required="True" />
        <Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
      </Params>
    </EndPoint>

    <EndPoint Name="get_request_task_worklog_details" Label="Get Request Task Worklog Details"  Template="RequestTaskWorklogTemplate"
		Url="/requests/[$RequestId$]/tasks/[$TaskId$]/worklogs/[$WorklogId$]"
		Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
		Filter="$.worklog" IncludeParentColumns="True">
      <Params>
        <Param Name="RequestId" Required="True" />
        <Param Name="TaskId" Required="True" />
        <Param Name="WorklogId" Required="True"/>
        <Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
      </Params>
    </EndPoint>

  </EndPoints>

	<Tables>  
		<Table Name="Requests" SelectEndPoint="get_requests" LookupEndPoint="get_request_details" DeleteEndPoint="delete_request"/>
	</Tables>
  
  <Examples>
		<Example Group="ODBC" Label="List requests" Desc="This example shows how to list requests." >
			<Code>
				<![CDATA[SELECT * FROM Requests]]>
			</Code>
		</Example>
		<Example Group="ODBC" Label="Read request details by ID" Desc="This example shows how to read extended information about a single request" >
			<Code>
				<![CDATA[SELECT * FROM Requests Where id=111112345]]>
			</Code>
		</Example>
    <Example Group="ODBC" Label="Delete request" Desc="This example shows how to delete a request by ID." >
      <Code>
        <![CDATA[DELETE FROM Requests Where id=111112345]]>
      </Code>
    </Example>    
		<Example Group="ODBC" Label="List request tasks" Desc="This example shows how to read all tasks for a single Request ID" >
			<Code>
				<![CDATA[SELECT * FROM get_Request_Tasks WITH (RequestId=111112345) ]]>
			</Code>
		</Example>
		<Example Group="ODBC" Label="Read request task details" Desc="This example shows how to read request task details by single Request ID and Task ID " >
			<Code>
				<![CDATA[SELECT * FROM get_Request_Task_Details  (RequestId=111112345, TaskId=222212345) ]]>
			</Code>
		</Example>    
    <Example Group="ODBC" Label="List request task comments" Desc="This example shows how to read all comment for specific task" >
      <Code>
        <![CDATA[SELECT * FROM get_Request_Task_Comments  (RequestId=111112345, TaskId=222212345)]]>
      </Code>
    </Example>
    <Example Group="ODBC" Label="Read request task comment details" Desc="This example shows how to read a single comment details for a specific task" >
      <Code>
        <![CDATA[SELECT * FROM get_Request_Task_Comment_Details (RequestId=111112345, TaskId=222212345, CommentId=333312345)]]>
      </Code>
    </Example>
    <Example Group="ODBC" Label="List request notes" Desc="This example shows how to read all notes for a single Request ID" >
      <Code>
        <![CDATA[SELECT * FROM get_Request_Notes WITH (RequestId=111112345) ]]>
      </Code>
    </Example>
    <Example Group="ODBC" Label="Read request note details" Desc="This example shows how to read request note details by single Request ID and Note ID " >
      <Code>
        <![CDATA[SELECT * FROM get_Request_Note_Details (RequestId=111112345, NoteId=222212345) ]]>
      </Code>
    </Example>
    <Example Group="ODBC" Label="List request worklog" Desc="This example shows how to read all worklogs for a single Request ID" >
      <Code>
        <![CDATA[SELECT * FROM get_Request_Worklogs WITH (RequestId=111112345) ]]>
      </Code>
    </Example>
    <Example Group="ODBC" Label="Read request worklog details" Desc="This example shows how to read request worklog details by single Request ID and Worklog ID" >
      <Code>
        <![CDATA[SELECT * FROM get_Request_Worklog_Details (RequestId=111112345, WorklogId=222212345) ]]>
      </Code>
    </Example>
    <Example Group="ODBC" Label="List request task worklog" Desc="This example shows how to read all worklogs for a single Request Task ID" >
      <Code>
        <![CDATA[SELECT * FROM get_Request_Task_Worklogs WITH (RequestId=111112345, TaskId=22222345) ]]>
      </Code>
    </Example>
    <Example Group="ODBC" Label="Read request task worklog details" Desc="This example shows how to read request task worklog details by single Request Task ID and Worklog ID" >
      <Code>
        <![CDATA[SELECT * FROM get_Request_Task_Worklog_Details (RequestId=111112345, TaskId=22222345, WorklogId=333312345) ]]>
      </Code>
    </Example>
  </Examples>

</ApiConfig>