Zoho SalesIQ Connector - Source Code

<?xml version="1.0" encoding="utf-8"?>
<ApiConfig Name="Zoho SalesIQ"
  EngineVersion="15"
  Version="1"
  Id="F3DBC0B8-6AD4-498E-A795-82BBE49A6144"
  Slug="zoho-salesiq-connector"
  Desc="Zoho SalesIQ Connector can be used to integrate Zoho SalesIQ API in your App / BI Tools. You can exchange data on Chats, Visits and more."
  HelpLink="https://www.zoho.com/salesiq/help/developer-section/rest-api-new.html"
  Logo="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJYAAACWCAYAAAA8AXHiAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAAHdElNRQfoAggXCA/IuGqsAAAkgUlEQVR4Xu1dCVxV1dYnEkUCJ1QQFVFxwAlHEGUQNCccPhQTJ5xntMH0OZSzODVZkpIpJs/Mej5ffurrlc/SLPtyTE3LMjVzCK2sV9qz1399ax329RGee+4F77lw8f5/v/9PhD2dfdZZe629197bww033HDDDTfccMMNN9xwww033HDDDTfcKL4gIk/8/HML7NnTAuvWtcDChS3Qo0cuk5L++G9+DhvWAi+80ALbtrUA4KOKdONeBPbujUB6egSioyPg5xeBoUPTaO1aolmziEaPJkpOJmrenKhFC6JWrf77b8uWf6SkiYkhSk0levRRom7dFsPDI0JjrVoRSEmJwOrVESy4pVTVbpQk4L332mLatCgEBUVRQsJQeuIJon79iOrXJ/L2JhKl5WhWrkzUti3RsGGE+PgpLGxRaN06CpmZUSxoqmVuuBzw2mvtKC4uDi1a9KepU4m6diWqUOFOAXAma9cmGj6cEBMzge67L47Gjo2jAwfiVJPdKK7Ahx+2w+TJCQgN7UMjRhA1bKj/gosD77+fWHsSzZtH6Nx5OJ58soN6DDeKC7BgQQwPM0mYNOnf1LEjm+Ke+i+zuLJ0aaLEREK9eqno3r0Lvf9+R/VobhQFMGVKDFWv3htduvxCVarovzRXY7NmRI88QujadSDef7+TelQ3nAFMnRqLypWT0K7ddfL11X9Brs7q1YkmTBABG4T/+7/O6tHdMANYtCiWgoOTWaCuUbly+i+ksPTyIqpUKdfAbt06d3ohPp6od2+inj3vpPw+Li53KqJJE6KaNYnKl8+1nfTKLyxr1SKMH/+bpsEOHnQLmCOBnTtj0bbtQMTGXtFevt4LKAjl5QcHE3XoQCykN+DhkQ1f32w0b56NlJRsLF+ejWXLsrF1azY+/TQbR4/eyZMns7F5czYWLszGtGnZ6NkzGw0bZqN06WwuM0dsJm1Yk/bed59+OwrCOnUIEybc5HoSVbe4UVjg1q1YjByZiqSkb+TL1e1weynapH178cB+J2/vLOrVK4v+/OcsHDjwmKrOYaDLl4fS3r1ZNHVqFgtXFjsTWYiM/JkiIoh8fPTbZydRp84vqFkzFc89101V50ZBgIyMDpg//5w2yajTwXZRtEXLlgRPz5cRGpqJFSsycebMDFWFU4F33klDenomgoIy0bHjr9pzlS2r325brFBBPpAfUbt2D1W8G/aA6taNQ0LC2ULbUbLU0rcvoWXLNVi6dJ4qttgAhw49ykNoBqpWzZDhmEJC9J/DBlGu3HUWrnH8jO7h0Qj07rsiUJPh53dGryMNKXNBkZHEeV/Cww8/y7bRXFVssQb+8Y/HkZi4QlufDAvTfzYj+vsTa8DvEB/fUxXpRl7I8gaGDPmcQkP1O9AaxZvjYQW1ar2EefMWqOJcDjh9ehoGDVoOL6/nC7xi4OlJqF49hw37x5CT49ZeFrBRLWt6n9MDD+h3nB5LlSJq104EajWefLLYDXd3A5o0aY62JFXQj4wFkj3Uy1i/3q292ICNY1vjlDaU5e8oa5S5nYCATMyc6RLDXWGATz4RDfY0PfRQrhOi1w96ZLuUvehLmDr13hQu7rgYjB8/jz22U7odpEcJcZEwlFGjVklwniqqRIO9ycfZCXlKm7DV6xM9suZHdPQ3LJS9VTH3Btiwjsbs2ccL1Fns6aFZs0z885/T78XAOcydm05jxmgaSbd/8rNsWUJY2Ddo1aqXKqJkA59/Ho05c44XyH5ISSHMn/8iC1QZVcw9CXz44cNo2nQZNW2q30/5yY4NgoMvUEREydZcdOJEe9ZUx6hePf2OyM+KFQm+vpnYuHEyAG9VzD0PTJ68VJueEAdGr9/yskwZQkjI1+jQoWRqLhw8WDBNFRYmkZarafbsB1QRbuQB1qwZh9Kll9q16M22KQvXeTY9Spbmwm+/dcKzzx63W1PFxxMee2wVrl3zU0W4oQPuK09UqrTUrlg09rpRr945dOlScjQXe3+PauEleg+cnxJJmZGxioc+t1DZATpwoBS1bLlYi9bI35f5Kd5iZOQ5evhh19dcqFEjhlX2Qd0Hzc/evQlZWTKVUF5ld8MOsO3qhe7dl2hrpPn7ND/Fbk1JOYctW1x3nou6dm3P6vekPZOf8PBYSYsXs0XqFqrCgDV8aQwfvsgu4QoKInaizuL69X4qu+uAFixoj8TEk3bNu/ToQVi1KkVldaOQoLNny2DYsHS7zI5GjYjTutbaKn74IR4LF56iwED9h8pLsanWrVvNhnp1ld2NuwA+/NAbvXotsicUB+XLf05NmriOvYWkpCFaHLjOw/yBFqECKqqsbjgAPAKURcuW6RQQoN/vFsocV9eu5/HSS8V/SKR+/dqjSZMTug+Sl40by5RCpluozAEPh2URELDQ5iRq1aqExo1nqmzFE8jJicXcuV/Y3MpevTrhwQczMXFiJZXVDRPADpEPc4HuO8hDVKx4BuHh/6OyFT9QQkKyzSC1++4jVKq0GsnJbk3lBGDlyr7Uq5f+u7BQhsQePS6yA9VXZSs+QFpaNNq1+1y34Xk5aBDhrbemqGzFFnT4cEccO7Yfr7yyHzNm7MeCBbmcP38/lizZj7ff3o8jRwap5MUW9Nln/hgzZgE1aKD/PiysXJlQv/6jKlvxAH76qR2WLTtvcwiMiiI884xMgAaorMUCdOpUS+zefZBtvoMIDT3Iw8dB+Ptf0MJ65IXIZlTxsoSyDU02tTZtSggMzNHSensfRFTUQaSnH2RBLHbbsjRjvlGjBeTnp/9eFBEc/DU6d+6jshU9MGlSL+3kFJ3G3malSoT27TNp69ZiMQGKDz5ojE2bjvAQcATlyp3VvNigoMKdlyWHkMhLk8jWcuUusVAewezZR7BlS7yqrsiBjz4aQmlp+u23UGK4ypdPU1mKFrhypS0PD+cNT3gRu8rbew1/8eVUtiIDPf98Ax62T6B27XNapIUZZ2aJJyYOip/fJbRte4KGDGmvqi8y8ChRAU88MZfCw/XbrMie5EXW1MkqW9GAG+uBxMSeMour10gL0azZ75gwYbbK5nRwOz2xZk1dTJ58il/2OS0awNFnLFijLPyWKnURTZqcQseObWnz5iILqUbfvt4ICUkXY123rUIJDhw//ir27Su6tUTs2dOGX9ZF3QZaKOEaNWuuxebNReIF4tChYPZ2TmmRlHJ8o14bnUGJifL0vIyePb/EI4+w8VY04dXIzh7DAvabbhstFBsyPn40t/E+lc15kErRrVsi1a2r3zhFdOp0C1lZ81U2pwJ9+gQjPv6MdiSQszSULbItxmbBFTz33Fk6cSJcNdVpkBg3HmXStT7Ra58ijzA59MEHzl/uwTfftGVPMEevUbcpu3SjotbR99871bbC0aM+PNzVQpUqZwp9PoJQTokRgRSbSYYPKUsiNeT/8vu7OUVGZry7d8/B8OHNVLOdBu6fsRg79lfddlnIHjGSkweoLM4Dq9NomT7QbZSiHH6BV1916go6PvmkOhYv/gw+PjkFPjJS0ovwiHfk4XEdvr7X2Ta6zgb4daSkXOch7Dp/7dfRqtV1NGhwnTWP8DctgkMErqCCJsNj7drXEBHhVOHi0aYsDRq02DCiVxyu8uVH0urVzhuyaffu+1GtWg/dBlkoAWWtWm2gb791Wsw62w/VkZ7+habmC/KS5WghX1+Cv/81Nlyv4dln/8y/96fAQH+KjfWnAQP86amn/GnbNn969FF/6tEj9/c+Pv54/fVlPNRf4yH3GguZ8D+GxnF+svZD/fpXWYCbqsdwCnDs2ETWWr8Y9RN/UD+yRu2qspgPevzxcP5yf9JrjIVISLjB2ipdZTEd2LKlOnr3/qJAZ5HKlv6AAMLAgTl44YW/UHBwBdq4sUJBdgTx1+9F169XoPHjK7BwVsCf/rSanz2Hvc/f7R6GRbhKl76KsmWbqGJNB7e7DAYMWKKddZ+/PRbmxsmPwunTpVU288ANKsUGeU/Dsz9leSAi4s/SeJXNVPCDV8eiRafFbtFtT37KCw8MJKSmXsKOHVuxYoWfo9oqgoa0ND9kZq7lj+8SD6e/2xNBqw09vr5XeWh0mubij3ESkpKMFcSIEb/gtdfMP4cLn33WGkuX3tBrhIUID/+ZhyTnaav09E9teTm3KfNKHTpcwN//vh0bNvhISK8qxqHQPsApU3wwa9YGhIVd0E7Fyd+W/GSHgAXrKmJjnaK5tDa2bLnc8IOsXZvQtKn5c1o0cGA4de6s3wihHKnj7b1Bdo+oLKaCNU9Nru+yblvyUl4sG6vo1+/vNHs2G0HkpYowFVzP/RQTU4aF61VtHs2W7ScTlOHhVzFjRlPOa/o8Ep56ajJFR/+g2xZF1KkzRiJTVRbHQwvY7949yfDrk6N0Roz4s8piKqhfv5oICPiSPbjfddtioQwzNWt+idWr3+KXVSQz35SU5IkePV7VtmnZEi52JthovmyWNs0L6Q+UKrVEtx2KbIvdwqpV5i2usy3THEuWGM7asuF6nfbsWayymAY6daoWOnY8rRng+drwB4oGLVNmFws8fw1FMJOcB1y/BwYP3iQnINsSLn7ZP6Fu3RYqq6lA585LDSe6a9SQndTmXWZAo0a1pE6d9CsXiv1SvXq2Sm4qsHLlMVubNFmT3WJvaxf/fL/KViyAIUNe1YTLaJ5NPog6db6TuxPN/iCwc+fD6Nbtqm47FNkWG0cnTpgzdcQVNNCOtc5X6W1KjNLjj7+ukpsGbNpUDzVqfKXNgOu1Q5EN4e/RpYv5rnIhoAkXawJD4ZLlnzFjLqkspgKenssM2/Loo4R33umikjsOMreDPn0G6FaqiDZtvsPWrabPtGPSpKOGnox0UIMGxDbVP/hrL1baKi/Qvv2rPOQZe9je3qK12piutaKjl2mCrtMGjQkJhLQ0x0+W0r594TRnjn6lQnGVvbw2qeSmAS++2Bh+fl8Y2Sg8/N3C6NF/L85CZQFatTprOFMvWmvUKNO1FrKzX9CuctFrg1Da4eERo5I7Dhg7tplhlKjMYHfo8JpKbhowbtwRw42wMosdH3+DUlNd4pA2bNuWrR2kZjCss9a6ipdfbivGv1nAmTMT0bevYQgUmxWPOjyggAuubfhCIyIITz21XSU3BThwoAWCg09bfQkyrVC58i1+WdsLsixT1EBi4iusZa0PibLuOmXKZbPnBnlYXm44lTR/PuHwYcd5h/ySfGjMmNG6lSkiMvIK9ux5QmUxBVi79qjNta1Bg/7tKtoqLxAU9K3Vlyoeoo/PVyqpaUC/fs8Y9m9yMmHp0gSV/O6B775rTOvX61emyOOv+cNgePg+q2uUoq2qVLmFN9/8q3wIKotLQIY4Gjw4i7XWL7rPxmRtcgVz5sSbOhyuWZOp3Z2tU79Gmfzu1MmBgvXRR2E0d65+ZULZ8Fi58l9UclOAvXvboVw560d3y0LvQw+J5nTZs0rZlvrKqlMiFzOlpFxhwTJt5QA7doxCbOxZ3fqFMk9ZqZIDBWvRojDq31+/MmHNmrIGZ65gbdhw1Oi0YH4pt/D006/j6lVflcWlQK+/7oUhQ65bnSeU4dDb+7RKbhp45HlWt35F/rsDBWvQoDC5XkSvIo1ywMfs2eYKVmrqPqpWTb9+6fSQkB/5oV1WW8nUCHt+q+DnZ3049PG5jK1bTd0QCy+vDKP9AdzHrVXSuwcSEsJEePQq0ige4fr15gpWnTr7rAbOyTzQ5MnEX32x2mFdGLCddd7qcCgbYtetu6iSmgI0apRhdMUKRoxYhCtXqqrkdwf+UsIMF3t79iQcP/62Sm4KuJ5376hXkV/Gb1iyZIOrn7Is3ixiYi5Y3Y0tu8lHjjylkpsCdOmSYbgG+9xzhGPHHDPlwOovTLcSRfbWzuHw4XEqucPBD9Kd3fEv9OoWcvt+YbqUJ6gH7ajHGTMuWN2dLeE0ERHmCtbEiRmGN1/MmEH0/vtxKvndwaZgeXiYOwxu335Iu09Zp241KXoDNWoEqeQOB1auDMa4cePQtes4JCbeScvvjf4Vbto0jm0pq3Ns2nrsxo2/WD2JT1YVqlQxV7Ceey6DoqP16xc++STR/v0OE6xA3UoU+e/bVFJTgPT03Va3KskaZWTkDSQnmyJYCAwMRpMmb2p3OMvJM3L+V37K7+V2VKN/hQMHEiZPfoH7SzfigoWuFP72t0VswP+s+6xMzmuuYC1fnmHoqE2YQLRp090LFq5fr4gFC5bqVqJoumDNnbvbaiCaCFZ8/A32Gh0uWKhbtxH8/d+0FZ5TIMppxStXrmTtVEVVcwe4P62u2RW5YCUlEc2Z4wDB+umnMHrjDW3I0a2IabpgzZtnXbAkRnzw4BtYtcrxglWhwhhtz6FevXdDMYBPnGijqvkD+O8PcH9ajeEvcsGSy6EWLHCAYP34Y31at654C9a0aTewa5fjBcvDI1W3zrul3LA/Z45u2DH//R4RrOKusWQoTEq6gZkzXUewRo4kPP/8Pa6xxMZatOgZ3UoUTRes2bN3azHiOnVrs+6tWt1A9+6uIViy3jZ6dCa9+67VyVyut+TbWAIuMOCOCvLQdMFasWK35n3p1K0JVsOGN5CQUPwFS9ZU69Z9kX/WnXLQlnXefHN+sfYKR48myspyjGDxwxTtPNauXYc0d1+nbiFKlZL1tbIqucNQaMGKjCSaNi13zmfWLJLIELRunYnIyMlGGz+1eax1636xGs8vUSQNG5orWM88k0Ht2+vXL5w504kTpK1bX8Thw4+p5A4HDh3qiaCgL/XqFrJg/YYNG+SWC4cu6RRasFq2JLz22tO4eXM4zp8fh6tXZWLU5tYpbeZ9woQLVi+2krjzzp3NFazp0zOk/br1Cx0qWDbWChEaehRnzpi3oZHB9VhdK9QWpzMyCCdPBqrkDkGhBYvJebfwvwU6IVrbit+06QWrh4jIWuHw4eYKVq9eGdpRkXr1C596ynHhyYiICDMKWRVtwgZ2qkpuClh4rUc35G6g+AkjRzpm1V3hbgRLs/18ffehRo06qjib4Hxl4Ol54Y6yLAwJIWzaZOqOHX7XGUaXOyE1dQlrVsdEkWjxWEbrR82aSTzWP1RyU4AZMz6x6hkyUbr0j/yvQ2Pd70qwhDLH5u29jzVQbVWkIThPGX6OC9amdrisb7Fnj6l3OqNcuQyjY5e4TxwYj7V8eRgNGKBbkcbgYAmbNTuCNF67X0+vfibbWbcwc+Ym7NvnsAjSuxYsYa7m+lDORFXFWgU2b/bmfvxRVzPz79Cu3WWV1DTwM9uaWnJgBOmuXWFauIRORRrFqGzQwFTBEmhfv7XoRtnhwt4MP7jDokhtCpYsMNtx4aQ2VJcuvZ81gaFwsYHvifnzk9Co0R0HryAk5AYb9t04jUrteODjj4ejUyerTpIWSXLffQ7epbN2rX5lQvkqPTzM3wXdv/8xo6317GTcwpo1bzhql44twULdus9hyJCNdgmX9JGf38dynpcq3iqQlNQTkyb9TiNG5M7ST5r0K6KiOqs/mwZkZ2fKNcq67RfWrUuIjnacYImrjLS08bqVKYqaxvHjM1QWU4B589rCy+u0Xv0axaZJSLjlqINAbAqWh8c4bNkSiOTkndrlTTpp/sBczfUxlSljW7jee68DsrK6sAnQBXv3xqpfmwp+jmcN9xXKjbgzZjhOsATciSFGsdDUoYN4LKbuhBagXr2PrXqHTH5x/8bUqW/i66/veki0Q7C0DwkLFgTzS/m7XcKVq7kOoVq1YncHNipUeMaob2nqVMLOnQ+q5I6BHHRPcXH6FQrFgE9KMn/T6urVJ4y8Q+3FhYTcdITWskOwpqukFuF6y9aZXRpFc3l7H0aZMsVKuPh5luu2VxEPPjiVjh2roJI7BvT66+H0yCO6FWqUzvLyelUlNw04fLgZOwpf2nCJ/4369bfTE0/c1dE/XNbQ/GXnpUVjWcDCVYOF6227hCtXc32CSpWqqexFCmzcOBFxcdYPBZHlJA+PaJXccaCDB8uiW7chupUqsp11DXv2zFVZTAPWrzec09LmgeS6lZSU7XfjRSEycpjV4a1JE0KfPrNU0tu4LVxyeaZevryUkJ/SpY+z9ipy4cL48c8bLuWEh8v1vuZcJsASW99wDJb7V+bOfUMlNw24dKkhv/RzhpdWinDJ8DxgwA6VrcBA796VEBh4503wop2Dg1fRnDm6M9BYuDCIhWuX4UFmFuZqruP8IRTpnkj2qJcajQI0apTsHTVHsGjo0JZipOtWLJS7YQICNqjkpgKxsaHcGed125GXsslz/PgdhdVc/DH5ID5+oXb2qtzL2KuXCGsml2a4Dlgg4crVXMdQtqxDl6TsBRvkaWyTfqvbNkW0apXmyMnnPwC7drWg6dN1K77NDh1+YPd4kcpiKtj7+9Su2yhkjY2HRZWtwNDMgEmTwmRHOLvbYXTmjF2Hj9GyZQHo12+33ZqrXLkT8Pd3unBhzJhlhsOgXCNTpUpHldzxkLAO9gyTdSu3UIbDmTM3qiymAn/9ax1+2WcNd2lbGBQkJw5u55+deiS3DJfUr9+7dt2c8V/NZXUHj6PBmvw+8vVdfMdwn4eszf6DadO6qyzmgB58MFwLZMtX+W2K9xAQ8Ao32Cnnf/LwXAuhoV9pSzr525KfEhbs7b2d5Mz33buddj4p5sypYrdwWTRXQIBThAvbtk1io/x73bYoolatcZSZ6fBAyj8A77zTmqX3pl4DLGTN8C/avt30SwQsoPr1a/GXftZow8dtynpXhQrn2MN9k4eoMs66mgXp6ZXooYfe1W7K12tXXuZqLtOFSz5+7odlhvFXcuFWtWrmX9JEJ054UefOvQ1vf5fGNG/+ssriFKB8+RB+GefsEi5ZyJZogcDAC+jffws/ywP0+usPwOQrRlhzVWSba4/V45jyUoRLNJeJwyJOnnwYo0ZJuJF+G5jo3PkGpk93zsXj7HqGa1opXyPyMcvZZ4GyrSCayz7hEloEzM/vMiZOvIy1a1/ll+nHAuCH06f9JNSZv2rdy5y0r53/zh6VHwYO9NPyeXhoP/PfVKo7wTZX+QIJV67mqqyyOxQYPvxJat5cv25FVKkyEjt2OOcSBrnOFVWr9tJriIXcGTcQHe20q+UsoHLlamvCZWCM3kG2a7TQHz+/3+Hjk4OePXPkvmvu0Bxs3rySBaZiftLmzXOwZUsOC2QOWrfOYdsth3+f+3PfvrIUZBWa4CYn77VLuCw2l4M1F2VlleHnXWT4EcpNI927J6kszgFiY6O1eCS9BgnlaytbdgMlJzvt6l4LNJsrNPSc4WWd1igdLROvsqFBYsx9fP7DAvPdHfT2vqUtyotHKo6D5QXlRo3e4GF2MFassPql0+zZD9ituUS4HKy5MGJEGpo1M74VY+zYH/H2284ZBi3AP/8ZhUceuabXIAu5c39F+/ZOvWzcAkyZEoJBg85pxrIMeTrtM5NISLjJbTA0enlYLGu35pIP1c/vuCM0F5fnxTbpEkOtzh4sYmLG8LDuvMvGBVyhJ7p27WEz0qB06XX8hRfJoWj47LMQvPLKlwgOvmJ4uZQZlGEkMbGvaopVyKWcmnAZXc5gYW5/HrsbzcXv7QF2WJ5AzZq/6tahiJSU77Bxo/neoB6wf38Epk41vN1Ui+ps1GglHTlSoK1QjgJ3ZBksXRrK3s+XKFXqYqGGx8KwdWs55yBZNcMQWqx7v37v2yVcuZrrGA/XhVpbpEOHRmP8+P9odmX+si0UEyAsbKwoD5XNueCK5czKXhQaemfjLBTbIzqasHjxkypbkUDmqzByZEPWsrkCZhS06ADyMHKVDXu7w4mVcO2zW3N5e0vITYH2UeKjj/wQGbnQ1rOzpv2W7UNTdwPZBPbsicKkSdb3wgnFoK1S5SW0aVPkh8+yN+eJp59uIofE8pd/QYtXF0PdUXaYnBPq4/MtfH0LvPFBE67kZPs0l0RYSDxXAYIFsWDBMMTH/0e3PAu5boSHTyxo200BPfRQb2rR4s5G5qWs1fXokYHDh02ZkykM8MEHzbFhwwnWuic0l/6BB77RZqH9/TUBsSlsYvz6+eUu0jZoILc25KBVqxMYODBRVVFgyNJJgTRX6dJHOa3tGHoPD28W9vm25viQmnqRHTPnTjFYA33/fXse6i7YPP2uUyfCs89OU9mKHfDGG9F46aUjLBhH0LTpEX4RR/iF5DIw8Hs2eOV05v/+zt//CKKjj7D2O4KdO4/g0CGHvBBNuOzVXLk211EkJTUDEKyK+AM0Tdip0zztA9Arw8KGDWXeKk1lKx5g2yUWoaFndBtsoSxQV6myipo1KxJD/m6AffvG0vvvz1H/NR2sSX3sNuiFbdoQvfbaAfrhhz/sXWRhq0hr1syhBx/Uz2chOzX405+u4NKlPipr8QFatuxnMyRXPI62bVfT9OmODcovgdCEq29f++a5hBIuvWbNx3K8pypChvu+NJFNJr30eYj69c8hJcXm9EiRgN54Iw6DBn1lGDIslA5IS3vR4Ts+SiC0xXEZFu0VrubNRbj+V/KyUHqjYsW5tuwqLRAyNnaqVmFxBdsmMWyPnNR9gLwUeysz80VW1cVil0pxhiZcornsCblhsv33IVWtGocWLebZjLCVNdLx47+hzz6za86tSIGOHYdYPfA/L1NSCFu3jlTZ3DAA/vY334IIl7bSYCuwUKaBGjf+Bg89VPzsKj2wh5SAceM+t/m1iLvs5fUCu/kVVVY3DIDsbImK2GO3cNkgSpU6jerVXUOoLMCcOTFISPjccLuYUNxlH5/VFBzstrfsAGVlldeEy54wZyOyzYaoqCIJELhraPZWpUpHdR8sL2XbmK/vKv7ZLVx2QISL+va1L4Zej3Ir/oAB53l47a+KdD1g9OhJhluLLJQlCh8fl5zjKgqw51eRNdc/7dpxnZdifjRpcgqTJ/+PKso1gZs3O+OZZz61erNEXormKlNmFVatGsjeokve7exMaMKVmPiOXdvfLGzdmjBlimsOgfmBQ4diMH36ScPdIHnZv7/MxbxAdhxhfa+DfHz8UaPGP2zOHVrYrh1h2bL5KrvrA2+/HYthwz6VHTy6D5yfMs81dWoGay6XvznVbFC9ev4IDHzL3lgzeHi8hRkzRnHfNlRFuDbo4Yfj0LWr/cIlJ5zExa3E8uVu4bIBREZWRc2aO+3WXB07El55ZTd+/bWECNesWbnCxZ6J7gPnp6wtsseIRYsm8xfmnG1ILgrUrl0V1artsNvmiowkvPzy7pKjuUS4Row4aRgvn59duhD69l3Jdpdzg/tdDIiJCdQOnbN3VIiKIqxevZt++qmBKsK1QWfPxuGJJ05S48b6D6xHCRYsX/5FzJ07nQXMqYd7uBLwyCOB6Njxf+1aVhNGROQKF1EJEa7jx+MwcOA8eHpaPwlZj/Hxcl7TSmzePFMV5UY+YOfO6khN3Wa4HyEvxVvMHRZvh9y4PODjk4CgoC8kEFD3ofUodkSfPnIAyfOqGDfyAevXB2nCZa/mUsNi3ngulwfbUB3Rvv0XWgx5/gc2oixPeHmtQps2i7B9e5HuBCqOwLp1NVi43izQsJiZKZorVBXh+sCsWfEYN+6MXPqk+9BGlBBeOcaxdesXacUKp4UQuwI04RoyxH7hatuWsHZtCROuTz5JQP/+kxEaet7wsFVrlOOV5E4dH59VGDXqWRw5csfJxvci2H4KxvDhb1q9Ajk/RbhkWLx50+5r8VwCGDo0AYMHfy3bqnQf3BYlHLdJE6KePWVb1mr2lDKwY4epV7IUd+AvfwlGWto2mXjW7bP8bNWKaM2ad1lzlTDhevvtBHTuPIqHt0sFMuzzU/JKZ8bGSnBbJmJiMvlrzMRbb5l23XBxBb37bi3MmLHN5j5QC8XmWrv2PRauEFVEyYFme82de4W6ddN/+IJQziwQeywmRnYLycEYWVS+fBY7D1k0fnwWPf98Fu3YkUUXL2bh/PkhqgklCiwkvli0aL2mkfT6KD8lImL16j1086bNOxddDvjXv0S4BmL06GtykotuBxSWYsvJkdly3he73DLLLxd/suBdgYdHdgnkS6hZc59d1+FZyBoOa9bsxXffNVKvpGQBBw50YO8vmQXsunaii14nuGkOJWBzwID26lWUTOCjjzpg0KC+ePLJn6l7d8cd6uGmIdlb34vExMbqNZRc0A8/yJpjIgUEJKNPn9/sujPQzcJT7idq0qST6v57A7RqVRy6d++HmTN/166gLcw8mJvGlHCnoKA41eX3FvD559FyxSyio/vTsmXaxti73i7lZi6bNSN07erY63tdEbh4MZqWL4+jxo3jEBc3jNLTiYYOJe3uY3ujLd28TYSETKHUVPdOqvzAqVNRyMyMQkxMFHx9ozB48CQeQommTNGmGLTpBpnfkXU1W4dp3EvMPalwCv/stDuIXBpE5Ilr1yKwfXsEli+PQEpKBHr1iuBhNAIeHm5a6OcXQaNHu6N33XDDDTfccMMNN9xwww033HDDDTfccMMNN+yHh8f/A/llnxlcCKfDAAAAAElFTkSuQmCC"
	>
  <VersionHistory>
    <Change Date="2023-12-31">Initial version</Change>
  </VersionHistory>

  <ServiceUrls>
    <ServiceUrl Name="US Domain" Url="https://salesiq.zoho.com/api/v2/[$Compnay$]"/>
	<ServiceUrl Name="EU Domain" Url="https://salesiq.zoho.eu/api/v2/[$Compnay$]"/>
	<ServiceUrl Name="AU Domain" Url="https://salesiq.zoho.com.au/api/v2/[$Compnay$]"/>
	<ServiceUrl Name="IN Domain" Url="https://salesiq.zoho.in/api/v2/[$Compnay$]"/>
	<ServiceUrl Name="CN Domain" Url="https://salesiq.zoho.com.cn/api/v2/[$Compnay$]"/>
	<ServiceUrl Name="JP Domain" Url="https://salesiq.zoho.jp/api/v2/[$Compnay$]"/>
  </ServiceUrls>
  <!-- https://www.zoho.com/crm/developer/docs/api/access-refresh.html -->
  <Auths>
    <Auth Type="OAuth" Desc="OAuth Connection for Zoho CRM API" HelpLink="https://www.zoho.com/crm/developer/docs/api/register-client.html"
          ConnStr="Provider=Custom;OAuthVersion=OAuth2;ScopeSeparator={space};ReturnUrl=[$RedirectUrl$];ExtraAttributesForAuthRequest=access_type=offline&amp;prompt=consent;AuthUrl=[$AccountUrl$]/oauth/v2/auth;TokenUrl=[$AccountUrl$]/oauth/v2/token;ClientId=[$ClientId$];ClientSecret=[$ClientSecret$];Scope=[$Permissions$];ExpiresInAttribute=expires_in_sec;" TestEndPoint="get_departments">
      <Params>
		<Param Name="Compnay" Label="Company Screen Name for URL (e.g. mycompany)" />
        <Param Name="ClientId" />
        <Param Name="ClientSecret" Secret="True" />
        <Param Name="Permissions" Value="SalesIQ.operators.READ SalesIQ.conversations.READ SalesIQ.feedbacks.READ SalesIQ.departments.READ"/>
        <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>
    <!-- When name not specified in EndPoints node .. its considered as base for all other template -->
	<Param Name="date" Options="2023-12-31T00:00:00;now;today;yesterday;yearstart-10y;monthstart;monthend;yearstart;yearend;weekstart;weekend;yearstart-1y;yearend-1y;monthstart-1d;monthend+1d;monthend+1d-1y" Desc="The date for which to retrieve the report in YYYYMMDD format. Supported functions now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)"
	ValueTemplate="&lt;&lt;{$value$}||unix_timestamp_ms,FUN_TO_DATETIME_UTC&gt;&gt;" />
		
    <EndPoint Name="Pagination">
      <Params>
		<Param Name="PageSize" Value="99" Hidden="True" />
		<Param Name="PagingIncrementBy" Type="Property" Value="99" ValueTemplate="[$PageSize$]" />
        <Param Name="NextUrlEndIndicator" Type="Property" Value="regex=(^$)|false" Desc="Stop pagination when more_data_available is false or missing"  />
        <Param Name="StopIndicatorAttributeOrExpr" Type="Property" Value="$.more_data_available" />
        <Param Name="PagingMode" Type="Property" Value="ByUrlParameter" />
		
        <Param Name="PagingByUrlAttributeName" Type="Property" Value="index" />
		
        <Param Name="PagingByUrlEndStrategy" Type="Property" Value="DetectBasedOnMultipleRules" />
        <Param Name="PagingEndRules" Type="Property" Value="&lt;ArrayOfPagingEndRule&gt;&lt;PagingEndRule&gt;&lt;Mode&gt;DetectBasedOnResponseStatusCode&lt;/Mode&gt;&lt;StatusCode&gt;204&lt;/StatusCode&gt;&lt;/PagingEndRule&gt;&lt;PagingEndRule&gt;&lt;Mode&gt;DetectBasedOnResponseStatusCode&lt;/Mode&gt;&lt;StatusCode&gt;304&lt;/StatusCode&gt;&lt;/PagingEndRule&gt;&lt;PagingEndRule&gt;&lt;Mode&gt;DetectBasedOnResponseStatusCode&lt;/Mode&gt;&lt;Mode&gt;DetectBasedOnRecordCount&lt;/Mode&gt;&lt;/PagingEndRule&gt;&lt;/ArrayOfPagingEndRule&gt;" />
      </Params>
    </EndPoint>
    

    <EndPoint Name="NoPagination" Template=".">

    </EndPoint>
	
  </Template>

	<EndPoints>
		<EndPoint Name="get_feedbacks" Template="Pagination" Url="/feedbacks?limit=[$PageSize$]" Filter="$.data[*]"  >
			<Params>
				
				<Param Name="Ratings" Key="ratings" Options=";happy;neutral;sad" Type="Query" MultiSelect="True" MultiSelectSeparator=","  />
				<Param Name="OperatorIds" Key="operator_ids" OptionsEndPoint="get_operators" OptionsEndPointValueColumn="Id" OptionsEndPointLabelColumn="EmailId" Type="Query" MultiSelect="True" MultiSelectSeparator=","   />
				<Param Name="DepartmentIds" Key="department_ids" OptionsEndPoint="get_departments" OptionsEndPointValueColumn="Id" OptionsEndPointLabelColumn="Name" Type="Query" MultiSelect="True" MultiSelectSeparator=","   />
				<Param Name="AppIds" Key="app_ids"  Type="Query"   />
				<Param Name="StartTime" Key="start_time" Template="date" Type="Query"  />
				<Param Name="EndTime" Key="end_time" Template="date" Type="Query"  />
				<Param Name="TimezoneOffset" Key="timezone_offset" Type="Query"  />
				<Param Name="VisitorEmail" Key="visitor_email" Type="Query"  />
			</Params>			
			<OutputColumns>
				<Column Name="reference_id" DataType="DT_WSTR" Label="ReferenceId" Length="50" />
				<Column Name="question" DataType="DT_WSTR" Label="Question" Length="4000" />
				<Column Name="created_time" DataType="DT_DBTIMESTAMP" Label="CreatedTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE" />
				<Column Name="attender.email" DataType="DT_WSTR" Label="AttenderEmail" Length="500" />
				<Column Name="rating.type" DataType="DT_WSTR" Label="RatingType" Length="100" />
				<Column Name="rating.value" DataType="DT_WSTR" Label="RatingValue" Length="100" />
				<Column Name="feedback" DataType="DT_WSTR" Label="Feedback" Length="1280" />

				<Column Name="visitor.phone" DataType="DT_WSTR" Label="VisitorPhone" Length="500" />
				<Column Name="visitor.email" DataType="DT_WSTR" Label="VisitorEmail" Length="500" />
				<Column Name="visitor.name" DataType="DT_WSTR" Label="VisitorName" Length="500" />
				<Column Name="visitor.supported_operations" DataType="DT_WSTR" Label="VisitorSupportedOperations" Length="50" />
				<Column Name="visitor.ip" DataType="DT_WSTR" Label="VisitorIp" Length="500" />

				<Column Name="support_ticket_id" DataType="DT_WSTR" Label="SupportTicketId" Length="100" />
				
				<Column Name="attender_id" DataType="DT_WSTR" Label="AttenderId" Length="500" />
				<Column Name="attender.display_name" DataType="DT_WSTR" Label="AttenderDisplayName" Length="500" />
				<Column Name="attender.type" DataType="DT_WSTR" Label="AttenderType" Length="100" />
				<Column Name="attender.image_url" DataType="DT_WSTR" Label="AttenderImageUrl" Length="1000" />
				<Column Name="notes_available" DataType="DT_BOOL" Label="NotesAvailable" />
				
				<Column Name="conversation.reference_id" DataType="DT_WSTR" Label="ConversationReferenceId" Length="50" />
				<Column Name="conversation.mode" DataType="DT_WSTR" Label="ConversationMode" Length="50" />
				<Column Name="conversation.id" DataType="DT_WSTR" Label="ConversationId" Length="500" />
				<Column Name="department_id" DataType="DT_WSTR" Label="DepartmentId" Length="500" />
				<Column Name="start_time" DataType="DT_DBTIMESTAMP" Label="StartTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE" />
				<Column Name="end_time" DataType="DT_DBTIMESTAMP" Label="EndTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE" />
				
				
			</OutputColumns>		
		</EndPoint>
		<EndPoint Name="get_conversations" Template="Pagination" Url="/conversations?limit=[$PageSize$]" Filter="$.data[*]"  >
			<Params>				
				<Param Name="Status" Key="status" Options=";open;closed;waiting;connected;missed;end" Type="Query"  />
				<Param Name="OperatorIds" Key="attender_id" OptionsEndPoint="get_operators" OptionsEndPointValueColumn="Id" OptionsEndPointLabelColumn="EmailId" Type="Query"  />
				<Param Name="DepartmentId" Key="department_id" OptionsEndPoint="get_departments" OptionsEndPointValueColumn="Id" OptionsEndPointLabelColumn="Name" Type="Query" />
				<Param Name="AppId" Key="app_id"  Type="Query"   />
				<Param Name="Email" Key="email"  Type="Query"   />
				<Param Name="StartTime" Key="from_time" Template="date" Type="Query" />
				<Param Name="EndTime" Key="to_time" Template="date" Type="Query"  />
				<Param Name="VisitorType" Key="visitor_type" Options=";lead;contact" Type="Query" />
				<Param Name="UpdatedTimeStart" Key="updated_till_time" Template="date" Type="Query"  />
				<Param Name="UpdatedTimeEnd" Key="updated_from_time" Template="date" Type="Query"  />				
				<Param Name="SortBy" Key="sort_by" Options=";end_time;updated_time" Type="Query"  />
			</Params>		
			<OutputColumns>
				<Column Name="id" DataType="DT_WSTR" Label="Id" Length="500" />			
				<Column Name="question" DataType="DT_WSTR" Label="Question" Length="1000" />
				<Column Name="status" DataType="DT_WSTR" Label="Status" Length="500" />
				<Column Name="start_time" DataType="DT_DBTIMESTAMP" Label="StartTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE" />
				<Column Name="end_time" DataType="DT_DBTIMESTAMP" Label="EndTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE"  />
				<Column Name="chat_duration" DataType="DT_WSTR" Label="ChatDuration" Length="500" />
				<Column Name="missed_reason" DataType="DT_WSTR" Label="MissedReason" Length="500" />
				<Column Name="owner.email" DataType="DT_WSTR" Label="OwnerEmail" Length="500" />
				<Column Name="owner.id" DataType="DT_WSTR" Label="OwnerId" Length="500" />
				<Column Name="last_message_info.message.rating_string" DataType="DT_WSTR" Label="RatingString" Length="100" />
				<Column Name="last_message_info.message.rating" DataType="DT_I4" Label="Rating" />
				<Column Name="visitor.country_code" DataType="DT_WSTR" Label="VisitorCountryCode" Length="50" />
				<Column Name="visitor.name" DataType="DT_WSTR" Label="VisitorName" Length="500" />
				<Column Name="visitor.email" DataType="DT_WSTR" Label="VisitorEmail" Length="1000" />
				<Column Name="visitor.id" DataType="DT_WSTR" Label="VisitorId" Length="500" />
				
				<Column Name="visitor.channel_details.channel" DataType="DT_WSTR" Label="VisitorChannelDetailsChannel" Length="100" />
				<Column Name="visitor.channel_details.source" DataType="DT_WSTR" Label="VisitorChannelDetailsSource" Length="4000" />
				<Column Name="visitor.supported_operations" DataType="DT_WSTR" Label="VisitorSupportedOperations" Length="4000" />
				<Column Name="visitor.ip" DataType="DT_WSTR" Label="VisitorIp" Length="500" />
				<Column Name="visitor.phone" DataType="DT_WSTR" Label="VisitorPhone" Length="500" />
				
				<Column Name="visitor.type" DataType="DT_WSTR" Label="VisitorType" Length="100" />
				<Column Name="visitor.channel_name" DataType="DT_WSTR" Label="VisitorChannelName" Length="100" />
				<Column Name="notes" DataType="DT_BOOL" Label="HasNotes" />
				
				<Column Name="unread_chats" DataType="DT_BOOL" Label="UnreadChats" />
				<Column Name="uvid" DataType="DT_WSTR" Label="Uvid" Length="500" />
				<Column Name="status_code" DataType="DT_I4" Label="StatusCode" />				
				
				<Column Name="department.name" DataType="DT_WSTR" Label="DepartmentName" Length="500" />
				<Column Name="department.id" DataType="DT_WSTR" Label="DepartmentId" Length="500" />
				<Column Name="app_name" DataType="DT_WSTR" Label="AppName" Length="100" />
				<Column Name="last_modified_time" DataType="DT_DBTIMESTAMP" Label="LastModifiedTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE" />
				
				<Column Name="app_id" DataType="DT_WSTR" Label="AppId" Length="500" />
				<Column Name="type" DataType="DT_WSTR" Label="Type" Length="50" />
				<Column Name="chat_status.state_key" DataType="DT_WSTR" Label="ChatStatusStateKey" Length="50" />
				<Column Name="chat_status.status_code" DataType="DT_I4" Label="ChatStatusStatusCode" />
				<Column Name="chat_status.state" DataType="DT_I4" Label="ChatStatusState" />
				<Column Name="chat_status.id" DataType="DT_WSTR" Label="ChatStatusId" Length="50" />
				<Column Name="chat_status.label" DataType="DT_WSTR" Label="ChatStatusLabel" Length="500" />
				<Column Name="chat_status.status_key" DataType="DT_WSTR" Label="ChatStatusStatusKey" Length="100" />
				<Column Name="reference_id" DataType="DT_WSTR" Label="ReferenceId" Length="50" />
				<Column Name="missed_time" DataType="DT_DBTIMESTAMP" Label="MissedTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE" />
				
				<Column Name="visitor.uuid" DataType="DT_WSTR" Label="VisitorUuid" Length="500" />
				<Column Name="supervisors" DataType="DT_WSTR" Label="Supervisors" Length="4000" />
				<Column Name="owner.image_key" DataType="DT_WSTR" Label="OwnerImageKey" Length="500" />

				<Column Name="owner.name" DataType="DT_WSTR" Label="OwnerName" Length="500" />
				<Column Name="owner.is_bot" DataType="DT_BOOL" Label="OwnerIsBot" />
				<Column Name="owner.call_enabled" DataType="DT_BOOL" Label="OwnerCallEnabled" />

				<Column Name="ended_by.name" DataType="DT_WSTR" Label="EndedByName" Length="500" />
				<Column Name="ended_by.type" DataType="DT_WSTR" Label="EndedByType" Length="100" />
				<Column Name="ended_by.id" DataType="DT_WSTR" Label="EndedById" Length="500" />
				<Column Name="attender.image_key" DataType="DT_WSTR" Label="AttenderImageKey" Length="500" />
				<Column Name="attender.email" DataType="DT_WSTR" Label="AttenderEmail" Length="500" />
				<Column Name="attender.name" DataType="DT_WSTR" Label="AttenderName" Length="500" />
				<Column Name="attender.is_bot" DataType="DT_BOOL" Label="AttenderIsBot" />
				<Column Name="attender.call_enabled" DataType="DT_BOOL" Label="AttenderCallEnabled" />
				<Column Name="attender.id" DataType="DT_WSTR" Label="AttenderId" Length="500" />
				<Column Name="participants" DataType="DT_WSTR" Label="Participants" Length="4000" />
				
				<Column Name="attended_time" DataType="DT_DBTIMESTAMP" Label="AttendedTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE" />
				<Column Name="last_message_info.sequence_id" DataType="DT_WSTR" Label="LastMessageInfoSequenceId" Length="50" />
				<Column Name="last_message_info.sender.name" DataType="DT_WSTR" Label="LastMessageInfoSenderName" Length="500" />
				<Column Name="last_message_info.sender.id" DataType="DT_WSTR" Label="LastMessageInfoSenderId" Length="500" />
				<Column Name="last_message_info.type" DataType="DT_WSTR" Label="LastMessageInfoType" Length="50" />


				<Column Name="last_message_info.time" DataType="DT_DBTIMESTAMP" Label="LastMessageInfoTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE" />
				<Column Name="last_message_info.last_read_message_id" DataType="DT_WSTR" Label="LastMessageInfoLastReadMessageId" Length="500" />
				<Column Name="last_message_info.id" DataType="DT_WSTR" Label="LastMessageInfoId" Length="500" />
				<Column Name="visitor.status_while_end" DataType="DT_WSTR" Label="VisitorStatusWhileEnd" Length="100" />
				<Column Name="customer_info.company" DataType="DT_WSTR" Label="CustomerInfoCompany" Length="500" />
				<Column Name="last_message_info.message.text" DataType="DT_WSTR" Label="LastMessageInfoText" Length="50" />
				<Column Name="last_message_info.message.formatted_text" DataType="DT_WSTR" Label="LastMessageInfoFormattedText" Length="4000" />
				<Column Name="last_message_info.message.message" DataType="DT_WSTR" Label="LastMessageInfoMessage" Length="1280" />
				<Column Name="last_message_info.message.time" DataType="DT_DBTIMESTAMP" Label="LastMessageInfoMessageTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE" />
				<Column Name="last_message_info.message.mode" DataType="DT_WSTR" Label="LastMessageInfoMode" Length="100" />
				<Column Name="last_message_info.message.operation_user.name" DataType="DT_WSTR" Label="LastMessageInfoOperationUserName" Length="500" />
				<Column Name="last_message_info.message.operation_user.id" DataType="DT_WSTR" Label="LastMessageInfoOperationUserId" Length="500" />

				<Column Name="owner.aboutme" DataType="DT_WSTR" Label="OwnerAboutme" Length="500" />
				<Column Name="attender.aboutme" DataType="DT_WSTR" Label="AttenderAboutme" Length="500" />
				<Column Name="last_message_info.edited_time" DataType="DT_DBTIMESTAMP" Label="LastMessageInfoEditedTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE" />
				<Column Name="last_message_info.edited" DataType="DT_BOOL" Label="LastMessageInfoEdited" />
				<Column Name="visitor.user_id" DataType="DT_WSTR" Label="VisitorUserId" Length="500" />
			</OutputColumns>		
		</EndPoint>	
		<EndPoint Name="get_operators" Url="/operators" Filter="$.data[*]"  >
			<Params>
				<Param Name="LastSyncTime" Key="last_sync_time" Template="date" Type="Query"  />
			</Params>
			<OutputColumns>
				<Column Name="id" DataType="DT_WSTR" Label="Id" Length="500" />			
				<Column Name="first_name" DataType="DT_WSTR" Label="FirstName" Length="500" />			
				<Column Name="last_name" DataType="DT_WSTR" Label="LastName" Length="500" />				
				<Column Name="email_id" DataType="DT_WSTR" Label="EmailId" Length="500" />				
				<Column Name="nick_name" DataType="DT_WSTR" Label="NickName" Length="500" />				
				<Column Name="is_chat_enabled" DataType="DT_WSTR" Label="IsChatEnabled" Length="50" />
				<Column Name="is_enabled" DataType="DT_WSTR" Label="IsEnabled" Length="50" />
				<Column Name="is_deleted" DataType="DT_WSTR" Label="IsDeleted" Length="50" />				
				<Column Name="role" DataType="DT_WSTR" Label="Role" Length="500" />
				<Column Name="wms_id" DataType="DT_WSTR" Label="WmsId" Length="500" />
				<Column Name="type" DataType="DT_WSTR" Label="Type" Length="50" />
				<Column Name="modified_time" DataType="DT_DBTIMESTAMP" Label="ModifiedTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE"/>
				<Column Name="status_code" DataType="DT_WSTR" Label="StatusCode" Length="50" />
				<Column Name="status_message" DataType="DT_WSTR" Label="StatusMessage" Length="100" />
				<Column Name="notify.new_visit" DataType="DT_WSTR" Label="NotifyNewVisit" Length="50" />
				<Column Name="notify.return_visit" DataType="DT_WSTR" Label="NotifyReturnVisit" Length="50" />
				<Column Name="zuid" DataType="DT_WSTR" Label="Zuid" Length="100" />
				<Column Name="is_owner" DataType="DT_WSTR" Label="IsOwner" Length="50" />

				<Column Name="is_confirmed" DataType="DT_WSTR" Label="IsConfirmed" Length="50" />
				<Column Name="description" DataType="DT_WSTR" Label="Description" Length="500" />
				<Column Name="maximum_concurrent_chat" DataType="DT_WSTR" Label="MaximumConcurrentChat" Length="50" />
				<Column Name="created_time" DataType="DT_DBTIMESTAMP" Label="CreatedTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE"/>
				<Column Name="image_url" DataType="DT_WSTR" Label="ImageUrl" Length="1000" />

			</OutputColumns>		
		</EndPoint>
		<EndPoint Name="get_departments" Url="/departments" Filter="$.data[*]"   >
			<Params>
				<Param Name="LastSyncTime" Key="last_sync_time" Template="date" Type="Query"  />
			</Params>		
			<OutputColumns>
				<Column Name="id" DataType="DT_WSTR" Label="Id" Length="500" />			
				<Column Name="name" DataType="DT_WSTR" Label="Name" Length="500" />
				<Column Name="modified_time" DataType="DT_DBTIMESTAMP" Label="ModifiedTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE" />
				
				<Column Name="is_enabled" DataType="DT_WSTR" Label="IsEnabled" Length="50" />
				<Column Name="created_by" DataType="DT_WSTR" Label="CreatedBy" Length="500" />
				<Column Name="is_public" DataType="DT_WSTR" Label="IsPublic" Length="50" />
				<Column Name="image_url" DataType="DT_WSTR" Label="ImageUrl" Length="1000" />
				<Column Name="is_system_generated" DataType="DT_WSTR" Label="IsSystemGenerated" Length="50" />
				<Column Name="created_time" DataType="DT_DBTIMESTAMP" Label="CreatedTime" Functions="UNIX_TIMESTAMP_MS_TO_DATE" />
				<Column Name="description" DataType="DT_WSTR" Label="Description" Length="1000" />
				<Column Name="display_name" DataType="DT_WSTR" Label="DisplayName" Length="500" />
			</OutputColumns>		
		</EndPoint>	
	</EndPoints>
	
	<Tables>
		<Table Name="Departments" SelectEndPoint="get_departments"/>
		<Table Name="Operators" SelectEndPoint="get_operators"/>
		<Table Name="Conversations" SelectEndPoint="get_conversations"/>
		<Table Name="Feedbacks" SelectEndPoint="get_feedbacks"/>
	</Tables>
	<Examples>
		<Example Group="ODBC" Label="Get Departments" Desc="List all departments">
			<Code>
				<![CDATA[SELECT * FROM Departments]]>
			</Code>
		</Example>
		<Example Group="ODBC" Label="Get Operators" Desc="List all operators">
			<Code>
				<![CDATA[SELECT * FROM Operators]]>
			</Code>
		</Example>		
		<Example Group="ODBC" Label="Get Feedbacks (i.e. ratings)" Desc="List all feedbacks (ratings)">
			<Code>
				<![CDATA[SELECT * FROM Feedbacks]]>
			</Code>
		</Example>			
		<Example Group="ODBC" Label="Get Conversations (i.e. chats)" Desc="List all conversations (chats)">
			<Code>
				<![CDATA[SELECT * FROM Conversations]]>
			</Code>
		</Example>
		
		<Example Group="ODBC" Label="Get Total Feedbacks by Rating Type and Operator for Last Year" Desc="Count Feedbacks by Rating Type and Operator for Last Year.">
			<Code>
				<![CDATA[SELECT
 OwnerEmail,
 OwnerId, 
 RatingString,
 COUNT(Id) Total
FROM Conversations
GROUP BY OwnerEmail, OwnerId, RatingString
Order BY OwnerEmail,RatingString
WITH(
	  --OperatorIds='81565000003048017,81565000002408043,81565000013131025' --You can supply Operator Ids to filter result for those Operators only
	  StartTime='yearstart-1y'
	, EndTime='yearstart-1d'
)]]>
			</Code>
		</Example>	
		
		<Example Group="ODBC" Label="Get Feedbacks (more than 99 rows)" Desc="Get Feedbacks (more than 99 rows). Pagination is not supported so this example shows how to workaround this issue to fetch more rows (assuming each month has less than 99 rows).">
			<Code>
				<![CDATA[SELECT * into #t1 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-01-01', EndTime='2023-02-01');
SELECT * into #t2 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-02-01', EndTime='2023-03-01');
SELECT * into #t3 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-03-01', EndTime='2023-04-01');
SELECT * into #t4 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-04-01', EndTime='2023-05-01');
SELECT * into #t5 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-05-01', EndTime='2023-06-01');
SELECT * into #t6 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-06-01', EndTime='2023-07-01');
SELECT * into #t7 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-07-01', EndTime='2023-08-01');
SELECT * into #t8 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-08-01', EndTime='2023-09-01');
SELECT * into #t9 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-09-01', EndTime='2023-10-01');
SELECT * into #t10 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-10-01', EndTime='2023-11-01');
SELECT * into #t11 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-11-01', EndTime='2023-12-01');
SELECT * into #t12 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-12-01', EndTime='2024-01-01');

select * from #t1 UNION 
select * from #t2 UNION 
select * from #t3 UNION 
select * from #t4 UNION 
select * from #t5 UNION 
select * from #t6 UNION 
select * from #t7 UNION 
select * from #t8 UNION 
select * from #t9 UNION 
select * from #t10 UNION 
select * from #t11 UNION 
select * from #t12;]]>
			</Code>
		</Example>
		
	</Examples>	 
	

	
</ApiConfig>