Reference
Source code
<?xml version="1.0" encoding="utf-8"?>
<ApiConfig Name="Zoho SalesIQ"
EngineVersion="15"
Version="2"
Id="F3DBC0B8-6AD4-498E-A795-82BBE49A6144"
Slug="zoho-salesiq-connector"
Desc="Read and write Zoho SalesIQ data effortlessly. Integrate, manage, and automate chats and visits — almost no coding required."
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 Ver="2" Date="2025-02-03" Type="Fix">Increased length of LastMessageInfoText, Supervisors and Question columns to 4000</Change>
<Change Ver="1" 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&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="United States (US) Datacenter=https://accounts.zoho.com;
United Kingdom (UK) Datacenter=https://accounts.zoho.uk;
Europe (EU) Datacenter=https://accounts.zoho.eu;
Canada (CA) Datacenter=https://accounts.zohocloud.ca;
Australia (AU) Datacenter=https://accounts.zoho.au;
India (IN) Datacenter=https://accounts.zoho.in;
Japan (JP) Datacenter=https://accounts.zoho.jp;
Saudi Arabia (SA) Datacenter=https://accounts.zoho.sa;
China (CN) Datacenter=https://accounts.zoho.com.cn;"
HelpLink="https://www.zoho.com/accounts/protocol/oauth/multi-dc.html"
/>
<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="<<{$value$}||unix_timestamp_ms,FUN_TO_DATETIME_UTC>>" />
<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="<ArrayOfPagingEndRule><PagingEndRule><Mode>DetectBasedOnResponseStatusCode</Mode><StatusCode>204</StatusCode></PagingEndRule><PagingEndRule><Mode>DetectBasedOnResponseStatusCode</Mode><StatusCode>304</StatusCode></PagingEndRule><PagingEndRule><Mode>DetectBasedOnResponseStatusCode</Mode><Mode>DetectBasedOnRecordCount</Mode></PagingEndRule></ArrayOfPagingEndRule>" />
</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="4000" />
<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="4000" />
<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="4000" />
<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" Slug="read-departments" Label="Read departments">
<Desc><![CDATA[<p>Reads all departments configured in the Zoho SalesIQ account. This list includes department names, IDs, and status, which are essential for routing chats and organizing operators.</p>
<p>The <code>Departments</code> table allows you to view the organizational structure used for chat distribution.</p>]]></Desc>
<Code>
<![CDATA[SELECT * FROM Departments]]>
</Code>
</Example>
<Example Group="ODBC" Slug="read-operators" Label="Read operators">
<Desc><![CDATA[<p>Reads all operators (agents) associated with the account. This includes their profile details, availability status, and associated departments.</p>
<p>Query the <code>Operators</code> table to manage agent accounts and monitor their current status.</p>]]></Desc>
<Code>
<![CDATA[SELECT * FROM Operators]]>
</Code>
</Example>
<Example Group="ODBC" Slug="read-feedbacks" Label="Read feedbacks">
<Desc><![CDATA[<p>Reads visitor feedback and ratings submitted after chat sessions. This data helps in evaluating operator performance and customer satisfaction.</p>
<p>The <code>Feedbacks</code> table contains ratings and comments provided by visitors.</p>]]></Desc>
<Code>
<![CDATA[SELECT * FROM Feedbacks]]>
</Code>
</Example>
<Example Group="ODBC" Slug="read-conversations" Label="Read conversations">
<Desc><![CDATA[<p>Reads all chat conversations between visitors and operators. This includes message content, timestamps, and visitor details for auditing and analysis.</p>
<p>Use the <code>Conversations</code> table to retrieve full chat transcripts and session metadata.</p>]]></Desc>
<Code>
<![CDATA[SELECT * FROM Conversations]]>
</Code>
</Example>
<Example Group="ODBC" Slug="read-feedback-summary-by-operator" Label="Read feedback summary by operator">
<Desc><![CDATA[<p>Reads a summary of feedback ratings grouped by operator for the previous year. This aggregation is useful for performance reviews and identifying top-performing agents.</p>
<p>This query aggregates data from the <code>Conversations</code> table, grouping by <code>OwnerEmail</code> and <code>RatingString</code> to provide a count of each rating type per operator.</p>]]></Desc>
<Code>
<![CDATA[SELECT
OwnerEmail,
OwnerId,
RatingString,
COUNT(Id) Total
FROM Conversations
GROUP BY OwnerEmail, OwnerId, RatingString
ORDER BY OwnerEmail, RatingString
WITH(
--OperatorIds='81565000003048017,81565000002408043' --You can supply Operator Ids to filter result for those Operators only
StartTime='yearstart-1y'
, EndTime='yearstart-1d'
)]]>
</Code>
</Example>
<Example Group="ODBC" Slug="read-feedbacks-manual-pagination" Label="Read feedbacks with manual pagination">
<Desc><![CDATA[<p>Reads feedback records in batches to overcome API pagination limits. This example demonstrates how to retrieve data month-by-month and combine the results using <code>UNION</code> to get a complete dataset for a longer period.</p>
<p>This approach is necessary when the total number of records exceeds the API's single-request limit, ensuring all data is captured by iterating through date ranges.</p>]]></Desc>
<Code>
<![CDATA[SELECT * INTO #t1 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-01-01', EndTime='2023-02-01');
SELECT * INTO #t2 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-02-01', EndTime='2023-03-01');
SELECT * INTO #t3 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-03-01', EndTime='2023-04-01');
SELECT * INTO #t4 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-04-01', EndTime='2023-05-01');
SELECT * INTO #t5 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-05-01', EndTime='2023-06-01');
SELECT * INTO #t6 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-06-01', EndTime='2023-07-01');
SELECT * INTO #t7 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-07-01', EndTime='2023-08-01');
SELECT * INTO #t8 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-08-01', EndTime='2023-09-01');
SELECT * INTO #t9 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-09-01', EndTime='2023-10-01');
SELECT * INTO #t10 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-10-01', EndTime='2023-11-01');
SELECT * INTO #t11 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-11-01', EndTime='2023-12-01');
SELECT * INTO #t12 FROM Feedbacks WITH(OperatorIds='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>