ManagedEngine ServiceDesk Plus (Zoho) Connector - Source Code
<?xml version="1.0" encoding="utf-8"?>
<ApiConfig Name="ManagedEngine ServiceDesk Plus (Zoho)"
EngineVersion="16"
Version="2"
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="2024-06-30">Added many new tables / endpoints for Projects, Members, Milestones, Changes, Assests, Problems, Contracts and PurchaseOrders</Change>
<Change Date="2022-05-19">Initial version</Change>
</VersionHistory>
<ServiceUrls>
<ServiceUrl Name="United States - Data centre" Url="https://sdpondemand.manageengine.com/api/v3"/>
<ServiceUrl Name="United States - Data centre (Using App Name)" Url="https://sdpondemand.manageengine.com/app/{enter-your-app-url-name}/api/v3" Desc="Enter your App URL Name like described here https://www.manageengine.com/products/service-desk/sdpod-v3-api/getting-started/portals.html"/>
<ServiceUrl Name="Canada - Data centre" Url="https://servicedeskplus.ca/api/v3"/>
<ServiceUrl Name="Europe - Data centre" Url="https://sdpondemand.manageengine.eu/api/v3"/>
<ServiceUrl Name="India - Data centre" Url="https://sdpondemand.manageengine.in/api/v3"/>
<ServiceUrl Name="Australia - Data centre" Url="https://servicedeskplus.net.au/api/v3"/>
<ServiceUrl Name="Japan - Data centre" Url="https://servicedeskplus.jp/api/v3"/>
<ServiceUrl Name="United Kingdom - Data centre" Url="https://servicedeskplus.uk/api/v3"/>
<ServiceUrl Name="Saudi Arabia - Data centre" Url="https://servicedeskplus.sa/api/v3"/>
<ServiceUrl Name="China - Data centre" Url="https://servicedeskplus.cn/api/v3"/>
<ServiceUrl Name="General - Data centre" Url="https://sdpondemand.manageengine.com/api/v3"/>
<ServiceUrl Name="General - Data centre (Using App Name)" Url="https://sdpondemand.manageengine.com/app/{enter-your-appname}/api/v3" Desc="Enter your App URL Name like described here https://www.manageengine.com/products/service-desk/sdpod-v3-api/getting-started/portals.html"/>
</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&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="BaseTemplate">
<OutputColumns>
</OutputColumns>
</EndPoint>
<EndPoint Name="RequestTemplate" Template="BaseTemplate">
<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="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="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="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" />
<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="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="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" />
</OutputColumns>
</EndPoint>
<EndPoint Name="TaskTemplate" Template="BaseTemplate" >
<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_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" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />
<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" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />
<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="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" 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="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" 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" />
<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="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="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="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" />
</OutputColumns>
</EndPoint>
<EndPoint Name="TaskCommentTemplate" Template="BaseTemplate">
<OutputColumns>
<Column Name="id" DataType="DT_WSTR" Length="180" />
<Column Name="comment" DataType="DT_WSTR" Length="4000" />
<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="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="210" />
<Column Name="created_time.value" Label="created_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="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" />
</OutputColumns>
</EndPoint>
<EndPoint Name="NoteTemplate" Template="BaseTemplate">
<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="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_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="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="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" />
</OutputColumns>
</EndPoint>
<EndPoint Name="ChangeTemplate" Template="BaseTemplate">
<OutputColumns>
<Column Name="id" Label="id" DataType="DT_WSTR" Length="50" />
<Column Name="title" Label="title" DataType="DT_WSTR" Length="500" />
<Column Name="template.inactive" Label="template_inactive" DataType="DT_BOOL" />
<Column Name="template.name" Label="template_name" DataType="DT_WSTR" Length="255" />
<Column Name="template.id" Label="template_id" DataType="DT_WSTR" Length="100" />
<Column Name="display_id.display_value" Label="display_id_display_value" DataType="DT_WSTR" Length="20" />
<Column Name="display_id.value" Label="display_id_value" DataType="DT_WSTR" Length="8" />
<Column Name="emergency" Label="emergency" DataType="DT_BOOL" />
<Column Name="description" Label="description" DataType="DT_WSTR" Length="2000" />
<Column Name="change_type.color" Label="change_type_color" DataType="DT_WSTR" Length="28" />
<Column Name="change_type.pre_approved" Label="change_type_pre_approved" DataType="DT_BOOL" />
<Column Name="change_type.name" Label="change_type_name" DataType="DT_WSTR" Length="255" />
<Column Name="change_type.id" Label="change_type_id" DataType="DT_WSTR" Length="50" />
<Column Name="change_owner.email_id" Label="change_owner_email_id" DataType="DT_WSTR" Length="255" />
<Column Name="change_owner.cost_per_hour" Label="change_owner_cost_per_hour" DataType="DT_R8" />
<Column Name="change_owner.phone" Label="change_owner_phone" DataType="DT_WSTR" Length="40" />
<Column Name="change_owner.name" Label="change_owner_name" DataType="DT_WSTR" Length="255" />
<Column Name="change_owner.mobile" Label="change_owner_mobile" DataType="DT_WSTR" Length="44" />
<Column Name="change_owner.id" Label="change_owner_id" DataType="DT_WSTR" Length="50" />
<Column Name="change_owner.photo_url" Label="change_owner_photo_url" DataType="DT_WSTR" Length="56" />
<Column Name="change_owner.sms_mail_id" Label="change_owner_sms_mail_id" DataType="DT_WSTR" Length="50" />
<Column Name="urgency.name" Label="urgency_name" DataType="DT_WSTR" Length="255" />
<Column Name="urgency.id" Label="urgency_id" DataType="DT_WSTR" Length="50" />
<Column Name="workflow_instance_details.id" Label="workflow_instance_details_id" DataType="DT_WSTR" Length="50" />
<Column Name="workflow_instance_details.status.name" Label="workflow_instance_details_status_name" DataType="DT_WSTR" Length="255" />
<Column Name="workflow_instance_details.status.id" Label="workflow_instance_details_status_id" DataType="DT_WSTR" Length="50" />
<Column Name="change_requester.email_id" Label="change_requester_email_id" DataType="DT_WSTR" Length="68" />
<Column Name="change_requester.is_technician" Label="change_requester_is_technician" DataType="DT_BOOL" />
<Column Name="change_requester.sms_mail" Label="change_requester_sms_mail" DataType="DT_WSTR" Length="72" />
<Column Name="change_requester.phone" Label="change_requester_phone" DataType="DT_WSTR" Length="40" />
<Column Name="change_requester.name" Label="change_requester_name" DataType="DT_WSTR" Length="255" />
<Column Name="change_requester.mobile" Label="change_requester_mobile" DataType="DT_WSTR" Length="44" />
<Column Name="change_requester.id" Label="change_requester_id" DataType="DT_WSTR" Length="50" />
<Column Name="change_requester.photo_url" Label="change_requester_photo_url" DataType="DT_WSTR" Length="56" />
<Column Name="change_requester.is_vip_user" Label="change_requester_is_vip_user" DataType="DT_BOOL" />
<Column Name="group.deleted" Label="group_deleted" 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="50" />
<Column Name="item.name" Label="item_name" DataType="DT_WSTR" Length="255" />
<Column Name="item.id" Label="item.id" DataType="DT_WSTR" Length="50" />
<Column Name="workflow.validated" Label="workflow.validated" DataType="DT_BOOL" />
<Column Name="workflow.name" Label="workflow_name" DataType="DT_WSTR" Length="255" />
<Column Name="workflow.id" Label="workflow.id" DataType="DT_WSTR" Length="50" />
<Column Name="approval_status.name" Label="approval_status_name" DataType="DT_WSTR" Length="255" />
<Column Name="approval_status.id" Label="approval_status.id" DataType="DT_WSTR" Length="50" />
<Column Name="change_manager.email_id" Label="change_manager_email_id" DataType="DT_WSTR" Length="52" />
<Column Name="change_manager.cost_per_hour" Label="change_manager_cost_per_hour" DataType="DT_R8" />
<Column Name="change_manager.phone" Label="change_manager_phone" DataType="DT_WSTR" Length="40" />
<Column Name="change_manager.name" Label="change_manager_name" DataType="DT_WSTR" Length="255" />
<Column Name="change_manager.mobile" Label="change_manager_mobile" DataType="DT_WSTR" Length="44" />
<Column Name="change_manager.id" Label="change_manager_id" DataType="DT_WSTR" Length="50" />
<Column Name="change_manager.photo_url" Label="change_manager_photo_url" DataType="DT_WSTR" Length="56" />
<Column Name="change_manager.sms_mail_id" Label="change_manager_sms_mail_id" DataType="DT_WSTR" Length="50" />
<Column Name="impact.name" Label="impact_name" DataType="DT_WSTR" Length="255" />
<Column Name="impact.id" Label="impact_id" DataType="DT_WSTR" Length="50" />
<Column Name="retrospective" Label="retrospective" DataType="DT_BOOL" />
<Column Name="delete_pre_template_tasks" Label="delete_pre_template_tasks" DataType="DT_BOOL" />
<Column Name="priority.color" Label="priority_color" DataType="DT_WSTR" Length="28" />
<Column Name="priority.name" Label="priority_name" DataType="DT_WSTR" Length="255" />
<Column Name="priority.id" Label="priority_id" DataType="DT_WSTR" Length="50" />
<Column Name="scheduled_end_time.display_value" Label="scheduled_end_time_display_value" DataType="DT_WSTR" Length="84" />
<Column Name="scheduled_end_time.value" Label="scheduled_end_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />
<Column Name="releases.display_id.display_value" Label="releases_display_id_display_value" DataType="DT_WSTR" Length="20" />
<Column Name="releases.display_id.value" Label="releases_display_id_value" DataType="DT_WSTR" Length="8" />
<Column Name="releases.id" Label="releases_id" DataType="DT_WSTR" Length="50" />
<Column Name="releases.title" Label="releases_title" DataType="DT_WSTR" Length="40" />
<Column Name="site.deleted" Label="site.deleted" DataType="DT_BOOL" />
<Column Name="site.name" Label="site_name" DataType="DT_WSTR" Length="255" />
<Column Name="site.id" Label="site_id" DataType="DT_WSTR" Length="50" />
<Column Name="completed_time" Label="completed_time" DataType="DT_WSTR" Length="1020" />
<Column Name="reason_for_change.name" Label="reason_for_change_name" DataType="DT_WSTR" Length="255" />
<Column Name="reason_for_change.id" Label="reason_for_change_id" DataType="DT_WSTR" Length="50" />
<Column Name="stage.internal_name" Label="stage_internal_name" DataType="DT_WSTR" Length="255" />
<Column Name="stage.stage_index" Label="stage_stage_index" DataType="DT_I8" />
<Column Name="stage.name" Label="stage_name" DataType="DT_WSTR" Length="255" />
<Column Name="stage.id" Label="stage_id" DataType="DT_WSTR" Length="50" />
<!--
<Column Name="udf_fields.udf_ref1.name" Label="udf_fields.udf_ref1_name" DataType="DT_WSTR" Length="255" />
<Column Name="udf_fields.udf_ref1.id" Label="udf_fields.udf_ref1_id" DataType="DT_WSTR" Length="50" />
<Column Name="udf_fields.udf_boolean1" Label="udf_fields.udf_boolean1" DataType="DT_BOOL" />
<Column Name="udf_fields.udf_long1" Label="udf_fields.udf_long1" DataType="DT_WSTR" Length="50" />
<Column Name="udf_fields.udf_date1.display_value" Label="udf_fields.udf_date1_display_value" DataType="DT_WSTR" Length="84" />
<Column Name="udf_fields.udf_date1.value" Label="udf_fields.udf_date1_value" DataType="DT_WSTR" Length="52" />
<Column Name="udf_fields.udf_double1" Label="udf_fields.udf_double1" DataType="DT_WSTR" Length="50" />
<Column Name="udf_fields.udf_char1" Label="udf_fields.udf_char1" DataType="DT_WSTR" Length="56" />
<Column Name="udf_fields.deptheadid.name" Label="udf_fields.deptheadid_name" DataType="DT_WSTR" Length="255" />
<Column Name="udf_fields.deptheadid.id" Label="udf_fields.deptheadid_id" DataType="DT_WSTR" Length="50" />
-->
<Column Name="comment" Label="comment" DataType="DT_WSTR" Length="48" />
<Column Name="risk.name" Label="risk_name" DataType="DT_WSTR" Length="255" />
<Column Name="risk.id" Label="risk_id" DataType="DT_WSTR" Length="50" />
<Column Name="category.deleted" Label="category_deleted" DataType="DT_BOOL" />
<Column Name="category.name" Label="category_name" DataType="DT_WSTR" Length="255" />
<Column Name="category.id" Label="category_id" DataType="DT_WSTR" Length="50" />
<Column Name="subcategory.name" Label="subcategory_name" DataType="DT_WSTR" Length="255" />
<Column Name="subcategory.id" Label="subcategory_id" DataType="DT_WSTR" Length="50" />
<Column Name="deleted_time" Label="deleted_time" DataType="DT_WSTR" Length="1020" />
<Column Name="notes_present" Label="notes_present" DataType="DT_BOOL" />
<Column Name="scheduled_start_time.display_value" Label="scheduled_start_time_display_value" DataType="DT_WSTR" Length="84" />
<Column Name="scheduled_start_time.value" Label="scheduled_start_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />
<Column Name="status.internal_name" Label="status_internal_name" DataType="DT_WSTR" Length="255" />
<Column Name="status.stage.id" Label="status_stage_id" DataType="DT_WSTR" Length="50" />
<Column Name="status.name" Label="status_name" DataType="DT_WSTR" Length="255" />
<Column Name="status.id" Label="status_id" DataType="DT_WSTR" Length="50" />
<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="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="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" />
</OutputColumns>
</EndPoint>
<EndPoint Name="WorklogTemplate" Template="BaseTemplate">
<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" 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" 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" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />
<Column Name="include_nonoperational_hours" DataType="DT_BOOL" />
<Column Name="mark_first_response" DataType="DT_BOOL" />
<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="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="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" />
</OutputColumns>
</EndPoint>
<EndPoint Name="TaskWorklogTemplate" Template="BaseTemplate">
<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" 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" 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" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />
<Column Name="mark_first_response" DataType="DT_BOOL" />
<!--common-->
<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_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="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" />
</OutputColumns>
</EndPoint>
<EndPoint Name="AssetTemplate" Template="BaseTemplate">
<OutputColumns>
<Column Name="id" DataType="DT_WSTR" Label="id" Length="100" />
<Column Name="name" DataType="DT_WSTR" Label="name" Length="200" />
<Column Name="loan.start_time.display_value" DataType="DT_WSTR" Label="loan_start_time_display_value" Length="100" />
<Column Name="loan.start_time.value" Label="loan_start_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>
<Column Name="loan.id" DataType="DT_WSTR" Label="loan_id" Length="100" />
<Column Name="loan.returned_time.display_value" DataType="DT_WSTR" Label="loan_returned_time_display_value" Length="100" />
<Column Name="loan.returned_time.value" Label="loan_returned_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>
<Column Name="loan.barcode" DataType="DT_WSTR" Label="loan_barcode" Length="50" />
<Column Name="loan.due_by_time.display_value" DataType="DT_WSTR" Label="loan_due_by_time_display_value" Length="100" />
<Column Name="loan.due_by_time.value" Label="loan_due_by_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>
<Column Name="loan.loan_id.display_value" DataType="DT_WSTR" Label="loan_loan_id_display_value" Length="50" />
<Column Name="loan.loan_id.value" DataType="DT_WSTR" Label="loan_loan_id_value" Length="50" />
<Column Name="retain_user_site" DataType="DT_BOOL" Label="retain_user_site" />
<Column Name="type.name" DataType="DT_WSTR" Label="type_name" Length="50" />
<Column Name="type.id" DataType="DT_WSTR" Label="type_id" Length="100" />
<Column Name="purchase_cost" DataType="DT_R8" Label="purchase_cost" />
<Column Name="state.name" DataType="DT_WSTR" Label="state_name" Length="50" />
<Column Name="state.description" DataType="DT_WSTR" Label="state_description" Length="100" />
<Column Name="state.id" DataType="DT_WSTR" Label="state_id" Length="100" />
<Column Name="barcode" DataType="DT_WSTR" Label="barcode" Length="50" />
<Column Name="product.part_no" DataType="DT_WSTR" Label="product_part_no" Length="50" />
<Column Name="product.name" DataType="DT_WSTR" Label="product_name" Length="50" />
<Column Name="product.id" DataType="DT_WSTR" Label="product_id" Length="100" />
<Column Name="product.manufacturer" DataType="DT_WSTR" Label="product_manufacturer" Length="100" />
<Column Name="site.deleted" DataType="DT_BOOL" Label="site_deleted" />
<Column Name="site.name" DataType="DT_WSTR" Label="site_name" Length="50" />
<Column Name="site.id" DataType="DT_WSTR" Label="site_id" Length="100" />
<Column Name="product_type.image" DataType="DT_WSTR" Label="product_type_image" Length="50" />
<Column Name="product_type.name" DataType="DT_WSTR" Label="product_type_name" Length="50" />
<Column Name="product_type.id" DataType="DT_WSTR" Label="product_type_id" Length="100" />
<Column Name="location" DataType="DT_WSTR" Label="location" Length="100" />
<Column Name="is_loanable" DataType="DT_BOOL" Label="is_loanable" />
<Column Name="category.name" DataType="DT_WSTR" Label="category_name" Length="50" />
<Column Name="category.description" DataType="DT_WSTR" Label="category_description" Length="100" />
<Column Name="category.id" DataType="DT_WSTR" Label="category_id" Length="100" />
<Column Name="state_history_comments" DataType="DT_WSTR" Label="state_history_comments" Length="2000" />
<!--common-->
<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_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="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" />
</OutputColumns>
</EndPoint>
<EndPoint Name="ProjectTemplate" Template="BaseTemplate">
<OutputColumns>
<Column Name="id" DataType="DT_WSTR" Label="id" Length="100" />
<Column Name="title" DataType="DT_WSTR" Label="title" Length="200" />
<Column Name="project_template.name" DataType="DT_WSTR" Label="project_template_name" Length="50" />
<Column Name="project_template.id" DataType="DT_WSTR" Label="project_template_id" Length="100" />
<Column Name="project_template.title" DataType="DT_WSTR" Label="project_template_title" Length="50" />
<Column Name="project_template.active" DataType="DT_BOOL" Label="project_template_active" />
<Column Name="display_id.display_value" DataType="DT_WSTR" Label="display_id_display_value" Length="50" />
<Column Name="display_id.value" DataType="DT_WSTR" Label="display_id_value" Length="50" />
<Column Name="percentage_completion" DataType="DT_WSTR" Label="percentage_completion" Length="50" />
<Column Name="description" DataType="DT_WSTR" Label="description" Length="2000" />
<Column Name="actual_hours" DataType="DT_WSTR" Label="actual_hours" Length="50" />
<Column Name="actual_end_time.display_value" DataType="DT_WSTR" Label="actual_end_time_display_value" Length="100" />
<Column Name="actual_end_time.value" Label="actual_end_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>
<Column Name="actual_start_time.display_value" DataType="DT_WSTR" Label="actual_start_time_display_value" Length="100" />
<Column Name="actual_start_time.value" Label="actual_start_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>
<Column Name="department.name" DataType="DT_WSTR" Label="department_name" Length="100" />
<Column Name="department.id" DataType="DT_WSTR" Label="department_id" Length="100" />
<Column Name="owner.email_id" DataType="DT_WSTR" Label="owner_email_id" Length="100" />
<Column Name="owner.is_technician" DataType="DT_BOOL" Label="owner_is_technician" />
<Column Name="owner.sms_mail" DataType="DT_WSTR" Label="owner_sms_mail" Length="100" />
<Column Name="owner.phone" DataType="DT_WSTR" Label="owner_phone" Length="50" />
<Column Name="owner.name" DataType="DT_WSTR" Label="owner_name" Length="50" />
<Column Name="owner.mobile" DataType="DT_WSTR" Label="owner_mobile" Length="50" />
<Column Name="owner.id" DataType="DT_WSTR" Label="owner_id" Length="100" />
<Column Name="owner.photo_url" DataType="DT_WSTR" Label="owner_photo_url" Length="100" />
<Column Name="owner.is_vip_user" DataType="DT_BOOL" Label="owner_is_vip_user" />
<Column Name="owner.department" DataType="DT_WSTR" Label="owner_department" Length="1020" />
<Column Name="project_type.color" DataType="DT_WSTR" Label="project_type_color" Length="50" />
<Column Name="project_type.name" DataType="DT_WSTR" Label="project_type_name" Length="50" />
<Column Name="project_type.id" DataType="DT_WSTR" Label="project_type_id" Length="100" />
<Column Name="project_code" DataType="DT_WSTR" Label="project_code" Length="100" />
<Column Name="priority.color" DataType="DT_WSTR" Label="priority_color" Length="50" />
<Column Name="priority.name" DataType="DT_WSTR" Label="priority_name" Length="50" />
<Column Name="priority.id" DataType="DT_WSTR" Label="priority_id" Length="100" />
<Column Name="scheduled_end_time.display_value" DataType="DT_WSTR" Label="scheduled_end_time_display_value" Length="100" />
<Column Name="scheduled_end_time.value" Label="scheduled_end_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>
<Column Name="site.deleted" DataType="DT_BOOL" Label="site_deleted" />
<Column Name="site.name" DataType="DT_WSTR" Label="site_name" Length="50" />
<Column Name="site.id" DataType="DT_WSTR" Label="site_id" Length="100" />
<Column Name="actual_cost" DataType="DT_WSTR" Label="actual_cost" Length="50" />
<Column Name="estimated_cost" DataType="DT_WSTR" Label="estimated_cost" Length="50" />
<Column Name="project_requester.email_id" DataType="DT_WSTR" Label="project_requester_email_id" Length="100" />
<Column Name="project_requester.is_technician" DataType="DT_BOOL" Label="project_requester_is_technician" />
<Column Name="project_requester.sms_mail" DataType="DT_WSTR" Label="project_requester_sms_mail" Length="100" />
<Column Name="project_requester.phone" DataType="DT_WSTR" Label="project_requester_phone" Length="50" />
<Column Name="project_requester.name" DataType="DT_WSTR" Label="project_requester_name" Length="50" />
<Column Name="project_requester.mobile" DataType="DT_WSTR" Label="project_requester_mobile" Length="50" />
<Column Name="project_requester.id" DataType="DT_WSTR" Label="project_requester_id" Length="100" />
<Column Name="project_requester.photo_url" DataType="DT_WSTR" Label="project_requester_photo_url" Length="100" />
<Column Name="project_requester.is_vip_user" DataType="DT_BOOL" Label="project_requester_is_vip_user" />
<Column Name="estimated_hours" DataType="DT_WSTR" Label="estimated_hours" Length="50" />
<Column Name="udf_fields.udf_long1" DataType="DT_WSTR" Label="udf_fields_udf_long1" Length="100" />
<Column Name="udf_fields.udf_date1.display_value" DataType="DT_WSTR" Label="udf_fields_udf_date1_display_value" Length="100" />
<Column Name="udf_fields.udf_date1.value" DataType="DT_WSTR" Label="udf_fields_udf_date1_value" Length="100" />
<Column Name="udf_fields.udf_char1" DataType="DT_WSTR" Label="udf_fields_udf_char1" Length="100" />
<Column Name="projected_end.display_value" DataType="DT_WSTR" Label="projected_end_display_value" Length="100" />
<Column Name="projected_end.value" DataType="DT_WSTR" Label="projected_end_value" Length="100" />
<Column Name="scheduled_start_time.display_value" DataType="DT_WSTR" Label="scheduled_start_time_display_value" Length="100" />
<Column Name="scheduled_start_time.value" Label="scheduled_start_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>
<Column Name="status.internal_name" DataType="DT_WSTR" Label="status_internal_name" Length="50" />
<Column Name="status.color" DataType="DT_WSTR" Label="status_color" Length="50" />
<Column Name="status.name" DataType="DT_WSTR" Label="status_name" Length="50" />
<Column Name="status.id" DataType="DT_WSTR" Label="status_id" Length="100" />
<!--common-->
<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="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" />
</OutputColumns>
</EndPoint>
<EndPoint Name="ProjectMemberTemplate" Template="BaseTemplate">
<OutputColumns>
<Column Name="id" DataType="DT_WSTR" Label="id" Length="100" />
<Column Name="user.email_id" DataType="DT_WSTR" Label="user_email_id" Length="100" />
<Column Name="project.title" DataType="DT_WSTR" Label="project_title" Length="50" />
<Column Name="role.name" DataType="DT_WSTR" Label="role_name" Length="50" />
<Column Name="role.id" DataType="DT_WSTR" Label="role_id" Length="100" />
<Column Name="is_active" DataType="DT_BOOL" Label="is_active" />
<Column Name="project.project_code" DataType="DT_WSTR" Label="project_code" Length="100" />
<Column Name="project.id" DataType="DT_WSTR" Label="project_id" Length="100" />
<Column Name="project.display_id.display_value" DataType="DT_WSTR" Label="project_display_id_display_value" Length="50" />
<Column Name="project.display_id.value" DataType="DT_WSTR" Label="project_display_id_value" Length="50" />
<Column Name="user.is_technician" DataType="DT_BOOL" Label="user_is_technician" />
<Column Name="user.sms_mail" DataType="DT_WSTR" Label="user_sms_mail" Length="100" />
<Column Name="user.phone" DataType="DT_WSTR" Label="user_phone" Length="100" />
<Column Name="user.name" DataType="DT_WSTR" Label="user_name" Length="50" />
<Column Name="user.mobile" DataType="DT_WSTR" Label="user_mobile" Length="50" />
<Column Name="user.id" DataType="DT_WSTR" Label="user_id" Length="100" />
<Column Name="user.photo_url" DataType="DT_WSTR" Label="user_photo_url" Length="500" />
<Column Name="user.is_vip_user" DataType="DT_BOOL" Label="user_is_vip_user" />
<Column Name="user.department" DataType="DT_WSTR" Label="user_department" Length="1020" />
</OutputColumns>
</EndPoint>
<EndPoint Name="ProjectMilestoneTemplate" Template="BaseTemplate">
<OutputColumns>
<Column Name="id" DataType="DT_WSTR" Label="id" Length="100" />
<Column Name="title" DataType="DT_WSTR" Label="title" Length="200" />
<Column Name="index" DataType="DT_WSTR" Label="index" Length="50" />
<Column Name="description" DataType="DT_WSTR" Label="description" Length="2000" />
<Column Name="project.project_code" DataType="DT_WSTR" Label="project_project_code" Length="100" />
<Column Name="project.id" DataType="DT_WSTR" Label="project_id" Length="100" />
<Column Name="project.display_id.display_value" DataType="DT_WSTR" Label="project_display_id_display_value" Length="50" />
<Column Name="project.display_id.value" DataType="DT_WSTR" Label="project_display_id_value" Length="50" />
<Column Name="project.title" DataType="DT_WSTR" Label="project_title" Length="50" />
<Column Name="owner.email_id" DataType="DT_WSTR" Label="owner_email_id" Length="100" />
<Column Name="owner.is_technician" DataType="DT_BOOL" Label="owner_is_technician" />
<Column Name="owner.sms_mail" DataType="DT_WSTR" Label="owner_sms_mail" Length="100" />
<Column Name="owner.phone" DataType="DT_WSTR" Label="owner_phone" Length="50" />
<Column Name="owner.name" DataType="DT_WSTR" Label="owner_name" Length="50" />
<Column Name="owner.mobile" DataType="DT_WSTR" Label="owner_mobile" Length="50" />
<Column Name="owner.id" DataType="DT_WSTR" Label="owner_id" Length="100" />
<Column Name="owner.photo_url" DataType="DT_WSTR" Label="owner_photo_url" Length="100" />
<Column Name="owner.is_vip_user" DataType="DT_BOOL" Label="owner_is_vip_user" />
<Column Name="created_time.display_value" DataType="DT_WSTR" Label="created_time_display_value" Length="100" />
<Column Name="created_time.value" DataType="DT_WSTR" Label="created_time_value" Length="100" />
<Column Name="priority.color" DataType="DT_WSTR" Label="priority_color" Length="50" />
<Column Name="priority.name" DataType="DT_WSTR" Label="priority_name" Length="50" />
<Column Name="priority.id" DataType="DT_WSTR" Label="priority_id" Length="100" />
<Column Name="scheduled_end_time.display_value" DataType="DT_WSTR" Label="scheduled_end_time_display_value" Length="100" />
<Column Name="scheduled_end_time.value" DataType="DT_WSTR" Label="scheduled_end_time_value" Length="100" />
<Column Name="actual_hours" DataType="DT_WSTR" Label="actual_hours" Length="50" />
<Column Name="actual_end_time.display_value" DataType="DT_WSTR" Label="actual_end_time_display_value" Length="100" />
<Column Name="actual_end_time.value" DataType="DT_WSTR" Label="actual_end_time_value" Length="100" />
<Column Name="estimated_hours" DataType="DT_WSTR" Label="estimated_hours" Length="50" />
<Column Name="actual_start_time.display_value" DataType="DT_WSTR" Label="actual_start_time_display_value" Length="100" />
<Column Name="actual_start_time.value" DataType="DT_WSTR" Label="actual_start_time_value" Length="100" />
<Column Name="projected_end.display_value" DataType="DT_WSTR" Label="projected_end_display_value" Length="100" />
<Column Name="projected_end.value" DataType="DT_WSTR" Label="projected_end_value" Length="100" />
<Column Name="user.email_id" DataType="DT_WSTR" Label="user_email_id" Length="100" />
<Column Name="user.is_technician" DataType="DT_BOOL" Label="user_is_technician" />
<Column Name="user.sms_mail" DataType="DT_WSTR" Label="user_sms_mail" Length="100" />
<Column Name="user.phone" DataType="DT_WSTR" Label="user_phone" Length="50" />
<Column Name="user.name" DataType="DT_WSTR" Label="user_name" Length="50" />
<Column Name="user.mobile" DataType="DT_WSTR" Label="user_mobile" Length="50" />
<Column Name="user.id" DataType="DT_WSTR" Label="user_id" Length="100" />
<Column Name="user.photo_url" DataType="DT_WSTR" Label="user_photo_url" Length="300" />
<Column Name="user.is_vip_user" DataType="DT_BOOL" Label="user_is_vip_user" />
<Column Name="scheduled_start_time.display_value" DataType="DT_WSTR" Label="scheduled_start_time_display_value" Length="100" />
<Column Name="scheduled_start_time.value" DataType="DT_WSTR" Label="scheduled_start_time_value" Length="100" />
<Column Name="status.internal_name" DataType="DT_WSTR" Label="status_internal_name" Length="50" />
<Column Name="status.color" DataType="DT_WSTR" Label="status_color" Length="50" />
<Column Name="status.name" DataType="DT_WSTR" Label="status_name" Length="50" />
<Column Name="status.id" DataType="DT_WSTR" Label="status_id" Length="100" />
</OutputColumns>
</EndPoint>
<EndPoint Name="ReleaseTemplate" Template="BaseTemplate">
<OutputColumns>
<Column Name="id" DataType="DT_WSTR" Label="id" Length="100" />
<Column Name="title" DataType="DT_WSTR" Label="title" Length="300" />
<Column Name="template.inactive" DataType="DT_BOOL" Label="template_inactive" />
<Column Name="template.name" DataType="DT_WSTR" Label="template_name" Length="100" />
<Column Name="template.id" DataType="DT_WSTR" Label="template_id" Length="100" />
<Column Name="display_id.display_value" DataType="DT_WSTR" Label="display_id_display_value" Length="50" />
<Column Name="display_id.value" DataType="DT_WSTR" Label="display_id_value" Length="50" />
<Column Name="emergency" DataType="DT_BOOL" Label="emergency" />
<Column Name="release_requester" DataType="DT_WSTR" Label="release_requester" Length="1020" />
<Column Name="description" DataType="DT_WSTR" Label="description" Length="1020" />
<Column Name="release_engineer" DataType="DT_WSTR" Label="release_engineer" Length="1020" />
<Column Name="next_review_on" DataType="DT_WSTR" Label="next_review_on" Length="1020" />
<Column Name="urgency" DataType="DT_WSTR" Label="urgency" Length="1020" />
<Column Name="workflow_instance_details.id" DataType="DT_WSTR" Label="workflow_instance_details_id" Length="100" />
<Column Name="workflow_instance_details.status.name" DataType="DT_WSTR" Label="workflow_instance_details_status_name" Length="50" />
<Column Name="workflow_instance_details.status.id" DataType="DT_WSTR" Label="workflow_instance_details_status_id" Length="100" />
<Column Name="group" DataType="DT_WSTR" Label="group" Length="1020" />
<Column Name="reason_for_release" DataType="DT_WSTR" Label="reason_for_release" Length="1020" />
<Column Name="created_time.display_value" DataType="DT_WSTR" Label="created_time_display_value" Length="100" />
<Column Name="created_time.value" Label="created_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />
<Column Name="item" DataType="DT_WSTR" Label="item" Length="1020" />
<Column Name="workflow.validated" DataType="DT_BOOL" Label="workflow_validated" />
<Column Name="workflow.name" DataType="DT_WSTR" Label="workflow_name" Length="100" />
<Column Name="workflow.id" DataType="DT_WSTR" Label="workflow_id" Length="100" />
<Column Name="workflow.allowed_stages_config" DataType="DT_WSTR" Label="workflow_allowed_stages_config" Length="50" />
<Column Name="release_manager" DataType="DT_WSTR" Label="release_manager" Length="1020" />
<Column Name="impact" DataType="DT_WSTR" Label="impact" Length="1020" />
<Column Name="release_type" DataType="DT_WSTR" Label="release_type" Length="1020" />
<Column Name="priority" DataType="DT_WSTR" Label="priority" Length="1020" />
<Column Name="scheduled_end_time" DataType="DT_WSTR" Label="scheduled_end_time" Length="1020" />
<Column Name="site" DataType="DT_WSTR" Label="site" Length="1020" />
<Column Name="completed_time" DataType="DT_WSTR" Label="completed_time" Length="1020" />
<Column Name="stage.internal_name" DataType="DT_WSTR" Label="stage_internal_name" Length="50" />
<Column Name="stage.inactive" DataType="DT_BOOL" Label="stage_inactive" />
<Column Name="stage.stage_index" DataType="DT_I4" Label="stage_stage_index" />
<Column Name="stage.name" DataType="DT_WSTR" Label="stage_name" Length="50" />
<Column Name="stage.id" DataType="DT_WSTR" Label="stage_id" Length="100" />
<Column Name="risk" DataType="DT_WSTR" Label="risk" Length="1020" />
<Column Name="category" DataType="DT_WSTR" Label="category" Length="1020" />
<Column Name="subcategory" DataType="DT_WSTR" Label="subcategory" Length="1020" />
<Column Name="deleted_time" DataType="DT_WSTR" Label="deleted_time" Length="1020" />
<Column Name="notes_present" DataType="DT_BOOL" Label="notes_present" />
<Column Name="scheduled_start_time" DataType="DT_WSTR" Label="scheduled_start_time" Length="1020" />
<Column Name="status.in_progress" DataType="DT_BOOL" Label="status_in_progress" />
<Column Name="status.internal_name" DataType="DT_WSTR" Label="status_internal_name" Length="50" />
<Column Name="status.stage.id" DataType="DT_WSTR" Label="status_stage_id" Length="100" />
<Column Name="status.name" DataType="DT_WSTR" Label="status_name" Length="50" />
<Column Name="status.id" DataType="DT_WSTR" Label="status_id" Length="100" />
<Column Name="release_engineer.email_id" DataType="DT_WSTR" Label="release_engineer_email_id" Length="100" />
<Column Name="release_engineer.cost_per_hour" DataType="DT_WSTR" Label="release_engineer_cost_per_hour" Length="50" />
<Column Name="release_engineer.phone" DataType="DT_WSTR" Label="release_engineer_phone" Length="1020" />
<Column Name="release_engineer.name" DataType="DT_WSTR" Label="release_engineer_name" Length="50" />
<Column Name="release_engineer.mobile" DataType="DT_WSTR" Label="release_engineer_mobile" Length="1020" />
<Column Name="release_engineer.last_name" DataType="DT_WSTR" Label="release_engineer_last_name" Length="100" />
<Column Name="release_engineer.id" DataType="DT_WSTR" Label="release_engineer_id" Length="100" />
<Column Name="release_engineer.photo_url" DataType="DT_WSTR" Label="release_engineer_photo_url" Length="500" />
<Column Name="release_engineer.sms_mail_id" DataType="DT_WSTR" Label="release_engineer_sms_mail_id" Length="1020" />
<Column Name="release_engineer.first_name" DataType="DT_WSTR" Label="release_engineer_first_name" Length="50" />
<Column Name="urgency.name" DataType="DT_WSTR" Label="urgency_name" Length="50" />
<Column Name="urgency.id" DataType="DT_WSTR" Label="urgency_id" Length="100" />
<Column Name="reason_for_release.name" DataType="DT_WSTR" Label="reason_for_release_name" Length="500" />
<Column Name="reason_for_release.id" DataType="DT_WSTR" Label="reason_for_release_id" Length="100" />
<Column Name="release_type.color" DataType="DT_WSTR" Label="release_type_color" Length="50" />
<Column Name="release_type.pre_approved" DataType="DT_BOOL" Label="release_type_pre_approved" />
<Column Name="release_type.name" DataType="DT_WSTR" Label="release_type_name" Length="50" />
<Column Name="release_type.id" DataType="DT_WSTR" Label="release_type_id" Length="100" />
<Column Name="priority.color" DataType="DT_WSTR" Label="priority_color" Length="50" />
<Column Name="priority.name" DataType="DT_WSTR" Label="priority_name" Length="50" />
<Column Name="priority.id" DataType="DT_WSTR" Label="priority_id" Length="100" />
<Column Name="risk.name" DataType="DT_WSTR" Label="risk_name" Length="50" />
<Column Name="risk.id" DataType="DT_WSTR" Label="risk_id" Length="100" />
<Column Name="category.deleted" DataType="DT_BOOL" Label="category_deleted" />
<Column Name="category.name" DataType="DT_WSTR" Label="category_name" Length="100" />
<Column Name="category.id" DataType="DT_WSTR" Label="category_id" Length="100" />
<Column Name="subcategory.name" DataType="DT_WSTR" Label="subcategory_name" Length="100" />
<Column Name="subcategory.id" DataType="DT_WSTR" Label="subcategory_id" Length="100" />
</OutputColumns>
</EndPoint>
<EndPoint Name="PurchaseOrderTemplate" Template="BaseTemplate">
<OutputColumns>
<Column Name="id" DataType="DT_WSTR" Label="id" Length="100" />
<Column Name="owner.email_id" DataType="DT_WSTR" Label="owner_email_id" Length="100" />
<Column Name="owner.is_technician" DataType="DT_BOOL" Label="owner_is_technician" />
<Column Name="owner.sms_mail" DataType="DT_WSTR" Label="owner_sms_mail" Length="1020" />
<Column Name="owner.mobile" DataType="DT_WSTR" Label="owner_mobile" Length="50" />
<Column Name="owner.last_name" DataType="DT_WSTR" Label="owner_last_name" Length="50" />
<Column Name="owner.user_scope" DataType="DT_WSTR" Label="owner_user_scope" Length="100" />
<Column Name="owner.sms_mail_id" DataType="DT_WSTR" Label="owner_sms_mail_id" Length="1020" />
<Column Name="owner.phone" DataType="DT_WSTR" Label="owner_phone" Length="1020" />
<Column Name="owner.employee_id" DataType="DT_WSTR" Label="owner_employee_id" Length="50" />
<Column Name="owner.name" DataType="DT_WSTR" Label="owner_name" Length="50" />
<Column Name="owner.id" DataType="DT_WSTR" Label="owner_id" Length="100" />
<Column Name="owner.photo_url" DataType="DT_WSTR" Label="owner_photo_url" Length="500" />
<Column Name="owner.is_vip_user" DataType="DT_BOOL" Label="owner_is_vip_user" />
<Column Name="owner.department" DataType="DT_WSTR" Label="owner_department" Length="1020" />
<Column Name="owner.first_name" DataType="DT_WSTR" Label="owner_first_name" Length="50" />
<Column Name="owner.job_title" DataType="DT_WSTR" Label="owner_job_title" Length="1020" />
<Column Name="template.inactive" DataType="DT_BOOL" Label="template_inactive" />
<Column Name="template.name" DataType="DT_WSTR" Label="template_name" Length="100" />
<Column Name="template.id" DataType="DT_WSTR" Label="template_id" Length="100" />
<Column Name="required_date.display_value" DataType="DT_WSTR" Label="required_date_display_value" Length="50" />
<Column Name="required_date.value" DataType="DT_WSTR" Label="required_date_value" Length="100" />
<Column Name="total_price.display_value" DataType="DT_WSTR" Label="total_price_display_value" Length="50" />
<Column Name="total_price.currency_symbol" DataType="DT_WSTR" Label="total_price_currency_symbol" Length="50" />
<Column Name="total_price.value" DataType="DT_R8" Label="total_price_value" />
<Column Name="total_price.secondary_currency.display_value" DataType="DT_R8" Label="total_price_secondary_currency_display_value" />
<Column Name="total_price.secondary_currency.currency_symbol" DataType="DT_WSTR" Label="total_price_secondary_currency_currency_symbol" Length="50" />
<Column Name="total_price.secondary_currency.value" DataType="DT_R8" Label="total_price_secondary_currency_value" />
<Column Name="custom_id" DataType="DT_WSTR" Label="custom_id" Length="50" />
<Column Name="sites" DataType="DT_WSTR" Label="sites" Length="500" />
<Column Name="requested_by.email_id" DataType="DT_WSTR" Label="requested_by_email_id" Length="100" />
<Column Name="requested_by.is_technician" DataType="DT_BOOL" Label="requested_by_is_technician" />
<Column Name="requested_by.sms_mail" DataType="DT_WSTR" Label="requested_by_sms_mail" Length="1020" />
<Column Name="requested_by.mobile" DataType="DT_WSTR" Label="requested_by_mobile" Length="50" />
<Column Name="requested_by.last_name" DataType="DT_WSTR" Label="requested_by_last_name" Length="50" />
<Column Name="requested_by.user_scope" DataType="DT_WSTR" Label="requested_by_user_scope" Length="100" />
<Column Name="requested_by.sms_mail_id" DataType="DT_WSTR" Label="requested_by_sms_mail_id" Length="1020" />
<Column Name="requested_by.phone" DataType="DT_WSTR" Label="requested_by_phone" Length="1020" />
<Column Name="requested_by.employee_id" DataType="DT_WSTR" Label="requested_by_employee_id" Length="50" />
<Column Name="requested_by.name" DataType="DT_WSTR" Label="requested_by_name" Length="50" />
<Column Name="requested_by.id" DataType="DT_WSTR" Label="requested_by_id" Length="100" />
<Column Name="requested_by.photo_url" DataType="DT_WSTR" Label="requested_by_photo_url" Length="500" />
<Column Name="requested_by.is_vip_user" DataType="DT_BOOL" Label="requested_by_is_vip_user" />
<Column Name="requested_by.department" DataType="DT_WSTR" Label="requested_by_department" Length="1020" />
<Column Name="requested_by.first_name" DataType="DT_WSTR" Label="requested_by_first_name" Length="50" />
<Column Name="requested_by.job_title" DataType="DT_WSTR" Label="requested_by_job_title" Length="1020" />
<Column Name="vendor.name" DataType="DT_WSTR" Label="vendor_name" Length="50" />
<Column Name="vendor.description" DataType="DT_WSTR" Label="vendor_description" Length="100" />
<Column Name="vendor.currency.symbol" DataType="DT_WSTR" Label="vendor_currency_symbol" Length="50" />
<Column Name="vendor.currency.code" DataType="DT_WSTR" Label="vendor_currency_code" Length="50" />
<Column Name="vendor.currency.exchange_rate" DataType="DT_WSTR" Label="vendor_currency_exchange_rate" Length="50" />
<Column Name="vendor.currency.name" DataType="DT_WSTR" Label="vendor_currency_name" Length="50" />
<Column Name="vendor.currency.id" DataType="DT_WSTR" Label="vendor_currency_id" Length="100" />
<Column Name="vendor.id" DataType="DT_WSTR" Label="vendor_id" Length="100" />
<Column Name="name" DataType="DT_WSTR" Label="name" Length="50" />
<Column Name="currency.symbol" DataType="DT_WSTR" Label="currency_symbol" Length="50" />
<Column Name="currency.code" DataType="DT_WSTR" Label="currency_code" Length="50" />
<Column Name="currency.exchange_rate" DataType="DT_WSTR" Label="currency_exchange_rate" Length="50" />
<Column Name="currency.name" DataType="DT_WSTR" Label="currency_name" Length="50" />
<Column Name="currency.id" DataType="DT_WSTR" Label="currency_id" Length="100" />
<Column Name="created_date.display_value" DataType="DT_WSTR" Label="created_date_display_value" Length="50" />
<Column Name="created_date.value" Label="created_date" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE" />
<Column Name="status.name" DataType="DT_WSTR" Label="status_name" Length="100" />
<Column Name="status.id" DataType="DT_WSTR" Label="status_id" Length="100" />
<Column Name="required_date" DataType="DT_WSTR" Label="required_date" Length="1020" />
</OutputColumns>
</EndPoint>
<EndPoint Name="ContractTemplate" Template="BaseTemplate">
<OutputColumns>
<Column Name="id" DataType="DT_WSTR" Label="id" Length="100" />
<Column Name="name" DataType="DT_WSTR" Label="name" Length="300" />
<Column Name="owner.email_id" DataType="DT_WSTR" Label="owner_email_id" Length="100" />
<Column Name="owner.is_technician" DataType="DT_BOOL" Label="owner_is_technician" />
<Column Name="owner.sms_mail" DataType="DT_WSTR" Label="owner_sms_mail" Length="1020" />
<Column Name="owner.mobile" DataType="DT_WSTR" Label="owner_mobile" Length="1020" />
<Column Name="owner.last_name" DataType="DT_WSTR" Label="owner_last_name" Length="50" />
<Column Name="owner.user_scope" DataType="DT_WSTR" Label="owner_user_scope" Length="100" />
<Column Name="owner.sms_mail_id" DataType="DT_WSTR" Label="owner_sms_mail_id" Length="1020" />
<Column Name="owner.cost_per_hour" DataType="DT_WSTR" Label="owner_cost_per_hour" Length="50" />
<Column Name="owner.site.id" DataType="DT_WSTR" Label="owner_site_id" Length="100" />
<Column Name="owner.phone" DataType="DT_WSTR" Label="owner_phone" Length="1020" />
<Column Name="owner.employee_id" DataType="DT_WSTR" Label="owner_employee_id" Length="1020" />
<Column Name="owner.name" DataType="DT_WSTR" Label="owner_name" Length="50" />
<Column Name="owner.id" DataType="DT_WSTR" Label="owner_id" Length="100" />
<Column Name="owner.photo_url" DataType="DT_WSTR" Label="owner_photo_url" Length="100" />
<Column Name="owner.is_vip_user" DataType="DT_BOOL" Label="owner_is_vip_user" />
<Column Name="owner.department" DataType="DT_WSTR" Label="owner_department" Length="1020" />
<Column Name="owner.first_name" DataType="DT_WSTR" Label="owner_first_name" Length="50" />
<Column Name="owner.job_title" DataType="DT_WSTR" Label="owner_job_title" Length="1020" />
<Column Name="template.inactive" DataType="DT_BOOL" Label="template_inactive" />
<Column Name="template.name" DataType="DT_WSTR" Label="template_name" Length="100" />
<Column Name="template.id" DataType="DT_WSTR" Label="template_id" Length="100" />
<Column Name="is_definite" DataType="DT_BOOL" Label="is_definite" />
<Column Name="cost.display_value" DataType="DT_WSTR" Label="cost_display_value" Length="50" />
<Column Name="cost.currency_symbol" DataType="DT_WSTR" Label="cost_currency_symbol" Length="50" />
<Column Name="cost.value" DataType="DT_I4" Label="cost_value" />
<Column Name="cost.secondary_currency.display_value" DataType="DT_I4" Label="cost_secondary_currency_display_value" />
<Column Name="cost.secondary_currency.currency_symbol" DataType="DT_WSTR" Label="cost_secondary_currency_currency_symbol" Length="50" />
<Column Name="cost.secondary_currency.value" DataType="DT_I4" Label="cost_secondary_currency_value" />
<Column Name="request_creation_days" DataType="DT_WSTR" Label="request_creation_days" Length="50" />
<Column Name="display_id.display_value" DataType="DT_WSTR" Label="display_id_display_value" Length="50" />
<Column Name="display_id.value" DataType="DT_WSTR" Label="display_id_value" Length="50" />
<Column Name="sites" DataType="DT_WSTR" Label="sites" Length="500" />
<Column Name="active_from.display_value" DataType="DT_WSTR" Label="active_from_display_value" Length="50" />
<Column Name="active_from.value" DataType="DT_WSTR" Label="active_from_value" Length="100" />
<Column Name="type" DataType="DT_WSTR" Label="type" Length="1020" />
<Column Name="is_req_creation_required" DataType="DT_BOOL" Label="is_req_creation_required" />
<Column Name="vendor.name" DataType="DT_WSTR" Label="vendor_name" Length="50" />
<Column Name="vendor.description" DataType="DT_WSTR" Label="vendor_description" Length="100" />
<Column Name="vendor.currency.symbol" DataType="DT_WSTR" Label="vendor_currency_symbol" Length="50" />
<Column Name="vendor.currency.code" DataType="DT_WSTR" Label="vendor_currency_code" Length="50" />
<Column Name="vendor.currency.exchange_rate" DataType="DT_WSTR" Label="vendor_currency_exchange_rate" Length="50" />
<Column Name="vendor.currency.name" DataType="DT_WSTR" Label="vendor_currency_name" Length="50" />
<Column Name="vendor.currency.id" DataType="DT_WSTR" Label="vendor_currency_id" Length="100" />
<Column Name="vendor.id" DataType="DT_WSTR" Label="vendor_id" Length="100" />
<Column Name="is_draft" DataType="DT_BOOL" Label="is_draft" />
<Column Name="active_till.display_value" DataType="DT_WSTR" Label="active_till_display_value" Length="50" />
<Column Name="active_till.value" DataType="DT_WSTR" Label="active_till_value" Length="100" />
<Column Name="currency.symbol" DataType="DT_WSTR" Label="currency_symbol" Length="50" />
<Column Name="currency.code" DataType="DT_WSTR" Label="currency_code" Length="50" />
<Column Name="currency.exchange_rate" DataType="DT_WSTR" Label="currency_exchange_rate" Length="50" />
<Column Name="currency.is_frequent" DataType="DT_BOOL" Label="currency_is_frequent" />
<Column Name="currency.name" DataType="DT_WSTR" Label="currency_name" Length="50" />
<Column Name="currency.id" DataType="DT_WSTR" Label="currency_id" Length="100" />
<Column Name="deleted_time" DataType="DT_WSTR" Label="deleted_time" Length="1020" />
<Column Name="notes_present" DataType="DT_BOOL" Label="notes_present" />
<Column Name="status.name" DataType="DT_WSTR" Label="status_name" Length="50" />
<Column Name="status.id" DataType="DT_WSTR" Label="status_id" Length="100" />
<Column Name="type.color" DataType="DT_WSTR" Label="type_color" Length="50" />
<Column Name="type.name" DataType="DT_WSTR" Label="type_name" Length="50" />
<Column Name="type.id" DataType="DT_WSTR" Label="type_id" Length="100" />
</OutputColumns>
</EndPoint>
<EndPoint Name="ProblemTemplate" Template="BaseTemplate">
<OutputColumns>
<Column Name="id" DataType="DT_WSTR" Label="id" Length="50" />
<Column Name="title" DataType="DT_WSTR" Label="title" Length="255" />
<Column Name="template.name" DataType="DT_WSTR" Label="template_name" Length="50" />
<Column Name="template.id" DataType="DT_WSTR" Label="template_id" Length="100" />
<Column Name="updated_time.display_value" DataType="DT_WSTR" Label="updated_time_display_value" Length="100" />
<Column Name="updated_time.value" Label="updated_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>
<Column Name="display_id.display_value" DataType="DT_WSTR" Label="display_id_display_value" Length="50" />
<Column Name="display_id.value" DataType="DT_WSTR" Label="display_id_value" Length="50" />
<Column Name="description" DataType="DT_WSTR" Label="description" Length="100" />
<Column Name="urgency.name" DataType="DT_WSTR" Label="urgency_name" Length="50" />
<Column Name="urgency.id" DataType="DT_WSTR" Label="urgency_id" Length="100" />
<Column Name="reported_by.email_id" DataType="DT_WSTR" Label="reported_by_email_id" Length="100" />
<Column Name="reported_by.is_technician" DataType="DT_BOOL" Label="reported_by_is_technician" />
<Column Name="reported_by.sms_mail" DataType="DT_WSTR" Label="reported_by_sms_mail" Length="100" />
<Column Name="reported_by.phone" DataType="DT_WSTR" Label="reported_by_phone" Length="50" />
<Column Name="reported_by.name" DataType="DT_WSTR" Label="reported_by_name" Length="50" />
<Column Name="reported_by.mobile" DataType="DT_WSTR" Label="reported_by_mobile" Length="50" />
<Column Name="reported_by.id" DataType="DT_WSTR" Label="reported_by_id" Length="100" />
<Column Name="reported_by.photo_url" DataType="DT_WSTR" Label="reported_by_photo_url" Length="100" />
<Column Name="reported_by.is_vip_user" DataType="DT_BOOL" Label="reported_by_is_vip_user" />
<Column Name="reported_by.job_title" DataType="DT_WSTR" Label="reported_by_job_title" Length="100" />
<Column Name="group.site.id" DataType="DT_WSTR" Label="group_site_id" Length="100" />
<Column Name="group.deleted" DataType="DT_BOOL" Label="group_deleted" />
<Column Name="group.name" DataType="DT_WSTR" Label="group_name" Length="100" />
<Column Name="group.id" DataType="DT_WSTR" Label="group_id" Length="100" />
<Column Name="item.name" DataType="DT_WSTR" Label="item_name" Length="50" />
<Column Name="item.id" DataType="DT_WSTR" Label="item_id" Length="100" />
<Column Name="impact.name" DataType="DT_WSTR" Label="impact_name" Length="100" />
<Column Name="impact.id" DataType="DT_WSTR" Label="impact_id" Length="100" />
<Column Name="technician.email_id" DataType="DT_WSTR" Label="technician_email_id" Length="100" />
<Column Name="technician.cost_per_hour" DataType="DT_R8" Label="technician_cost_per_hour" />
<Column Name="technician.phone" DataType="DT_WSTR" Label="technician_phone" Length="50" />
<Column Name="technician.name" DataType="DT_WSTR" Label="technician_name" Length="50" />
<Column Name="technician.mobile" DataType="DT_WSTR" Label="technician_mobile" Length="50" />
<Column Name="technician.id" DataType="DT_WSTR" Label="technician_id" Length="100" />
<Column Name="technician.photo_url" DataType="DT_WSTR" Label="technician_photo_url" Length="100" />
<Column Name="technician.sms_mail_id" DataType="DT_WSTR" Label="technician_sms_mail_id" Length="100" />
<Column Name="closed_time" DataType="DT_WSTR" Label="closed_time" Length="1020" />
<Column Name="priority.color" DataType="DT_WSTR" Label="priority_color" Length="50" />
<Column Name="priority.name" DataType="DT_WSTR" Label="priority_name" Length="50" />
<Column Name="priority.id" DataType="DT_WSTR" Label="priority_id" Length="100" />
<Column Name="due_by_time.display_value" DataType="DT_WSTR" Label="due_by_time_display_value" Length="100" />
<Column Name="due_by_time.value" Label="due_by_time" DataType="DT_DBTIMESTAMP" Functions="FUN_UNIX_TIMESTAMP_MS_TO_DATE"/>
<Column Name="site.deleted" DataType="DT_BOOL" Label="site_deleted" />
<Column Name="site.name" DataType="DT_WSTR" Label="site_name" Length="50" />
<Column Name="site.id" DataType="DT_WSTR" Label="site_id" Length="100" />
<Column Name="udf_fields.udf_long1" DataType="DT_WSTR" Label="udf_fields_udf_long1" Length="100" />
<Column Name="udf_fields.udf_char1" DataType="DT_WSTR" Label="udf_fields_udf_char1" Length="100" />
<Column Name="category.deleted" DataType="DT_BOOL" Label="category_deleted" />
<Column Name="category.name" DataType="DT_WSTR" Label="category_name" Length="50" />
<Column Name="category.id" DataType="DT_WSTR" Label="category_id" Length="100" />
<Column Name="subcategory.name" DataType="DT_WSTR" Label="subcategory_name" Length="50" />
<Column Name="subcategory.id" DataType="DT_WSTR" Label="subcategory_id" Length="100" />
<Column Name="notes_present" DataType="DT_BOOL" Label="notes_present" />
<Column Name="status.in_progress" DataType="DT_BOOL" Label="status_in_progress" />
<Column Name="status.internal_name" DataType="DT_WSTR" Label="status_internal_name" Length="100" />
<Column Name="status.stop_timer" DataType="DT_BOOL" Label="status_stop_timer" />
<Column Name="status.color" DataType="DT_WSTR" Label="status_color" Length="50" />
<Column Name="status.name" DataType="DT_WSTR" Label="status_name" Length="50" />
<Column Name="status.id" DataType="DT_WSTR" Label="status_id" Length="100" />
</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="PaginatedTaskTemplate" Template="TaskTemplate" >
<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="PaginatedTaskCommentTemplate" Template="TaskCommentTemplate" >
<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="PaginatedWorklogTemplate" Template="WorklogTemplate" >
<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="PaginatedNoteTemplate" Template="NoteTemplate" >
<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="PaginatedChangeTemplate" Template="ChangeTemplate">
<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="PaginatedAssetTemplate" Template="AssetTemplate">
<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="PaginatedProblemTemplate" Template="ProblemTemplate">
<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="PaginatedProjectTemplate" Template="ProjectTemplate">
<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="PaginatedReleaseTemplate" Template="ReleaseTemplate">
<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="PaginatedPurchaseOrderTemplate" Template="PurchaseOrderTemplate">
<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="PaginatedContractTemplate" Template="ContractTemplate">
<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="PaginatedProjectMemberTemplate" Template="ProjectMemberTemplate" >
<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="PaginatedProjectMilestoneTemplate" Template="ProjectMilestoneTemplate" >
<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>
<!-- request -->
<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="get_request_tasks" Label="Get Request Tasks" Template="PaginatedTaskTemplate"
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="TaskTemplate"
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="PaginatedTaskCommentTemplate"
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="TaskCommentTemplate"
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="PaginatedNoteTemplate"
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="NoteTemplate"
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="PaginatedWorklogTemplate"
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="WorklogTemplate"
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="PaginatedWorklogTemplate"
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="TaskWorklogTemplate"
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>
<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>
<InputColumns>
<Column Name="RequestId" Label="id" MapToParam="True" Key="True" />
</InputColumns>
</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>
<!--
************ changes ************
-->
<EndPoint Name="get_changes" Label="Get Changes" Template="PaginatedChangeTemplate"
Url="/changes?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="$.changes[*]">
<Params>
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_change_details" Label="Get Change Details" Template="ChangeTemplate" Url="/changes/[$ChangeId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.change" IncludeParentColumns="True">
<Params>
<Param Name="ChangeId" 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="get_change_tasks" Label="Get Change Tasks" Template="PaginatedTaskTemplate"
Url="/changes/[$ChangeId$]/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="ChangeId" Required="True" ReadAs="change_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_change_task_details" Label="Get Change Task Details" Template="TaskTemplate"
Url="/changes/[$ChangeId$]/tasks/[$TaskId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.task" IncludeParentColumns="True">
<Params>
<Param Name="ChangeId" Required="True" IsKey="True" ReadAs="change_id" />
<Param Name="TaskId" Required="True" IsKey="True" ReadAs="id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_change_task_comments" Label="Get Change Task Comments" Template="PaginatedTaskCommentTemplate"
Url="/changes/[$ChangeId$]/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="ChangeId" Required="True" IsKey="True" ReadAs="change_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_change_task_comment_details" Label="Get Change Task Comment Details" Template="TaskCommentTemplate"
Url="/changes/[$ChangeId$]/tasks/[$TaskId$]/comments/[$CommentId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.task_comment" IncludeParentColumns="True">
<Params>
<Param Name="ChangeId" Required="True" IsKey="True" ReadAs="change_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_change_notes" Label="Get Change Notes" Template="PaginatedNoteTemplate"
Url="/changes/[$ChangeId$]/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="ChangeId" Required="True" IsKey="True" ReadAs="change_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_change_note_details" Label="Get Change Note Details" Template="NoteTemplate"
Url="/changes/[$ChangeId$]/notes/[$NoteId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.note" IncludeParentColumns="True">
<Params>
<Param Name="ChangeId" Required="True" IsKey="True" ReadAs="change_id" />
<Param Name="NoteId" Required="True" IsKey="True" ReadAs="id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_change_worklogs" Label="Get Change Worklogs" Template="PaginatedWorklogTemplate"
Url="/changes/[$ChangeId$]/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="ChangeId" Required="True" IsKey="True" ReadAs="change_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_change_worklog_details" Label="Get Change Worklog Details" Template="WorklogTemplate"
Url="/changes/[$ChangeId$]/worklogs/[$WorklogId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.worklog" IncludeParentColumns="True">
<Params>
<Param Name="ChangeId" Required="True" IsKey="True" ReadAs="change_id" />
<Param Name="WorklogId" Required="True" IsKey="True" ReadAs="id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_change_task_worklogs" Label="Get Change Task Worklogs" Template="PaginatedWorklogTemplate"
Url="/changes/[$ChangeId$]/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="ChangeId" Required="True" />
<Param Name="TaskId" Required="True" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_change_task_worklog_details" Label="Get Change Task Worklog Details" Template="TaskWorklogTemplate"
Url="/changes/[$ChangeId$]/tasks/[$TaskId$]/worklogs/[$WorklogId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.worklog" IncludeParentColumns="True">
<Params>
<Param Name="ChangeId" Required="True" />
<Param Name="TaskId" Required="True" />
<Param Name="WorklogId" Required="True"/>
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<!--
************ problems ************
-->
<EndPoint Name="get_problems" Label="Get Problems" Template="PaginatedProblemTemplate"
Url="/problems?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="$.problems[*]">
<Params>
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_problem_details" Label="Get Problem Details" Template="ProblemTemplate" Url="/problems/[$ProblemId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.problem" IncludeParentColumns="True">
<Params>
<Param Name="ProblemId" 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="get_problem_tasks" Label="Get Problem Tasks" Template="PaginatedTaskTemplate"
Url="/problems/[$ProblemId$]/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="ProblemId" Required="True" ReadAs="problem_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_problem_task_details" Label="Get Problem Task Details" Template="TaskTemplate"
Url="/problems/[$ProblemId$]/tasks/[$TaskId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.task" IncludeParentColumns="True">
<Params>
<Param Name="ProblemId" Required="True" IsKey="True" ReadAs="problem_id" />
<Param Name="TaskId" Required="True" IsKey="True" ReadAs="id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_problem_task_comments" Label="Get Problem Task Comments" Template="PaginatedTaskCommentTemplate"
Url="/problems/[$ProblemId$]/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="ProblemId" Required="True" IsKey="True" ReadAs="problem_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_problem_task_comment_details" Label="Get Problem Task Comment Details" Template="TaskCommentTemplate"
Url="/problems/[$ProblemId$]/tasks/[$TaskId$]/comments/[$CommentId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.task_comment" IncludeParentColumns="True">
<Params>
<Param Name="ProblemId" Required="True" IsKey="True" ReadAs="problem_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_problem_notes" Label="Get Problem Notes" Template="PaginatedNoteTemplate"
Url="/problems/[$ProblemId$]/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="ProblemId" Required="True" IsKey="True" ReadAs="problem_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_problem_note_details" Label="Get Problem Note Details" Template="NoteTemplate"
Url="/problems/[$ProblemId$]/notes/[$NoteId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.note" IncludeParentColumns="True">
<Params>
<Param Name="ProblemId" Required="True" IsKey="True" ReadAs="problem_id" />
<Param Name="NoteId" Required="True" IsKey="True" ReadAs="id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_problem_worklogs" Label="Get Problem Worklogs" Template="PaginatedWorklogTemplate"
Url="/problems/[$ProblemId$]/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="ProblemId" Required="True" IsKey="True" ReadAs="problem_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_problem_worklog_details" Label="Get Problem Worklog Details" Template="WorklogTemplate"
Url="/problems/[$ProblemId$]/worklogs/[$WorklogId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.worklog" IncludeParentColumns="True">
<Params>
<Param Name="ProblemId" Required="True" IsKey="True" ReadAs="problem_id" />
<Param Name="WorklogId" Required="True" IsKey="True" ReadAs="id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_problem_task_worklogs" Label="Get Problem Task Worklogs" Template="PaginatedWorklogTemplate"
Url="/problems/[$ProblemId$]/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="ProblemId" Required="True" />
<Param Name="TaskId" Required="True" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_problem_task_worklog_details" Label="Get Problem Task Worklog Details" Template="TaskWorklogTemplate"
Url="/problems/[$ProblemId$]/tasks/[$TaskId$]/worklogs/[$WorklogId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.worklog" IncludeParentColumns="True">
<Params>
<Param Name="ProblemId" Required="True" />
<Param Name="TaskId" Required="True" />
<Param Name="WorklogId" Required="True"/>
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<!--
************ projects ************
-->
<EndPoint Name="get_projects" Label="Get Projects" Template="PaginatedProjectTemplate"
Url="/projects?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="$.projects[*]">
<Params>
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_project_details" Label="Get Project Details" Template="ProjectTemplate" Url="/projects/[$ProjectId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.project" IncludeParentColumns="True">
<Params>
<Param Name="ProjectId" 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="get_project_tasks" Label="Get Project Tasks" Template="PaginatedTaskTemplate"
Url="/projects/[$ProjectId$]/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="ProjectId" Required="True" ReadAs="project_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_project_members" Label="Get Project Members" Template="PaginatedProjectMemberTemplate"
Url="/projects/[$ProjectId$]/project_members?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="$.project_members[*]">
<Params>
<Param Name="ProjectId" Required="True" ReadAs="project_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_project_milestones" Label="Get Project Milestones" Template="PaginatedProjectMilestoneTemplate"
Url="/projects/[$ProjectId$]/milestones?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="$.milestones[*]">
<Params>
<Param Name="ProjectId" Required="True" ReadAs="project_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_project_milestone_tasks" Label="Get Project Milestone Tasks" Template="PaginatedTaskTemplate"
Url="/projects/[$ProjectId$]/milestones/[$MilestoneId$]/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="ProjectId" Required="True" ReadAs="project_id" />
<Param Name="MilestoneId" Required="True" ReadAs="milestone_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_project_task_details" Label="Get Project Task Details" Template="TaskTemplate"
Url="/projects/[$ProjectId$]/tasks/[$TaskId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.task" IncludeParentColumns="True">
<Params>
<Param Name="ProjectId" Required="True" IsKey="True" ReadAs="project_id" />
<Param Name="TaskId" Required="True" IsKey="True" ReadAs="id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_project_task_comments" Label="Get Project Task Comments" Template="PaginatedTaskCommentTemplate"
Url="/projects/[$ProjectId$]/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="ProjectId" Required="True" IsKey="True" ReadAs="project_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_project_task_comment_details" Label="Get Project Task Comment Details" Template="TaskCommentTemplate"
Url="/projects/[$ProjectId$]/tasks/[$TaskId$]/comments/[$CommentId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.task_comment" IncludeParentColumns="True">
<Params>
<Param Name="ProjectId" Required="True" IsKey="True" ReadAs="project_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_project_notes" Label="Get Project Notes" Template="PaginatedNoteTemplate"
Url="/projects/[$ProjectId$]/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="ProjectId" Required="True" IsKey="True" ReadAs="project_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_project_note_details" Label="Get Project Note Details" Template="NoteTemplate"
Url="/projects/[$ProjectId$]/notes/[$NoteId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.note" IncludeParentColumns="True">
<Params>
<Param Name="ProjectId" Required="True" IsKey="True" ReadAs="project_id" />
<Param Name="NoteId" Required="True" IsKey="True" ReadAs="id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_project_worklogs" Label="Get Project Worklogs" Template="PaginatedWorklogTemplate"
Url="/projects/[$ProjectId$]/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="ProjectId" Required="True" IsKey="True" ReadAs="project_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_project_worklog_details" Label="Get Project Worklog Details" Template="WorklogTemplate"
Url="/projects/[$ProjectId$]/worklogs/[$WorklogId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.worklog" IncludeParentColumns="True">
<Params>
<Param Name="ProjectId" Required="True" IsKey="True" ReadAs="project_id" />
<Param Name="WorklogId" Required="True" IsKey="True" ReadAs="id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_project_task_worklogs" Label="Get Project Task Worklogs" Template="PaginatedWorklogTemplate"
Url="/projects/[$ProjectId$]/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="ProjectId" Required="True" />
<Param Name="TaskId" Required="True" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_project_task_worklog_details" Label="Get Project Task Worklog Details" Template="TaskWorklogTemplate"
Url="/projects/[$ProjectId$]/tasks/[$TaskId$]/worklogs/[$WorklogId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.worklog" IncludeParentColumns="True">
<Params>
<Param Name="ProjectId" Required="True" />
<Param Name="TaskId" Required="True" />
<Param Name="WorklogId" Required="True"/>
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<!--
************ releases ************
-->
<EndPoint Name="get_releases" Label="Get Releases" Template="PaginatedReleaseTemplate"
Url="/releases?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="$.releases[*]">
<Params>
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_release_details" Label="Get Release Details" Template="ReleaseTemplate" Url="/releases/[$ReleaseId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.release" IncludeParentColumns="True">
<Params>
<Param Name="ReleaseId" 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="get_release_tasks" Label="Get Release Tasks" Template="PaginatedTaskTemplate"
Url="/releases/[$ReleaseId$]/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="ReleaseId" Required="True" ReadAs="release_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_release_task_details" Label="Get Release Task Details" Template="TaskTemplate"
Url="/releases/[$ReleaseId$]/tasks/[$TaskId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.task" IncludeParentColumns="True">
<Params>
<Param Name="ReleaseId" Required="True" IsKey="True" ReadAs="release_id" />
<Param Name="TaskId" Required="True" IsKey="True" ReadAs="id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_release_task_comments" Label="Get Release Task Comments" Template="PaginatedTaskCommentTemplate"
Url="/releases/[$ReleaseId$]/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="ReleaseId" Required="True" IsKey="True" ReadAs="release_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_release_task_comment_details" Label="Get Release Task Comment Details" Template="TaskCommentTemplate"
Url="/releases/[$ReleaseId$]/tasks/[$TaskId$]/comments/[$CommentId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.task_comment" IncludeParentColumns="True">
<Params>
<Param Name="ReleaseId" Required="True" IsKey="True" ReadAs="release_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_release_notes" Label="Get Release Notes" Template="PaginatedNoteTemplate"
Url="/releases/[$ReleaseId$]/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="ReleaseId" Required="True" IsKey="True" ReadAs="release_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_release_note_details" Label="Get Release Note Details" Template="NoteTemplate"
Url="/releases/[$ReleaseId$]/notes/[$NoteId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.note" IncludeParentColumns="True">
<Params>
<Param Name="ReleaseId" Required="True" IsKey="True" ReadAs="release_id" />
<Param Name="NoteId" Required="True" IsKey="True" ReadAs="id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_release_worklogs" Label="Get Release Worklogs" Template="PaginatedWorklogTemplate"
Url="/releases/[$ReleaseId$]/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="ReleaseId" Required="True" IsKey="True" ReadAs="release_id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_release_worklog_details" Label="Get Release Worklog Details" Template="WorklogTemplate"
Url="/releases/[$ReleaseId$]/worklogs/[$WorklogId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.worklog" IncludeParentColumns="True">
<Params>
<Param Name="ReleaseId" Required="True" IsKey="True" ReadAs="release_id" />
<Param Name="WorklogId" Required="True" IsKey="True" ReadAs="id" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_release_task_worklogs" Label="Get Release Task Worklogs" Template="PaginatedWorklogTemplate"
Url="/releases/[$ReleaseId$]/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="ReleaseId" Required="True" />
<Param Name="TaskId" Required="True" />
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_release_task_worklog_details" Label="Get Release Task Worklog Details" Template="TaskWorklogTemplate"
Url="/releases/[$ReleaseId$]/tasks/[$TaskId$]/worklogs/[$WorklogId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.worklog" IncludeParentColumns="True">
<Params>
<Param Name="ReleaseId" Required="True" />
<Param Name="TaskId" Required="True" />
<Param Name="WorklogId" Required="True"/>
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<!--
************ assets ************
-->
<EndPoint Name="get_assets" Label="Get Assets" Template="PaginatedAssetTemplate"
Url="/assets?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="$.assets[*]">
<Params>
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_asset_details" Label="Get Asset Details" Template="AssetTemplate" Url="/assets/[$AssetId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.asset" IncludeParentColumns="True">
<Params>
<Param Name="AssetId" 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>
<!--
************ tasks ************
-->
<EndPoint Name="get_tasks" Label="Get Tasks" Template="PaginatedTaskTemplate"
Url="/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="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_task_details" Label="Get Task Details" Template="TaskTemplate" Url="/tasks/[$TaskId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.task" IncludeParentColumns="True">
<Params>
<Param Name="TaskId" 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>
<!--
************ contracts ************
-->
<EndPoint Name="get_contracts" Label="Get Contracts" Template="PaginatedContractTemplate"
Url="/contracts?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="$.contracts[*]">
<Params>
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_contract_details" Label="Get Contract Details" Template="ContractTemplate" Url="/contracts/[$ContractId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.contract" IncludeParentColumns="True">
<Params>
<Param Name="ContractId" 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>
<!--
************ purchase_orders ************
-->
<EndPoint Name="get_purchase_orders" Label="Get Purchase Orders" Template="PaginatedPurchaseOrderTemplate"
Url="/purchase_orders?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="$.purchase_orders[*]">
<Params>
<Param Name="ContineOn404Error" Type="Property" Value="True" Hidden="True" />
</Params>
</EndPoint>
<EndPoint Name="get_purchase_order_details" Label="Get Purchase Order Details" Template="PurchaseOrderTemplate" Url="/purchase_orders/[$PurchaseOrderId$]"
Method="GET" Headers="Accept:application/vnd.manageengine.sdp.v3+json"
Filter="$.purchase_order" IncludeParentColumns="True">
<Params>
<Param Name="PurchaseOrderId" 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>
</EndPoints>
<Tables>
<Table Name="Requests" SelectEndPoint="get_requests" LookupEndPoint="get_request_details" DeleteEndPoint="delete_request"/>
<Table Name="Changes" SelectEndPoint="get_changes" LookupEndPoint="get_change_details" />
<Table Name="Problems" SelectEndPoint="get_problems" LookupEndPoint="get_problem_details" />
<Table Name="Projects" SelectEndPoint="get_projects" LookupEndPoint="get_project_details" />
<Table Name="Releases" SelectEndPoint="get_releases" LookupEndPoint="get_release_details" />
<Table Name="Assets" SelectEndPoint="get_assets" LookupEndPoint="get_asset_details" />
<Table Name="Tasks" SelectEndPoint="get_tasks" LookupEndPoint="get_task_details" />
<Table Name="Contracts" SelectEndPoint="get_contracts" LookupEndPoint="get_contract_details" />
<Table Name="PurchaseOrders" SelectEndPoint="get_purchase_orders" LookupEndPoint="get_purchase_order_details" />
</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>
<Example Group="ODBC" Label="List projects" Desc="This example shows how to list projects." >
<Code><![CDATA[SELECT * FROM Projects]]></Code>
</Example>
<Example Group="ODBC" Label="Read project details by ID" Desc="This example shows how to read extended information about a single project" >
<Code><![CDATA[SELECT * FROM Projects Where id=111112345]]></Code>
</Example>
<Example Group="ODBC" Label="List assets" Desc="This example shows how to list assets." >
<Code>
<![CDATA[SELECT * FROM Assets]]>
</Code>
</Example>
<Example Group="ODBC" Label="Read asset by ID" Desc="This example shows how to read extended information about an asset" >
<Code>
<![CDATA[SELECT * FROM Assets Where id=111112345]]>
</Code>
</Example>
<Example Group="ODBC" Label="List purchase orders" Desc="This example shows how to list purchase orders." >
<Code>
<![CDATA[SELECT * FROM PurchaseOrders]]>
</Code>
</Example>
<Example Group="ODBC" Label="Read purchase order details by ID" Desc="This example shows how to read extended information about a single purchase order" >
<Code>
<![CDATA[SELECT * FROM PurchaseOrders Where id=111112345]]>
</Code>
</Example>
<Example Group="ODBC" Label="List changes" Desc="This example shows how to list changes." >
<Code>
<![CDATA[SELECT * FROM Changes]]>
</Code>
</Example>
<Example Group="ODBC" Label="Read change details by ID" Desc="This example shows how to read extended information about a change" >
<Code>
<![CDATA[SELECT * FROM Changes Where id=111112345]]>
</Code>
</Example>
<Example Group="ODBC" Label="List contracts" Desc="This example shows how to list contracts." >
<Code>
<![CDATA[SELECT * FROM Contracts]]>
</Code>
</Example>
<Example Group="ODBC" Label="Read contract details by ID" Desc="This example shows how to read extended information about a contract" >
<Code>
<![CDATA[SELECT * FROM Contracts Where id=111112345]]>
</Code>
</Example>
<Example Group="ODBC" Label="List tasks" Desc="This example shows how to list tasks." >
<Code>
<![CDATA[SELECT * FROM Tasks]]>
</Code>
</Example>
<Example Group="ODBC" Label="Read task details by ID" Desc="This example shows how to read extended information about a task" >
<Code>
<![CDATA[SELECT * FROM Tasks Where id=111112345]]>
</Code>
</Example>
</Examples>
</ApiConfig>
