Mailchimp Connector - Source Code
<?xml version="1.0" encoding="utf-8"?>
<ApiConfig Name="Mailchimp"
Desc="Read / write MailChimp Campaigns, Lists, Members, Reports and more in without coding."
Slug="mailchimp-connector"
Id="9acfe153-b7b2-49b1-b62d-7d3d55d6af64"
Logo="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJYAAACWCAYAAAA8AXHiAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAACxMAAAsTAQCanBgAAC9QSURBVHhe7Z0FeJTH1sdpr5RLFW7vbe9te/uVlgr03pYCLQ5xF0hCjBBiBJdAAiRAsECCQ3B3D27Bpbi7U7xYcSmW850zm3f3lbPJbjaypLvP83t2d/aVkf/OnJk5M28JALBhI99hA23YsBQ20IYNS2EDbdiwFDbQhg1LYQNt2LAUNtCGDUthAzkiXe1LNHa2K9HIsU6JcKe6JRo51UHqlgjD76H2tUo0dKhdIgTfQx1qlQiqW6NEsF1NAX0ORBrUqV4iEAmoXU1Ax+uuoYWuF+PuKO4p3l3sS0S7OYjPhPSZ3ptkh0nfJeh7E3cn/TWk77p3xMPJ8D37c6yns/6zdN1Y/C6dT0jXjnFzLBEl3Qs/03nR+E7f6RxxHXEt3X2l69Hv0v31x7k7vo6f/Zt6Omcgp5D9sR7O/fG3j3W/644zpEuXN5SnxqC8j3CxE1C5UZlR+dB1pLTorpUdh+xwum6Uq4NROG1wsIEcxVBYryFfIoFYqInIYCzQEfieijTD8MrZBa4/n5CubZGwPJzK4zGxeL+JyD7kIQIML5DjeOw4xBvP/Qtdg65lE5Z1CesveLwnFtIkLLBfZQVojKtITzyntPwe4rN5wnodP9th+Ai83kXZ9c3lEl6nKV7zTzZhWYewPsKM64MFc01VUKZyA+/jLd1D3M80Yf0HP/fC8y+prmcpm6Jc7T9Qi0mOTVgM+SYsD6dP8H0sFsRTVcHkhZcoku547dfF/XIWVlU8nuwlasq4a+lp4esOkR6u0MDBDvzs7MDf3g6CHe0h2t2JPV4C73EmxL7mx5S/HCE2YWnJB2G9hxnfDwvgibpAzKFvrCss7OcOresZwvC6i/Be73DCwvCa+Pta+TXUdG4cApMH94f+vftAWONm8L/qrlDm/75n+fSrSvBTpepCaNy18J4HMB9LUl5y2ISlwgJhvYbfozDTb6gLgSM6MBBCO3QH/36TwWfMSvCashm8Jm2AwJR0uLzaC+Cgj+CX5V6QEOQiP/cY3u9LvbDcHctjj3Kp7HcFncJDIGPiONi5dRukDRmdo5iMUfH7qhDlpq3FsJbsFYH5w0FCsAlLRl6Ehe+fYW2xXp3xapr4+UJwYpoQkfOqi8glDd+2TIPzqz30wiJubfSGnlEKcd3F+wZigQzFz89l4Tq8XGBIl05wYMc2OHn6LLSM7wYfflmFFY2plP26MieuhxiPMpQHHDZhyTBXWJgpMZjB91UZriAqOBj8+08Bl6VnWDHJ+ahmPZiUZq8QFvF4pzekt3Nlry/R3NsVJvTvC5fP/wIXLl6GZnFd4B9lf2CFkhe+++4nzT0xL9pSXnFQmdmElY3pwnIsg7XUAnVGy4lp4A9+/aeCy4rzeuHUX30Spvw8Fg7ubg9jt0yC8DX7FML64HsHCAuqrhEW8XK/D8zu7a65TzOsocalpcCvly7Cnbv3ILFnf/iwnGU1lDHI0JffG/NgA+UJh1RuNmEhpggLM6Q6ZqrRMaFYbzcI6joQXJecUoim34px8OhAoEYwZ/Y0h8kotpi1u6CsXyv4v/I/wPN93vrf724z2FzEhjEeWDvp7jWocwc4f/oUZGVlwZRZGVCuYl1WEPkFGfSq9D7GP9mfdb1SLY2xObQJC8lNWJgZZKAbHUJoHBkLntO3KwQl8V1gE1g32VkhEjWnMn0htVMdOLfKYGfR55ZRNeHZXoPYDi8Mhz1bNmH2AFz59Tr4hjZhhZDffPFNZU2aY9wcykq1lBqys2zCQnIQ1p+w2h+ozlSJWB93COgzDpxXXmBFRXwT2Q3++fn3MCZFa0PlRqVqlcHbqyrc3uoDWZfHAbx4jFkDsGj5avj8+zqsCAqCDz//QZN2tDVrUF5xUD7ahIUYEdZbKCqjXfrIsHCspbaxYpLzfafR+gJq20RZAxFX1nnChiku8FQVTnRsWQuqO/nB4SNHMEsAHj58hL29ZEWhFwbvf/a9Jv0RLvZOVC4cthorG42wXO0/ivVwPqDOTInQDj1M6u0RP03cDqW/tdMXkqdHVbi52VMhoIzhjvDV95UgIrQ6zBnqCLd/JvuqHlw8OAF+f/oUswPgwOFjUMXOW1HghcU/ylbU5AH+8epGCVFooXy0CQtRCesLrKl+UWckEevjAX6DZrICMkadpb9AyW6L4b3KHvqC+l+VynB4kZtCXLvmusLXFSvpfq/uDOfP7MNsAGGgj544w+IxKUv4uBzbFH4niUUNCcImLEQSFv4LK2KmsRPH0cFB4Dl1Cyue3CjVbxOU7LUK3q0VpC+sT76pCMvGOCnEdWW9JyR0agO3fruNWQBw9959aNiknaKQi4KvKlTR5Afml9FBUpohsAkLoethQmtght1RZyDROKopuC04yorGFP4+dBu8kboB3uizFt5xMfTk/o62S1rnupB1AIV1qB5kXZ+HSc9CUGdHjkPFWoZarij5qVI1dZ7clItFDQnCJiwk0sWuNmYWO5Ie1qojuCw7ywrGVD4evVsnrGzeCuisKLj2LbFZvH8Ak617zc5YCh99XVVxTFHiXqu2Ik/QVFhNtRKHJJQ/jLCMgYmriZnFelQGd+qT41CCqXw56aBCWMSbEWlQpmwlYZCfOXcekwzw7NlzSOjWly3couLvSGNXR0W+oCi6cwOjhDQZ/YcWFl7rp1gjNVWDXiNZkeSF72Ye0wiLcEmbDbfv3MXkAly7cRPc/BuzhVuUfFlea1+hLVqTyocj3LmuEESxF5Yx8Hwy1G+rM428BMithRNIXqk896RCUGTIR4xeAk+fPcOkAuw/dBQqVHVmC7aoca5eS5k/aF9hzcRO51BTSOVDgii2wuLEJIHnl0M74boqwxAX8BswnRVHXqHainqFkqhKtZsM7dJGw8uXLzGZACvWbICPv7Eee0rOP8tWhCiVZynm2wS5UOTQwOgfVlh4zAeYqDPyzBJgTeU3MP9E5bjiInw6dq+hpuq7Dt5ukAiJvQeKsSl6jZk0E/7xef65uKj5AXtzn3ylGxvLC5UqVlXmEYLNoCOVDQeVSfEXFkOQXc03m7g77lZnFuE3YBorkLxQa/E5KDN0q15UJbsugveq+0P3vkMwabpBz259BrOFaQ5Uo9SpURN8nezAz8UevBzriu9f/fdHYXSXq1AFBreoD50beYJTndrieDrvX1+YJuYgrYvyOWzuXpf3AiWovCj/i7WwOILr1vgT2gFLVBklCOg7nhVIXqgy7yS82d/Q9L3ZYhSU/qYmdE/Vier58xfQokM3tiDzwidfVhKiGt7aH8a3b6BnWCs/aNHADZrUd9GHDUKReTrUFcc383eFr1GA3DWJCvibOp/wTxmHNRbaU1rIaC+2wqLvksDU4PVogagmswKTh7ICyQv/nXEUSqZtzG761sPbNF71WUVI6jUAk0TDCc+gUdP2bEHmxAefV4RKlasJUTT2cYJWgW7QIdQDEhp6QlyIO8T6uUCLADeFsHKiTxNfGNHGH8bGBUCop6OYC5Tfj2q7QAdNbXUba6a31TWVBJUD5XOxE5YkLg68TrQqkwQh8T1ZgeSFchMPGJq+3qvhXYdwUUjtEnuJpo9qqkaxcYoCzAkqbPtatYSARrcNYAWSXySGe8G/yxmaR1pIoc4rNNq7C7dsBior6U9dLIXFgcdVw4zROOk1ah4HzjL34bziuPIifDJmj0FU3ZfBez/5igKKbtVR9P5IWOSLLhWcKXxevgr89GN1cEBxBbo7QHKkNysKjrHtAmBoCz/oF+MLvSO8ITnMC7qEekJSiKd4p++9I3xgQGw9GIU1F53TKcxTuMeQoBu5OCjyCqHa6j11LSVBzWCxFJYxGjrW/hD/aZdVmQSR4ZHguuQ0KxRzcFhxAT4csVMvqr+hkV66oosQhl9YM9H00atryiCNcEyBbCAyzOOx1lLbUHJG4m+p0b5CNG3ruynSagpx/m7QN8oHfPBetX+sofkdbahEKgsOKhtJRMVKWCH2ZFux0IYWm9WZFBPgB+5z97NCMQcS1T/TdxhE1XkelP6vvRCEnWewcMqj18jx0zSCyYmP0BinAu4V7cOKSCK9pR/0CPeGdn7mC8kYsV6YPx7qcSvnC5Eu9qXI+VENTd9QeRRTYfFEudrTymRlJnm7gfeEdaxQzMF++QX4R/p2g6g6zoLSFWoLYXxXww2u37iFSQBYtGw1vK8yjI3xMQqqkZcTjMxumjjI1kqJ9IG4fBRTbmDh1pfXUHKoLIqlsIyB57ljpmSpMyk/pmocVKIqFT8dSn9dQ4jjPxVqwNHjpzD6ANt37YN/fWW8Oy/nv2gst8fmjpq8ro29NIKi2omaueZeigWsBQ4a5ksp7zmkcihewtLZTyx43Mexns631JkUGteNFYo56Jo/WU2VgDVVtqhokWjmus0YdYDTZ8+bvdiBfLPc7OrA0FZ+ekENQwO8U5CHIh2FCZZBPImFgzpGxVJYRngNI7tak0Fh4Sb7qBuDpmg+GC6zqRLn65s/In3MFIw2CO/PH2p7KkSTG19+WwW6yGqq4a38oXNw0QlKxgvMey8SCEexE5Yx0K6KU2dOrK8HeM7g1/yZitPKS/DRqF16UdEUTen/OeiF0bx9V4wywNOnz8A9IEIhmtxwqVtbDFaSoMagDUVDAc3QiFanowi5h/lflsqBg/K9GAgLPztjG88Q4WL3LWbC76pMAf+0SaxYzOGz8fsMouqxAkr/4KYXhnO9MLGShsaqYtsmKUSTEx9+8YOYcpFqKRouaOlTuDaUqaAA1kr5z/HKCysMbSgj/AkjukOdIY2atQPnlfwOL6ZSftphvajeSFkD71X304vjq8r2cPXX6xhdgNTBoxTCyYkvKlTRDydQLzAhULs3g7WBrQH2DutimWh5xYVFieC7vRjBeHVGxPjVA7eMw6xYTKXSnBNQUhJV3/XwroPBw5OM9U0/78So6nzU//6ZacMK5MoyFHt5JKo0rKVaeFtnLaUm1sPpGOb161QWJB41r6awsv8VHBHOdl9iwh+rM6L+4NmsWEylxsIzCge9d+opJ48HpI/DaAJs3roLPihXWfGbMWpWqwGj0I4a0y4AEq3DODcLFNc8LJM3SDAcr5ywUDzCO5HhNUzsOnUGiCaQEYup2C07D+8O2qIX1ZvRAxUCadC4BbxEm4qGFcp+Z+gZ5oRdzVrCm2AY1lZt6uW855U1E+3mMBcF9BqJSA0NQbwywqKIUjPIgccEahLu7QEVhq3DnlzebSv5/F+p+BlQ5gvDQGeFn5zFkALtSfWjvY9CPMaQREWTwoU9yGkqtN9WWusImD0oCRakJ8PY5DbQ1t+LPRbtrZZqA14OCcLqhcUZi9mUwtrqgjrRP7ZIEYKgeby6WPNwwsmJryYblmqV7LFcMazwPtpVm7fuhGfPn4NviGlbCNXA5o+avp7h3op4WhMD42Lg/PY58OjMagU3Dy2BUV1acefcQ3H9E8HCZyCPB+sXFk+0m2NPdYJD/AOhVJ81emG8PXAL/JRhuhfDj/NPQck03blvpKKxXjdUIRLJtbhtp56KcGNU/KGq6PXRdIw6rtbCjP6d4OHpTI2o7u6fCTc3D0PSIb19Y815TdwdU1lRIVR2VisscnflbkTgb//BxGkM9s8TxutFJUEend9OP8IKSQ7Vbm8P3Kw/7+1Apf9UTdcAMQA6YtxURbgxaEiB/M2LckomJ6jpWzqmt0ZQj85kwu0d4+HG+oF6zi9PhbZ+miGRG1gOf6Fy4rDeGkvloiEH/y2TVYkEr4axCkGpoRUzNC3DiYr490jDyHqpthOhjGyDWGoC9x44DMtXbxCf5QLioI3KekT5QEcrHZ+KD/aFvUvHMKLCmmrvdIWoJGb0bKq5DorDSS4aOdSTt0phMTaVINLFrgImSvEEhlhPF/h3l9kKIXH8fdg2qL3knEZU5KsuHUOLSeV2FdE+KUUsKjV1/R8tVOgYaH01VUtfN5ie1hFuHlzMiur+kQUookEaURHH5vfUXA/NkX6cmUJYbY0l+VOrobEUdQKdI9opBJQTbw3YLFbSSKKqveQX5XiVW1OFSGg44cjxU9gbdFKEG4OWWRX0GFWreu5Y69QTNU+7AC9o4WPcP4uOG5oQC6sm9IVr+xdpxCTx4NhiuLlxCCsqicSGvoprx3o4b5ZWQashUVilsDijENtumg98KU9cEy9XeL/7QoV4coMM9K+nHBLC+pdsaOHNZukaoQwZNREcfRpqwjnKlq8MnQpAVNTtn5TSAXYuHAm/7lvICuP+iZWiF3d17wK4sjtDHHf3+Ar2WDX3jy7MVVTEmI4R6rjdVdtWcsj7weqExQyGUo01TZUwsI9OUIjGHPT7ViG0CKJ0+VoKoVSq4wWNm3VQhOVEhFfODzoyl9Z+HrB4ZE+4fXQZKwjLyYS7+2bAjQ1886dm8YDWmjjiH/5DEgcHOV1anbDUtRXe5BNMiOJRH7F5qK2M8a5ztEYo1Z0NE865UaVStXx1d+ndLAwu7pzHiCF/uH8kA279PJIVkDF+ntBZE08UR3WutiJosNQKhaW8AdZW9Pw/RaJcGrdhRWIub7Y07GycF6gXGO6i3EPKEga1j4E7x5azgrCEh6dWwr0Ds80WlMSReT00cUVxBHGiIsiAt3Zh/RUTodkb9OOkGaxQzKFkyhoo/Z1phrkxfOrUVcTLElKaN9KK6vQqrGHQZto/C+7snQZ39kzF9+ni+71D84SN9ODEMiEcOpZ4eHIFPDi+BH+fL875betok5s8Y1xcmaaJLwqkg1w4coT5Ym3CkttWUW4OAeoE+QU3ZoViLrQDDCcWU2H258wzbf094dIuQ/NHwri9cwIKYjBb0EVBS1/lBDoKZKC6ppKwSmHJ7atYD6fl8sQQ5ePSWaGYAy0wLVPOtJU0HP/5shI2BflnsK+akJpdQ2XCnd1T2IItDH5Z1pcNJzqF+CjijGUzgxtuIEg0ViusaFeHf2ICFEZ7hK+PYk4wr7zrEsMKxlTq1c2/JrBjaH24f1LXlP22bQxbqIXB+tHxIj4DWobA1TX9Nb/3ig5QxBuFtVYuHDlUa1mhsHQXxpu3kCeEqBPTmRWKOZTqMF3sBMMJxhS4jTMsYUF6d1Fb/bZ9rKYwC5PBrUP1cZrRI1bz+5A2DRXxjvV0PqxuAiWEkKxNWHTD7KpU48j3SeI0Vizm8J5sM39z+aBsRc1OwpZyevMM3ZiSqiALmx6R/vo4kT11TtUsjk+MUsQb+U0uHAkSkHi3NmFlX/gdjPgzeUIa1a8PJVPXs2IxlVJtJrCCMZW6VWvKM9ZiaGSdenXWYKT3adJAEbcFaS0Vv8/t01zxO5KFAvmbJBxsGlE8BkFZnbDohlideqgSAfZR8axYzOG9mg1YwZjCx+XQYFdtnGEpfWiIYc9URQEWFSM6hCvjhkKT/56ZHqf4nUBDvTw9WZ9Ehd+tW1jUq8CbawZFv24/ghWLqZSKm8wKxlRcaiif0pAfDO/cHG5tTlcUYFGxqL/SY7SFjyv8unaA/vfd07oofidQUFOwrP7zigjLgf4BmepElOmxhBWMqbxr34gVjCl8+lUlmtFXxCc/GJ/cSlG4RcHNTcPg9q6JcGnLJNg4cxBkTkqDKX3joVNDPzi5sLf+OBokJSdBJh3Ucyc/uS+svinEHsclWcQhvF49Viym8rekDOwJ5n37a7ea+V9bERO7NVUUcmFCrsc0ek8T0tLArJwHpzLht72zFPZfatMgNh3ZPMcKYQIK5xOrFBaq/lOMpGIrIt/QaFYwpvKOr+l7gKqhwdCCqK0I6mnJC9sUrmHzdGxeMuyYEA+bR7WDrWPbw4EZSXB5VRp7PAeN6j+kKSBGUGrk/loHZydDXECufvyPUWC9UEB6w94qhIW1Vao6so6RcaxgTKFkymook73lUF5w0j76I98YiQazutCNcSUzDTaNbAtTO4Xo932QM7FDIKwa1AzOL+/Dni9xZ/dkVkDEw5PLhZDE3KMsnDxMad6Rfrt+YBHMH9YN2gcpR+IZzqKY7KxJWJqN/ms3SWJFYwpvRg1gBWMK//r8h3ydupFo5avz/OzXPJgtfDUnMrrD9KSGSiHFB8L0xFCY2lkptMkdg+Hw7K7sdWhCWi4YvXCOLlR5PgyCo4sHwt75A9mVPAQ5E5I9RjMH6vTJeIlC6oFCer3IhYWROaGKHNSM7cqKxhQsGWKoXqW6Ih75RZewejA7pTl0DPGRFSbP6UW9YFJCEEzAGmlJagzsmtwRzi3pDdfXGY65uqYfHJubDOvTW8M0FNvE+CA4g+fJr0PQ5LZaIOQ9ofZ+OL2wp16op9aO05wj596JlZA5MVW4QnNpJbBpnIfCeqNoaywPp+nqiNnl0VuUnsmc1+kb2kw/zFmzPXW+cWpRbzE/dykX22jftM6wfXwH7JWlsr+rIRvs8KwucArFIQ+neUi1KO4eWwaX1w/H35XC2jUpQS+sQ0vTNedxkLfr3MFdxDAFl15kD5ZtMxTWW0UiLLxpZYyEwnj3zmWJlzHeaqhcYErPlPnimyrw3Xc/wY8/VBOuL5UqVoPy3/4oBkDlx3KP/shP5vVtoShMS7iwvC+cWtATzi8zbl/RtJFcCFd3z4XJnUKFeBakxOiFS03i2cyhooacmtgQbh0yvhCD49TG6dAtKsfe4zUUV/1CFxZdFO0sxRL6SF9vKNl3HSuenHivhr945kytH2tAAwe7XHt3jVwchbH+dYUq4F2nDntMfhEf5AVXV2u9CEzl+roBsHNiPMzq2khfuxAzu4bB/umJmuN1QwsGAZzZMFFx3srBLYWtJf1+eccsuLF/geIcU6HaiwZ/uXRnkxXt5tiCPE2NwWmDgw3koGoSq8wZ6sh83lG72jkn3k/OAPc6KCbVdayJBf2U83GmQqJamtZECIKEtXpwCzHsQEMQ28a1h5/HxGnOUQuLjPI1ozrphZU5sqPid0uhcbBJvduz6c7mBdZaVbk1pASnDQ42kINqrBg3Rz91ROoHR2CtlfskNB1TuWVfiPG2/t3yWtdzU4xumwoZ9GuHtRJGNve7HBqDolXOwnWZEcDFbTPg5JqxaISbtmTMHEi8i4YkwOA2DVnbC5vEDdyiV4LTBgcbyJHtlvxXrLU0O8o4RrXPsUl8KyUTPMOaKc7JiRwMzUKjd3QA61hnMdjTI29U9ZhUYUL+91KP88SCXpqFr0gWViQfSnaVHE4bHGwgh1QVRrnaB6siIfAMawpv916lEdU7vVZAQFCY5ngJ8iuf0LMdbJ2XDhd2zNV5bWLiH5xcBZd3zReLQqf2TYD2gbkO/OU7w+MaieZNI4488tv2ccIdR13Qhc3dvdMU8dowOkGTdjR9HOVOghKcNjjYQA7ayU8Cb6qxtYigBiHwD7ShJFGRuzItsuCOJUEtHd3L5MWfNC4zb2hX9loFyeiExnDNEnFhzUA9uvuHM9h0FTZUW6lXWW8e10mTbmwOXciuVsNpg4MN5KAHAMko2YR5MAAR6esFX3UYJYTlGMkbiQPaRcPVPXnr2UxO6cBesyAZ3LphruNaEjc3DobbOybAvQNz4MHxpRhnfoS8qFBviXR5VT/oHuGnSTPWTp+qayuC0wYHG8ghb2dp66Jse2ukOkISXtg0cuETe8Vhz8S0iVaO20eWQYcgjU1QYKQ1C4LjGb0UI+ocVCvdOzjXqDFuDdDiWHmcya9rYKsQTZqxXHfTeBYHpw0ONpCDEZaoGrHKDMXIPFBHjoP20TQ2x0XcPLAAzm2cLKYrzm+ZKkagueMWDu/OXr+goCVW2ydpx6AIcgi8f3g+G09rQmyJJJsiItuRJtuZ9GahgJzkD4OQw2mDgw3kMCYsIS53x/IYoaOqCCqgvQ/ITlInmGqv/QsHw5xeMfqxG4kJ8YGwYlh7uLR9puIc2kOBrkkObrSFkPpeBQUZ88czDEMJ1LujNYfyuFkjtC+E3H+LRDU6QbNTjQBF1Yu2OzIGpw0ONpAjJ2FlQ5vbanafIZp7u4pVL+oEX9szD+anxGoEpYYmb/cvGqI4Nzk6GPq2bAzpnUwfxsgPSMyjEiLhzgFs9mTxsVZo2b+8pvp1TX/xB+HShlBtVY7KlqNQm0KJ6Ox3FJfm6fRT+sRrEnxt73yY3iVcIaAFKVGweXQ72D2lo5hwXTO0pcL95Himwb1kcp8OYs9OchFR368gaRvgBSfWT1WkxRp5eGqFxlAnN2ayGbl0SWDrM1panMzBaYODDeSQREVjWdIDBOhGJDJSsgTaXDPlEaV/uHz/A5FobD4yUpvrBTM7ORxOLuihyASJq6v7weohLcRxM7tFYIbpjOM1U/qLcS6aXJXfryChnfoOrZqgSIs1Qka6ekjh6Pyewi1ISkvLeh6wd8sm6NhII7T71PrIKw05nDY42EAOSVg0Ecl1Q7N5DSN2Qx7Rge2iNQk/umKkXlTzU5rC1XXG1+9dWz8ErqN9sHJgM3H8pW26JpV2y6N3GlAtrJF6ErM8HdaGbo+tEZo8XDuyA7Spb7BF44Lqw8lDB7BYAVbNm61II9HE3ametN8DLcSgMqfdAAlJD7nBBnIYaiza050VVYkYN4fP1JFcPq6PJgOWDGwjREIuIJe3Gl+/t3taEkxNDBO9xKs/TxDn0Oy++npdIwIV9ywIRia11NzXWiCnQLEtkir/qOkbFa8coO7RLBquXb6ERap73bl1S7PKB4WFzaHYA03UUvQ0Enp8CoGnmAQbyCEJiwZI6UkHHGhnucgjSBxZPUmRCQ+whiFjnESyani8zlNSlSESUzuHwpYpPfXnHlwyTHEtCRpwbV6AtVZcA+8cN6ItKmg0nxMUQdM08YHKR6RMGdwffn/yGItT+erbrqXiOOQS2sp+aNa8UWjCIuRtrhyMSIQqgsLJX54Z1/fNF6IiDi9NhwfHlrAZQ5Cf+Jye0XDjQM6j9CMSW4j5RhKA+v75werJ/dj7FgU0eU09vVtbyMNUm2eH53SH/i2CFfGPDw2AvT/rno/NveaNG604XsYlLFO/QhEWNXlURXKgylvLI0ZVrHpA9OruOXphkWsIjQMZ2yF440hdkzm5Ywhsm55idMB0XPe2YgK7W2TOPZ680KVxA4tmCvIFzCOyn3La9I32fadmT96s0WeqpR7cu4dFaPy1fe1qRZpV0BBEhxC7miUIPNwk2EAOg7BIRE4sKKyW8khR86TOpN8OL9YLi8axKOz2rklsZtFA3vrhrfXHz0qOhKu7tA8vOrZWt3SqR4x2esJS1k8foLlfYSD2Jz00D8U00egfj9gzrSsMaxemsZNS41rB2WNHsehyf50+ckhxLkMWVigOBTqORReXG+xysNZqpI4UN9o+o2tjIRTJEH94YrnRfyJBC0FnZC+zmtU9Suyhrr4mkRiu3ITMUqhpNXVvdovAGknsT3pwrlhfyPXs5Jxb2gcW9W8NyY21k8c9mseIZo+eiW3q69eLF8Rqnj7NwyE5KlgjUgKbxJ0F5kFKkPEudUXVoJ3loI4QNVHqjNw0qbsQybFVhgFP9QSpGlrwSTYXnXc8U7uyhVxu6REi6vtbAnlSqO9jEadXicWl9w7OgTt7pokBzFtbUESykXFjHMvoKfZ1pwFO7hmLae1bw76tW8wSlPR6+fSRIp70SDsSmOoeWVhxNMDDWX2oYQM5JGHphht4YSH/VkUGdiwcoYg0cWN/hliJsm5skiI8t62DJH/ynbPTFOcR536epbhvfrCTibu5kP8TuSDrFp7mLiDicmY/2Du9qxiWoW2MEoL4Tkkbf2+YMmQA/HLyBBZR3l9Zz3TCurbfsGhj37Kx3D2P4OGsPtSwgRxyYXFDDRJ484vyyMzs31kfWTlnN06GlenaqR713JacJak6Ye2epx2oXF0AUzuWDjFQzSQ18edXpIo9FvbO6Aq7pibB1gmdYN2oeFg2qA3M7t0MxnaKFCuwOwb7QDMmLhI0Yj6iZ1fYuWEd/P5YO3SQl9eL3++Lp7helLUu1NKo74029HQ8nNWHGjaQQy6snOwsvPkEeWQ6h/nn6CrDQQ5yYp5LJrArq/uL3iEJ69wm7T4H/dtEKjLBUsgVWn0PcyDDm+JNxnWf2LwP4JK906N5NMwamQ4Htm9lx6EseT198gTG9u0FS0b1UsSfXMJVcXmMTeEHeAqrDzVsIIdcWNI8IUeMm4ObKkKwa9EoRaRNhXpGNAh4Z99MWDlY1zuclxKrEerZLTMV98sPyM1Hfg+zoCGUTcNgzYgO0Nxbaw8Zo7WfN/RqGQvj0lJgxewZcGTPLnh4P+ehAkteN65eEfcjDxF1ng7pEKuIG1YYmVT+eJpJsIEcamFxtVU2f1YvbO0Z21AY1/KI58TdY8vh4OKhcAKN9H0LBulda2h658rO2ZrjabpFfr/8YEh8rOY+pvLg2CI4MreHYg5zcFICLJ46CTLnzYG1izJg88plsGvTBji6bw9cOncGHty9i9lsySsLnt27ClkvX2R/z/m1Z/NGaNegHqS2aqx58sbPc4cp8oKgHj+VL55qEmwgh6bGEiJiDXgagW+ljhhtUCGPfG7sQTtqWlKYEBRNAa0aniBcbdTH0ZNJ1ffKDyyZG6SVy+kyn6fM+XMxCwvglfUSnt6+AA9OrsVafa74nNvryaOHYtCU4tUPzYffjigHnWnYo2tjw07N2VxCUb1RaMKiz0Z4A6vO8/LIta7vAWcYZ7+coOr5t0OL9UvC1NCzAONDjO+mYgn0tHi6R15G3anGlR5FkhjREF6+fIlZmD8vGhp48utRuIeCuLl5ONzaNg4eXzkoRJbb6/iBfZAYqdsXnpbaq8foyPQ4vayfIh8IrCyihXsUgpcxCTaQQyMs/Ew+0CpB6cHf/dURpP0zL+XTo9luHFwMPZsYNtfPbyjjf9k6Gw5nTmTvnxOnNhl8xKanD8bsy+srC148ug1Prh0TtdLtnZOzOzODsPc8H36/fsIkQT24e0cMS1BHgB61N3dIFxSRyjShJ3BsHQ0L+yk300UeYU31N6qtCqfGws/0/Dvhp+PAg4a8xlWZxMW5KZsDOQ6Sa7L62vlJaqsI8eQvc2tZ4uDK8frrzO7TGu4eXACPftkOv984Bc/v/QovHt/FmuehqH1eYlf/+cNb8OzOJSGURxd2wf3jq+HO3lliP1KpV0w95Dt70b68uAdePrmPRZL768Xz57AO7Tnyv6K4UE+X7UhRy5D9BA71aD7aVguovCXwsibBBnIYExY52Afb1SgRxBBsX7MURmyvPKIELYBYOb5vnpqZLXOGFpgXA0deHn5JrsvS+VO6NTGIwwxubhwKd/bMhAenN6AgT0PW8ydYDKa9qOnduWEtdI02rMIZ1rEZ/5hhIapx4p7c1t4x7o4NpNqqUGssEha5UzSoU50Fa65/YQRPqiNMkDfC+ukDc10NTRtj0BJ8msvirlOQ5KXppvTQAhI6v1fTcGETPTy3De6fwLQcXiJqsLsHMsT7vSNLsYbKhIdnt8DjS/vh6a2zovmDPEzNPH/2DLatWQXJsYYxvQS0QamXx8VTNH+yZwUNbat8Lg9yJ8rV/m/y4SS8jUmwgRx5FRb9jr3EDzCSmj1MJagGo6eYzh3SFdZM6QebZg2GdVMHQEZ6shhjoeX43HmFwZktyqVnpjIwLkZ/jeP792IWFtzr9s0bsHTGVOgYZnAbojylnfzUvT4JWmxxa+sovagOzeku7C/pfAJbmxFyUVmfsHT+WrQ8bBxGWLEroLWzf4Vhr09zmu49SwzOc53Cg+H6lcuYjfn3evTwAexYtwbSuyXqa0eCxs5o8pyenM/Fi6AhBYX9hgxqpe0IoZD+S2UtB29tEmwgRz4IS7TR+O4Sa6RptEaoBqXCuIm90B0LzJuUHtPN8JT5doH1YO3C+fDk8SPMTvNfZIjTZPPq+XNgSFICtPBVLtRt4+cp5mUv7855VTa55qhdlLYyDy3HVma9WlQERsUk2ECO/BIWPTwo2s3xzxhx8t3apU6QtTEp23WGdroxd5CXxomoiZdfr7WfFwxPToJlM6eJ0e+zx47A1Yvn4QbWaNcuX4SLZ0/DiYP7Ydem9WIFzdShA4XTXqv6vDnQq2lDINdpY02eBD2YgB6hIhcUcSWzH3QO1e6FgUa7h9y5QILTBgcbyJHPwtL5yAucymET2RZrsXmYIFqmfw+h5vIFJbCoSQpvIJaakZ1H4uIKLSfun1wFC4Z3z9etAMhTluxPU+0/WrCibvokJnWJ1lwfy+NgpIv9a9KgqBxOGxxsIEdBCUv37kQGvgI85i+YwCPqRBcF0oawo7vqRuPzAvk6kQdB76ZaN+KcIEHShDitJt80awhc2WP6PlvkC0auzZygiE1jO7L3xDL2C3WojT16LZw2ONhAjsIWFt0jwsW+KibUKmougtYvcgVoLrcOLxErqmmohcSWMawbkgwLR/SAFeP6wKaZg2H/8nHCP8qcyXs92OzRNt+0VxcnKII8Utv6aWtR/DPvxnx/jTyFOThtcLCBHIUpLApriP8OAs/pr058UUHd8etWuL5Qz+lM4ShJLjucmCTOL0+FJNlyeznRrg4OXBMowWmDgw3kKExh0XiJbE+mkhhmFU0isRFrEyrEY+umaAu2iBBrDamG2jSUFZIccntOiVE+DlgCy2EJla8xqLw5bXCwgRyFKSxaDULXlsB7fo8J/12dEUXB4A5NRGH2ax1ptmdsfkPuOcKGymGFkxwSVQ67zTyJcLb7Qv6wADWvvLBo5a0arIajmcwodMjwluYCyX2XK/CChMR0Z88Uo708Y9A+Djm5SGOZJEs1E8crLyz6raEj2lcM+NsYLlMKG+rZ0Tt1+/NkXFtAXh6CTg+e6hZu/DFz1PtG4fxVXjvJKRbCokE4yXBn+Cues5nLnKLC3EHT/IAWtXIC4tg5JQnaN8hxrvUZ2rRVaIGMMcg0efWFhdelPQKCjRBqX+t9/IedYTKoSGjj5wEXdmiX/Rc0ZKzntE6RHmM3p0/zXBdzYH535UwPCSrrYiUsumagEUIdan2JmXJLnUlFBS0WUS9IKAzEE1gZW+vw3B7ikS1cXOVgOWwIsqvxJ7UfnUSxFVawve6dI8yxdpVYT+f7XIYVBbSqh9unosChsavsoQYy0KcmN4EWJiw5w1r/CgrnQ8bcEFAZFF9h4b+Gu6YE3r86ZpLViIs2gFPvB1YY0AT04pE9oJ2/Bxsvht9RKFWl7R/VUJmR2VHshRVQuxpLgzrVMC72NTCj7qoyrsigp2aQo2JhjHGR2/ScQUnQLkC5c18uZGEZhoZga8BBg9Ikrj+8sCgj8Dx6rPBNVQYWKbTYY+3U/rm6s5gLTWbTdfu3iTJrMlsCe3kdgyh/GSgvqTxswsoWFl0D+RozTrGW0Rog7wTaypLEQFsBmDvuRVuOk4Ph7IFJwsshL2KSiHJz6KMuHwm0WWlDF5uwCLmwxLXdHT9Cg36fOkOtCRIarYckX35yIiTBzB/aTTB7YKJ4rC79Rg585BXKXSMPZGHe9KayoF61GLbJXqLHlTVhE5ZSWMSb2OOZw2TuH5WXmCcJNLFPNRGVGYaxZcxhE5ZBWOL6eK22mIHPZBn8R+QZ/snEZh74bpag1NiEJT7r3pFqmJmaZ1j/QbiP+etEeYuf2TI1F5uwsq9PYXiPMmh3/aGaRkzvCUz/N5TX+J0tz4KGDeR4VYUlrq+7dn3M5CvyAiiOYJM3CdP8FqWd4MqyMGADOV51YYnf3BzfxYwfggVQHG2vXzGdvoY80NlVXFkWBmwgR3EQFn3Pjss3mOmLmcJ5FXmBaRmO6XuP8pHSKaWVK8fCgg3kKE7Cko7D8Gpoj6xiCuuVAAW1EvPuf5KgbMKyEmFJv2FYRSyk6VhYT9WFZ4VkYVxXYD5V06eBERZXhoUJG8hRnIUl3ikO7k4f4PdOWHjWuLfEPRTUKIzjtxRfWuOnT4NNWNYuLAzTnfsahlfFghyIBVqU3qpPYj2cl2A8QjBuisfp2oT1agpLfNe9i8flfY20RntsIRa24tHE+QztWXEUxTQS41UfeUsRNxk2YRUDYUlx04d5OH2GQquHdENmoBi2IZcRU4cxHiNnUagb8PyxSBxe0wEpbbiX7r6KuMmwCat4CkuP/rsuDSVRJG4omGHIRhQPTScRZLOtwJqoNx5THaGmVneO7jzlZ/Fdd11F3GQUG2HZsGEObKANG5bCBtqwYSlsoA0blsIG2rBhKWygDRuWwgbasGEZUOL/AdNppA4sFs57AAAAAElFTkSuQmCC"
Version="1"
EngineVersion="12">
<VersionHistory>
<Change Date="2023-05-11" Type="New">Initial version</Change>
</VersionHistory>
<ServiceUrls>
<ServiceUrl Url="https://[$DataCenter$].api.mailchimp.com" Desc="For OAuth This URL is ignored. Only used for API Key Auth"/>
<ServiceUrl Url="https://storage.googleapis.com" Hidden="True" Desc="Internal - Needed for Bulk Operation to download GZipped report"/>
</ServiceUrls>
<Auths>
<Auth Name="OAuth" Type="OAuth" ConnStr="Provider=MailChimp;ScopeSeparator={space};" TestEndPoint="get_user_details" >
<Notes>
<![CDATA[To get the credentials you need in order to set up your OAuth workflow, you'll first need to register your application with Mailchimp:
<ol>
<li>Navigate to the <a target="_blank" href="https://admin.mailchimp.com/account/oauth2/">Registered Apps page</a> in your Mailchimp account.</li>
<li>Click <a target="_blank" href="https://admin.mailchimp.com/account/oauth2/client/">Register An App</a>.</li>
<li>Fill out the <b>Register An App form</b>.</li>
<li>Click <b>Create</b>.</li>
<li>After successfully registering your application, you'll see the <b>client_id</b> and <b>client_secret</b> at the bottom of the page - record these values and store them securely.</li>
<li>Record your Mailchimp data center, since we will need it later. The data center will be located in your browser's address bar URL. If the URL is "https://us21.admin.mailchimp.com/account/api/", then your data center is "us21".</li>
<li>Back at the connector screen, enter the data center that was recorded in step 6 into the <b>Data Center</b> field.</li>
<li>Enter the <b>client_id</b> value that was recorded in step 5 into the <b>Client Id</b> field.</li>
<li>Enter the <b>client_secret</b> value that was recorded in step 5 into the <b>Client Secret</b> field.</li>
<li>Click <b>Generate Token</b>. If proper authentication occurs, you will see a notice saying so.
If you get any errors, click <b>Yes</b> on the dialog box and then a large browser window will launch
- log into your Mailchimp account here and approve the use of the application.</li>
<li>Select the <b>Test Connection</b> button at the bottom of the window to verify proper connectivity with your Mailchimp account.</li>
<li>If the connection test succeeds, select <b>OK</b>.</li>
</ol>]]>
</Notes>
<Params>
<Param Name="DataCenter" Label="Data Center" Value="" Options="us1;us2;us3;...;us14;type-your-own" Required="True" Desc="The data center will be located in your browser's address bar URL. If the URL is https://us21.admin.mailchimp.com then your data center is us21." />
<Param Name="ClientId" Label="Client Id" Required="True" />
<Param Name="ClientSecret" Label="Client Secret" Secret="True" Required="True" />
<Param Name="RetryMode" Value="RetryWhenStatusCodeMatch" Options="None;RetryAny;RetryWhenStatusCodeMatch;" Hidden="True" />
<Param Name="RetryStatusCodeList" Value="429" Hidden="True" />
<Param Name="RetryCountMax" Value="5" Hidden="True" />
<Param Name="RetryMultiplyWaitTime" Value="True" Hidden="True" />
<Param Name="ListId" Label="Default List Id" Template="ListIdParam" />
</Params>
</Auth>
<Auth Name="Http" Label="ApiKey Auth" Type="Http" ConnStr="CredentialType=Basic;" TestEndPoint="get_user_details" >
<Notes>
<![CDATA[The simplest way to authenticate a request to the Mailchimp Marketing API is by using an API key (If you require access to Mailchimp on behalf of other Mailchimp users, you'll want to set up OAuth authentication instead)::
<ol>
<li>Log into your Mailchimp account.</li>
<li>Navigate to the API Keys section of your Mailchimp account: <a target="_blank" href="https://admin.mailchimp.com/account/api/">https://admin.mailchimp.com/account/api/</a></li>
<li>In the <b>Your API keys</b> section of the page, click <b>Create New Key</b>.</li>
<li>Give your new key a descriptive name that will remind you which application it's used for.</li>
<li>Copy the generated key immediately and store it in a secure location. (You won’t be able to see or copy the key once you finish generating it.)</li>
<li>Record your Mailchimp data center, since we will need it later. The data center will be located in your browser's address bar URL. If the URL is "https://us21.admin.mailchimp.com/account/api/", then your data center is "us21".</li>
<li>Back at the connector screen, enter the data center that was recorded in step 6 into the <b>Data Center</b> field.</li>
<li>Enter the API key that was recorded in step 5 into the <b>Api Key</b> field.</li>
<li>Select the <b>Test Connection</b> button at the bottom of the window to verify proper connectivity with your Mailchimp account.</li>
<li>If the connection test succeeds, select <b>OK</b>.</li>
</ol>]]>
</Notes>
<Params>
<Param Name="Password" Type="Property" Required="True" Label="Api Key" Secret="True" />
<Param Name="DataCenter" Label="Data Center" Value="" Options="us1;us2;us3;...;us14;type-your-own" Desc="usually last few letters from your key. E.g. If you key is abcxxxx-us14 then type your datacenter as us14." />
<Param Name="RetryMode" Value="RetryWhenStatusCodeMatch" Options="None;RetryAny;RetryWhenStatusCodeMatch;" Hidden="True" />
<Param Name="RetryStatusCodeList" Value="429" Hidden="True" />
<Param Name="RetryCountMax" Value="5" Hidden="True" />
<Param Name="RetryMultiplyWaitTime" Value="True" Hidden="True" />
<Param Name="ListId" Label="Default List Id" Template="ListIdParam" />
</Params>
</Auth>
</Auths>
<Template>
<Param Name="ListIdParam" Type="Placeholder" OptionsEndPoint="get_lists" OptionsEndPointValueColumn="id" OptionsEndPointLabelColumn="name" Desc="The ID of the list for which you like to perform this operation." Required="True" />
<Param Name="DateSelectionParam" Type="Query"
Value="" Options="today;yesterday;monthstart;monthend;yearstart;yearend;weekstart;weekend;yearstart-1y;yearend-1y;monthstart-1d;monthend+1d"
ValueTemplate="<<{$value$}||yyyy-MM-ddTHH:mm:ss,FUN_TO_DATETIME>>" />
<EndPoint Name="Pagination">
<Params>
<Param Name="PagingMode" Type="Property" Value="ByUrlPath" />
<Param Name="PagingByUrlAttributeName" Type="Property" Value="{offset}" />
<Param Name="PagingIncrementBy" Type="Property" Value="1000" />
<Param Name="PagingByUrlCurrentPage" Type="Property" Value="0" />
</Params>
</EndPoint>
<EndPoint Name="CampaignPagination" Template="Pagination">
<Params>
<Param Name="PagingMaxRowsExpr" Type="Property" Value="$.total_items" />
<Param Name="PagingMaxRowsDataPathExpr" Type="Property" Value="$.campaigns[*]" />
</Params>
</EndPoint>
<EndPoint Name="ListPagination" Template="Pagination">
<Params>
<Param Name="PagingMaxRowsExpr" Type="Property" Value="$.total_items" />
<Param Name="PagingMaxRowsDataPathExpr" Type="Property" Value="$.lists[*]" />
</Params>
</EndPoint>
<EndPoint Name="MemberPagination" Template="Pagination">
<Params>
<Param Name="PagingMaxRowsExpr" Type="Property" Value="$.total_items" />
<Param Name="PagingMaxRowsDataPathExpr" Type="Property" Value="$.members[*]" />
</Params>
</EndPoint>
<EndPoint Name="ListPostInputColumns">
<InputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Desc="The name of the list." Length="200" Required="True" />
<Column Name="contact.company" Label="Company" DataType="DT_WSTR" Desc="The company name for the list." Length="200" Required="True" />
<Column Name="contact.address1" Label="Address1" DataType="DT_WSTR" Desc="Line 1 of the street address for the list contact." Length="200" Required="True" />
<Column Name="contact.address2" Label="Address2" DataType="DT_WSTR" Desc="Line 2 of the street address for the list contact." Length="200" />
<Column Name="contact.city" Label="City" DataType="DT_WSTR" Desc="The city for the list contact." Length="200" Required="True" />
<Column Name="contact.state" Label="State" DataType="DT_WSTR" Desc="The state for the list contact." Length="20" />
<Column Name="contact.zip" Label="Zip" DataType="DT_WSTR" Desc="The postal or zip code for the list contact." Length="20" />
<Column Name="contact.country" Label="Country" DataType="DT_WSTR" Desc="A two-character ISO3166 country code. Defaults to US if invalid." Length="200" Required="True" />
<Column Name="contact.phone" Label="Phone" DataType="DT_WSTR" Desc="The phone number for the list contact." Length="30" />
<Column Name="permission_reminder" Label="PermissionReminder" DataType="DT_WSTR" Desc="The permission reminder for the list." Length="500" Required="True" />
<Column Name="use_archive_bar" Label="UseArchiveBar" DataType="DT_WSTR" Raw="True" Desc="Whether campaigns for this list use the Archive Bar in archives by default." />
<Column Name="campaign_defaults.from_name" Label="CampaignDefaultFromName" DataType="DT_WSTR" Desc="The default from name for campaigns sent to this list." Length="200" Required="True" />
<Column Name="campaign_defaults.from_email" Label="CampaignDefaultFromEmail" DataType="DT_WSTR" Desc="The default from email for campaigns sent to this list." Length="200" Required="True" />
<Column Name="campaign_defaults.subject" Label="CampaignDefaultSubject" DataType="DT_WSTR" Desc="The default subject line for campaigns sent to this list." Length="200" Required="True" />
<Column Name="campaign_defaults.language" Label="CampaignDefaultLanguage" DataType="DT_WSTR" Desc="The default language for this lists's forms." Length="200" Required="True" />
<Column Name="notify_on_subscribe" Label="NotifyOnSubscribe" DataType="DT_WSTR" Desc="The email address to send subscribe notifications to." Length="200" />
<Column Name="notify_on_unsubscribe" Label="NotifyOnUnsubscribe" DataType="DT_WSTR" Desc="The email address to send unsubscribe notifications to." Length="200" />
<Column Name="email_type_option" Label="EmailTypeOption" DataType="DT_WSTR" Raw="True" Desc="Whether the list supports multiple formats for emails. When set to true, subscribers can choose whether they want to receive HTML or plain-text emails. When set to false, subscribers will receive HTML emails, with a plain-text alternative backup." Required="True" />
<Column Name="double_optin" Label="DoubleOptIn" DataType="DT_WSTR" Raw="True" Desc="Whether or not to require the subscriber to confirm subscription via email." Required="True" />
<Column Name="marketing_permissions" Label="MarketingPermissions" DataType="DT_WSTR" Raw="True" Desc="Whether or not the list has marketing permissions (eg. GDPR) enabled." />
</InputColumns>
</EndPoint>
<EndPoint Name="ListPatchInputColumns">
<InputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Desc="The name of the list." Length="200" />
<Column Name="contact.company" Label="Company" DataType="DT_WSTR" Desc="The company name for the list." Length="200" />
<Column Name="contact.address1" Label="Address1" DataType="DT_WSTR" Desc="Line 1 of the street address for the list contact." Length="200" />
<Column Name="contact.address2" Label="Address2" DataType="DT_WSTR" Desc="Line 2 of the street address for the list contact." Length="200" />
<Column Name="contact.city" Label="City" DataType="DT_WSTR" Desc="The city for the list contact." Length="200" />
<Column Name="contact.state" Label="State" DataType="DT_WSTR" Desc="The state for the list contact." Length="20" />
<Column Name="contact.zip" Label="Zip" DataType="DT_WSTR" Desc="The postal or zip code for the list contact." Length="20" />
<Column Name="contact.country" Label="Country" DataType="DT_WSTR" Desc="A two-character ISO3166 country code. Defaults to US if invalid." Length="200" />
<Column Name="contact.phone" Label="Phone" DataType="DT_WSTR" Desc="The phone number for the list contact." Length="30" />
<Column Name="permission_reminder" Label="PermissionReminder" DataType="DT_WSTR" Desc="The permission reminder for the list." Length="500" />
<Column Name="use_archive_bar" Label="UseArchiveBar" DataType="DT_WSTR" Raw="True" Desc="Whether campaigns for this list use the Archive Bar in archives by default." />
<Column Name="campaign_defaults.from_name" Label="CampaignDefaultFromName" DataType="DT_WSTR" Desc="The default from name for campaigns sent to this list." Length="200" />
<Column Name="campaign_defaults.from_email" Label="CampaignDefaultFromEmail" DataType="DT_WSTR" Desc="The default from email for campaigns sent to this list." Length="200" />
<Column Name="campaign_defaults.subject" Label="CampaignDefaultSubject" DataType="DT_WSTR" Desc="The default subject line for campaigns sent to this list." Length="200" />
<Column Name="campaign_defaults.language" Label="CampaignDefaultLanguage" DataType="DT_WSTR" Desc="The default language for this lists's forms." Length="200" />
<Column Name="notify_on_subscribe" Label="NotifyOnSubscribe" DataType="DT_WSTR" Desc="The email address to send subscribe notifications to." Length="200" />
<Column Name="notify_on_unsubscribe" Label="NotifyOnUnsubscribe" DataType="DT_WSTR" Desc="The email address to send unsubscribe notifications to." Length="200" />
<Column Name="email_type_option" Label="EmailTypeOption" DataType="DT_WSTR" Raw="True" Desc="Whether the list supports multiple formats for emails. When set to true, subscribers can choose whether they want to receive HTML or plain-text emails. When set to false, subscribers will receive HTML emails, with a plain-text alternative backup." />
<Column Name="double_optin" Label="DoubleOptin" DataType="DT_WSTR" Raw="True" Desc="Whether or not to require the subscriber to confirm subscription via email." />
<Column Name="marketing_permissions" Label="MarketingPermissions" DataType="DT_WSTR" Raw="True" Desc="Whether or not the list has marketing permissions (eg. GDPR) enabled." />
</InputColumns>
</EndPoint>
<EndPoint Name="MemberPostInputColumns">
<InputColumns>
<Column Name="email_address" Label="EmailAddress" DataType="DT_WSTR" Desc="" Length="200" Required="True" />
<Column Name="status" Label="Status" DataType="DT_WSTR" Length="80" Options="subscribed;unsubscribed;cleaned;pending;transactional" Desc="Subscriber's current status. Possible values: subscribed, unsubscribed, cleaned, pending, or transactional." Required="True" />
<Column Name="email_type" Label="EmailType" DataType="DT_WSTR" Length="20" Options="html;text" Desc="Type of email this member asked to get ('html' or 'text')." />
<Column Name="merge_fields.FNAME" Label="FirstName" DataType="DT_WSTR" Length="255" />
<Column Name="merge_fields.LNAME" Label="LastName" DataType="DT_WSTR" Length="255" />
<Column Name="merge_fields.ADDRESS.addr1" DataType="DT_WSTR" Label="AddressLine1" Length="200" />
<Column Name="merge_fields.ADDRESS.addr2" DataType="DT_WSTR" Label="AddressLine2" Length="200" />
<Column Name="merge_fields.ADDRESS.city" DataType="DT_WSTR" Label="City" Length="200" />
<Column Name="merge_fields.ADDRESS.state" DataType="DT_WSTR" Label="State" Length="100" />
<Column Name="merge_fields.ADDRESS.zip" DataType="DT_WSTR" Label="Zip" Length="20" />
<Column Name="merge_fields.ADDRESS.country" DataType="DT_WSTR" Label="Country" Length="100" />
<Column Name="merge_fields.PHONE" DataType="DT_WSTR" Label="Phone" Length="50" />
<Column Name="merge_fields.BIRTHDAY" DataType="DT_WSTR" Label="Birthday" Length="50" />
<Column Name="merge_fields" Label="MergeFields" DataType="DT_WSTR" Length="4000" Raw="True" Desc="A dictionary of merge fields where the keys are the merge tags." Example="{"FNAME": "John","LNAME":"Doe","ADDRESS":{"addr1":"123 Freddie Ave","city":"Atlanta","state":"GA","zip":"12345"}" />
<Column Name="interests" Label="Interests" DataType="DT_WSTR" Length="4000" Raw="True" Desc="The key of this object's properties is the ID of the interest in question." />
<Column Name="language" Label="Language" DataType="DT_WSTR" Length="10" Options="en=English;ar=Arabic;af=Afrikaans;be=Belarusian;bg=Bulgarian;ca=Catalan;zh=Chinese;hr=Croatian;cs=Czech;da=Danish;nl=Dutch;et=Estonian;fa=Farsi;fi=Finnish;fr=French (France);fr_CA=French (Canada);de=German;el=Greek;he=Hebrew;hi=Hindi;hu=Hungarian;is=Icelandic;id=Indonesian;ga=Irish;it=Italian;ja=Japanese;km=Khmer;ko=Korean;lv=Latvian;lt=Lithuanian;mt=Maltese;ms=Malay;mk=Macedonian;no=Norwegian;pl=Polish;pt=Portuguese (Brazil);pt_PT=Portuguese (Portugal);ro=Romanian;ru=Russian;sr=Serbian;sk=Slovak;sl=Slovenian;es=Spanish (Mexico);es_ES=Spanish (Spain);sw=Swahili;sv=Swedish;ta=Tamil;th=Thai;tr=Turkish;uk=Ukrainian;vi=Vietnamese;" Desc="If set/detected, the subscriber's language." />
<Column Name="vip" Label="Vip" DataType="DT_BOOL" Options="true;false" Desc="VIP status for subscriber." />
<Column Name="location.latitude" Label="Latitude" DataType="DT_WSTR" Desc="The location latitude." />
<Column Name="location.longitude" Label="Longitude" DataType="DT_WSTR" Desc="The location longitude." />
<Column Name="marketing_permissions" Label="MarketingPermissions" DataType="DT_WSTR" Length="4000" Raw="True" Desc="The marketing permissions for the subscriber." />
<Column Name="ip_signup" Label="IpSignup" DataType="DT_WSTR" Length="200" Desc="IP address the subscriber signed up from." />
<Column Name="timestamp_signup" Label="TimestampSignup" DataType="DT_DBTIMESTAMP" Desc="The date and time the subscriber signed up for the list in ISO 8601 format." />
<Column Name="ip_opt" Label="IpOpt" DataType="DT_WSTR" Length="200" Desc="The IP address the subscriber used to confirm their opt-in status." />
<Column Name="timestamp_opt" Label="TimestampOpt" DataType="DT_DBTIMESTAMP" Desc="The date and time the subscriber confirmed their opt-in status in ISO 8601 format." />
<Column Name="tags" Label="Tags" DataType="DT_WSTR" Length="4000" Raw="True" Desc="The tags that are associated with a member." />
</InputColumns>
</EndPoint>
<EndPoint Name="MemberPatchInputColumns">
<InputColumns>
<Column Name="email_address" Label="EmailAddress" DataType="DT_WSTR" Desc="" Length="200" />
<Column Name="status" Label="Status" DataType="DT_WSTR" Length="80" Options="subscribed;unsubscribed;cleaned;pending;transactional" Desc="Subscriber's current status. Possible values: subscribed, unsubscribed, cleaned, pending, or transactional." />
<Column Name="email_type" Label="EmailType" DataType="DT_WSTR" Length="20" Options="html;text" Desc="Type of email this member asked to get ('html' or 'text')." />
<Column Name="merge_fields.FNAME" Label="FirstName" DataType="DT_WSTR" Length="255" />
<Column Name="merge_fields.LNAME" Label="LastName" DataType="DT_WSTR" Length="255" />
<Column Name="merge_fields" Label="MergeFields" DataType="DT_WSTR" Length="4000" Raw="True" Desc="A dictionary of merge fields where the keys are the merge tags." Example="{"FNAME": "John","LNAME":"Doe","ADDRESS":{"addr1":"123 Freddie Ave","city":"Atlanta","state":"GA","zip":"12345"}" />
<Column Name="interests" Label="Interests" DataType="DT_WSTR" Length="4000" Raw="True" Desc="The key of this object's properties is the ID of the interest in question." />
<Column Name="language" Label="Language" DataType="DT_WSTR" Length="10" Options="en=English;ar=Arabic;af=Afrikaans;be=Belarusian;bg=Bulgarian;ca=Catalan;zh=Chinese;hr=Croatian;cs=Czech;da=Danish;nl=Dutch;et=Estonian;fa=Farsi;fi=Finnish;fr=French (France);fr_CA=French (Canada);de=German;el=Greek;he=Hebrew;hi=Hindi;hu=Hungarian;is=Icelandic;id=Indonesian;ga=Irish;it=Italian;ja=Japanese;km=Khmer;ko=Korean;lv=Latvian;lt=Lithuanian;mt=Maltese;ms=Malay;mk=Macedonian;no=Norwegian;pl=Polish;pt=Portuguese (Brazil);pt_PT=Portuguese (Portugal);ro=Romanian;ru=Russian;sr=Serbian;sk=Slovak;sl=Slovenian;es=Spanish (Mexico);es_ES=Spanish (Spain);sw=Swahili;sv=Swedish;ta=Tamil;th=Thai;tr=Turkish;uk=Ukrainian;vi=Vietnamese;" Desc="If set/detected, the subscriber's language." />
<Column Name="vip" Label="Vip" DataType="DT_BOOL" Options="true;false" Desc="VIP status for subscriber." />
<Column Name="location.latitude" Label="Latitude" DataType="DT_WSTR" Desc="The location latitude." />
<Column Name="location.longitude" Label="Longitude" DataType="DT_WSTR" Desc="The location longitude." />
<Column Name="marketing_permissions" Label="MarketingPermissions" DataType="DT_WSTR" Length="4000" Raw="True" Desc="The marketing permissions for the subscriber." />
<Column Name="ip_signup" Label="IpSignup" DataType="DT_WSTR" Length="200" Desc="IP address the subscriber signed up from." />
<Column Name="timestamp_signup" Label="TimestampSignup" DataType="DT_DBTIMESTAMP" Desc="The date and time the subscriber signed up for the list in ISO 8601 format." />
<Column Name="ip_opt" Label="IpOpt" DataType="DT_WSTR" Length="200" Desc="The IP address the subscriber used to confirm their opt-in status." />
<Column Name="timestamp_opt" Label="TimestampOpt" DataType="DT_DBTIMESTAMP" Desc="The date and time the subscriber confirmed their opt-in status in ISO 8601 format." />
<Column Name="tags" Label="Tags" DataType="DT_WSTR" Length="4000" Raw="True" Example="["tag1", "tag2"]" Desc="The tags that are associated with a member." />
</InputColumns>
</EndPoint>
<EndPoint Name="FieldFilterParams">
<Param Name="fields" Label="Fields to show" Type="Query" Desc="Limit data retrieval to only the selected fields." MultiSelect="True" MultiSelectSeparator="," Options="" />
<Param Name="exclude_fields" Label="Fields to hide" Type="Query" Desc="Limit data retrieval to exclude the selected fields." MultiSelect="True" MultiSelectSeparator="," Options="" />
<Param Name="count" Label="Number of records to return" Type="Query" Desc="The number of records to return. Maximum value is 1000." Value="1000" Hidden="True" />
</EndPoint>
<EndPoint Name="CampaignFilterParams" Template="FieldFilterParams">
<Param Name="fields" Options="id;web_id;type;create_time;archive_url;long_archive_url;status;emails_sent;send_time;content_type;needs_block_refresh;resendable;recipients.list_id;recipients.list_is_active;recipients.list_name;recipients.segment_text;recipients.recipient_count;recipients.segment_opts.saved_segment_id;recipients.segment_opts.prebuilt_segment_id;recipients.segment_opts.match;settings.subject_line;settings.preview_text;settings.title;settings.from_name;settings.reply_to;settings.use_conversation;settings.to_name;settings.folder_id;settings.authenticate;settings.auto_footer;settings.inline_css;settings.auto_tweet;settings.fb_comments;settings.timewarp;settings.template_id;settings.drag_and_drop;variate_settings.winning_combination_id;variate_settings.winning_campaign_id;variate_settings.winner_criteria;variate_settings.wait_time;variate_settings.test_size;tracking.opens;tracking.html_clicks;tracking.text_clicks;tracking.goal_tracking;tracking.ecomm360;tracking.google_analytics;tracking.clicktale;tracking.salesforce.campaign;tracking.salesforce.notes;tracking.capsule.notes;rss_opts.feed_url;rss_opts.frequency;rss_opts.schedule.hour;rss_opts.schedule.daily_send.sunday;rss_opts.schedule.daily_send.monday;rss_opts.schedule.daily_send.tuesday;rss_opts.schedule.daily_send.wednesday;rss_opts.schedule.daily_send.thursday;rss_opts.schedule.daily_send.friday;rss_opts.schedule.daily_send.saturday;rss_opts.schedule.weekly_send_day;rss_opts.schedule.;rss_opts.schedule.monthly_send_date;rss_opts.last_sent;rss_opts.constrain_rss_img;ab_split_opts.split_test;ab_split_opts.pick_winner;ab_split_opts.wait_units;ab_split_opts.wait_time;ab_split_opts.split_size;ab_split_opts.from_name_a;ab_split_opts.from_name_b;ab_split_opts.reply_email_a;ab_split_opts.reply_email_b;ab_split_opts.subject_a;ab_split_opts.subject_b;ab_split_opts.send_time_a;ab_split_opts.send_time_b;ab_split_opts.send_time_winner;social_card.image_url;social_card.description;social_card.title;report_summary.opens;report_summary.unique_opens;report_summary.open_rate;report_summary.clicks;report_summary.subscriber_clicks;report_summary.click_rate;report_summary.ecommerce.total_orders;report_summary.ecommerce.total_spent;report_summary.ecommerce.total_revenue;delivery_status.enabled;delivery_status.can_cancel;delivery_status.status;delivery_status.emails_sent;delivery_status.emails_canceled" />
<Param Name="exclude_fields" Options="id;web_id;type;create_time;archive_url;long_archive_url;status;emails_sent;send_time;content_type;needs_block_refresh;resendable;recipients.list_id;recipients.list_is_active;recipients.list_name;recipients.segment_text;recipients.recipient_count;recipients.segment_opts.saved_segment_id;recipients.segment_opts.prebuilt_segment_id;recipients.segment_opts.match;settings.subject_line;settings.preview_text;settings.title;settings.from_name;settings.reply_to;settings.use_conversation;settings.to_name;settings.folder_id;settings.authenticate;settings.auto_footer;settings.inline_css;settings.auto_tweet;settings.fb_comments;settings.timewarp;settings.template_id;settings.drag_and_drop;variate_settings.winning_combination_id;variate_settings.winning_campaign_id;variate_settings.winner_criteria;variate_settings.wait_time;variate_settings.test_size;tracking.opens;tracking.html_clicks;tracking.text_clicks;tracking.goal_tracking;tracking.ecomm360;tracking.google_analytics;tracking.clicktale;tracking.salesforce.campaign;tracking.salesforce.notes;tracking.capsule.notes;rss_opts.feed_url;rss_opts.frequency;rss_opts.schedule.hour;rss_opts.schedule.daily_send.sunday;rss_opts.schedule.daily_send.monday;rss_opts.schedule.daily_send.tuesday;rss_opts.schedule.daily_send.wednesday;rss_opts.schedule.daily_send.thursday;rss_opts.schedule.daily_send.friday;rss_opts.schedule.daily_send.saturday;rss_opts.schedule.weekly_send_day;rss_opts.schedule.;rss_opts.schedule.monthly_send_date;rss_opts.last_sent;rss_opts.constrain_rss_img;ab_split_opts.split_test;ab_split_opts.pick_winner;ab_split_opts.wait_units;ab_split_opts.wait_time;ab_split_opts.split_size;ab_split_opts.from_name_a;ab_split_opts.from_name_b;ab_split_opts.reply_email_a;ab_split_opts.reply_email_b;ab_split_opts.subject_a;ab_split_opts.subject_b;ab_split_opts.send_time_a;ab_split_opts.send_time_b;ab_split_opts.send_time_winner;social_card.image_url;social_card.description;social_card.title;report_summary.opens;report_summary.unique_opens;report_summary.open_rate;report_summary.clicks;report_summary.subscriber_clicks;report_summary.click_rate;report_summary.ecommerce.total_orders;report_summary.ecommerce.total_spent;report_summary.ecommerce.total_revenue;delivery_status.enabled;delivery_status.can_cancel;delivery_status.status;delivery_status.emails_sent;delivery_status.emails_canceled" />
</EndPoint>
<EndPoint Name="ListFilterParams" Template="FieldFilterParams">
<Param Name="fields" Options="id;web_id;name;contact.company;contact.address1;contact.address2;contact.city;contact.state;contact.zip;contact.country;contact.phone;permission_reminder;use_archive_bar;campaign_defaults.from_name;campaign_defaults.from_email;campaign_defaults.subject;campaign_defaults.language;notify_on_subscribe;notify_on_unsubscribe;date_created;list_rating;email_type_option;subscribe_url_short;subscribe_url_long;beamer_address;visibility;double_optin;has_welcome;marketing_permissions;stats.member_count;stats.total_contacts;stats.unsubscribe_count;stats.cleaned_count;stats.member_count_since_send;stats.unsubscribe_count_since_send;stats.cleaned_count_since_send;stats.campaign_count;stats.campaign_last_sent;stats.merge_field_count;stats.avg_sub_rate;stats.avg_unsub_rate;stats.target_sub_rate;stats.open_rate;stats.click_rate;stats.last_sub_date;stats.last_unsub_date" />
<Param Name="exclude_fields" Options="id;web_id;name;contact.company;contact.address1;contact.address2;contact.city;contact.state;contact.zip;contact.country;contact.phone;permission_reminder;use_archive_bar;campaign_defaults.from_name;campaign_defaults.from_email;campaign_defaults.subject;campaign_defaults.language;notify_on_subscribe;notify_on_unsubscribe;date_created;list_rating;email_type_option;subscribe_url_short;subscribe_url_long;beamer_address;visibility;double_optin;has_welcome;marketing_permissions;stats.member_count;stats.total_contacts;stats.unsubscribe_count;stats.cleaned_count;stats.member_count_since_send;stats.unsubscribe_count_since_send;stats.cleaned_count_since_send;stats.campaign_count;stats.campaign_last_sent;stats.merge_field_count;stats.avg_sub_rate;stats.avg_unsub_rate;stats.target_sub_rate;stats.open_rate;stats.click_rate;stats.last_sub_date;stats.last_unsub_date" />
</EndPoint>
<EndPoint Name="MemberFilterParams" Template="FieldFilterParams">
<Param Name="fields" Options="" />
<Param Name="exclude_fields" Options="" />
</EndPoint>
<EndPoint Name="SortingParams">
<Param Name="sort_field" Label="Sort by" Type="Query" Desc="Returns records sorted by the specified field." MultiSelect="True" MultiSelectSeparator="," Options="" />
<Param Name="sort_dir" Label="Sort direction" Type="Query" Desc="Determines the order direction for sorted results. Possible values: asc or desc." Value="asc" Options="asc;desc" />
</EndPoint>
<EndPoint Name="CampaignSortingParams" Template="SortingParams">
<Param Desc="Returns files sorted by the specified field. Possible values: create_time or send_time."
Options="id;web_id;type;create_time;archive_url;long_archive_url;status;emails_sent;send_time;content_type;needs_block_refresh;resendable;recipients.list_id;recipients.list_is_active;recipients.list_name;recipients.segment_text;recipients.recipient_count;recipients.segment_opts.saved_segment_id;recipients.segment_opts.prebuilt_segment_id;recipients.segment_opts.match;settings.subject_line;settings.preview_text;settings.title;settings.from_name;settings.reply_to;settings.use_conversation;settings.to_name;settings.folder_id;settings.authenticate;settings.auto_footer;settings.inline_css;settings.auto_tweet;settings.fb_comments;settings.timewarp;settings.template_id;settings.drag_and_drop;variate_settings.winning_combination_id;variate_settings.winning_campaign_id;variate_settings.winner_criteria;variate_settings.wait_time;variate_settings.test_size;tracking.opens;tracking.html_clicks;tracking.text_clicks;tracking.goal_tracking;tracking.ecomm360;tracking.google_analytics;tracking.clicktale;tracking.salesforce.campaign;tracking.salesforce.notes;tracking.capsule.notes;rss_opts.feed_url;rss_opts.frequency;rss_opts.schedule.hour;rss_opts.schedule.daily_send.sunday;rss_opts.schedule.daily_send.monday;rss_opts.schedule.daily_send.tuesday;rss_opts.schedule.daily_send.wednesday;rss_opts.schedule.daily_send.thursday;rss_opts.schedule.daily_send.friday;rss_opts.schedule.daily_send.saturday;rss_opts.schedule.weekly_send_day;rss_opts.schedule.;rss_opts.schedule.monthly_send_date;rss_opts.last_sent;rss_opts.constrain_rss_img;ab_split_opts.split_test;ab_split_opts.pick_winner;ab_split_opts.wait_units;ab_split_opts.wait_time;ab_split_opts.split_size;ab_split_opts.from_name_a;ab_split_opts.from_name_b;ab_split_opts.reply_email_a;ab_split_opts.reply_email_b;ab_split_opts.subject_a;ab_split_opts.subject_b;ab_split_opts.send_time_a;ab_split_opts.send_time_b;ab_split_opts.send_time_winner;social_card.image_url;social_card.description;social_card.title;report_summary.opens;report_summary.unique_opens;report_summary.open_rate;report_summary.clicks;report_summary.subscriber_clicks;report_summary.click_rate;report_summary.ecommerce.total_orders;report_summary.ecommerce.total_spent;report_summary.ecommerce.total_revenue;delivery_status.enabled;delivery_status.can_cancel;delivery_status.status;delivery_status.emails_sent;delivery_status.emails_canceled" />
</EndPoint>
<EndPoint Name="ListSortingParams" Template="SortingParams">
<Param Name="sort_field" Desc="Returns files sorted by the specified field. Possible value: date_created."
Options="id;web_id;name;contact.company;contact.address1;contact.address2;contact.city;contact.state;contact.zip;contact.country;contact.phone;permission_reminder;use_archive_bar;campaign_defaults.from_name;campaign_defaults.from_email;campaign_defaults.subject;campaign_defaults.language;notify_on_subscribe;notify_on_unsubscribe;date_created;list_rating;email_type_option;subscribe_url_short;subscribe_url_long;beamer_address;visibility;double_optin;has_welcome;marketing_permissions;stats.member_count;stats.total_contacts;stats.unsubscribe_count;stats.cleaned_count;stats.member_count_since_send;stats.unsubscribe_count_since_send;stats.cleaned_count_since_send;stats.campaign_count;stats.campaign_last_sent;stats.merge_field_count;stats.avg_sub_rate;stats.avg_unsub_rate;stats.target_sub_rate;stats.open_rate;stats.click_rate;stats.last_sub_date;stats.last_unsub_date" />
</EndPoint>
<EndPoint Name="MemberSortingParams" Template="SortingParams">
<Param Name="sort_field" Desc="Returns files sorted by the specified field. Possible value: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX."
Options="" />
</EndPoint>
<EndPoint Name="CampaignOutputColumns">
<OutputColumns>
<Column Name="id" DataType="DT_WSTR" Label="Id" Length="100" Key="True" />
<Column Name="web_id" DataType="DT_I4" Label="WebId" />
<Column Name="type" DataType="DT_WSTR" Label="Type" Length="100" />
<Column Name="create_time" DataType="DT_DBTIMESTAMP" Label="CreateTime" />
<Column Name="archive_url" DataType="DT_WSTR" Label="ArchiveUrl" Length="500" />
<Column Name="long_archive_url" DataType="DT_WSTR" Label="LongArchiveUrl" Length="1024" />
<Column Name="status" DataType="DT_WSTR" Label="Status" Length="100" />
<Column Name="emails_sent" DataType="DT_I4" Label="EmailsSent" />
<Column Name="send_time" DataType="DT_WSTR" Label="SendTime" Length="500" />
<Column Name="content_type" DataType="DT_WSTR" Label="ContentType" Length="100" />
<Column Name="needs_block_refresh" DataType="DT_BOOL" Label="NeedsBlockRefresh" />
<Column Name="resendable" DataType="DT_BOOL" Label="Resendable" />
<Column Name="recipients.list_id" DataType="DT_WSTR" Label="RecipientsListId" Length="100" />
<Column Name="recipients.list_is_active" DataType="DT_BOOL" Label="RecipientsListIsActive" />
<Column Name="recipients.list_name" DataType="DT_WSTR" Label="RecipientsListName" Length="500" />
<Column Name="recipients.segment_text" DataType="DT_WSTR" Label="RecipientsSegmentText" Length="4000" />
<Column Name="recipients.recipient_count" DataType="DT_I4" Label="RecipientsRecipientCount" />
<Column Name="settings.subject_line" DataType="DT_WSTR" Label="SettingsSubjectLine" Length="1000" />
<Column Name="settings.title" DataType="DT_WSTR" Label="SettingsTitle" Length="1000" />
<Column Name="settings.from_name" DataType="DT_WSTR" Label="SettingsFromName" Length="500" />
<Column Name="settings.reply_to" DataType="DT_WSTR" Label="SettingsReplyTo" Length="500" />
<Column Name="settings.use_conversation" DataType="DT_BOOL" Label="SettingsUseConversation" />
<Column Name="settings.to_name" DataType="DT_WSTR" Label="SettingsToName" Length="500" />
<Column Name="settings.folder_id" DataType="DT_WSTR" Label="SettingsFolderId" Length="500" />
<Column Name="settings.authenticate" DataType="DT_BOOL" Label="SettingsAuthenticate" />
<Column Name="settings.auto_footer" DataType="DT_BOOL" Label="SettingsAutoFooter" />
<Column Name="settings.inline_css" DataType="DT_BOOL" Label="SettingsInlineCss" />
<Column Name="settings.auto_tweet" DataType="DT_BOOL" Label="SettingsAutoTweet" />
<Column Name="settings.fb_comments" DataType="DT_BOOL" Label="SettingsFbComments" />
<Column Name="settings.timewarp" DataType="DT_BOOL" Label="SettingsTimeWarp" />
<Column Name="settings.template_id" DataType="DT_I4" Label="SettingsTemplateId" />
<Column Name="settings.drag_and_drop" DataType="DT_BOOL" Label="SettingsDragAndDrop" />
<Column Name="tracking.opens" DataType="DT_BOOL" Label="TrackingOpens" />
<Column Name="tracking.html_clicks" DataType="DT_BOOL" Label="TrackingHtmlClicks" />
<Column Name="tracking.text_clicks" DataType="DT_BOOL" Label="TrackingTextClicks" />
<Column Name="tracking.goal_tracking" DataType="DT_BOOL" Label="TrackingGoalTracking" />
<Column Name="tracking.ecomm360" DataType="DT_BOOL" Label="TrackingEcomm360" />
<Column Name="tracking.google_analytics" DataType="DT_WSTR" Label="TrackingGoogleAnalytics" Length="4000" />
<Column Name="tracking.clicktale" DataType="DT_WSTR" Label="TrackingClicktale" Length="4000" />
<Column Name="delivery_status.enabled" DataType="DT_BOOL" Label="DeliveryStatusEnabled" />
</OutputColumns>
</EndPoint>
<EndPoint Name="ListOutputColumns">
<OutputColumns>
<Column Name="id" DataType="DT_WSTR" Label="Id" Length="100" Key="True" />
<Column Name="web_id" DataType="DT_I4" Label="WebId" />
<Column Name="name" DataType="DT_WSTR" Label="Name" Length="100" />
<Column Name="contact.company" DataType="DT_WSTR" Label="Company" Length="500" />
<Column Name="contact.address1" DataType="DT_WSTR" Label="Address1" Length="500" />
<Column Name="contact.address2" DataType="DT_WSTR" Label="Address2" Length="500" />
<Column Name="contact.city" DataType="DT_WSTR" Label="City" Length="100" />
<Column Name="contact.state" DataType="DT_WSTR" Label="State" Length="100" />
<Column Name="contact.zip" DataType="DT_WSTR" Label="Zip" Length="100" />
<Column Name="contact.country" DataType="DT_WSTR" Label="Country" Length="100" />
<Column Name="contact.phone" DataType="DT_WSTR" Label="Phone" Length="100" />
<Column Name="permission_reminder" DataType="DT_WSTR" Label="PermissionReminder" Length="4000" />
<Column Name="use_archive_bar" DataType="DT_BOOL" Label="UseArchiveBar" />
<Column Name="campaign_defaults.from_name" DataType="DT_WSTR" Label="CampaignDefaultFromName" Length="100" />
<Column Name="campaign_defaults.from_email" DataType="DT_WSTR" Label="CampaignDefaultFromEmail" Length="500" />
<Column Name="campaign_defaults.subject" DataType="DT_WSTR" Label="CampaignDefaultSubject" Length="500" />
<Column Name="campaign_defaults.language" DataType="DT_WSTR" Label="CampaignDefaultLanguage" Length="100" />
<Column Name="notify_on_subscribe" DataType="DT_WSTR" Label="NotifyOnSubscribe" Length="500" />
<Column Name="notify_on_unsubscribe" DataType="DT_WSTR" Label="NotifyOnUnsubscribe" Length="500" />
<Column Name="date_created" DataType="DT_DBTIMESTAMP" Label="DateCreated" />
<Column Name="list_rating" DataType="DT_I4" Label="ListRating" />
<Column Name="email_type_option" DataType="DT_BOOL" Label="EmailTypeOption" />
<Column Name="subscribe_url_short" DataType="DT_WSTR" Label="SubscribeUrlShort" Length="512" />
<Column Name="subscribe_url_long" DataType="DT_WSTR" Label="SubscribeUrlLong" Length="1024" />
<Column Name="beamer_address" DataType="DT_WSTR" Label="BeamerAddress" Length="500" />
<Column Name="visibility" DataType="DT_WSTR" Label="Visibility" Length="100" />
<Column Name="double_optin" DataType="DT_BOOL" Label="DoubleOptin" />
<Column Name="has_welcome" DataType="DT_BOOL" Label="HasWelcome" />
<Column Name="marketing_permissions" DataType="DT_BOOL" Label="MarketingPermissions" />
<Column Name="modules" DataType="DT_WSTR" Label="Modules" Length="500" />
<Column Name="stats.member_count" DataType="DT_I4" Label="MemberCount" />
<Column Name="stats.unsubscribe_count" DataType="DT_I4" Label="UnsubscribeCount" />
<Column Name="stats.cleaned_count" DataType="DT_I4" Label="CleanedCount" />
<Column Name="stats.member_count_since_send" DataType="DT_I4" Label="MemberCountSinceSend" />
<Column Name="stats.unsubscribe_count_since_send" DataType="DT_I4" Label="UnsubscribeCountSinceSend" />
<Column Name="stats.cleaned_count_since_send" DataType="DT_I4" Label="CleanedCountSinceSend" />
<Column Name="stats.campaign_count" DataType="DT_I4" Label="CampaignCount" />
<Column Name="stats.campaign_last_sent" DataType="DT_WSTR" Label="CampaignLastSent" Length="500" />
<Column Name="stats.merge_field_count" DataType="DT_I4" Label="MergeFieldCount" />
<Column Name="stats.avg_sub_rate" DataType="DT_I4" Label="AvgSubRate" />
<Column Name="stats.avg_unsub_rate" DataType="DT_I4" Label="AvgUnsubRate" />
<Column Name="stats.target_sub_rate" DataType="DT_I4" Label="TargetSubRate" />
<Column Name="stats.open_rate" DataType="DT_I4" Label="OpenRate" />
<Column Name="stats.click_rate" DataType="DT_I4" Label="ClickRate" />
<Column Name="stats.last_sub_date" DataType="DT_DBTIMESTAMP" Label="LastSubDate" />
<Column Name="stats.last_unsub_date" DataType="DT_DBTIMESTAMP" Label="LastUnsubDate" />
</OutputColumns>
</EndPoint>
<EndPoint Name="MemberOutputColumns">
<OutputColumns>
<Column Name="id" DataType="DT_WSTR" Label="Id" Length="200" Key="True"/>
<Column Name="list_id" DataType="DT_WSTR" Label="ListId" Length="200" />
<Column Name="email_address" DataType="DT_WSTR" Label="EmailAddress" Length="200" />
<Column Name="unique_email_id" DataType="DT_WSTR" Label="UniqueEmailId" Length="200" />
<Column Name="contact_id" DataType="DT_WSTR" Label="ContactId" Length="200" />
<Column Name="full_name" DataType="DT_WSTR" Label="FullName" Length="100" />
<Column Name="web_id" DataType="DT_I4" Label="WebId" />
<Column Name="email_type" DataType="DT_WSTR" Label="EmailType" Length="20" />
<Column Name="status" DataType="DT_WSTR" Label="Status" Length="20" />
<Column Name="consents_to_one_to_one_messaging" DataType="DT_BOOL" Label="ConsentsToOneToOneMessaging" />
<Column Name="merge_fields.FNAME" DataType="DT_WSTR" Label="FirstName" Length="50" />
<Column Name="merge_fields.LNAME" DataType="DT_WSTR" Label="LastName" Length="50" />
<Column Name="merge_fields.ADDRESS.addr1" DataType="DT_WSTR" Label="AddressLine1" Length="200" />
<Column Name="merge_fields.ADDRESS.addr2" DataType="DT_WSTR" Label="AddressLine2" Length="200" />
<Column Name="merge_fields.ADDRESS.city" DataType="DT_WSTR" Label="City" Length="200" />
<Column Name="merge_fields.ADDRESS.state" DataType="DT_WSTR" Label="State" Length="100" />
<Column Name="merge_fields.ADDRESS.zip" DataType="DT_WSTR" Label="Zip" Length="20" />
<Column Name="merge_fields.ADDRESS.country" DataType="DT_WSTR" Label="Country" Length="100" />
<Column Name="merge_fields.PHONE" DataType="DT_WSTR" Label="Phone" Length="50" />
<Column Name="merge_fields.BIRTHDAY" DataType="DT_WSTR" Label="Birthday" Length="50" />
<Column Name="stats.avg_open_rate" DataType="DT_I4" Label="StatsAvgOpenRate" />
<Column Name="stats.avg_click_rate" DataType="DT_I4" Label="StatsAvgClickRate" />
<Column Name="ip_signup" DataType="DT_WSTR" Label="IpSignup" Length="200" />
<Column Name="timestamp_signup" DataType="DT_DBTIMESTAMP" Label="TimestampSignup" />
<Column Name="ip_opt" DataType="DT_WSTR" Label="IpOpt" Length="200" />
<Column Name="timestamp_opt" DataType="DT_DBTIMESTAMP" Label="TimestampOpt" />
<Column Name="member_rating" DataType="DT_I4" Label="MemberRating" />
<Column Name="last_changed" DataType="DT_DBTIMESTAMP" Label="LastChanged" />
<Column Name="language" DataType="DT_WSTR" Label="Language" Length="100" />
<Column Name="vip" DataType="DT_BOOL" Label="Vip" />
<Column Name="email_client" DataType="DT_WSTR" Label="EmailClient" Length="200" />
<Column Name="location.latitude" DataType="DT_I4" Label="Latitude" />
<Column Name="location.longitude" DataType="DT_I4" Label="Longitude" />
<Column Name="location.gmtoff" DataType="DT_I4" Label="LocationGmtOff" />
<Column Name="location.dstoff" DataType="DT_I4" Label="LocationDstOff" />
<Column Name="location.country_code" DataType="DT_WSTR" Label="CountryCode" Length="100" />
<Column Name="location.timezone" DataType="DT_WSTR" Label="TimeZone" Length="100" />
<Column Name="location.region" DataType="DT_WSTR" Label="Region" Length="100" />
<Column Name="source" DataType="DT_WSTR" Label="Source" Length="100" />
<Column Name="tags_count" DataType="DT_I4" Label="TagsCount" />
<Column Name="tags" DataType="DT_WSTR" Label="Tags" Length="4000" />
</OutputColumns>
</EndPoint>
</Template>
<EndPoints>
<!-- Get User Details -->
<EndPoint Name="get_user_details"
Label="Get User Details"
Url="/3.0/"
Method="GET"
Desc="Gets details about the current Mailchimp user account."
HelpLink="https://mailchimp.com/developer/marketing/api/root/list-api-root-resources/">
<OutputColumns>
<Column Name="account_id" DataType="DT_WSTR" Label="AccountId" Length="200" />
<Column Name="login_id" DataType="DT_WSTR" Label="LoginId" Length="100" />
<Column Name="account_name" DataType="DT_WSTR" Label="AccountName" Length="100" />
<Column Name="email" DataType="DT_WSTR" Label="Email" Length="200" />
<Column Name="first_name" DataType="DT_WSTR" Label="FirstName" Length="50" />
<Column Name="last_name" DataType="DT_WSTR" Label="LastName" Length="50" />
<Column Name="username" DataType="DT_WSTR" Label="UserName" Length="100" />
<Column Name="avatar_url" DataType="DT_WSTR" Label="AvatarUrl" Length="4000" />
<Column Name="role" DataType="DT_WSTR" Label="Role" Length="50" />
<Column Name="member_since" DataType="DT_DBTIMESTAMP" Label="MemberSince" />
<Column Name="pricing_plan_type" DataType="DT_WSTR" Label="PricingPlanType" Length="100" />
<Column Name="first_payment" DataType="DT_WSTR" Label="FirstPayment" Length="100" />
<Column Name="account_timezone" DataType="DT_WSTR" Label="AccountTimeZone" Length="100" />
<Column Name="account_industry" DataType="DT_WSTR" Label="AccountIndustry" Length="100" />
<Column Name="contact.company" DataType="DT_WSTR" Label="ContactCompany" Length="100" />
<Column Name="contact.addr1" DataType="DT_WSTR" Label="ContactAddress1" Length="100" />
<Column Name="contact.addr2" DataType="DT_WSTR" Label="ContactAddress2" Length="100" />
<Column Name="contact.city" DataType="DT_WSTR" Label="ContactCity" Length="100" />
<Column Name="contact.state" DataType="DT_WSTR" Label="ContactState" Length="50" />
<Column Name="contact.zip" DataType="DT_WSTR" Label="ContactZip" Length="20" />
<Column Name="contact.country" DataType="DT_WSTR" Label="ContactCountry" Length="100" />
<Column Name="pro_enabled" DataType="DT_BOOL" Label="ProEnabled" />
<Column Name="last_login" DataType="DT_DBTIMESTAMP" Label="LastLogin" />
<Column Name="total_subscribers" DataType="DT_I4" Label="TotalSubscribers" />
<Column Name="_links" DataType="DT_NTEXT" Label="Links" />
</OutputColumns>
</EndPoint>
<!-- Get List of Campaigns -->
<EndPoint Name="get_campaigns"
Label="Get List of Campaigns"
Url="/3.0/campaigns?count=1000&offset={offset}"
Method="GET"
Filter="$.campaigns[*]"
Template="CampaignPagination,CampaignFilterParams,CampaignSortingParams,CampaignOutputColumns"
Desc="Get all campaigns in an account."
OutputHeaders="StatusCode"
HelpLink="https://mailchimp.com/developer/marketing/api/campaigns/list-campaigns/">
<Params>
<Param Name="type" Label="Campaign type" Type="Query" Desc="The campaign type. Possible values: regular, plaintext, absplit, rss, or variate." Options="regular;plaintext;absplit;rss;variate" />
<Param Name="status" Label="Status of the campaign" Type="Query" Desc="The status of the campaign. Possible values: save, paused, schedule, sending, or sent." Options="save;paused;schedule;sending;sent" />
<Param Name="before_send_time" Label="Campaign sent before (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict the response to campaigns sent before the set time. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="since_send_time" Label="Campaign sent after (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict the response to campaigns sent after the set time. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="before_create_time" Label="Campaign created before (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict the response to campaigns created before the set time. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="since_create_time" Label="Campaign created after (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict the response to campaigns created after the set time. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="list_id" Label="Using list Id" Type="Query" Desc="The unique id for the list." />
<Param Name="folder_id" Label="Using folder Id" Type="Query" Desc="The unique folder id." />
<Param Name="member_id" Label="To customer" Type="Query" Desc="Retrieve campaigns sent to a particular list member. Member ID is The MD5 hash of the lowercase version of the list member’s email address." />
<Param Name="ContineOnErrorForStatusCode" Value="True" Type="Property" />
<Param Name="ErrorStatusCodeToMatchRegex" Value="404|405" Type="Property" />
</Params>
</EndPoint>
<!-- Get Campaign Details -->
<EndPoint Name="get_campaign"
Label="Get Campaign Details"
Url="/3.0/campaigns/[$CampaignId$]"
Method="GET"
Template="CampaignFilterParams,CampaignOutputColumns"
Desc="Get information about a specific campaign."
HelpLink="https://mailchimp.com/developer/marketing/api/campaigns/get-campaign-info/">
<Params>
<Param Name="CampaignId" ReadAs="Id" Label="Campaign Id" IsKey="True" Type="Placeholder" Desc="The ID of the campaign for which data should be read." Required="True" />
<Param Name="ContineOnErrorForStatusCode" Value="True" Type="Property" />
<Param Name="ErrorStatusCodeToMatchRegex" Value="404|405" Type="Property" />
</Params>
</EndPoint>
<!-- Add New List -->
<EndPoint Name="add_list"
Label="Add New List"
Url="/3.0/lists"
Method="POST"
ContentType="application/json"
JsonRowFormat="Multicontent"
Template="ListPostInputColumns,ListOutputColumns"
Desc="Create a new list in your Mailchimp account."
DotAsPath="True"
Body="{$rows$}"
HelpLink="https://mailchimp.com/developer/marketing/api/lists/add-list/">
</EndPoint>
<!-- Get Lists -->
<EndPoint Name="get_lists"
Label="Get Lists"
Url="/3.0/lists?count=1000&offset={offset}"
Method="GET"
Filter="$.lists[*]"
Template="ListPagination,ListFilterParams,ListSortingParams,ListOutputColumns"
Desc="Get information about all lists in the account."
HelpLink="https://mailchimp.com/developer/marketing/api/lists/get-lists-info/">
<Params>
<Param Name="before_date_created" Label="Created before (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict response to lists created before the set date. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="since_date_created" Label="Created after (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict results to lists created after the set date. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="before_campaign_last_sent" Label="Created before last campaign send date (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict results to lists created before the last campaign send date. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="since_campaign_last_sent" Label="Created after last campaign send date (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict results to lists created after the last campaign send date. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="email" Label="Includes email address" Type="Query" Desc="Restrict results to lists that include a specific subscriber's email address." />
<Param Name="has_ecommerce_store" Label="Contains active ecommerce store" Type="Query" Desc="Restrict results to lists that contain an active, connected, undeleted ecommerce store." Options="true;false" />
</Params>
</EndPoint>
<!-- Get List Details -->
<EndPoint Name="get_list"
Label="Get List Details"
Url="/3.0/lists/[$Id$]"
Method="GET"
Template="ListFilterParams,ListOutputColumns"
Desc="Get information about a specific campaign."
HelpLink="https://mailchimp.com/developer/marketing/api/lists/get-list-info/">
<Params>
<Param Name="Id" Label="List Id" IsKey="True" Type="Placeholder" Desc="The ID of the list for which data should be read." Required="True" />
<Param Name="ContineOnErrorForStatusCode" Value="True" Type="Property" />
<Param Name="ErrorStatusCodeToMatchRegex" Value="404|405" Type="Property" />
</Params>
</EndPoint>
<!-- Delete List -->
<EndPoint Name="delete_list"
Label="Delete List"
Url="/3.0/lists/[$Id$]"
Method="DELETE"
OutputHeaders="StatusCode"
Desc="Delete a specific list."
HelpLink="https://mailchimp.com/developer/marketing/api/lists/delete-list/">
<Params>
<Param Name="Id" Label="List Id" IsKey="True" Type="Placeholder" Desc="The ID of the list which should be deleted." Required="True" OptionsEndPoint="get_lists" OptionsEndPointValueColumn="Id" OptionsEndPointLabelColumn="Name" />
<Param Name="RawOutputDataRowTemplate" Value="{}" ValueTemplate="{Status:'Deleted', Id:'[$Id$]'}" Type="Property" />
<Param Name="EnableRawOutputModeSingleRow" Value="True" Type="Property" />
<Param Name="ContineOnErrorForStatusCode" Value="True" Type="Property" />
<Param Name="ErrorStatusCodeToMatchRegex" Value="404|405" Type="Property" />
</Params>
<OutputColumns>
<Column Name="Id" />
<Column Name="Status" />
<Column Name="ResponseHeaders_StatusCode" Label="StatusCode" DataType="DT_I4" />
</OutputColumns>
<InputColumns>
<Column Name="Id" MapToParam="True" Key="True"/>
</InputColumns>
</EndPoint>
<!-- Update List Details -->
<EndPoint Name="update_list"
Label="Update List Details"
Url="/3.0/lists/[$Id$]"
Method="PATCH"
ContentType="application/json"
JsonRowFormat="Multicontent"
Headers="Expect:"
Template="ListPatchInputColumns,ListOutputColumns"
Desc="Update the settings for a specific list."
DotAsPath="True"
Body="{$rows$}"
HelpLink="https://mailchimp.com/developer/marketing/api/lists/update-lists/">
<Params>
<Param Name="Id" Label="List Id" IsKey="True" Type="Placeholder" Desc="The ID of the list for which data should be updated." Required="True" />
</Params>
<InputColumns>
<Column Name="Id" MapToParam="True" DataType="DT_WSTR" Length="100" ExcludeFromRowMap="True" Key="True" Desc="The ID of the list for which data should be updated." Required="True" />
</InputColumns>
</EndPoint>
<!-- Add New List Member -->
<EndPoint Name="add_list_member"
Label="Add New List Member"
Url="/3.0/lists/[$ListId$]/members"
Method="POST"
ContentType="application/json"
JsonRowFormat="Multicontent"
Template="MemberPostInputColumns,MemberOutputColumns"
Desc="Add a new member to the list. It throws error if same email exists"
DotAsPath="True"
Body="{$rows$}"
HelpLink="https://mailchimp.com/developer/marketing/api/list-members/add-member-to-list/">
<Params>
<Param Name="ListId" Template="ListIdParam" Label="List Id" />
<Param Name="SkipMergeValidation" Key="skip_merge_validation" Label="Skip Merge Validation" Type="Query" Value="false" Options="true;false" Desc="If skip_merge_validation is true, member data will be accepted without merge field values, even if the merge field is usually required. This defaults to false." />
</Params>
<InputColumns>
<Column Name="ListId" MapToParam="True" DataType="DT_WSTR" Length="100" ExcludeFromRowMap="True" Desc="The ID of the list for which to add a new member." Required="True" />
</InputColumns>
</EndPoint>
<!-- Add New List Member -->
<EndPoint Name="upsert_list_members"
Label="Add or Update Upsert List Members (Bulk Subscribe or Unsubscribe)"
Url="/3.0/lists/[$ListId$]"
Method="POST"
ContentType="application/json"
Template="MemberPostInputColumns,MemberOutputColumns"
Desc="Add or Update Upsert List Members (Bulk Subscribe or Unsubscribe)."
DotAsPath="True"
BatchSize="500"
Filter="$.new_members[*]"
ExtraFilters="$.updated_members[*]::$.errors[*]"
ExtraFilterColumns="RowStatus=New::RowStatus=Updated::RowStatus=Error"
IncludeParentColumns="True"
HelpLink="https://mailchimp.com/developer/marketing/api/lists/batch-subscribe-or-unsubscribe/">
<Body>
<![CDATA[{"update_existing": [$UpdateExisting$],"sync_tags": [$SyncTags$], "members": {$rows$}}]]>
</Body>
<Params>
<Param Name="ListId" Template="ListIdParam" Label="List Id" />
<Param Name="SkipMergeValidation" Key="skip_merge_validation" Label="Skip Merge Validation" Type="Query" Value="false" Options="true;false" Desc="If skip_merge_validation is true, member data will be accepted without merge field values, even if the merge field is usually required. This defaults to false." />
<Param Name="SkipDuplicateCheck" Key="skip_duplicate_check" Label="Skip Duplicate Check" Type="Query" Value="false" Options="true;false" Desc="If skip_duplicate_check is true, we will ignore duplicates sent in the request when using the batch sub/unsub on the lists endpoint. The status of the first appearance in the request will be saved. This defaults to false." />
<Param Name="UpdateExisting" Label="Update Exising Subscription Status?" Value="true" Options="true;false" Desc="Whether this batch operation will change existing members' subscription status." />
<Param Name="SyncTags" Label="Sync Tags" Value="false" Options="true;false" Desc="Whether this batch operation will replace all existing tags with tags in request." />
<Param Name="ExtraFilters" Type="Property" Hidden="True" Value="$.updated_members[*]::$.errors[*]" />
<Param Name="ExtraFilterColumns" Type="Property" Hidden="True" Value="RowStatus=New::RowStatus=Updated::RowStatus=Error" />
<ParamXX Name="IncludeParentWhenChildNull" Type="Property" Hidden="True" Value="True" />
</Params>
<OutputColumns>
<Column Name="RowStatus" DataType="DT_WSTR" Length="50" />
<Column Name="P_total_created" Label="TotalCreated" DataType="DT_I4" />
<Column Name="P_total_updated" Label="TotalUpdated" DataType="DT_I4" />
<Column Name="P_error_count" Label="ErrorCount" DataType="DT_I4" />
<Column Name="error" Label="ErrorMessage" DataType="DT_WSTR" Length="4000" />
<Column Name="error_code" Label="ErrorCode" DataType="DT_WSTR" Length="255" />
<Column Name="field" Label="ErrorField" DataType="DT_WSTR" Length="255" />
<Column Name="field_message" Label="ErrorFieldMessage" DataType="DT_WSTR" Length="4000" />
</OutputColumns>
</EndPoint>
<!-- Add New List Members in Bulk -->
<EndPoint Name="add_list_members_bulk"
Label="Add New List Members in Bulk"
Url="/3.0/batches"
Method="POST"
BatchSize="1000"
ContentType="application/json"
Template="MemberPostInputColumns"
Desc="Adds multiple members using Bulk API."
HelpLink="https://mailchimp.com/developer/marketing/api/batch-webhooks/">
<Body>
<![CDATA[{"operations": {$rows$}}]]>
</Body>
<Params>
<Param Name="ListId" Template="ListIdParam" Label="List Id" />
<Param Name="SkipMergeValidation" Key="skip_merge_validation" Label="Skip Merge Validation" Type="Query" Value="false" Options="true;false" Desc="If skip_merge_validation is true, member data will be accepted without merge field values, even if the merge field is usually required. This defaults to false." />
</Params>
<LayoutMap>
<![CDATA[<?xml version="1.0" encoding="utf-8"?>
<settings ver="3">
<dataset id="root" readfrominput="True" />
<map name="method" value="POST" />
<map name="path" value="/lists/[$ListId$]/members" />
<map name="operation_id" value="<<FUN_SEQUENCE>>" />
<map name="body" datatype="String">
<map src="email_address" name="email_address" />
<map src="status" name="status" />
<map src="email_type" name="email_type" />
<map src="merge_fields" name="merge_fields" fragment="True" />
<map src="interests" name="interests" fragment="True" />
<map src="language" name="language" />
<map src="vip" name="vip" />
<map name="location">
<map src="latitude" name="latitude" />
<map src="longitude" name="longitude" />
</map>
<map src="marketing_permissions" name="marketing_permissions" fragment="True"/>
<map src="ip_signup" name="ip_signup" />
<map src="timestamp_signup" name="timestamp_signup" />
<map src="ip_opt" name="ip_opt" />
<map src="timestamp_opt" name="timestamp_opt" />
<map src="tags" name="tags" fragment="True"/>
</map>
</settings>]]>
</LayoutMap>
<!-- IncludeParentColumns is needed if we use single column filter -->
<EndPoint Url="/3.0/batches/[$parent.id$]" Method="GET"
IncludeParentColumns="True"
Filter="$">
<Params>
<Param Name="EnableStatusCheck" Type="Property" Value="true" />
<Param Name="StatusFieldFilterType" Type="Property" Value="Json" />
<Param Name="StatusFieldFilterExpr" Type="Property" Value="$.status" />
<Param Name="StatusSuccessValue" Type="Property" Value="finished|failed|cancelled|error" />
<Param Name="StatusContinueValue" Type="Property" Value="pending|preprocessing|started|finalizing" />
<Param Name="StatusCheckIterationWaitSeconds" Type="Property" Value="4" />
<Param Name="StatusCheckMaxWaitSeconds" Type="Property" Value="200" />
</Params>
<EndPoint Name="ChildDownloadReport"
Url="[$parent.response_body_url$]"
Method="GET"
CachedTtl="60"
Filter="$">
<Params>
<Param Name="EnableStatusCheck" Type="Property" Value="false" />
<Param Name="FileCompressionType" Value="TarGZip" />
</Params>
</EndPoint>
</EndPoint>
<InputColumns>
</InputColumns>
<OutputColumns>
<Column Name="response" Label="Id" Length="100" Functions="[$1]|~|$.id|~|,,FUN_JSON_TO_TEXT" />
<Column Name="response" Label="Email" Length="255" Functions="[$1]|~|$.email_address|~|,,FUN_JSON_TO_TEXT" />
<Column Name="status_code" Label="StatusCode" DataType="DT_I4" />
<Column Name="operation_id" Label="OperationId" Length="255" />
<Column Name="response" Label="ErrorTitle" Functions="[$1]|~|$.title|~|,,FUN_JSON_TO_TEXT" />
<Column Name="response" Label="ErrorDetail" Functions="[$1]|~|$.detail|~|,,FUN_JSON_TO_TEXT" />
</OutputColumns>
</EndPoint>
<!-- Get List Members -->
<EndPoint Name="get_list_members"
Label="Get List Members"
Url="/3.0/lists/[$ListId$]/members?count=1000&offset={offset}"
Method="GET"
Filter="$.members[*]"
Template="MemberPagination,MemberFilterParams,MemberSortingParams,MemberOutputColumns"
Desc="Get information about members in a specific Mailchimp list."
HelpLink="https://mailchimp.com/developer/marketing/api/list-members/list-members-info/">
<Params>
<Param Name="ListId" Template="ListIdParam" Label="List Id" />
<Param Name="email_type" Label="Email Type" Type="Query" Options="html;text" Desc="The email type." />
<Param Name="status" Label="Status" Type="Query" MultiSelect="True" MultiSelectSeparator="," Options="subscribed;unsubscribed;cleaned;pending;transactional;archived" Desc="The subscriber's status. Possible values: subscribed, unsubscribed, cleaned, pending, transactional, or archived." />
<Param Name="since_timestamp_opt" Label="Since Timestamp Opt (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict results to subscribers who opted-in after the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="before_timestamp_opt" Label="Before Timestamp Opt (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict results to subscribers who opted-in before the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="since_last_changed" Label="Since Last Changed (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict results to subscribers whose information changed after the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="before_last_changed" Label="Before Last Changed (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict results to subscribers whose information changed before the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="unique_email_id" Label="Unique Email Id" Type="Query" Desc="A unique identifier for the email address across all Mailchimp lists." />
<Param Name="vip_only" Label="VIP Only" Type="Query" Options="true;false" Desc="A filter to return only the list's VIP members. Passing true will restrict results to VIP list members, passing false will return all list members." />
<Param Name="interest_category_id" Label="Interest Category Id" Type="Query" Desc="The unique id for the interest category." />
<Param Name="interest_ids" Label="Interest Ids" Type="Query" Desc="Used to filter list members by interests. Must be accompanied by interest_category_id and interest_match. The value must be a comma separated list of interest ids present for any supplied interest categories." />
<Param Name="interest_match" Label="Interest Match" Type="Query" Desc="Used to filter list members by interests. Must be accompanied by interest_category_id and interest_ids. 'any' will match a member with any of the interest supplied, 'all' will only match members with every interest supplied, and 'none' will match members without any of the interest supplied. Possible values: 'any', 'all', or 'none'." />
<Param Name="since_last_campaign" Label="Since Last Campaign" Type="Query" Options="true;false" Desc="Filter subscribers by those subscribed/unsubscribed/pending/cleaned since last email campaign send. Member status is required to use this filter." />
<Param Name="unsubscribed_since" Label="Unsubscribed Since (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Filter subscribers by those unsubscribed since a specific date. Using any status other than unsubscribed with this filter will result in an error." />
</Params>
</EndPoint>
<!-- Get All Members in All Lists -->
<EndPoint Name="get_list_members_all"
Label="Get All Members in All Lists"
Url="/3.0/lists?count=1000&offset={offset}"
Method="GET"
Filter="$.lists[*]"
Template="ListPagination,MemberOutputColumns"
Desc="Get information about all members in all lists."
HelpLink="https://mailchimp.com/developer/marketing/api/list-members/list-members-info/">
<Params>
<Param Name="email_type" Label="Email Type" Type="Query" Options="html;text" Desc="The email type." />
<Param Name="status" Label="Status" Type="Query" MultiSelect="True" MultiSelectSeparator="," Options="subscribed;unsubscribed;cleaned;pending;transactional;archived" Desc="The subscriber's status. Possible values: subscribed, unsubscribed, cleaned, pending, transactional, or archived." />
<Param Name="since_timestamp_opt" Label="Since Timestamp Opt (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict results to subscribers who opted-in after the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="before_timestamp_opt" Label="Before Timestamp Opt (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict results to subscribers who opted-in before the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="since_last_changed" Label="Since Last Changed (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict results to subscribers whose information changed after the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="before_last_changed" Label="Before Last Changed (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Restrict results to subscribers whose information changed before the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00." />
<Param Name="unique_email_id" Label="Unique Email Id" Type="Query" Desc="A unique identifier for the email address across all Mailchimp lists." />
<Param Name="vip_only" Label="VIP Only" Type="Query" Options="true;false" Desc="A filter to return only the list's VIP members. Passing true will restrict results to VIP list members, passing false will return all list members." />
<Param Name="interest_category_id" Label="Interest Category Id" Type="Query" Desc="The unique id for the interest category." />
<Param Name="interest_ids" Label="Interest Ids" Type="Query" Desc="Used to filter list members by interests. Must be accompanied by interest_category_id and interest_match. The value must be a comma separated list of interest ids present for any supplied interest categories." />
<Param Name="interest_match" Label="Interest Match" Type="Query" Desc="Used to filter list members by interests. Must be accompanied by interest_category_id and interest_ids. 'any' will match a member with any of the interest supplied, 'all' will only match members with every interest supplied, and 'none' will match members without any of the interest supplied. Possible values: 'any', 'all', or 'none'." />
<Param Name="since_last_campaign" Label="Since Last Campaign" Type="Query" Options="true;false" Desc="Filter subscribers by those subscribed/unsubscribed/pending/cleaned since last email campaign send. Member status is required to use this filter." />
<Param Name="unsubscribed_since" Label="Unsubscribed Since (Format: 2015-10-21T15:41:36)" Type="Query" Template="DateSelectionParam" Desc="Filter subscribers by those unsubscribed since a specific date. Using any status other than unsubscribed with this filter will result in an error." />
</Params>
<EndPoint Name="child_get_list_members"
Url="/3.0/lists/[$parent.id$]/members?count=1000&offset={offset}"
Method="GET"
Filter="$.members[*]"
Template="MemberPagination,MemberFilterParams,MemberSortingParams">
</EndPoint>
</EndPoint>
<!-- Get a Specific Member From All Lists -->
<EndPoint Name="get_list_member_all"
Label="Get a Specific Member From All Lists"
Url="/3.0/lists?count=1000&offset={offset}"
Method="GET"
Filter="$.lists[*]"
Template="MemberOutputColumns"
Desc="Get information about all members in all lists."
HelpLink="https://mailchimp.com/developer/marketing/api/list-members/list-members-info/">
<Params>
<Param Name="MemberId" ReadAs="Id" IsKey="True" Label="Member Id" Type="Placeholder" Desc="The ID of the member for which to get details." Required="True" />
</Params>
<EndPoint Name="child_get_list_member"
Url="/3.0/lists/[$parent.id$]/members/[$MemberId$]"
Method="GET">
</EndPoint>
</EndPoint>
<!-- Get List Member Details -->
<EndPoint Name="get_list_member"
Label="Get List Member Details"
Url="/3.0/lists/[$ListId$]/members/[$MemberId$]"
Method="GET"
Template="MemberFilterParams,MemberOutputColumns"
Desc="Get information about a specific list member, including a currently subscribed, unsubscribed, or bounced member."
HelpLink="https://mailchimp.com/developer/marketing/api/list-members/get-member-info/">
<Params>
<Param Name="ListId" Template="ListIdParam" Label="List Id" />
<Param Name="MemberId" ReadAs="Id" IsKey="True" Label="Member Id" Type="Placeholder" Desc="The ID of the list member for which data should be read." Required="True" />
<Param Name="ContineOnErrorForStatusCode" Value="True" Type="Property" />
<Param Name="ErrorStatusCodeToMatchRegex" Value="404|405" Type="Property" />
</Params>
</EndPoint>
<!-- Delete List Member (Archive) -->
<EndPoint Name="delete_list_member"
Label="Delete List Member (Archive)"
Url="/3.0/lists/[$ListId$]/members/[$Id$]"
Method="DELETE"
OutputHeaders="StatusCode"
Desc="Archive a list member. To permanently delete, use the delete_list_member_permanent endpoint."
HelpLink="https://mailchimp.com/developer/marketing/api/list-members/delete-list-member/">
<Params>
<Param Name="ListId" Template="ListIdParam" Label="List Id" />
<Param Name="Id" ReadAs="Id" Label="Member Id" IsKey="True" Type="Placeholder" Desc="The ID of the list member for which data should be deleted." Required="True" />
<Param Name="RawOutputDataRowTemplate" Value="{}" ValueTemplate="{Status:'Deleted', Id:'[$Id$]', ListId:'[$ListId$]'}" Type="Property" />
<Param Name="EnableRawOutputModeSingleRow" Value="True" Type="Property" />
<Param Name="ContineOnErrorForStatusCode" Value="True" Type="Property" />
<Param Name="ErrorStatusCodeToMatchRegex" Value="404|405" Type="Property" />
</Params>
<OutputColumns>
<Column Name="Id" />
<Column Name="ListId" />
<Column Name="Status" />
<Column Name="ResponseHeaders_StatusCode" Label="StatusCode" DataType="DT_I4" />
</OutputColumns>
<InputColumns>
<Column Name="Id" Label="Id" MapToParam="True" Key="True"/>
</InputColumns>
</EndPoint>
<!-- Delete List Member (permanent delete include personal data) -->
<EndPoint Name="delete_list_member_permanent"
Label="Delete List Member (Permanent delete)"
Url="/3.0/lists/[$ListId$]/members/[$Id$]/actions/delete-permanent"
Method="POST"
OutputHeaders="StatusCode"
Desc="Delete all personally identifiable information related to a list member, and remove them from a list. This will make it impossible to re-import the list member."
HelpLink="https://mailchimp.com/developer/marketing/api/list-members/delete-list-member/">
<Params>
<Param Name="ListId" Template="ListIdParam" Label="List Id" />
<Param Name="Id" IsKey="True" Label="Member Id" Type="Placeholder" Desc="The ID of the list member for which data should be deleted." Required="True" />
<Param Name="RawOutputDataRowTemplate" Value="{}" ValueTemplate="{Status:'Deleted', Id:'[$Id$]'}" Type="Property" />
<Param Name="EnableRawOutputModeSingleRow" Value="True" Type="Property" />
<Param Name="ContineOn404Error" Value="True" Type="Property" />
</Params>
<OutputColumns>
<Column Name="Id" />
<Column Name="Status" />
<Column Name="ResponseHeaders_StatusCode" Label="StatusCode" DataType="DT_I4" />
<InputColumns>
<Column Name="Id" Label="Id" MapToParam="True" Key="True"/>
</InputColumns>
</OutputColumns>
</EndPoint>
<!-- Update List Member Details -->
<EndPoint Name="update_list_member"
Label="Update List Member Details"
Url="/3.0/lists/[$ListId$]/members/[$Id$]"
Method="PATCH"
ContentType="application/json"
JsonRowFormat="Multicontent"
Headers="Expect:"
Template="MemberPatchInputColumns,MemberOutputColumns"
Desc="Update the settings for a specific list member."
DotAsPath="True"
Body="{$rows$}"
HelpLink="https://mailchimp.com/developer/marketing/api/list-members/update-list-member/">
<Params>
<Param Name="ListId" Template="ListIdParam" Label="List Id" />
<Param Name="Id" IsKey="True" Label="Member Id" Type="Placeholder" Desc="The ID of the member to update." Required="True" />
<Param Name="SkipMergeValidation" Key="skip_merge_validation" Label="Skip Merge Validation" Type="Query" Value="false" Options="true;false" Desc="If skip_merge_validation is true, member data will be accepted without merge field values, even if the merge field is usually required. This defaults to false." />
<Param Name="ContineOnErrorForStatusCode" Value="True" Type="Property" />
<Param Name="ErrorStatusCodeToMatchRegex" Value="404|405" Type="Property" />
</Params>
<InputColumns>
<Column Name="ListId" MapToParam="True" DataType="DT_WSTR" Length="100" ExcludeFromRowMap="True" Desc="The ID of the list for which data should be updated." Required="True" />
<Column Name="Id" MapToParam="True" Key="True" DataType="DT_WSTR" Length="100" ExcludeFromRowMap="True" Desc="The ID of the member for which data should be updated." Required="True" />
</InputColumns>
</EndPoint>
</EndPoints>
<Tables>
<Table Name="Campaigns"
SelectEndPoint="get_campaigns"
LookupEndPoint="get_campaign"
/>
<Table Name="Lists"
InsertEndPoint="add_list"
SelectEndPoint="get_lists"
LookupEndPoint="get_list"
UpdateEndPoint="update_list"
DeleteEndPoint="delete_list"
/>
<Table Name="ListMembers" Desc="This table supports bulk operations. For bulk Add/Update use UPSERT operation. All other operations are row by row."
InsertEndPoint="add_list_member"
SelectEndPoint="get_list_members"
LookupEndPoint="get_list_member"
UpdateEndPoint="update_list_member"
UpsertEndPoint="upsert_list_members"
DeleteEndPoint="delete_list_member"
/>
<Table Name="ListMembersBulk" Desc="This table uses BULK API to create / update contacts in bulk. In this table add operation is slightly faster compared to ListMembers table. Use this endpoint if you have real need to speed up and you dont need some information returned by ListMembers operation."
InsertEndPoint="add_list_members_bulk"
SelectEndPoint="get_list_members_all"
LookupEndPoint="get_list_member"
UpdateEndPoint="update_list_member"
UpsertEndPoint="upsert_list_members"
DeleteEndPoint="delete_list_member"
/>
</Tables>
<Examples>
<Example Group="ODBC" Default="True" Label="Get a list of campaigns in your Mailchimp account.">
<Code>
<![CDATA[
SELECT * FROM Campaigns
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Get specific columns in list of campaigns in your Mailchimp account.">
<Code>
<![CDATA[
SELECT Id, WebId, Type, CreateTime, ArchiveUrl, LongArchiveUrl, Status, EmailsSent, SendTime, ContentType, NeedsBlockRefresh, Resendable, RecipientsListId, RecipientsListIsActive, RecipientsListName, RecipientsSegmentText, RecipientsRecipientCount, SettingsSubjectLine, SettingsTitle, SettingsFromName, SettingsReplyTo, SettingsUseConversation, SettingsToName, SettingsFolderId, SettingsAuthenticate, SettingsAutoFooter, SettingsInlineCss, SettingsAutoTweet, SettingsFbComments, SettingsTimeWarp, SettingsTemplateId, SettingsDragAndDrop, TrackingOpens, TrackingHtmlClicks, TrackingTextClicks, TrackingGoalTracking, TrackingEcomm360, TrackingGoogleAnalytics, TrackingClicktale, DeliveryStatusEnabled
FROM Campaigns
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Get details about a specific campaign in your Mailchimp account.">
<Code>
<![CDATA[
SELECT * FROM Campaigns
WHERE Id='328e99cbc4'
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Get list of lists/audiences in your Mailchimp account.">
<Code>
<![CDATA[
SELECT * FROM Lists
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Get specific columns in list of lists/audiences in your Mailchimp account.">
<Code>
<![CDATA[
SELECT Id, WebId, Name, Company, Address1, Address2, City, State, Zip, Country, Phone, PermissionReminder, UseArchiveBar, CampaignDefaultFromName, CampaignDefaultFromEmail, CampaignDefaultSubject, CampaignDefaultLanguage, NotifyOnSubscribe, NotifyOnUnsubscribe, DateCreated, ListRating, EmailTypeOption, SubscribeUrlShort, SubscribeUrlLong, BeamerAddress, Visibility, DoubleOptin, HasWelcome, MarketingPermissions, Modules, MemberCount, UnsubscribeCount, CleanedCount, MemberCountSinceSend, UnsubscribeCountSinceSend, CleanedCountSinceSend, CampaignCount, CampaignLastSent, MergeFieldCount, AvgSubRate, AvgUnsubRate, TargetSubRate, OpenRate, ClickRate, LastSubDate, LastUnsubDate
FROM Lists
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Get details of a list/audience in your Mailchimp account.">
<Code>
<![CDATA[
SELECT * FROM Lists
WHERE Id='e246f7e24d'
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Delete a list from Mailchimp account.">
<Code>
<![CDATA[
DELETE FROM Lists
WHERE Id='e246f7e24d'
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Get list of members within a specific list/audience in your Mailchimp account">
<Code>
<![CDATA[
SELECT * FROM get_list_members
WITH (ListId='e246f7e24d')
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Get the current user's account information, such as full name, user name, email address, role, etc.">
<Code>
<![CDATA[
SELECT * FROM get_user_details
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Get specific columns of the current user's account information, such as full name, user name, email address, role, etc.">
<Code>
<![CDATA[
SELECT AccountId, LoginId, AccountName, Email, FirstName, LastName, UserName, AvatarUrl, Role, MemberSince, PricingPlanType, FirstPayment, AccountTimeZone, AccountIndustry, ContactCompany, ContactAddress1, ContactAddress2, ContactCity, ContactState, ContactZip, ContactCountry, ProEnabled, LastLogin, TotalSubscribers
FROM get_user_details
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Create a new list/audience in your Mailchimp account">
<Code>
<![CDATA[
INSERT INTO Lists
(Name, Company, Address1, Address2, City, State, Zip, Country, Phone, PermissionReminder, UseArchiveBar, CampaignDefaultFromName, CampaignDefaultFromEmail, CampaignDefaultSubject, CampaignDefaultLanguage, NotifyOnSubscribe, NotifyOnUnsubscribe, EmailTypeOption, DoubleOptIn, MarketingPermissions)
VALUES
('The Awesome List', 'My Company Name', '123 Morgan Falls Lane', 'Suite 250','Albany', 'GA', '30114', 'US', '(770) 555-1234', 'Thank you for signing up for these notification emails!', 'false', 'Sales Team', 'salesteam@mycompany.com', 'The best deals are here!', 'en', 'salesteam@mycompany.com', 'salesteam@mycompany.com', 'true', 'false', 'true')
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Update details of a list/audience in your Mailchimp account (Update Mail Footer Address for SPAM compliance)">
<Code>
<![CDATA[
UPDATE Lists SET Address1='123 Main Street', Address2 = 'Suite 52', City = 'Chicago'
WHERE Id='e246f7e24d'
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Get a list member by Id from a Mailchimp List">
<Code>
<![CDATA[
SELECT * FROM ListMembers
WHERE Id='170a0722daae03855d6434eb3a5959fb'
WITH (ListId='e246f7e24d')
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Get a list member by Email from a Mailchimp List">
<Code>
<![CDATA[
SELECT * FROM ListMembers
WITH (ListId='e246f7e24d', Id='test@abc.com')
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Delete a list member (archive) from a Mailchimp List." Desc="Delete List Member by Id and archive it. To delete permanently use delete_list_member_permanent endpoint. Archived / bounced record cannot be resubscribed. To resubscribe you must call delete_list_member_permanent">
<Code>
<![CDATA[
DELETE FROM ListMembers
WHERE Id='170a0722daae03855d6434eb3a5959fb'
WITH (ListId='e246f7e24d')
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Delete list members (archive) from a Mailchimp List which are created after specific date (i.e. after Opt In time)." Desc="Delete list member operation archives the record. To delete permanently use delete_list_member_permanent endpoint. Archived / bounced record cannot be resubscribed. To resubscribe you must call delete_list_member_permanent.">
<Code>
<![CDATA[
DELETTE from ListMembers
WHERE TimestampOpt > '2023-06-16'
WITH (ListId='a4d24015f8')
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Delete list members permanently from a Mailchimp List which are created after specific date (i.e. after Opt In time)." Desc="Delete list member operation archives the record.">
<Code>
<![CDATA[
select * from delete_list_member_permanent
WITH (ListId='a4d24015f8' , Id='170a0722daae03855d6434eb3a5959fb' )
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Get list of all members within all lists/audiences in your Mailchimp account">
<Code>
<![CDATA[
SELECT * FROM ListMembers --scan all lists and then fetch members for each list
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Get details on a specific member within all lists/audiences in your Mailchimp account">
<Code>
<![CDATA[
SELECT * FROM ListMembers
WHERE Id='170a0722daae03855d6434eb3a5959fb'
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Get specific columns in list of members within a specific list/audience in your Mailchimp account">
<Code>
<![CDATA[
SELECT Id, ListId, EmailAddress, UniqueEmailId, ContactId, FullName, WebId, EmailType, Status, ConsentsToOneToOneMessaging, FirstName, LastName, AddressLine1, AddressLine2, City, State, Zip, Country, Phone, Birthday, StatsAvgOpenRate, StatsAvgClickRate, IpSignup, TimestampSignup, IpOpt, TimestampOpt, MemberRating, LastChanged, Language, Vip, EmailClient, Latitude, Longitude, LocationGmtOff, LocationDstOff, CountryCode, TimeZone, Region, Source, TagsCount, Tags
FROM ListMembers
WITH (ListId='e246f7e24d')
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Create a new member in the specified list/audience in your Mailchimp account">
<Code>
<![CDATA[
INSERT INTO ListMembers
(EmailAddress, Status, EmailType, MergeFields, Language, Vip, Latitude, Longitude, IpSignup, TimestampSignup, IpOpt, TimestampOpt, Tags)
VALUES
('np-brucewayne1@zappysys.com', 'subscribed', 'html',
'{"FNAME":"John","LNAME":"Doe","ADDRESS":{"addr1":"123","Freddie":"Ave","city":"Atlanta","state":"GA","zip":"12345"}}',
'en', false, '41.881832', '-87.623177', '192.168.0.8', '2023-04-01 18:00:00', '192.168.0.8', '2023-04-02 14:00:00',
'["Newtag1","Newtag2","Newtag3"]')
WITH (ListId='a4d24015f8')
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Update an existing member in the specified list/audience in your Mailchimp account">
<Code>
<![CDATA[
UPDATE ListMembers
SET EmailAddress='brucewayne10@mycompany.com'
, Status='subscribed' --subscribed, unsubscribed, cleaned, pending
, EmailType='text' --html, text
, Vip='false' --true
, FirstName='Bruce'
, LastName='Wayne'
/*,MergeFields= '{
"FNAME": "Bruce1",
"LNAME": "Wayne1",
"PHONE": "678-111-1234"
}',
*/
, Language='en' --fr
, TimestampOpt='2023-04-02 11:37:49'
, Latitude='38.8951' , Longitude='-77.0364' --Washington DC
, Tags='["tag1","tag2"]'
WHERE Id='e9f73ced3b649f0ca829103bcacb2846'
WITH (ListId='a4d24015f8',SkipMergeValidation='false')
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Bulk Add / Update MailChimp Subscibers (members) from Microsoft SQL Server Table - Subscribe / Unsubscribe">
<Code>
<![CDATA[
UPSERT INTO ListMembers
SOURCE('MSSQL', 'Data Source=localhost;Initial Catalog=tempdb;Integrated Security=true'
,'select ''brucewayne10@gmail.com'' EmailAddress,''first1'' as FirstName, ''subscribed'' Status
UNION ALL
select ''test55@gmail.com'' EmailAddress,''first1'' FirstName, ''subscribed'' Status
')
WITH(ListId='a4d24015f8')
--//column name alias must match with InputColumns of ListMembers
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Bulk Add / Update Subscibers (list members) from CSV File - Subscribe / Unsubscribe">
<Code>
<![CDATA[
UPSERT INTO ListMembers
SOURCE('ODBC', 'Driver={ZappySys CSV Driver};DataPath=c:\subscribers.csv'
,'select col1 as EmailAddress,col2 as FirstName, col3 as Status from $') --//column name alias must match with InputColumns of ListMembers
WITH(ListId='a4d24015f8')
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Bulk Add / Update Subscibers (list members) from any ODBC Source - Subscribe / Unsubscribe">
<Code>
<![CDATA[
UPSERT INTO ListMembers
SOURCE('ODBC', 'DSN=MyOdbcDsn
,'select col1 as EmailAddress,col2 as FirstName, col3 as Status from sometable') --//column name alias must match with InputColumns of ListMembers
WITH(ListId='a4d24015f8')
]]>
</Code>
</Example>
<Example Group="ODBC" Label="Bulk Add Subscibers (members) to the List from Source like MSSQL, ODBC">
<Code>
<![CDATA[
INSERT INTO ListMembersBulk
SOURCE('ODBC', 'DSN=MyOdbcDsn
,'select col1 as EmailAddress,col2 as FirstName, col3 as Status') --//column name alias must match with InputColumns of ListMembers
WITH(ListId='a4d24015f8')
]]>
</Code>
</Example>
</Examples>
</ApiConfig>
