Asana Connector - Source Code
<?xml version="1.0" encoding="utf-8"?>
<ApiConfig Name="Asana" Version="1"
Slug="asana-connector"
Id="871E4C4B-378F-4C3F-A999-12B603CFA164"
Ver="3"
EngineVersion="16"
Desc="Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more."
Logo="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAADICAYAAACtWK6eAAAABGdBTUEAALGeYUxB9wAAACBjSFJNAACHEAAAjBIAAP1NAACBPgAAWesAARIPAAA85gAAGc66ySIyAAABIWlDQ1BJQ0MgUHJvZmlsZQAAKM9jYGAycHRxcmUSYGDIzSspCnJ3UoiIjFJgP8/AxsDMAAaJycUFjgEBPiB2Xn5eKgMG+HaNgRFEX9YFmcVAGuBKLigqAdJ/gNgoJbU4mYGB0QDIzi4vKQCKM84BskWSssHsDSB2UUiQM5B9BMjmS4ewr4DYSRD2ExC7COgJIPsLSH06mM3EATYHwpYBsUtSK0D2MjjnF1QWZaZnlCgYWlpaKjim5CelKgRXFpek5hYreOYl5xcV5BcllqSmANVC3AcGghCFoBDTAGq00GSgMgDFA4T1ORAcvoxiZxBiCJBcWlQGZTIyGRPmI8yYI8HA4L+UgYHlD0LMpJeBYYEOAwP/VISYmiEDg4A+A8O+OQDAxk/9b5LlBAAAAAlwSFlzAAALEwAACxMBAJqcGAAAODBJREFUeF7tnQm0XVWVrgUbLESxQwuxowBFsAFEQDqRXsUOJH1oAzeE9AmQhoSQQCANnUE6FVQK5NUrrWevpdg8Lbsqm6eWlq8GlJYoJViCHbBvk1v/v/aa68y19lr77HPuPTfJzZpj/COQu89u5prf/ufc5+acJ+XIkSNHjhw5cuTIkSNHjhw5cuTIkSNHjhw5cuTIkSNHjhw5cmyZKE6f/ZRi4twXQ2+EJhUT5yyG1kO3QX8L3QPdDd0B3YBtVuLPGfjzROiVxYQ5z7S7ypFj249i0tynQK+FLoDugn4MPQoNd6EnoF9C/withk6AnmsPlSPHthHFpL4diknzDoXWQz+CBiEUuGj+CKT3Y/Qg9HfQJCjDkmPrDRTo81DEs6Dv+kUtWjDKqhzjN9D7oAPtKeXIseUDxbo7tAZCgcYKeWGPVTkmHGvBJ6Gj7SnmyDH2gQLcBQW6HH8+XC1aalEDLW6g2Otiip3Dwv8DHWBPOUeOsQkU3anQz8sijBWrLe7JMV00QgX7awvTwn7oGmhXe/o5cvQmUHAvhO5qFZ8tTFewsYKmLu6BYseh1Pn44Pw7dLK9lBw5RjdQcCdCv2wVYFiYsSK+ZAwUOy4Vnp+c9+L1xZSFT7GXlSPHyAMFtgTa3Cq2sBhjhbukjZZ2qNg+tGLnEJ6nA+bL0B728nLk6C5QRE9FYd3uF1lYhGGhxopbtGyUFNs3FZ4LFZ6vu5b/gF5vLzVHjs4CxbML9Fm/uMLiCwtUFfEUreU9kjqGPnblvPQ56+u55FHoeHvJOXI0CxTNs6CvlEXUBoZaCC5tqBURxbZLKXZse15RaDxgHoPeai89R476QNHsDN1bFo8uKltwURhiRRsretHKLhTbj1bsHMLzFFgofW1LAMmS7CQ56qN45/wdUDAfc0A4KHSRhUUYFmqsuKnLRlGx/VPhuVD6XPV1UB4sj0AH2VTkyFENFMt1VZfQBRYWX1igsWJeVdXULlXZV+x4VHhe+pz19QSwTFl2P/Qim44cOVqBIjm3VSy6iHRx6aILi9IWrVfUl7fR6gaKvS6UPV4tPPrc9TXpazXXf28xZWl+nyRHK1AcB0B/aRVKOyBsESZBiBW6aM0IFNufKDwHyp5fLTBRWK62qcmxvQeKYSfon+uhsEUWBSIs1FhhU1eMsmLHCM+F0udqz78CjL5mB8tJNkU5tudAMaz2C0RB0RaIsEBjhXxlDxU7HhWelz5nfS0CCxXCsuLn0LNsmnJsj4FCeB30RD0Uurh00YVFGSvgtS1NC3VVB4q8Xu87emx9bvq8qTpYJBcGlg02VTm2x0ARfNYHow4KXXCULkZbqK6AY0VOXT0Kiu2XUsePgqPPvTEsvHm81qYrx/YUKIJTOoNCF5sqxkqhxoqaWjfKih0jPBd7jrXA1MFibhwfsynLsb1EMXX5DiiAb/pg1EFhC6wCRFigsUJe32PFjqnPSZ+vvYbOYTnCpi7H9hBYeLiHhoKKQCEFFQUiLMpY8W5IaGMXiu1HFB43PDd93gEwbWExoPyDTV2O7SGw8F8YORS6IMOCVYU9XeuaUVCwzyRA+vwofe5NYPFAGYBeZ9OXYzwHFv1AaDAORh0Uuth0IdoCdUUbK+pre6DYcew5RKHR598VLDfYFOYYz4EFv6Y9GHVQ2OKLAhEW8XUJBdudkZC3XWw/VLidPh/KnmcSmDpYPFAeACTPtmnMMR4Di/wMLPh9XUHRFohI0bpix7ZaZ1LYV0cK9mFk9185vjoHI2zrhH21hSUJyntsKnOMx8BCH9cejDoodNGpYgxBqACA/Z0VCsfqSOq13J+ROkZbaOTvsE33sNxtU5ljPAYW+NrmYEgRJYrNAwLbV0BgUVudjeN4wvE7VrgPSB8jBo6GxrsG+X9enwjbe7Bgn1VQfo0c5jZrPAbcY0cs8Pd9MKQYUBjtnKIWCFukXgGjoM4R4e7rCe3KuR2qsg+K4IjkuPZcPGjs+TaCBdvVg/Jmm9Ic4ymwuHtBjzUDIwUFXhMFIgKCV+AYcqkZoiu6kH2t7MtIHaMOmm5hiYOy0qY0x3gKLO67m4GBPwUMKaYKFAEQURB0ca8Z7j9Pa3UXar2+oLBP/xgBNBVgNCyQgwXX6WBJgGJcRXK3/jM2pTnGU2Bx18TBUEVhoKDaQaGA8GAoi9eD4Hzq8kCrSvU1kGxb2QcUAFSC0wQYDQtBsbC0A6V0lPuhnW1ac4yXABgfj4KRcosQCik0D4oQBl3Aqsj7LmtpJrWyC6l9ONn9ewA1AEZgcc5ibwQGFg2K5En+m7nb+Bi095NyjJ8opm/YEYv7gzQYhCIEwxZRCIUBwkJRB4NX3CuG+y/QurRL2ddzf0bqGHJcB409N4G3AosF3lwnQbGwNAPlWKQ1x3gJLOqzoV+7RfbAsHdPFkfoFnVQaCA8V7BFrAt71vJAy1q6sEZ6u8o+1P49cCLAOIeJwJJylSgo9uYy/dozmdcc4ySwqC/Dov4p6RgeGBYKKA6FLbwUEK6AbZEbLfU1e0nnupDS+7H7DuHR0DhgIrAIKA4WAcXCUg/KUuY1xzgJLOxroAGzyG3BCN2CUFgwBIpaIGIQXFJqjujiLmX342T3H4KjoamFxYLvuUoNKK1hfqNJbI7xEVjUwzwwZMaogEEoLBhtoUgBQQAoXdgXDffP1VrcpdQ+vP2noGkDC68v5ioeKMiTBwoh2XCbSWyO8REA4+juwCAUFowKFAkgQgjmUYsCLSw1v6Fke28fAg0VgSbmMFFYlKu0BcW5yYdNYnOMjwAYx3jtlB2+TSuVBCN0C1tkFShCIBQErsgXtLSAmt+d9H48eEJoAmDqnMUDxbqKAsXNKHqYP/vqO01ic4yPwKIeqV3DmzFiYMhdVtyiDooKELaAPRDmDfcv1Jrbpezrub8oOAJNBJgQFgG+KSh8E9SAwjyu/ZBJbI7xEQDjYCzu5lY71SkYtrhCKKQgDRAxGGxhL5oTaHZLi9tIb6v3EYKjodHAiMMYUDQsBEXBEgOF+TEzCvJlHhG7tusmk9gc4yMAxr5Y3MJrp8x7FwKGhSMGhoECcrNEBAoNhC5iB8CFwwNaF83qXIup8vXcnw9QCI0GRsNiwa5zlXaglPPJ2jKzOcZFYFF3x+L+3nMNLr64RhKM0C1CKGxBBkBUQbig1MWimV3K7sdI9l2C46CpAKNgEWfxXKUBKLyRuLaLbnL5PJPYHOMjsKA7Y3Hvq7ZTnYJBKCwYCgjnEBoID4S+4YFLtM73tSSicBsjtY8oOBqYFCwWcO0qldbLQmKG+aib5H96O94Ci/v1qmsoMMzgnQDDgwKqQBEAEYJgiv48pRnDA0s7ELc30vsQaCgCo6CpgyXqKh2AUrrJITatOcZLYHFvr7iGPJViUciMkQSDUNj2qQKFAsKDQRX50nNLLaPO6U6yDyO7Xw2NwGKAqcLSasMEFKgdKF7bZSD5PW40u9u05hgvATDmVVxDt1O1YIRuYYuvAkUIgy7ws4cHlovO6lL29dyX228CGM9deL4ExcJSAcVCIqC4GSXiJrOW/RAu8mSb1hzjJbC4R1VdA0VgnkpZMMyMkQBD3KIOigoMqrgvPVPpjFIrGki2NVL7qEBjjy1wVmCJuEoKlHo3ye+ij8fA4j4Pi/zbRq6hW6kKGLboQiikUD0YbJEbTW9p5bTupPfh4IkAIw5TgUVAsbBoUCozinYTBcmcS86zKc0x3gKL/LnWrBFxjcqMEYIRukUKCiliXeBTS11GTelSdh9GITQaGA2LBbgCChSAYmYUB0rUTfqRw/1tOnOMt8Aiz6u4xiLCYdupWjAIhQUjhEI7hAZCw7BqstIkX5cnFG4nr7+MCqHRwChYxFk8VwkdBddrZpRI2+WGeAPJD+Aief4YrwEw9u1fsKBIuoZrpwiGhYPFFAWDUFgwaoFAYZuCn6g0YXhgdYfia/Q+KtDY40ZhsSCnQOH1Ciihm/gtV34HfbwHFvtrLThqXEO3UhUwWHi2CA0YGooACFfkp5daQ72nC9nXOwXQVGAhKBaWdqDQIQUU03ZF3WQzbixvsGnMMV4Di30+74xx12Db0QYMuTuLW1SgUEAoGAbXnDY8eIXo1KquDFTZxr4W+/HA8YAJYJFWLAoKrsvNKO3cxEDybZvCHOM5sNi7AY7flnBEXMO0UykwCEUIRghFCIQt8CvfrfSuUmtDvTPyd5Bs717vg5OGhaAILAlQeJ0Citd2VVquPpvCHOM9sOjXOTjMrJFwDT1jxMAInMKDQsNgCp3Fb3XVO2r09sjfQfr1Dhp7jCQsMVcJQNHDvGm7AjcpW65fA5Ln2vTlGO8BOPYBHH9xrqHhiLpGCgzrFlEoQhhY+NDV1CldyL5WAyTH0MAILNKKxUDRrVedm7RarlU2dTm2l8Di3xxtqTzXQBGxmAQM00oJGKFbEAoLhobCFfjbhgfXid7a0nqtt/j/r7dzr4U0NBVgLCgOlhgo7dxEQzLjt8jVC23acmwvgcXfE0XwB7+liriGDN8sLmmlNBh1UGgYHADUycODG0KdpBT8jNu711qINDQhLA4UC0sKFK/tspBoNykhWWJTlmN7C8CxsoRDu4bAocCwrpEGg1BYMAQKDYQrdgvAxhMjOiFQ+PMAIA2NwEKX4jl4oEAaFN16Jd3EQfJvcNdn2HTl2N4CRfAMwPGvXksVzhoEw7RTFgyZL1JuYYpWAcHCdkWOwr+GOt7XtaLjrNTPnOxrNTwGFgGGxyUoAou4inaUNm7C6zfvnzhI3mVTlWN7jYGV00+otlTtXCMAQ9yiAkUAhAPg2FLXab1ZKfiZ2V5eC2loPFgIioVFg1JpvbSbhJAgByUk+aN9cpQBOK4p4QhbqohrVFopDUYAhQZCQ3D9MRG9KVDw8xAggaYCC0GB2oEScxOBZNXkXyAnL7DpybG9BwpiJxTHt8qW6nS/pQpdoxYMW6wOihAIFP4NoqMDHTU8+F6IfxqFPxdwKA2MBcXBokGxkJjWy0Ki2y43m3iQbIaLnmBTkyNHGYBjH8DxkA+HdQ0Nh2mnImDIDCFO4UFhi5wAOB1ZalOpoU1HeJK/d9vJ6yrAKFg8V7Gg8DwFlNBNeH2u5XKQXGJTkiOHHyiSEwHHQLWlQlHFXEO3Uh4YIRRlkXsQ3Hh4oDcGUj/bRClwBBjnNBYUgUWDIkM9z9m0XQEkxk0EklNvt6nIkSMegOOsFhxhSxW6RgoMe7fXUGgI3kcdFujQQMHPQ3AEGAdLCpQaN/Eh+SwgeapNQ44c6UDBzEm2VCw2005FwBC3kJZJoNBA3ITiNzqkpZvfEJH6uVEAjsBi3SUKCs9PZhTPTSqQfBXXvIu9/Bw52gfgmGvg8FqqiGuwGAWOChgsZgUEi94BcPDw0C1arw+kfsZt5XUeMNw/QRFYAlD0jCKQODdxkNyLFvJZ9rJz5GgeKKKzAMdApaWKuEYFjAoUUvAWgFsPUjowIv1zSIPjwRK4inaU0E2qLdfHAUn+Succ3QcK6STA8XAJR7WlijuGQAEJFK7YUfy3UQcovW546P1K/H/v55QCR2ARZ6k4SsJNvJbrhBtwXTvYy8yRo/tAQb0CxfWdVksVuIbMGA4M5RYOClvoDoTXlvoA9ZqI7M/MdiE4ISwRUDw38SB5DJDkj+7JMboBOJ4OOK73WyoBQ7mGBkOcQkPhAHj18NAHRftHpH6uoRFgBDgNinYUgcS5iYHke4DkIHtJOXKMfgCOk1BwP/PgcK4ROEYIhYbh9v2UXhWR/rmChmA5WLSjRNxEnnrdeHiBc75y4L1HPt1eRo4cvQvAsQsK73IU4R+rrsGC1WBYF3BQoPjvoPZt6UOvjEj9nNtraBws2L/nKIGblC3XF9ACZtfIMfYBOPYCHO9HUT7uuYbMFSxi3v1Z1AIFC98A8IrhoQ+L9onI/ozbCTQhLClQSki+g/N7pz3VHDm2XACOfVGYm1CkDzswxDEcGBoKAPCRvY02G+0VUflzIw2NdhcNinGr124GJPfCSd6Fc9nRnl6OHFtHoEhfCDguhGv8E4q33wfDFrkAcSf1N1Z7Dm/+20DuZ1QJTQsWDYqB5BeA5L04fv5gtxzbRgCOV6OIF6OYv4iiftg4hUDhQHj58Oa7qJdFhL/nz40IjIWmBOUJ7PNHAG8TIDkZx3qmPWyOHNteoKhfgOI+FoW+GAV/J4r/24Dgl5vvfukfoIHNd79kuKqXDkGPbb7rpb/Ftj/G6z6F16/DfiYAtFcM3bnnU+zuc+QYfwEIngm9ePNHX/LqzR998WHQm6HjoeOgo6AD8fO9oOdt/ugeGYYcOXLkyJEjR44cOXLkyJEjR44cOXLkyJEjR44cOXLkyIHoX7Dgqf0L5z2/f9GcvQYWX3jgwEUXHDlwSd+xA0vOO25g6bnHDCw759CB5WftN7DijD0GVk7LH9O/FcTAyqlPG1gx/fkDl56598Dysw/CGh01sGTGcQOXnH/8wMUzjxm4aNah/Ytn79e/cO6L+hfMz2vWNPpnLXtq/+wlr+qfc/Hk/rmLN/TPW/gZJPAnAOS3AOQxADJkvlDSfK8gvzpNvjbtrH4A8igA+Y+By6Z8Y2DVpDsGLp8wf2DN6UcNXnHa8+zuc/QgBq84daeBNaftP7D69GkDl0/kB4B/buCyqT8FIA8BkMcByObyS3hm2O875JeCmm/N7e9fNPeR/gXz7u+fv+Ab/fMW3d4/96J5/XMuObL/wqX5uxAl+vsu27V/5opT+mddenP/hcv+FYAUAGQYgAwDkPLL6xfOM9/TXX5tcwiI/XYofpeF+34P+/UF5VcX/Nfgle/+7ODad84ZvOrtr7SHzTGCGLz6lOcMXvWOdw6ufddtg1ee+rPBNaf1tz4ZfnL51Qnm69z0t1RVACm/e30B1nb+Aqz1Iqz5RcMAZBiAPNg/a/mn+y+49ML+mSv3sYfdvqL/vDWH959/+S0A5FcAZBiAIDHLhgEIkhQCUn7pf5eAqA+hfvsTg+ve9uXB9W85d3DDSdlZOozB9ScfPbjurR8AIL+xH1Va5pbfMTK6gKAelg8DkGEA8nh/36ov9Z+3+qxixhXPsacyPqM4e91Ti3OumljMuPLrAGQYgAwDECRhzACxHyVqPmP3N4MbT1w/eM3xe5ZnlyMWg9ceu9PgNSdMQ66+ZT6J0X1U6ZgBghpZNQxAhgHIA8W5a9eihl5mT2/8RHHW+kkA5Ie4uOHi3CtxwQEgTEYSkBG1WClA5KNE/zh43bE3DF5/zIvLM83BGLzhqB0Hr3vz9MFrj/uJ91GlFUDst1SNDSConbXDxTlXP4pauqY4c8OL7Oluu1Gcce3hxZkbv1actWEYF4WLG21AkPwkIKfXAILFls/aLT9K9L8Hbzj64sH3HrlTeebbbwCONw1e/6Zvmk9hLD+BEbnCDYUf4B0CcsWp5kbkASLfvW4AwQ2Ma7QkAgg7gxCQ2RFAzq8AMowb7jAAeag445qFxbQbtr1PpC+mX/PMYvq110NDxZnX4IJ8QAoPECQhCQiSlwQESU8CgsWKAcLv+ZAPpBZA+Hm15hMTzUeJfn9o0xFHlVexfcXmGw9/9uCmI28ynxopH1PqAaI/DT4EBDekJCC4kSUBwQ0wCQhunPWADAOQ4WL6dd9FnR1mL2Prj2L6xiMByE9x0jh5qBYQXLwAMisEBElj8kJALiYgSLYGhF/j7ADBInGxcFerAoLFjQHCYrgBRVF+1u7Q0I1vXDN08yFPtpc07mPofW88dujGw//dfDmP+YhS+bBrCwhbUgMIbjACCL9kyAMENyZ+AWgICJ2eN7QkILgRJgHBDTQJyEYAwhq7jnU2gJpbUUxat3V/1nAxbcOCYtpGnmwJB0+elIeAzCAgq2sAQbICQPodIEhyDBAuCvtfDQi/Ts0AgsXkonJxeRd0gGDxWQQsBt41S0DkI0XvHbrpkJfYSxu3MXTToUsByBA/x9d82LUDxH4SPD/Z3gMENxrecEJA6Ny8QfFGFQUENzYBZFEICG6IcyKA9BEQ3Eg1IGdHAYHw/9M2fL6Ytn738sq2oiimXf20Ytq623FyOEmcaC0guEhcLC+6AgiTw0FNA8I+1QAy2yTXJJl3Iw8QLAYXhXcvBUg5qGOQDAHhYrNtCAFhcfA7PswHUvNjRQ/5z6Gb33C4vcxxFUO3vP6v4JJ3mY9ONR90rT/k2gJCh5UBXQChExtAcOOBQ8cBwQ2La8KHKB4guMHhRlcBhB0Db4xJQNagZnBjTQLCejOAQOvvRy1uPR9/VEy76jkA5Is4KZ5cHBD2iwYQXFwSECSFyWGSPEA4qCOZISDsa9nf8i6lAaHN0+7NN9ZaQHi3M4DoQR2A8O7Iu6R854eZQ/jB1PYT28vP3f3L0C0Hn2ovd1wE4Nht6OaD/2/5+b32Q64dIHr+0IDI/BEA4gb0ABDeuHgD04CwAzCA4IbHzoBry1nTAYIOgrMoa4EPb/oCQHiDbQ8ItO6PqMlTyqvdglFMXfsCAPJdnAxPyp4cTrICCE6eFxUCwv6SfSbvFhVAkDTeXQQQ3HVagMigHgKiBnUPEDWHxJ5kuUE9bLMICIroloM3o6jOtJe9TcfQrQftgWv5oflMYQcI2is3f2hAcANJPcFiTmOPeLkGbHkdILiRsSXm7FgBhAN6BBDeMHnj7CsB4cxqWnMDCOqMHQlrytQYhRrjjdkBwnq8aqCYtnZSedVbIIqpVzy/mHrlv+Ak7AlpQOTkCQj+FEBIvwNEPckKAZFBPQSEcwhtWgOSfC+kZlCvm0P4FMdvs8pPSy8/nPqM8uq3zRi69cDdcQ0/bn0CvG6vGs4f0QHdAuIN6AoQb0C3gFTeA7GAsNV2gOAGilmVM2sVELkJJwGB1g6hRifayx+7KKaueQYA+ToOzpOwJxQCwguIAMKLhF1W3gtJvpveGtSbPckK5xAAkppDuPgOkLDNsi4iX2/Aorr1oKGh2w58d5mFbSuG3n/AswHIdw3o8snv1j2q7VWT+SM2oGtA9PyhAUk84m30JqECpHzEC2lAWH+sQwvIVLxm6pX9qNW32DSMTQCQj+GgPDhOhICQVgWIN4cIIPh7N6jjdQ6QYFBv+yQrNqg3nEO4uJU5RLVZ14VtVsxFDvzz0G0HbDvP3RFDH9z/yQD7M+Wnviv34JxVeXrVrr1qOn9oQHBDo/MTkKZPsGof8cYAYd3FAGGdrnm0mLr6QJuO3gYOdDVkD4xC50kYQMRFQkDsHBICwjYr9qiXSao8ybJtVmVQbzOHpN5Rr22ztIsAkKqL8Hs4fjF02+u2mV91ANDXm69nMO5BOBLuIe2VcY+wvVLzh3OPYP5YEZs/LCCxAd17gsX5wwJSGdAtINEBnX/SPWKAsD4NINDq/19MvXy3MiM9imLqqtNxEB7MHjQGCE8yAkjqSVZqUOddJTaoR+eQsM0iIHSRujZLuwiKgUXh2qx2LmK+KOcLQ3fsvdV/CSbOc3rri3XoHoRDZg/tHtJeiXtIe0X3QK5S7ZV5gzDSXtXNHwTEtVcakOqA3sUTLIi1SPfwAIEu/0SZlR5EMeWylxdTVj3sA8KDxwDByXY6qJs5hIA0nUOQ9MocotosA0jYZmkXISBNXMS9cWghQZGVrRYhWVFmZ+sMnN8rAccj1daqE/fQ7RVuMO3aK65Bpb1qOn9oQHDjHNmAjtoMAVk1jBpebNMzugFAPg3hICEgOIlRGdTbzCGpNwwrbZZ2EbZZpYu02qw2LhL86knriZa0WoCExVZC0o8iPLTM0NYXOLcvlXCErRXdI3xylXAPbzjX7RXdQ7dXdI927VXT+QO1UJk/LCDR+UMAEffAtuWAbmuU9cq6JSCXPV5MWXmATdHoRDFlxdnYKXdeHiQKCKlVgFQGdfx3bA5hm+XNIarNcoB02GaxF/aeZkWG9VoXkVaLLhK2WsE8cuuB3xp6/2u2uk9fh3PMasGBczVw1LVW4h6Eo417YK4z853nHkF7taSmvUq9/9F4/ggBYb2x7kJAWJ/iHgBkigEEWvnVYsqC0WmPiymX7gZAHvABERexgIzGHNIXziFhm0VAIm1W7dMscREC0sRFCAldRFotFE+01QohOWhOma2tIwDti3BOD1XgoAsCdPOmYNhaOfdAHqKzh3aPYDgnIM49umivuNaV9go1RkBce6UBsTVl6kvcIwRE3CMGyAro0hk2XSML7GgDhB1aQHiQSpsVAwQn3XYOSbRZ3hwStFlMstdmaRfB4njDespF9CxCSFAMfJxpIAlarSQknEcsJLe8/kEU5AvKjG35wLnc6MFh5o4SjtbcEbZW4h6Eg+4BOBq5h7RXdA/dXtE9dHtF92jYXhEQ114JIKirtvMHa491SPeIAWLcAzKA/LKYsnxk/4y3mLJsL+zkTyUg3Cl3HgMEJ1M7h9gLMoDg7702i4C0a7OQTK/NqnvTsMZFOItUfsMXkDgXSbVahARFVeckt7x+rU3bFg2cx37Q462ZIwVHk9ZK3INwJGYPGc4r7qHbK7iHtFepp1eV9koAQV3Vvv9BQAQOcY8QENara69sLbOml19aZq3LKCYv24Sd2J0JINJmxQARF7GAdNRmWRdJtlnWRWyblRzWxUXcsN7ORcJWqxtI6CYH/w6gbPH3RnAeH+gcjqC1Mu4BOJx7IF/u964aukftcK7aK+Meifaq9vEu/yQcrLMYIKF7aEAMHNCyB4vJS59vU9dZ4IUvhh7BTuwOQ0DERSwgyTZLA4I/dZt1DgGpeZp1IQFpM6xzEUyblXIRQiIuQkiwyNGBXVqt1DwSg8QO7izEsuXaoo99cfy9oD+XLRXOixDXwcHft/KeWtW1Vgn3iM4e2j3qhvNIe5V6ehVrr6KAEA7tHhoQzz2GYQDQ0kU2fZ1FMXnJMrwYOyIg4iIWkGSbFQNEu4gAgr/32qzwaZZ2ESTRG9a1ixCQGhcxT7Sk1aKLABLjIrGBnZCgOLx5JAWJnklQgC03uR9usotN4ZgHIF3jwcGnVW4gV3B4Q3kKjrC1ksFc3IOtlbgH8t3IPaS9su4h7ZVxD91e0T0EENRTbXtFQAQO1l8MEO0eFUB+Vky+5OllBhtGMfninQDITw0g3Em0zYoBgpNr2mbxor02K3jT0BvWtYsgyTEXSc4i0mrRRQiJbrVS80gKEttusdAMJHwETFAUJO877PQyi2MbAOMZOPZ9vmtoOHDezjlicIRzB3JCl61trcQ9CEcD92AHEHUP3V7RPVBT3nBOQFBHjZ5eCSACB+s0BoiBA1oCXdLZvx0BIMfjRfbFdJEYIJ20WYREABEXwc86GdaTLpJ6okVI6CKxgT1stWLzSA0kxk1akARu0rtfZ6gJHPft4hpeS0XH03DwOtrBEW2tkLdwMHfugXzzxmTgaOIeBESG89A9CIhyD2mvku6hARE4tHtIe0VAlHv4gNxTZrFhAJBbfUA6abMISQwQcRGIF+vaLGwbG9ZrXUTPIpH3RZZgsZKtlkCCRe8YEhQWIWGhVVouFKRxkyMeRZGO+eds4bgfqbqGwCGu0QYO01rVzR1hayXuwdaK7gE4nHuoJ1e1s4d2D9QT2yvnHqiNintoQDQc2j00ILXtFeGALn4YavaYvpi8eOdi8kX34QV4oQUk2WYRkhggoYtoQEIXwXbiIqbNaugiptWiiwAS5yJ1A7u0WoDEtFqAhIsPSMyj3xQklcEdBZZquVqOMqb/sGpw0xG74pi/irqGhsN7WtUEjnDuCFsr5LbSWol7EA5xD6xXx+5BQFA/jYdzASTlHsn2CmKtX/SeMpttAoAcjo3tizpps3hSpDcGSMRFKr96gtelXMT9flbMRWIDe12rFZtHNCQoEgeJnUkcJCgsQuLeTAzcpAXK3WU2xyYGbzjq2FownGtoOHBdUThSQ3kAh26t9GBO93CtFdbGtFYduEf00S7rJtZeKThq26vAPSqAsN4v+oBNZ30UkxYvASR4QQhI6CLt2iyBxAISHdbxd21dBJA4FyEk4iJ1A7u0Wt1Cop0EBWTcREGScpMWKPehWHe2Ke154HiXt8CA3CAurmHh4Pm79zksHLzOWudAjqJzR5PWKnQPwME1dO97NHEP1o2tmbbuIYBYOJq1VxABWfzTYsKip5UZrYli0qJPloBoF+HO6tosnowCpK2L2LuBAQR/39RFXKuFZNcO7KrVajuP1EGCwiEkLCRpucxcIm6SBGUQel2Z0d4HjvXF0jHauYaGg64BOOiYHcHB1opwhK0V8l5pregeYWsl7oF1de6Bgk7OHqpePPcQQFhnGo7QPQSQlHtYQCYtfgK1v69NaTyKSQt2xkb3YePyRUkXUYC0dREFSFMXqTzREheRVosu0kmrxXkEC8o7XztIWCAoFA8SFpJxEwuJuIke4E3bpUC59rjpNq09DUCxK471QC0YoWtoOHidMTiYEwcHW6s6OGTuaNJaiXsQjl64hwDSzj10e4V6n7QIWlg/h2CDfaDHzcaxNquTYb2rWQTbOhfR74sQErpIbGAPWy15qhWDhK0WILk0BQkKw3u6Zd8n0XOJdpNY29VylI1lVnsbOM6rcbwBr5VyYFjX4BugAgevQ80b5n0OAweuO+ocMTiQSwMHWys7dzRprcxgLu5BOHADNHB06x6srRgcoXtoQKLuIYCstmmNBxzkRGxkN065SASQEbkIIcHfGRchJNjeuIi0WkhiX4NWy0CCxYnOI+0g0TMJIaGbKEiibhIBxTiKg+VTZVZ7GzjOO5JgpFzDwmHA4G/nenAgD+3gkKG8ERxhayXuwdaK7oF6ce6BgnfuoW6iHbsHAYnAkWyvDBzQgr+zaY0HNjgfshu3a7NCF4kA0shFpNXC3xMS5yJ4fXJgl1YLkJhWC5CYVsvOI7VDu4LEa7cICQqDkLBQpOViARlQLCQVN4mBAm04+Yco3J5/ADaOM8+AaY5LKBJgaNfQLZWDA9dNOOioBo7YzKHhYGtFOFJzRyetFdbatVaoAeMetja6cY/a9iqAo9VeEZBvl1lNRDFp/uoWINJmhZDUtVl1LsILsoAkXQQ/cy5CSNq1Wu3mkaaQoBA0JMZNFCQxN/FACR3FwPIAinbXMrO9C0Cx0YMiBUada2g4mIcRwYE1MHBgTQwc0lph3aS1ksE82lqhBsLWqmP3ICBN3UMAYd3Pv7+YNC/99BE/vAUb2Y3r2qxeuQghwc+ZrEqrJZDEWq1uIcHCu6dbhASFQUj0XNIUFAeLBeXqUx5F779HmdneBY7zkfJ4hCINRmvWCOCozBsCB/JSAwdz2oIDuRY46ObJuaNJa4UaSLqHgqMr9yAgSfeA5j8MBtLvqOOH97QASbkID5IApO0skoLEJoOQVAZ2vF63Wn11kHAeISScR+ogUTMJCyCEJOUmboBPgeK5yhMo2FeUme1d4BifaEGhwWArVQNGpaWycDAPHhzIE28qFTjUEyv5RcS2c0fYWhEO1IXXWql68ODopXuw1ln38/4EvbzMbCSKSXM/gQ3sxhaQjl1EIGngIl21WpF5hDbeFSR0E4HEtlzh8B5zkyQoHiyDKNjX2tT2LHCMfyyhsGDwPHg+MTDcLxzierRreC2VwEHX0HAgb5W2aiRwoC6irRVrwcKRaq1S7pF8cqUBSboHNO8JMJC+qeGHn2kBMtYuIpDgv12r1QEkMrTXQeIGd/0IWFouBUmtm4SgCCwAxbzJ6GAZQsH2/OMucYx7SyhKMAwUSTASrhG2VBoO5qkrOLAmBg6sUR/hsHOHaa1QDx21VgEgFfdgvSXgaOQerHXW/dz+YuLcV5WZjUQxcc6nsJHdWAHStYt0AwlkIMHft51HCAlbrRASLFYjSOgmgETPJRU3aQIK5EApYRlYc9ogCrbn76YDyi9VobBguFaqDoywpSIc4hpsqQQOeZSrZo4KHMh9CIcbyukehIPuQTiwpl5r1S0cTd1DwRF3j2HAUYCB9Lvp+OHfY6Ny47YuIpB04CJdt1rYnkntCBLtJFhIgYQLzP5ZIKlrufRsIm1XFJQoLP3QfmVmexc4xmfK41koPDBwfiEYup1KuYaGg67hwYE8toPDPbFia9UEDq69gqPT1mrE7sFaR91PnPMYtJdNbTWKibPvwAblxg6SNi6SarVG5CI1kNCe+asoBhIkv69DSHj3M5Bgwc1cEkCScpMUKDKjOFhYnAaWP0PpgW+UAse4p2yhBAoBg1BEwKAr8lrcrCGuQTgsGLalcsO4gYMtlYXDe1rVCRxYu+TcQUD439CouEcCjrR7EJBHwED6gzfww40GkI5dpFeQ4L8NJPi5gQSvEUg4j7SDpDK4Y2Fdy2UhqbRc2k3agWJhMaBUYHkI6u4TMzoIHON97pgVKCCvlQrASLmGaanUvOHBQdfQcAQzRwUOrH0MDjN3YH2btlYp92g0mNe5B+vcwAHNfqCYeGH6vSv8cCE2Kjf2XIQ76sJFumq1RhES7+kWFpR3PfdrKYREu0nQcunZJAlKLSw/R8HuVGa2d4HjLK9AYdxCg0Eo2oChXSOcNwwc0lIJHMhrN3CY1opwYE1DOHrdWtW7BwH5UTFxVvpjZAHIaQ6QlIv0emAP5xH+OSJIsIAakrqWS7tJrO0KQTEzisBCUDxYvlpmtbeB40yLQyFg8DwJhQJDD+EpMLRraDiYRw8O5Jn5NgN5DRztnlgl4YC6HsxD94jA0XIP6MLP2bTGA/QchI02p11kjFqtJCT4WS0kWJg+gQQLxsXj3c1AggWtPOFKuUkdKBYWB0oMFgPMB8us9jZwnMPjUGi3iDkG5LVTMdewLVU4bxg4kFcPDuQ9BgfXqAIH1zYFRwDIqMHR1j0IyCab1ngUEy94PiB5qGsX6ajVGiNInJtYSCotF0GxkHhukgDFtF4pV1GwLDt7QZnV3gaAeBGO9YgPhYBhz6/SSinX0GCkXMPBYV0jhKNPw4H1rXWOGBwakAZwjFZr5bsHNKuvzGpNYKNvlhu3gaRTF2k0jwSQVOaRNpC4p1uEBAtGSLiATVuuKCgooCgoUOgqGpal577ZprSnATh2xLG+Vx43BoUGg+dfA4Z+40+7RjhvGDjoGmypAId5E7AbOKAUHLVzx2i7h4GDemOZ1ZqAi9xQbqwg6XWrVRnau4SEC4MF8iDpEzexkOiWqyNQQkdJwFI6y++gF5YZ7X3gWLeVc4WFIuUWSTCsa5jHt6FrIEeha3hwEAzk28GBdeB6VAbybuEIAOlNawXNehC1/9wyozWBjU6tADLiVmuUIeGfBhL8vYMEr/MggZvwFxy94T3mJgDFvWeConBtVwQUz1UASgqWi/u+UmZzbAJATG0dW0HhwCAUXYBRcQ3bUoXzhoEDeddwcF1GBIcA0gCOkbdW0AWftemsD2y4B/TIiF2kdh5pCgmT1yEkruXCPgmJ13IRFAVJzE3MEJ8CBdLDfBqW5TadYxI43p447p8FiDgUGgxcTwoM3U6lXEPDwTzXwqHWqxEcAkgAR+O5oyv3gC5YWGazQWDjz0P2hSOApNE8EkASHdqbQIKfExIukIME+0u2XAk38dquGCgCC0GJwTJ7Mwr04DKTYxc47lfroYB4/mbGqAOjmWt484aBA3k3LRXWiu1vx3BAHcFhARl5awVdMFBMnPlqm8r2gY3PjwLSuNXqFBImow4SAYWJ1ZDYBdCQODexkOiWqxtQxFFkRjFvNAostvA0LAvn/qBYNLvn/9Q2jP5Fc+eloRAweP6EohMwYq5BOAQM5NmDg2BgPaLvc4wEjoh7pODorLWCZtb/U9swigkz0WbNRJvVgYvUziO9gkRAIST4k7+64A3veK3nJgoSPZu4tisFinYVghKDxQEzpu2VBCDdE8f+UxwK7RYNwEi0U1XXQG7NMI58e/PGaMIRcw/WUlM42rrHMOq980fyeNGdgKTcQVNIGs0jPYakruWyblKZTfoCUKKOIrCwuGKwQPMX/gXau8zg2AeO/feufdJQOLeAeA0GDFxXEzD4oEPASLqGhoNghHBwvWJwEIzRgsMC0llrBc38A2r9JWUGO4hiQt/ReKHdSQCIa7VGCRImIwUJE+ggEVA0JAKK3LUIioIk6SY1bZcBRVwFxSPDvINFuYqDxQDzv8rsbZnA8U+shcKBYaFIgtFyjfIJFdai4hqEQ4HRdt7oBRyBe6TgSLdWcI++O8rsdRF48VeSLpKcR5pCwovuFBIBRUMCeZDYhaq4CUGxkPCr30JQzCPhEBTIAwUSV3GwCDCmGI8sM7dlAnDsgHP4Vtk+xaDQbgFVZowWGNF2SrtGbUsVwsH1Gk04QvfoFA4LyISZQ6jx7h+o4MWnQNhZp5AIIB1CUtduJSERUASSYMEEEj2bxNqulKNQzlVsYQksvrM0e47e48B5vMedk4bCgWGh8MDA9YaOkWqnkq4hcBCMdnBwPbuBQ7uHgiM5lEPpuYPu8fEyayMI7OTLJSQEJAJJo6G9W0gEFA2JgCKQUBoSSiCxCxi6SSegmGHewiKFFYdli7qHBMDYAefzTy0gBArtFhoMukUKDMi1U8iZN2vY3DowIAeGhoPrFMLB9ewVHAqQ9NxBOAahkT+OLyacf5QBJDqP9BoS7SYCCeRBQmlIKIFEL6QFxTzpCkDR84kBhcLxHCjtYFlxV5mtrSNwPsdXnUJDAfG6DBQWjEorRUXAaOQaGg6uE+S1VKMNR8Q96uGgmn0fSJMAJB9IQ8KTICBNIOHFpSARUNpBQjHRAgmlIaEEEkogUQvr2i4o5igyozhXIShJWB6F/samaqsJnNNd5fmFUIRuUQNGtJ0SOJhXKOoaGg6CQQkcXMcQDq73KMJRP5RTD6OmR+9r8rCzv4Z+bXbedh4ZbUgEFIFEQBFIKA0JJZBQAgnVCSgU9hu6ShWWMfm19k4D5/US6CHnFA4KSKDwwOB1Q03BqHUNSuDgOlECB9cxhIPr3SkcAkgTOCwg5dwBnT/Tpmn0AjudAJUHaDS0dwOJgKIhgTxIBBSBBIq2XJQCxbkJFQOFCkGBBJQoLFd8afjcK3awKdrqAmCcWQ8FhWt0UFApMCjmLgUGxdwLGBTXh+tECRxcR8hrqWJwsC5GAkfgHi04Pm3TM/qBnd86epAIKO0gEVAEEgFFIKG4EFiQKCiyiFxQQkJxoSlZeAGFsqCYp14UXmtgwf58WH6Hottibwo2DZznR6JQeGDweqHGYFAxMCgBQ+DgOmk4CIaGg+s8mnCE7sEadXA8CL3Upmb0AzvfGfrn8mACSDtIeBGdQCKgCCQCikAioAgkAopdFAcJxYWTRWwKCuSBAgkovrOcZtOyVQfO81mA4kdVKChcm4FCctAUDIo5ZX4FDoIhcMiNS8DQcHAdNRxc5xAO1kMMDtZP13BQb7Np6V3gIPtA/9UZJCknEVA0JFBHkAgosihcIEIioMgickEpWWAuNha+DhT+dxyWlTYd20TgfPfHef+3g8J83A4VXKuDgsJ2jcAQOOwNyoEhcHCdoNqWCvLmjZ7AcbFNR+8DBzsGetyHhCfVK0gEFEmugGKT7yARUGSxmoJCoRiawXK7TcM2FQDjJJx7fwlFcF1GTcAQODQYAofcoAQMgYNgaDjkhqddQ8PBOhh1OG6yaRi7wEFPhfhmywghEVA0JAKKQCKgSHI1JAKKLIpAEoIii9otKKaoPl5M3TTmv8o+WoHzn1wPxUjBEDjsjcuBoeGQG57AYW+InmuEcLBeuobjo8WEs7bMgxQcfFJnkAgoGhKoAomAIpAIKJJcDYmAYhdl1ECpwPJJFFXPPwiu14HrOLMKRh0UKTAEDg2GwEEwBA6uk4bD3vBqWyrIG8a7gcMA8r+LCeelPwhuLAIn8W7osdGFREARSCAHiYASugnk3ERAkcWLgSKwhKDEYNl4T3HGxvZfMr+NBMCYhOsqeguGwBFzjU7gYJ10BceHAcfW4fY4maOhB5tBIqBoSAQUgURAEUgEFEIioEjSBRIBhZB0A0oMFlM419vLHFeB6zoBergKRTswBA4NBhQFQ+CQG5uAIXBwfTUcBCOEg3USwsF6qoVjnb3MrSdwUntD3/EhEVA0JFAFEgFFIBFQBBIBxSa3iZt4oMhiNgXFwII77LpZ9vLGZeD6XoXr/H5zKCJg1LZTAgfBEDjkhidgaDi4/iEcrBOIN9e2cPDB0fkz7OVtfQFL+yuc4E2dQyKgCCRQsuUSUAiJgCKL0Q4UgSUFioPl31AsR9jLGteB69wF+uDogSFwyA1MwBA45IYnYEC180YIB+so6hw/Qe0dYi9r6w6c6Gk44f8sIRFQNCQCikAioAgkAopAIqBIcgUSAUUWQ4Mii1YHShSWW6Fn20vZbgLXPBn6zcjBEDgIhsAhNzYBQ+AgGBoOrr+Gg2CEcLCOKnDciJvzM+2lbBsBSHbDid8MDVUhEVAEEgFFIBFQBBIBRZIrkChQKm1Xx6D8P+gke/rbZQCM3ZGDD7ZyMlIwBA65sQkYkANDw8H113CwPhJw8OY7oe970HH29LfNwAUcBn3eh0RAEUigdi1XrZsIKISkY1B+Dc2Hnm5PebsPgHEU8nGvD0U7MKBaMAQOgiFwxFwDqp03DBzoTvpm4yY8bp4sApSZJwKSL7iLjEESbbkCUJybxECRxakDRWC57JfQMhTA8+wp5ggCuXkrcnRv52AIHBoMqJFraDhYHxqOmfejji4uTu97jj3F8Re4yENxse+HHmpBokEhJAKKJE8gEVAIiYAii9AIlCHoG1jkc6D0V23l8AK5OgK6A7n7XTMwBA65kcXAEDjkhihgaDhYH7MGUStfg84sJvZtW3PGSAIX/AJoOhLwDxBg0ZBADhIBRZKq3KTSdkVBKbCQ3wcoa7CoB9nD5+gikL+/hs5GLj+FvP6uGRgCh9zgBAyBg2AIHFx/A0eBmvgXaBVqpOdfpb3VBxKxG5LyFmgtEvQl6FdIGJJESAQUSapAokDx265HoB9isT6EhZsB7VdMuGhHe6gcoxSA44XI7duQ53XQV5DzB6D+KhgCh9zgBAyBw9wQf481/wHW/w7oHNTDvsXEc7faf4i2xQNJehYS9iok7mRAch4SeRkS+l7oDiT4biT6o9CdSPytWICroQVYkNOxMIdigXYvJi/aZn+hcFsN5H1XaH+swVuwFn1Yk1VYn03Qh8r1mn8PhDWbhzWbdzXWdQHW93ToEKz17nCKfBPLkSNHjhw5cuTIkSNHjhw5cuTIkSNHjhw5cuTIkSNHjhw5cuTIse3Gk570PzW+/MRC6WZuAAAAAElFTkSuQmCC"
>
<VersionHistory>
<Change Ver="2" Date="2025-03-26" Type="New">Added new tables / endpoints: SubTasks, WorkspaceTasks, get_subtasks, get_workspace_tasks and search_tasks endpoints (Advanced Serverside Filter)</Change>
<Change Ver="2" Date="2025-03-26" Type="Fix">Enabled pagination for all endpoints to avoid error: The result is too large. You should use pagination</Change>
<Change Ver="2" Date="2025-03-26" Type="New">Added CreatedById and CreatedByName attributes</Change>
<Change Ver="2" Date="2025-03-26" Type="New">Made WorkspaceId and ProjectId required on connection setup UI</Change>
<Change Ver="2" Date="2024-11-29" Type="New">Added images in HTTP and OAuth authentication instructions</Change>
<Change Date="2024-02-23" Desc="Initial version" />
</VersionHistory>
<ServiceUrls>
<ServiceUrl Url="https://app.asana.com/api/1.0" />
<ServiceUrl Url="https://([\w\d\-.])+\.amazonaws.(com|cn|in)+--regex" Hidden="True"/>
</ServiceUrls>
<Auths>
<Auth Name="Token" Label="Personal Access Token" Type="Http" ConnStr="CredentialType=Token;" HelpLink="https://developers.asana.com/docs/personal-access-token" TestEndPoint="get_workspaces">
<Params>
<Param Name="Password" Required="True" Label="Enter Token (Personal Access Token - PAT)" Secret="True" />
<Param Name="WorkspaceId" Required="True" Template="T_WorkspaceIdParam" Label="Default Workspace" />
<Param Name="ProjectId" Required="True" Template="T_ProjectIdParam" Key="project" Label="Default Project" />
<Param Name="RetryMode" Hidden="True" Value="RetryWhenStatusCodeMatch" />
<Param Name="RetryStatusCodeList" Hidden="True" Value="429" HelpLink="https://developers.asana.com/docs/rate-limits"/>
<Param Name="RetryCountMax" Value="5" Hidden="True" />
<Param Name="RetryMultiplyWaitTime" Value="True" Hidden="True" />
</Params>
<Notes>
<![CDATA[Here is how to obtain a Personal Access Token (PAT) in Asana:
<ol>
<li>
Open <a target="_blank" href="https://app.asana.com/0/my-apps">My apps</a> in Asana portal
and click <strong>Create new token</strong> button:
<img src="https://cdn.zappysys.com/api/images/authentication/asana/PAT/create-personal-access-token-in-asana.png"
loading="lazy"
decoding="async"
class="img-thumbnail block"
alt="Create Personal Access Token in Asana"
title="Creating Personal Access Token in Asana"
width="900"
height="610" />
</li>
<li>
Once a popup opens, name your new token:
<img src="https://cdn.zappysys.com/api/images/authentication/asana/PAT/name-personal-access-token-in-asana.png"
loading="lazy"
decoding="async"
class="img-thumbnail block"
alt="Name Personal Access Token in Asana"
title="Naming Personal Access Token in Asana"
width="900"
height="570" />
</li>
<li>
Then click <strong>Copy</strong> button to copy the token:
<img src="https://cdn.zappysys.com/api/images/authentication/asana/PAT/use-personal-access-token-to-get-asana-data-via-rest-api.png"
loading="lazy"
decoding="async"
class="img-thumbnail block"
alt="Use Personal Access Token to get Asana data via REST API"
title="Using Personal Access Token to get Asana data via REST API"
width="900"
height="520" />
</li>
<li>
Now go to SSIS package or ODBC data source and use this token in <strong>Personal Access Token</strong> authentication configuration.
</li>
<li>
Choose <strong>Default Workspace</strong> and <strong>Default Project</strong> to work with.
</li>
<li>
Click <strong>Test Connection</strong> to confirm the connection is working.
</li>
<li>
Done! Now you are ready to use Asana Connector!
</li>
</ol>
]]>
</Notes>
</Auth>
<Auth Name="OAuth" Type="OAuth" Label="OAuth app" ConnStr="Provider=Custom;OAuthVersion=OAuth2;AuthorizeInFullBrowser=True;ScopeSeparator={space};AuthUrl=https://app.asana.com/-/oauth_authorize;TokenUrl=https://app.asana.com/-/oauth_token;" HelpLink="https://developers.asana.com/docs/oauth" TestEndPoint="get_workspaces">
<Params>
<Param Name="ClientId" Required="True"/>
<Param Name="ClientSecret" Label="Client Secret" Secret="True" Required="True" />
<Param Name="Scope" Label="Permissions" Key="Scope" Value="default" Options="default;openid;email;profile" MultiSelect="True" MultiSelectSeparator=" " Desc="To access Visists table you need add extra permissions and re-generate token."/>
<Param Name="ReturnUrl" Label="Redirect URL" Value="https://zappysys.com/oauth" Desc="This is the redirect URL you entered when you created app in the Portal. URL must match exactly including trailing slash" />
<Param Name="WorkspaceId" Required="True" Template="T_WorkspaceIdParam" Label="Default Workspace (** Select after Token is generated **)" />
<Param Name="ProjectId" Required="True" Template="T_ProjectIdParam" Key="project" Label="Default Project (** Select after Token is generated **)" />
<Param Name="RetryMode" Hidden="True" Value="RetryWhenStatusCodeMatch" />
<Param Name="RetryStatusCodeList" Hidden="True" Value="429" HelpLink="https://developers.asana.com/docs/rate-limits"/>
<Param Name="RetryCountMax" Value="5" Hidden="True" />
<Param Name="RetryMultiplyWaitTime" Value="True" Hidden="True" />
</Params>
<Notes>
<![CDATA[Here is how to register an OAuth app in Asana:
<ol>
<li>
Open <a target="_blank" href="https://app.asana.com/0/my-apps">My apps</a> in Asana portal
and click <strong>Create new app</strong> button:
<img src="https://cdn.zappysys.com/api/images/authentication/asana/oauth/create-new-oauth-app-in-asana.png"
loading="lazy"
decoding="async"
class="img-thumbnail block"
alt="Create new OAuth app in Asana"
title="Creating New OAuth app in Asana"
width="900"
height="580" />
</li>
<li>
Once a popup opens, name your app and check two options, and click <strong>Create app</strong> button:
<img src="https://cdn.zappysys.com/api/images/authentication/asana/oauth/name-oauth-app-in-asana.png"
loading="lazy"
decoding="async"
class="img-thumbnail block"
alt="Name OAuth app in Asana"
title="Naming OAuth app in Asana"
width="900"
height="580" />
</li>
<li>
Then copy <strong>Client ID</strong> and <strong>Client secret</strong> and save them in a file (we will need them for authentication):
<img src="https://cdn.zappysys.com/api/images/authentication/asana/oauth/use-oauth-app-to-get-asana-data-via-rest-api.png"
loading="lazy"
decoding="async"
class="img-thumbnail block"
alt="Use OAuth app to get Asana data via REST API"
title="Using OAuth App to Get Asana data via REST API"
width="1000"
height="640" />
</li>
<li>
Continue by selecting <strong>OAuth</strong> menu item on your left and click <strong>Add redirect URL</strong> button (you can have your own or use <code>https://zappysys.com/oauth</code>):
<img src="https://cdn.zappysys.com/api/images/authentication/asana/oauth/add-redirect-url-to-asana-oauth-app.png"
loading="lazy"
decoding="async"
class="img-thumbnail block"
alt="Add redirect URL to Asana OAuth app"
title="Adding Redirect URL to Asana OAuth app"
width="1000"
height="750" />
</li>
<li>
Proceed by clicking on the <strong>Manage distribution</strong> section on your left.
</li>
<li>
Then specify workspaces your app needs to access (use <strong>Any workspace</strong> to access them all):
<img src="https://cdn.zappysys.com/api/images/authentication/asana/oauth/choose-distribution-method-in-asana-oauth-app.png"
loading="lazy"
decoding="async"
class="img-thumbnail block"
alt="Choose distribution method in Asana OAuth app"
title="Choosing Distribution Method in Asana OAuth App"
width="1000"
height="680" />
</li>
<li>
Once you do that, click <strong>Save changes</strong> button.
</li>
<li>
Now go to SSIS package or ODBC data source and use
<strong>Client ID</strong>, <strong>Client Secret</strong>, and <strong>Redirect URL</strong> in <strong>OAuth app</strong> authentication configuration.
</li>
<li>
When you are done with that, click <strong>Generate Token</strong> button to generate Access and Refresh Tokens.
</li>
<li>
Choose <strong>Default Workspace</strong> and <strong>Default Project</strong> to work with.
</li>
<li>
Click <strong>Test Connection</strong> to confirm the connection is working.
</li>
<li>
Done! Now you are ready to use Asana Connector!
</li>
</ol>
]]>
</Notes>
</Auth>
</Auths>
<Template>
<EndPoint>
<Params>
<Param Name="NextUrlAttributeOrExpr" Type="Property" Value="$.next_page.uri" />
<Param Name="Limit" Key="limit" Value="100" Type="Query" Desc="Results per page. The number of objects to return per page. The value must be between 1 and 100." />
</Params>
<OutputColumns>
<Column Name="gid" Label="Id" DataType="DT_WSTR" Length="50" />
<Column__ Name="resource_type" Label="ResourceType" DataType="DT_WSTR" Length="100" />
</OutputColumns>
</EndPoint>
<Param Name="T_WorkspaceIdParam" Key="workspace" Label="Workspace Id" OptionsEndPoint="get_workspaces" OptionsEndPointLabelColumn="Name" OptionsEndPointValueColumn="Id" />
<Param Name="T_ProjectIdParam" Key="project" Label="Project Id" OptionsEndPoint="get_projects" OptionsEndPointLabelColumn="Name" OptionsEndPointValueColumn="Id" OptionsEndPointParameters="WorkspaceId=[$WorkspaceId$]" />
<Param Name="T_TeamIdParam" Key="team" Label="Team Id" OptionsEndPoint="get_workspace_teams" OptionsEndPointLabelColumn="Name" OptionsEndPointValueColumn="Id" />
<Param Name="T_PortfolioIdParam" Key="portfolio" Label="Portfolio Id" OptionsEndPoint="get_portfolios" OptionsEndPointLabelColumn="Name" OptionsEndPointValueColumn="Id" />
<Param Name="T_TaskIdParam" Key="task" Label="Task Id" OptionsEndPoint="get_tasks" OptionsEndPointLabelColumn="Name" OptionsEndPointValueColumn="Id" />
<Param Name="T_TagIdParam" Key="tag_gid" Label="Tag Id" OptionsEndPoint="get_tags" OptionsEndPointLabelColumn="Name" OptionsEndPointValueColumn="Id" />
<Param Name="T_SectionIdParam" Key="section" Label="Section Id" OptionsEndPoint="get_project_sections" OptionsEndPointLabelColumn="Name" OptionsEndPointValueColumn="Id" OptionsEndPointParameters="ProjectId=[$ProjectId$]"/>
<Param Name="T_UserIdParam" Label="User Id" OptionsEndPoint="get_users" OptionsEndPointLabelColumn="Name" OptionsEndPointValueColumn="Id" />
<Param Name="T_DateTimeParam"
Options="2023-12-31;2023-12-31T00:00:00;now;now-24h;today;yesterday;yearstart-10y;monthstart;monthend;yearstart;yearend;weekstart;weekend;yearstart-1y;yearend-1y;monthstart-1d;monthend+1d;monthend+1d-1y"
ValueTemplate="<<{$value$}|~|yyyy-MM-ddTHH:mm:ss.fffZ|~||~|true,FUN_TO_DATETIME>>"
/>
<Param Name="T_DateParam"
Options="2023-12-31;now;now-24h;today;yesterday;yearstart-10y;monthstart;monthend;yearstart;yearend;weekstart;weekend;yearstart-1y;yearend-1y;monthstart-1d;monthend+1d;monthend+1d-1y"
ValueTemplate="<<{$value$}|~|yyyy-MM-dd|~||~|true,FUN_TO_DATETIME>>"
/>
<EndPoint Name="T_Workspace">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="resource_type
;email_domains
;is_organization
;name"
/>
</Params>
<OutputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Length="255" />
<Column Name="email_domains" Label="EmailDomains" DataType="DT_WSTR" Length="500" />
<Column Name="is_organization" Label="IsOrganization" DataType="DT_BOOL" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_Project">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="archived
;resource_type
;color
;completed
;completed_at
;completed_by
;completed_by.name
;created_at
;created_from_template
;created_from_template.name
;current_status
;current_status.author
;current_status.author.name
;current_status.color
;current_status.created_at
;current_status.created_by
;current_status.created_by.name
;current_status.html_text
;current_status.modified_at
;current_status.text
;current_status.title
;current_status_update
;current_status_update.resource_subtype
;current_status_update.title
;custom_field_settings
;custom_field_settings.custom_field
;custom_field_settings.custom_field.asana_created_field
;custom_field_settings.custom_field.created_by
;custom_field_settings.custom_field.created_by.name
;custom_field_settings.custom_field.currency_code
;custom_field_settings.custom_field.custom_label
;custom_field_settings.custom_field.custom_label_position
;custom_field_settings.custom_field.date_value
;custom_field_settings.custom_field.date_value.date
;custom_field_settings.custom_field.date_value.date_time
;custom_field_settings.custom_field.description
;custom_field_settings.custom_field.display_value
;custom_field_settings.custom_field.enabled
;custom_field_settings.custom_field.enum_options
;custom_field_settings.custom_field.enum_options.color
;custom_field_settings.custom_field.enum_options.enabled
;custom_field_settings.custom_field.enum_options.name
;custom_field_settings.custom_field.enum_value
;custom_field_settings.custom_field.enum_value.color
;custom_field_settings.custom_field.enum_value.enabled
;custom_field_settings.custom_field.enum_value.name
;custom_field_settings.custom_field.format
;custom_field_settings.custom_field.has_notifications_enabled
;custom_field_settings.custom_field.id_prefix
;custom_field_settings.custom_field.is_formula_field
;custom_field_settings.custom_field.is_global_to_workspace
;custom_field_settings.custom_field.is_value_read_only
;custom_field_settings.custom_field.multi_enum_values
;custom_field_settings.custom_field.multi_enum_values.color
;custom_field_settings.custom_field.multi_enum_values.enabled
;custom_field_settings.custom_field.multi_enum_values.name
;custom_field_settings.custom_field.name
;custom_field_settings.custom_field.number_value
;custom_field_settings.custom_field.people_value
;custom_field_settings.custom_field.people_value.name
;custom_field_settings.custom_field.precision
;custom_field_settings.custom_field.representation_type
;custom_field_settings.custom_field.resource_subtype
;custom_field_settings.custom_field.text_value
;custom_field_settings.custom_field.type
;custom_field_settings.is_important
;custom_field_settings.parent
;custom_field_settings.parent.name
;custom_field_settings.project
;custom_field_settings.project.name
;custom_fields
;custom_fields.date_value
;custom_fields.date_value.date
;custom_fields.date_value.date_time
;custom_fields.display_value
;custom_fields.enabled
;custom_fields.enum_options
;custom_fields.enum_options.color
;custom_fields.enum_options.enabled
;custom_fields.enum_options.name
;custom_fields.enum_value
;custom_fields.enum_value.color
;custom_fields.enum_value.enabled
;custom_fields.enum_value.name
;custom_fields.id_prefix
;custom_fields.is_formula_field
;custom_fields.multi_enum_values
;custom_fields.multi_enum_values.color
;custom_fields.multi_enum_values.enabled
;custom_fields.multi_enum_values.name
;custom_fields.name
;custom_fields.number_value
;custom_fields.representation_type
;custom_fields.resource_subtype
;custom_fields.text_value
;custom_fields.type
;default_access_level
;default_view
;due_date
;due_on
;followers
;followers.name
;html_notes
;icon
;members
;members.name
;minimum_access_level_for_customization
;minimum_access_level_for_sharing
;modified_at
;name
;notes
;offset
;owner
;owner.name
;path
;permalink_url
;privacy_setting
;project_brief
;public
;start_on
;team
;team.name
;uri
;workspace
;workspace.name"
/>
</Params>
<OutputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Length="255" />
<Column Name="archived" Label="Archived" DataType="DT_BOOL" />
<Column Name="color" Label="Color" DataType="DT_WSTR" Length="50" />
<Column Name="created_at" Label="CreatedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="current_status.gid" Label="CurrentStatusId" DataType="DT_WSTR" Length="50" />
<Column Name="current_status.title" Label="CurrentStatusTitle" DataType="DT_WSTR" Length="100" />
<Column Name="current_status.text" Label="CurrentStatusText" DataType="DT_NTEXT" />
<Column Name="current_status.html_text" Label="CurrentStatusHtmlText" DataType="DT_NTEXT" />
<Column Name="current_status.color" Label="CurrentStatusColor" DataType="DT_WSTR" Length="50" />
<Column Name="current_status.author.gid" Label="CurrentStatusAuthorId" DataType="DT_WSTR" Length="50" />
<Column Name="current_status.author.name" Label="CurrentStatusAuthorName" DataType="DT_WSTR" Length="255" />
<Column Name="current_status.created_at" Label="CurrentStatusCreatedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="current_status.created_by.gid" Label="CurrentStatusCreatedById" DataType="DT_WSTR" Length="50" />
<Column Name="current_status.created_by.name" Label="CurrentStatusCreatedByName" DataType="DT_WSTR" Length="255" />
<Column Name="current_status.modified_at" Label="CurrentStatusModifiedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="current_status_update.gid" Label="CurrentStatusUpdateId" DataType="DT_WSTR" Length="50" />
<Column Name="current_status_update.title" Label="CurrentStatusUpdateTitle" DataType="DT_WSTR" Length="100" />
<Column Name="current_status_update.resource_subtype" Label="CurrentStatusUpdateResourceSubtype" DataType="DT_WSTR" Length="100" />
<Column Name="custom_field_settings" Label="CustomFieldSettings" DataType="DT_NTEXT" />
<Column Name="default_access_level" Label="DefaultAccessLevel" DataType="DT_WSTR" Length="50" />
<Column Name="default_view" Label="DefaultView" DataType="DT_WSTR" Length="50" />
<Column Name="due_date" Label="DueDate" DataType="DT_WSTR" Length="50" />
<Column Name="due_on" Label="DueOn" DataType="DT_WSTR" Length="50" />
<Column Name="html_notes" Label="HtmlNotes" DataType="DT_NTEXT" />
<Column Name="members" Label="Members" DataType="DT_WSTR" Length="500" />
<Column Name="modified_at" Label="ModifiedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="notes" Label="Notes" DataType="DT_NTEXT" />
<Column Name="public" Label="Public" DataType="DT_BOOL" />
<Column Name="start_on" Label="StartOn" DataType="DT_WSTR" Length="50" />
<Column Name="workspace.gid" Label="WorkspaceId" DataType="DT_WSTR" Length="50" />
<Column Name="workspace.name" Label="WorkspaceName" DataType="DT_WSTR" Length="255" />
<Column Name="custom_fields" Label="CustomFields" DataType="DT_WSTR" Length="4000" />
<Column Name="completed" Label="Completed" DataType="DT_BOOL" />
<Column Name="completed_at" Label="CompletedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="completed_by.gid" Label="CompletedById" DataType="DT_WSTR" Length="50" />
<Column Name="completed_by.name" Label="CompletedByName" DataType="DT_WSTR" Length="255" />
<Column Name="followers" Label="Followers" DataType="DT_WSTR" Length="500" />
<Column Name="owner.gid" Label="OwnerId" DataType="DT_WSTR" Length="50" />
<Column Name="owner.name" Label="OwnerName" DataType="DT_WSTR" Length="255" />
<Column Name="team.gid" Label="TeamId" DataType="DT_WSTR" Length="50" />
<Column Name="team.name" Label="TeamName" DataType="DT_WSTR" Length="255" />
<Column Name="icon" Label="Icon" DataType="DT_WSTR" Length="50" />
<Column Name="permalink_url" Label="PermalinkUrl" DataType="DT_WSTR" Length="500" />
<Column Name="project_brief.gid" Label="ProjectBriefId" DataType="DT_WSTR" Length="50" />
<Column Name="created_from_template.gid" Label="CreatedFromTemplateId" DataType="DT_WSTR" Length="50" />
<Column Name="created_from_template.name" Label="CreatedFromTemplateName" DataType="DT_WSTR" Length="255" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_Team">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="resource_type
;description
;edit_team_name_or_description_access_level
;edit_team_visibility_or_trash_team_access_level
;guest_invite_management_access_level
;html_description
;join_request_management_access_level
;member_invite_management_access_level
;name
;organization
;organization.name
;permalink_url
;team_content_management_access_level
;team_member_removal_access_level
;visibility"
/>
</Params>
<OutputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Length="255" />
<Column Name="description" Label="Description" DataType="DT_NTEXT" />
<Column Name="html_description" Label="HtmlDescription" DataType="DT_NTEXT" />
<Column Name="organization.gid" Label="OrganizationId" DataType="DT_WSTR" Length="50" />
<Column Name="organization.name" Label="OrganizationName" DataType="DT_WSTR" Length="255" />
<Column Name="permalink_url" Label="PermalinkUrl" DataType="DT_WSTR" Length="500" />
<Column Name="visibility" Label="Visibility" DataType="DT_WSTR" Length="50" />
<Column Name="edit_team_name_or_description_access_level" Label="EditTeamNameOrDescriptionAccessLevel" DataType="DT_WSTR" Length="100" />
<Column Name="edit_team_visibility_or_trash_team_access_level" Label="EditTeamVisibilityOrTrashTeamAccessLevel" DataType="DT_WSTR" Length="100" />
<Column Name="member_invite_management_access_level" Label="MemberInviteManagementAccessLevel" DataType="DT_WSTR" Length="100" />
<Column Name="guest_invite_management_access_level" Label="GuestInviteManagementAccessLevel" DataType="DT_WSTR" Length="100" />
<Column Name="join_request_management_access_level" Label="JoinRequestManagementAccessLevel" DataType="DT_WSTR" Length="100" />
<Column Name="team_content_management_access_level" Label="TeamContentManagementAccessLevel" DataType="DT_WSTR" Length="100" />
<Column Name="team_member_removal_access_level" Label="TeamMemberRemovalAccessLevel" DataType="DT_WSTR" Length="100" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_Attachment">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="name
;resource_subtype
;connected_to_app
;created_at
;download_url
;host
;parent
;parent.name
;parent.resource_subtype
;permanent_url
;size
;view_url"
/>
</Params>
<OutputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Length="255" />
<Column Name="resource_subtype" Label="ResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="connected_to_app" Label="ConnectedToApp" DataType="DT_BOOL" />
<Column Name="created_at" Label="CreatedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="download_url" Label="DownloadUrl" DataType="DT_WSTR" Length="500" />
<Column Name="host" Label="Host" DataType="DT_WSTR" Length="50" />
<Column Name="parent.gid" Label="ParentId" DataType="DT_WSTR" Length="50" />
<Column Name="parent.name" Label="ParentName" DataType="DT_WSTR" Length="255" />
<Column Name="parent.resource_subtype" Label="ParentResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="permanent_url" Label="PermanentUrl" DataType="DT_WSTR" Length="500" />
<Column Name="size" Label="Size" DataType="DT_I4" />
<Column Name="view_url" Label="ViewUrl" DataType="DT_WSTR" Length="500" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_AuditLog">
<OutputColumns>
<Column Name="actor.actor_type" Label="ActorActorType" DataType="DT_WSTR" Length="50" />
<Column Name="actor.email" Label="ActorEmail" DataType="DT_WSTR" Length="100" />
<Column Name="actor.gid" Label="ActorId" DataType="DT_WSTR" Length="50" />
<Column Name="actor.name" Label="ActorName" DataType="DT_WSTR" Length="255" />
<Column Name="context.api_authentication_method" Label="ContextApiAuthenticationMethod" DataType="DT_WSTR" Length="50" />
<Column Name="context.client_ip_address" Label="ContextClientIpAddress" DataType="DT_WSTR" Length="50" />
<Column Name="context.context_type" Label="ContextContextType" DataType="DT_WSTR" Length="50" />
<Column Name="context.oauth_app_name" Label="ContextOauthAppName" DataType="DT_WSTR" Length="255" />
<Column Name="context.rule_name" Label="ContextRuleName" DataType="DT_WSTR" Length="255" />
<Column Name="context.user_agent" Label="ContextUserAgent" DataType="DT_WSTR" Length="500" />
<Column Name="created_at" Label="CreatedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="event_category" Label="EventCategory" DataType="DT_WSTR" Length="50" />
<Column Name="event_type" Label="EventType" DataType="DT_WSTR" Length="50" />
<Column Name="resource.email" Label="ResourceEmail" DataType="DT_WSTR" Length="50" />
<Column Name="resource.gid" Label="ResourceId" DataType="DT_WSTR" Length="50" />
<Column Name="resource.name" Label="ResourceName" DataType="DT_WSTR" Length="255" />
<Column Name="resource.resource_subtype" Label="ResourceResourceSubtype" DataType="DT_WSTR" Length="50" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_Allocation">
<OutputColumns>
<Column Name="resource_subtype" Label="ResourceSubtype" DataType="DT_WSTR" Length="100" />
<Column Name="assignee.gid" Label="AssigneeId" DataType="DT_WSTR" Length="50" />
<Column Name="assignee.name" Label="AssigneeName" DataType="DT_WSTR" Length="255" />
<Column Name="parent.gid" Label="ParentId" DataType="DT_WSTR" Length="50" />
<Column Name="parent.name" Label="ParentName" DataType="DT_WSTR" Length="255" />
<Column Name="start_date" Label="StartDate" DataType="DT_WSTR" Length="50" />
<Column Name="end_date" Label="EndDate" DataType="DT_WSTR" Length="50" />
<Column Name="created_by.gid" Label="CreatedById" DataType="DT_WSTR" Length="50" />
<Column Name="created_by.name" Label="CreatedByName" DataType="DT_WSTR" Length="255" />
<Column Name="effort.type" Label="EffortType" DataType="DT_WSTR" Length="50" />
<Column Name="effort.value" Label="EffortValue" DataType="DT_I4" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_CustomField" CachedTtl="60">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="
custom_field
;asana_created_field
;created_by
;created_by.name
;currency_code
;custom_label
;custom_label_position
;date_value
;date_value.date
;date_value.date_time
;description
;display_value
;enabled
;enum_options
;enum_options.color
;enum_options.enabled
;enum_options.name
;enum_value
;enum_value.color
;enum_value.enabled
;enum_value.name
;format
;has_notifications_enabled
;id_prefix
;is_formula_field
;is_global_to_workspace
;is_value_read_only
;multi_enum_values
;multi_enum_values.color
;multi_enum_values.enabled
;multi_enum_values.name
;name
;number_value
;people_value
;people_value.name
;precision
;representation_type
;resource_subtype
;text_value
;type
;is_important
;parent
;parent.name
;project
;project.name
;portfolio
;portfolio.name
;workspace
"
/>
</Params>
<OutputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Length="255" />
<Column Name="type" Label="Type" DataType="DT_WSTR" Length="50" />
<Column Name="description" Label="Description" DataType="DT_NTEXT" />
<Column Name="asana_created_field" Label="AsanaCreatedField" DataType="DT_WSTR" Length="50" />
<Column Name="created_by.gid" Label="CreatedById" DataType="DT_WSTR" Length="50" />
<Column Name="created_by.name" Label="CreatedByName" DataType="DT_WSTR" Length="255" />
<Column Name="representation_type" Label="RepresentationType" DataType="DT_WSTR" Length="100" />
<Column__ Name="currency_code" Label="CurrencyCode" DataType="DT_WSTR" Length="50" />
<Column Name="custom_label" Label="CustomLabel" DataType="DT_WSTR" Length="50" />
<Column Name="custom_label_position" Label="CustomLabelPosition" DataType="DT_WSTR" Length="50" />
<Column__ Name="date_value.date" Label="DateValueDate" DataType="DT_WSTR" Length="50" />
<Column__ Name="date_value.date_time" Label="DateValueDateTime" DataType="DT_DBTIMESTAMP" />
<Column__ Name="display_value" Label="DisplayValue" DataType="DT_WSTR" Length="50" />
<Column Name="enabled" Label="Enabled" DataType="DT_BOOL" />
<Column Name="enum_options" Label="EnumOptions" DataType="DT_WSTR" Length="1000" />
<Column__ Name="enum_value.gid" Label="EnumValueId" DataType="DT_WSTR" Length="50" />
<Column__ Name="enum_value.color" Label="EnumValueColor" DataType="DT_WSTR" Length="50" />
<Column__ Name="enum_value.enabled" Label="EnumValueEnabled" DataType="DT_BOOL" />
<Column__ Name="enum_value.name" Label="EnumValueName" DataType="DT_WSTR" Length="255" />
<Column Name="format" Label="Format" DataType="DT_WSTR" Length="50" />
<Column Name="has_notifications_enabled" Label="HasNotificationsEnabled" DataType="DT_BOOL" />
<Column Name="is_global_to_workspace" Label="IsGlobalToWorkspace" DataType="DT_BOOL" />
<Column Name="is_formula_field" Label="IsFormulaField" DataType="DT_BOOL" />
<Column Name="is_value_read_only" Label="IsValueReadOnly" DataType="DT_BOOL" />
<Column__ Name="multi_enum_values" Label="MultiEnumValues" DataType="DT_WSTR" Length="1000" />
<Column__ Name="number_value" Label="NumberValue" DataType="DT_R8" />
<Column__ Name="people_value" Label="PeopleValue" DataType="DT_WSTR" Length="500" />
<Column Name="precision" Label="Precision" DataType="DT_I4" />
<Column Name="resource_subtype" Label="ResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column__ Name="text_value" Label="TextValue" DataType="DT_WSTR" Length="50" />
<Column Name="id_prefix" Label="IdPrefix" DataType="DT_WSTR" Length="100" />
<Column Name="type" Label="ValuePath" DataType="DT_WSTR" Length="50" ValueTemplate="<<{$value$}|~|EQ:enum|~|enum_value.name|~|EQ:number|~|number_value.name|~|text_value,FUN_CASE>>" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_CustomFieldCopy" Template="T_CustomField">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="
custom_field
;custom_field.asana_created_field
;custom_field.created_by
;custom_field.created_by.name
;custom_field.currency_code
;custom_field.custom_label
;custom_field.custom_label_position
;custom_field.date_value
;custom_field.date_value.date
;custom_field.date_value.date_time
;custom_field.description
;custom_field.display_value
;custom_field.enabled
;custom_field.enum_options
;custom_field.enum_options.color
;custom_field.enum_options.enabled
;custom_field.enum_options.name
;custom_field.enum_value
;custom_field.enum_value.color
;custom_field.enum_value.enabled
;custom_field.enum_value.name
;custom_field.format
;custom_field.has_notifications_enabled
;custom_field.id_prefix
;custom_field.is_formula_field
;custom_field.is_global_to_workspace
;custom_field.is_value_read_only
;custom_field.multi_enum_values
;custom_field.multi_enum_values.color
;custom_field.multi_enum_values.enabled
;custom_field.multi_enum_values.name
;custom_field.name
;custom_field.number_value
;custom_field.people_value
;custom_field.people_value.name
;custom_field.precision
;custom_field.representation_type
;custom_field.resource_subtype
;custom_field.text_value
;custom_field.type
;is_important
;parent
;parent.name
;project
;project.name
;portfolio
;portfolio.name
;workspace
"
/>
</Params>
</EndPoint>
<EndPoint Name="T_ProjectCustomField" Template="T_CustomFieldCopy" >
<OutputColumns>
<Column Name="P_data_gid" Label="FieldId" DataType="DT_WSTR" Length="50" />
<Column Name="P_data_project_gid" Label="ProjectId" DataType="DT_WSTR" Length="50" />
<Column Name="P_data_parent_gid" Label="ParentId" DataType="DT_WSTR" Length="50" />
<Column Name="P_data_parent_name" Label="ParentName" DataType="DT_WSTR" Length="255" />
<Column Name="P_data_project_name" Label="ProjectName" DataType="DT_WSTR" Length="255" />
<Column Name="P_data_is_important" Label="IsImportant" DataType="DT_BOOL" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_PortfolioCustomField" Template="T_CustomFieldCopy">
<OutputColumns>
<Column Name="P_data_gid" Label="Id" DataType="DT_WSTR" Length="50" />
<Column Name="P_data_portfolio_gid" Label="ProjectId" DataType="DT_WSTR" Length="50" />
<Column Name="P_data_portfolio_name" Label="ProjectName" DataType="DT_WSTR" Length="255" />
<Column Name="P_data_is_important" Label="IsImportant" DataType="DT_BOOL" />
<Column Name="P_data_parent_gid" Label="ParentId" DataType="DT_WSTR" Length="50" />
<Column Name="P_data_parent_name" Label="ParentName" DataType="DT_WSTR" Length="255" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_Section">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="name
;project
;project.name
;created_at
"
/>
</Params>
<OutputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Length="255" />
<Column Name="created_at" Label="CreatedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="project.gid" Label="ProjectId" DataType="DT_WSTR" Length="50" />
<Column Name="project.name" Label="ProjectName" DataType="DT_WSTR" Length="255" />
<Column__ Name="projects" Label="Projects" DataType="DT_WSTR" Length="500" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_Story">
<OutputColumns>
<Column Name="created_at" Label="CreatedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="html_text" Label="HtmlText" DataType="DT_NTEXT" />
<Column Name="is_pinned" Label="IsPinned" DataType="DT_BOOL" />
<Column Name="resource_subtype" Label="ResourceSubtype" DataType="DT_WSTR" Length="100" />
<Column Name="sticker_name" Label="StickerName" DataType="DT_WSTR" Length="255" />
<Column Name="text" Label="Text" DataType="DT_NTEXT" />
<Column Name="assignee.gid" Label="AssigneeId" DataType="DT_WSTR" Length="50" />
<Column Name="assignee.name" Label="AssigneeName" DataType="DT_WSTR" Length="255" />
<Column Name="created_by.gid" Label="CreatedById" DataType="DT_WSTR" Length="50" />
<Column Name="created_by.name" Label="CreatedByName" DataType="DT_WSTR" Length="255" />
<Column Name="custom_field.gid" Label="CustomFieldId" DataType="DT_WSTR" Length="50" />
<Column Name="custom_field.date_value.date" Label="CustomFieldDateValueDate" DataType="DT_WSTR" Length="50" />
<Column Name="custom_field.date_value.date_time" Label="CustomFieldDateValueDateTime" DataType="DT_DBTIMESTAMP" />
<Column Name="custom_field.display_value" Label="CustomFieldDisplayValue" DataType="DT_WSTR" Length="50" />
<Column Name="custom_field.enabled" Label="CustomFieldEnabled" DataType="DT_BOOL" />
<Column Name="custom_field.enum_options" Label="CustomFieldEnumOptions" DataType="DT_WSTR" Length="1000" />
<Column Name="custom_field.enum_value.gid" Label="CustomFieldEnumValueId" DataType="DT_WSTR" Length="50" />
<Column Name="custom_field.enum_value.color" Label="CustomFieldEnumValueColor" DataType="DT_WSTR" Length="50" />
<Column Name="custom_field.enum_value.enabled" Label="CustomFieldEnumValueEnabled" DataType="DT_BOOL" />
<Column Name="custom_field.enum_value.name" Label="CustomFieldEnumValueName" DataType="DT_WSTR" Length="255" />
<Column Name="custom_field.multi_enum_values" Label="CustomFieldMultiEnumValues" DataType="DT_WSTR" Length="1000" />
<Column Name="custom_field.name" Label="CustomFieldName" DataType="DT_WSTR" Length="255" />
<Column Name="custom_field.number_value" Label="CustomFieldNumberValue" DataType="DT_R8" />
<Column Name="custom_field.resource_subtype" Label="CustomFieldResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="custom_field.text_value" Label="CustomFieldTextValue" DataType="DT_WSTR" Length="50" />
<Column Name="custom_field.type" Label="CustomFieldType" DataType="DT_WSTR" Length="50" />
<Column Name="dependency.gid" Label="DependencyId" DataType="DT_WSTR" Length="50" />
<Column Name="dependency.name" Label="DependencyName" DataType="DT_WSTR" Length="255" />
<Column Name="dependency.resource_subtype" Label="DependencyResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="duplicate_of.gid" Label="DuplicateOfId" DataType="DT_WSTR" Length="50" />
<Column Name="duplicate_of.name" Label="DuplicateOfName" DataType="DT_WSTR" Length="255" />
<Column Name="duplicate_of.resource_subtype" Label="DuplicateOfResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="duplicated_from.gid" Label="DuplicatedFromId" DataType="DT_WSTR" Length="50" />
<Column Name="duplicated_from.name" Label="DuplicatedFromName" DataType="DT_WSTR" Length="255" />
<Column Name="duplicated_from.resource_subtype" Label="DuplicatedFromResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="follower.gid" Label="FollowerId" DataType="DT_WSTR" Length="50" />
<Column Name="follower.name" Label="FollowerName" DataType="DT_WSTR" Length="255" />
<Column Name="hearted" Label="Hearted" DataType="DT_BOOL" />
<Column Name="hearts" Label="Hearts" DataType="DT_WSTR" Length="1000" />
<Column Name="is_editable" Label="IsEditable" DataType="DT_BOOL" />
<Column Name="is_edited" Label="IsEdited" DataType="DT_BOOL" />
<Column Name="liked" Label="Liked" DataType="DT_BOOL" />
<Column Name="likes" Label="Likes" DataType="DT_WSTR" Length="1000" />
<Column Name="new_approval_status" Label="NewApprovalStatus" DataType="DT_WSTR" Length="50" />
<Column Name="new_date_value.due_at" Label="NewDateValueDueAt" DataType="DT_DBTIMESTAMP" />
<Column Name="new_date_value.due_on" Label="NewDateValueDueOn" DataType="DT_WSTR" Length="50" />
<Column Name="new_date_value.start_on" Label="NewDateValueStartOn" DataType="DT_WSTR" Length="50" />
<Column Name="new_dates.due_at" Label="NewDatesDueAt" DataType="DT_DBTIMESTAMP" />
<Column Name="new_dates.due_on" Label="NewDatesDueOn" DataType="DT_WSTR" Length="50" />
<Column Name="new_dates.start_on" Label="NewDatesStartOn" DataType="DT_WSTR" Length="50" />
<Column Name="new_enum_value.gid" Label="NewEnumValueId" DataType="DT_WSTR" Length="50" />
<Column Name="new_enum_value.color" Label="NewEnumValueColor" DataType="DT_WSTR" Length="50" />
<Column Name="new_enum_value.enabled" Label="NewEnumValueEnabled" DataType="DT_BOOL" />
<Column Name="new_enum_value.name" Label="NewEnumValueName" DataType="DT_WSTR" Length="255" />
<Column Name="new_multi_enum_values" Label="NewMultiEnumValues" DataType="DT_WSTR" Length="1000" />
<Column Name="new_name" Label="NewName" DataType="DT_WSTR" Length="255" />
<Column Name="new_number_value" Label="NewNumberValue" DataType="DT_I4" />
<Column Name="new_people_value" Label="NewPeopleValue" DataType="DT_WSTR" Length="500" />
<Column Name="new_resource_subtype" Label="NewResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="new_section.gid" Label="NewSectionId" DataType="DT_WSTR" Length="50" />
<Column Name="new_section.name" Label="NewSectionName" DataType="DT_WSTR" Length="255" />
<Column Name="new_text_value" Label="NewTextValue" DataType="DT_WSTR" Length="100" />
<Column Name="num_hearts" Label="NumHearts" DataType="DT_I4" />
<Column Name="num_likes" Label="NumLikes" DataType="DT_I4" />
<Column Name="old_approval_status" Label="OldApprovalStatus" DataType="DT_WSTR" Length="50" />
<Column Name="old_date_value.due_at" Label="OldDateValueDueAt" DataType="DT_DBTIMESTAMP" />
<Column Name="old_date_value.due_on" Label="OldDateValueDueOn" DataType="DT_WSTR" Length="50" />
<Column Name="old_date_value.start_on" Label="OldDateValueStartOn" DataType="DT_WSTR" Length="50" />
<Column Name="old_dates.due_at" Label="OldDatesDueAt" DataType="DT_DBTIMESTAMP" />
<Column Name="old_dates.due_on" Label="OldDatesDueOn" DataType="DT_WSTR" Length="50" />
<Column Name="old_dates.start_on" Label="OldDatesStartOn" DataType="DT_WSTR" Length="50" />
<Column Name="old_enum_value.gid" Label="OldEnumValueId" DataType="DT_WSTR" Length="50" />
<Column Name="old_enum_value.color" Label="OldEnumValueColor" DataType="DT_WSTR" Length="50" />
<Column Name="old_enum_value.enabled" Label="OldEnumValueEnabled" DataType="DT_BOOL" />
<Column Name="old_enum_value.name" Label="OldEnumValueName" DataType="DT_WSTR" Length="255" />
<Column Name="old_multi_enum_values" Label="OldMultiEnumValues" DataType="DT_WSTR" Length="1000" />
<Column Name="old_name" Label="OldName" DataType="DT_WSTR" Length="255" />
<Column Name="old_number_value" Label="OldNumberValue" DataType="DT_I4" />
<Column Name="old_people_value" Label="OldPeopleValue" DataType="DT_WSTR" Length="500" />
<Column Name="old_resource_subtype" Label="OldResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="old_section.gid" Label="OldSectionId" DataType="DT_WSTR" Length="50" />
<Column Name="old_section.name" Label="OldSectionName" DataType="DT_WSTR" Length="255" />
<Column Name="old_text_value" Label="OldTextValue" DataType="DT_WSTR" Length="100" />
<Column Name="previews" Label="Previews" DataType="DT_WSTR" Length="4000" />
<Column Name="project.gid" Label="ProjectId" DataType="DT_WSTR" Length="50" />
<Column Name="project.name" Label="ProjectName" DataType="DT_WSTR" Length="255" />
<Column Name="source" Label="Source" DataType="DT_WSTR" Length="50" />
<Column Name="story.gid" Label="StoryId" DataType="DT_WSTR" Length="50" />
<Column Name="story.created_at" Label="StoryCreatedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="story.created_by.gid" Label="StoryCreatedById" DataType="DT_WSTR" Length="50" />
<Column Name="story.created_by.name" Label="StoryCreatedByName" DataType="DT_WSTR" Length="255" />
<Column Name="story.resource_subtype" Label="StoryResourceSubtype" DataType="DT_WSTR" Length="100" />
<Column Name="story.text" Label="StoryText" DataType="DT_NTEXT" />
<Column Name="tag.gid" Label="TagId" DataType="DT_WSTR" Length="50" />
<Column Name="tag.name" Label="TagName" DataType="DT_WSTR" Length="255" />
<Column Name="target.gid" Label="TargetId" DataType="DT_WSTR" Length="50" />
<Column Name="target.name" Label="TargetName" DataType="DT_WSTR" Length="255" />
<Column Name="target.resource_subtype" Label="TargetResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="task.gid" Label="TaskId" DataType="DT_WSTR" Length="50" />
<Column Name="task.name" Label="TaskName" DataType="DT_WSTR" Length="255" />
<Column Name="task.resource_subtype" Label="TaskResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="type" Label="Type" DataType="DT_WSTR" Length="50" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_Tag">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="resource_type
;color
;created_at
;followers
;followers.name
;name
;notes
;offset
;path
;permalink_url
;uri
;workspace
;workspace.name"
/>
</Params>
<OutputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Length="255" />
<Column Name="color" Label="Color" DataType="DT_WSTR" Length="50" />
<Column Name="created_at" Label="CreatedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="followers" Label="Followers" DataType="DT_WSTR" Length="500" />
<Column Name="notes" Label="Notes" DataType="DT_WSTR" Length="2000" />
<Column Name="permalink_url" Label="PermalinkUrl" DataType="DT_WSTR" Length="500" />
<Column Name="workspace.gid" Label="WorkspaceId" DataType="DT_WSTR" Length="50" />
<Column Name="workspace.name" Label="WorkspaceName" DataType="DT_WSTR" Length="255" />
</OutputColumns>
</EndPoint>
<Param Name="T_FieldsParam" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="actual_time_minutes
;subtasks
;approval_status
;assignee
;assignee.name
;assignee_section
;assignee_section.name
;assignee_status
;completed
;completed_at
;completed_by
;completed_by.name
;created_at
;created_by
;created_by.name
;custom_fields
;custom_fields.asana_created_field
;custom_fields.created_by
;custom_fields.created_by.name
;custom_fields.currency_code
;custom_fields.custom_label
;custom_fields.custom_label_position
;custom_fields.date_value
;custom_fields.date_value.date
;custom_fields.date_value.date_time
;custom_fields.description
;custom_fields.display_value
;custom_fields.enabled
;custom_fields.enum_options
;custom_fields.enum_options.color
;custom_fields.enum_options.enabled
;custom_fields.enum_options.name
;custom_fields.enum_value
;custom_fields.enum_value.color
;custom_fields.enum_value.enabled
;custom_fields.enum_value.name
;custom_fields.format
;custom_fields.has_notifications_enabled
;custom_fields.id_prefix
;custom_fields.is_formula_field
;custom_fields.is_global_to_workspace
;custom_fields.is_value_read_only
;custom_fields.multi_enum_values
;custom_fields.multi_enum_values.color
;custom_fields.multi_enum_values.enabled
;custom_fields.multi_enum_values.name
;custom_fields.name
;custom_fields.number_value
;custom_fields.people_value
;custom_fields.people_value.name
;custom_fields.precision
;custom_fields.representation_type
;custom_fields.resource_subtype
;custom_fields.text_value
;custom_fields.type
;dependencies
;dependents
;due_at
;due_on
;external
;external.data
;followers
;followers.name
;hearted
;hearts
;hearts.user
;hearts.user.name
;html_notes
;is_rendered_as_separator
;liked
;likes
;likes.user
;likes.user.name
;memberships
;memberships.project
;memberships.project.name
;memberships.section
;memberships.section.name
;modified_at
;name
;notes
;num_hearts
;num_likes
;num_subtasks
;parent
;parent.created_by
;parent.name
;parent.resource_subtype
;permalink_url
;projects
;projects.name
;resource_subtype
;start_at
;start_on
;tags
;tags.name
;workspace
;workspace.name"
/>
<EndPoint Name="T_Task">
<Params>
<Param Name="EnableArrayFlattening" Value="True" Type="Property" Desc="Enables deep array flattening (e.g. Tag1Id, Tag2Id...) for selected filtered hierarchy. When you turn on this property it will flatten each property of each array item and expose as column (e.g. If you have array property called tags and value is ['red','blue','yellow'] and if you turn on array flatterning then may see columns tags.1, tags.2, tags.3... tags.N in the output. You can control how many array items you want to flatten by setting MaxArrayItemsToFlatten property." />
<Param Name="Fields" Template="T_FieldsParam" />
</Params>
<OutputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Length="255" />
<Column Name="actual_time_minutes" Label="ActualTimeMinutes" DataType="DT_I4" />
<Column Name="approval_status" Label="ApprovalStatus" DataType="DT_WSTR" Length="50" />
<Column Name="assignee_status" Label="AssigneeStatus" DataType="DT_WSTR" Length="50" />
<Column Name="completed" Label="Completed" DataType="DT_BOOL" />
<Column Name="completed_at" Label="CompletedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="completed_by.gid" Label="CompletedById" DataType="DT_WSTR" Length="50" />
<Column Name="completed_by.name" Label="CompletedByName" DataType="DT_WSTR" Length="255" />
<Column Name="created_at" Label="CreatedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="created_by.gid" Label="CreatedById" DataType="DT_WSTR" Length="50" />
<Column Name="created_by.name" Label="CreatedByName" DataType="DT_WSTR" Length="255" />
<Column Name="dependencies" Label="Dependencies" DataType="DT_WSTR" Length="500" />
<Column Name="dependents" Label="Dependents" DataType="DT_WSTR" Length="500" />
<Column Name="subtasks" Label="Subtasks" DataType="DT_NTEXT" />
<Column Name="due_at" Label="DueAt" DataType="DT_DBTIMESTAMP" />
<Column Name="due_on" Label="DueOn" DataType="DT_WSTR" Length="50" />
<Column Name="external.data" Label="ExternalData" DataType="DT_WSTR" Length="100" />
<Column Name="external.gid" Label="ExternalId" DataType="DT_WSTR" Length="50" />
<Column Name="hearted" Label="Hearted" DataType="DT_BOOL" />
<Column Name="hearts" Label="Hearts" DataType="DT_WSTR" Length="1000" />
<Column Name="html_notes" Label="HtmlNotes" DataType="DT_NTEXT" />
<Column Name="is_rendered_as_separator" Label="IsRenderedAsSeparator" DataType="DT_BOOL" />
<Column Name="liked" Label="Liked" DataType="DT_BOOL" />
<Column Name="likes" Label="Likes" DataType="DT_WSTR" Length="1000" />
<Column Name="memberships" Label="Memberships" DataType="DT_WSTR" Length="1000" />
<Column Name="modified_at" Label="ModifiedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="notes" Label="Notes" DataType="DT_WSTR" Length="2000" />
<Column Name="num_hearts" Label="NumHearts" DataType="DT_I4" />
<Column Name="num_likes" Label="NumLikes" DataType="DT_I4" />
<Column Name="num_subtasks" Label="NumSubtasks" DataType="DT_I4" />
<Column Name="resource_subtype" Label="ResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="start_at" Label="StartAt" DataType="DT_DBTIMESTAMP" />
<Column Name="start_on" Label="StartOn" DataType="DT_WSTR" Length="50" />
<Column Name="assignee.gid" Label="AssigneeId" DataType="DT_WSTR" Length="50" />
<Column Name="assignee.name" Label="AssigneeName" DataType="DT_WSTR" Length="255" />
<Column Name="assignee_section.gid" Label="AssigneeSectionId" DataType="DT_WSTR" Length="50" />
<Column Name="assignee_section.name" Label="AssigneeSectionName" DataType="DT_WSTR" Length="255" />
<Column Name="custom_fields" Label="CustomFields" DataType="DT_NTEXT" />
<Column Name="followers" Label="Followers" DataType="DT_WSTR" Length="500" />
<Column Name="parent.gid" Label="ParentId" DataType="DT_WSTR" Length="50" />
<Column Name="parent.name" Label="ParentName" DataType="DT_WSTR" Length="255" />
<Column Name="parent.created_by" Label="ParentCreatedBy" DataType="DT_WSTR" Length="255" />
<Column Name="parent_resource_subtype" Label="ParentResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="permalink_url" Label="PermalinkUrl" DataType="DT_WSTR" Length="500" />
<Column Name="projects" Label="Projects" DataType="DT_WSTR" Length="500" />
<Column Name="projects.1.gid" Label="Projects1Id" DataType="DT_WSTR" Length="50" />
<Column Name="projects.1.name" Label="Projects1Name" DataType="DT_WSTR" Length="255" />
<Column Name="projects.2.gid" Label="Projects2Id" DataType="DT_WSTR" Length="50" />
<Column Name="projects.2.name" Label="Projects2Name" DataType="DT_WSTR" Length="255" />
<Column Name="projects.3.gid" Label="Projects3Id" DataType="DT_WSTR" Length="50" />
<Column Name="projects.3.name" Label="Projects3Name" DataType="DT_WSTR" Length="255" />
<Column Name="tags" Label="Tags" DataType="DT_WSTR" Length="500" />
<Column Name="tags.1.gid" Label="Tags1Id" DataType="DT_WSTR" Length="50" />
<Column Name="tags.1.name" Label="Tags1Name" DataType="DT_WSTR" Length="255" />
<Column Name="tags.2.gid" Label="Tags2Id" DataType="DT_WSTR" Length="50" />
<Column Name="tags.2.name" Label="Tags2Name" DataType="DT_WSTR" Length="255" />
<Column Name="tags.3.gid" Label="Tags3Id" DataType="DT_WSTR" Length="50" />
<Column Name="tags.3.name" Label="Tags3Name" DataType="DT_WSTR" Length="255" />
<Column Name="tags.4.gid" Label="Tags4Id" DataType="DT_WSTR" Length="50" />
<Column Name="tags.4.name" Label="Tags4Name" DataType="DT_WSTR" Length="255" />
<Column Name="tags.5.gid" Label="Tags5Id" DataType="DT_WSTR" Length="50" />
<Column Name="tags.5.name" Label="Tags5Name" DataType="DT_WSTR" Length="255" />
<Column Name="workspace.gid" Label="WorkspaceId" DataType="DT_WSTR" Length="50" />
<Column Name="workspace.name" Label="WorkspaceName" DataType="DT_WSTR" Length="255" />
<Column Name="custom_fields"
Label="[$parent.name$]"
Expand="True"
DataEndPoint="get_project_custom_fields"
DataEndPointParameters="ProjectId=[$ProjectId$];"
ColumnInfoMap = "DataType=|number_w_prec=precision|number=name(equals:number)|date=name(equals:date)|people=name(equals:people)|enum=name(equals:enum)|multi_enum=name(equals:multi_enum)|text=name(equals:text)"
DataTypeMap="DT_I8=number;DT_R8=number_w_prec;DT_DBTIMESTAMP=datetime;DT_WSTR=text,enum,people"
UseCamelCaseLabel="True"
ValueTemplate="<<{$value$}|~|$.data[?(@name=='[$parent.name$]')].display_value|~|,,FUN_JSON_TO_TEXT>>"
/>
</OutputColumns>
</EndPoint>
<EndPoint Name="T_SubTask" Template="T_Task">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="gid
;name
;subtasks
;subtasks.actual_time_minutes
;subtasks.approval_status
;subtasks.assignee
;subtasks.assignee.name
;subtasks.assignee_section
;subtasks.assignee_section.name
;subtasks.assignee_status
;subtasks.completed
;subtasks.completed_at
;subtasks.completed_by
;subtasks.completed_by.name
;subtasks.created_at
;subtasks.created_by
;subtasks.created_by.name
;subtasks.custom_fields
;subtasks.custom_fields.asana_created_field
;subtasks.custom_fields.created_by
;subtasks.custom_fields.created_by.name
;subtasks.custom_fields.currency_code
;subtasks.custom_fields.custom_label
;subtasks.custom_fields.custom_label_position
;subtasks.custom_fields.date_value
;subtasks.custom_fields.date_value.date
;subtasks.custom_fields.date_value.date_time
;subtasks.custom_fields.description
;subtasks.custom_fields.display_value
;subtasks.custom_fields.enabled
;subtasks.custom_fields.enum_options
;subtasks.custom_fields.enum_options.color
;subtasks.custom_fields.enum_options.enabled
;subtasks.custom_fields.enum_options.name
;subtasks.custom_fields.enum_value
;subtasks.custom_fields.enum_value.color
;subtasks.custom_fields.enum_value.enabled
;subtasks.custom_fields.enum_value.name
;subtasks.custom_fields.format
;subtasks.custom_fields.has_notifications_enabled
;subtasks.custom_fields.id_prefix
;subtasks.custom_fields.is_formula_field
;subtasks.custom_fields.is_global_to_workspace
;subtasks.custom_fields.is_value_read_only
;subtasks.custom_fields.multi_enum_values
;subtasks.custom_fields.multi_enum_values.color
;subtasks.custom_fields.multi_enum_values.enabled
;subtasks.custom_fields.multi_enum_values.name
;subtasks.custom_fields.name
;subtasks.custom_fields.number_value
;subtasks.custom_fields.people_value
;subtasks.custom_fields.people_value.name
;subtasks.custom_fields.precision
;subtasks.custom_fields.representation_type
;subtasks.custom_fields.resource_subtype
;subtasks.custom_fields.text_value
;subtasks.custom_fields.type
;subtasks.dependencies
;subtasks.dependents
;subtasks.subtasks
;subtasks.due_at
;subtasks.due_on
;subtasks.external
;subtasks.external.data
;subtasks.followers
;subtasks.followers.name
;subtasks.hearted
;subtasks.hearts
;subtasks.hearts.user
;subtasks.hearts.user.name
;subtasks.html_notes
;subtasks.is_rendered_as_separator
;subtasks.liked
;subtasks.likes
;subtasks.likes.user
;subtasks.likes.user.name
;subtasks.memberships
;subtasks.memberships.project
;subtasks.memberships.project.name
;subtasks.memberships.section
;subtasks.memberships.section.name
;subtasks.modified_at
;subtasks.name
;subtasks.notes
;subtasks.num_hearts
;subtasks.num_likes
;subtasks.num_subtasks
;subtasks.parent
;subtasks.parent.created_by
;subtasks.parent.name
;subtasks.parent.resource_subtype
;subtasks.permalink_url
;subtasks.projects
;subtasks.projects.name
;subtasks.resource_subtype
;subtasks.start_at
;subtasks.start_on
;subtasks.tags
;subtasks.tags.name
;subtasks.workspace
;subtasks.workspace.name"
/>
</Params>
</EndPoint>
<EndPoint Name="T_Portfolio">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="archived
;resource_type
;color
;created_by
;created_by.name
;completed
;completed_at
;completed_by
;completed_by.name
;created_at
;created_from_template
;created_from_template.name
;current_status
;current_status.author
;current_status.author.name
;current_status.color
;current_status.created_at
;current_status.created_by
;current_status.created_by.name
;current_status.html_text
;current_status.modified_at
;current_status.text
;current_status.title
;current_status_update
;current_status_update.resource_subtype
;current_status_update.title
;custom_field_settings
;custom_field_settings.custom_field
;custom_field_settings.custom_field.asana_created_field
;custom_field_settings.custom_field.created_by
;custom_field_settings.custom_field.created_by.name
;custom_field_settings.custom_field.currency_code
;custom_field_settings.custom_field.custom_label
;custom_field_settings.custom_field.custom_label_position
;custom_field_settings.custom_field.date_value
;custom_field_settings.custom_field.date_value.date
;custom_field_settings.custom_field.date_value.date_time
;custom_field_settings.custom_field.description
;custom_field_settings.custom_field.display_value
;custom_field_settings.custom_field.enabled
;custom_field_settings.custom_field.enum_options
;custom_field_settings.custom_field.enum_options.color
;custom_field_settings.custom_field.enum_options.enabled
;custom_field_settings.custom_field.enum_options.name
;custom_field_settings.custom_field.enum_value
;custom_field_settings.custom_field.enum_value.color
;custom_field_settings.custom_field.enum_value.enabled
;custom_field_settings.custom_field.enum_value.name
;custom_field_settings.custom_field.format
;custom_field_settings.custom_field.has_notifications_enabled
;custom_field_settings.custom_field.id_prefix
;custom_field_settings.custom_field.is_formula_field
;custom_field_settings.custom_field.is_global_to_workspace
;custom_field_settings.custom_field.is_value_read_only
;custom_field_settings.custom_field.multi_enum_values
;custom_field_settings.custom_field.multi_enum_values.color
;custom_field_settings.custom_field.multi_enum_values.enabled
;custom_field_settings.custom_field.multi_enum_values.name
;custom_field_settings.custom_field.name
;custom_field_settings.custom_field.number_value
;custom_field_settings.custom_field.people_value
;custom_field_settings.custom_field.people_value.name
;custom_field_settings.custom_field.precision
;custom_field_settings.custom_field.representation_type
;custom_field_settings.custom_field.resource_subtype
;custom_field_settings.custom_field.text_value
;custom_field_settings.custom_field.type
;custom_field_settings.is_important
;custom_field_settings.parent
;custom_field_settings.parent.name
;custom_field_settings.project
;custom_field_settings.project.name
;custom_fields
;custom_fields.date_value
;custom_fields.date_value.date
;custom_fields.date_value.date_time
;custom_fields.display_value
;custom_fields.enabled
;custom_fields.enum_options
;custom_fields.enum_options.color
;custom_fields.enum_options.enabled
;custom_fields.enum_options.name
;custom_fields.enum_value
;custom_fields.enum_value.color
;custom_fields.enum_value.enabled
;custom_fields.enum_value.name
;custom_fields.id_prefix
;custom_fields.is_formula_field
;custom_fields.multi_enum_values
;custom_fields.multi_enum_values.color
;custom_fields.multi_enum_values.enabled
;custom_fields.multi_enum_values.name
;custom_fields.name
;custom_fields.number_value
;custom_fields.representation_type
;custom_fields.resource_subtype
;custom_fields.text_value
;custom_fields.type
;default_access_level
;default_view
;due_date
;due_on
;followers
;followers.name
;html_notes
;icon
;members
;members.name
;minimum_access_level_for_customization
;minimum_access_level_for_sharing
;modified_at
;name
;notes
;offset
;owner
;owner.name
;path
;permalink_url
;privacy_setting
;project_brief
;public
;start_on
;team
;team.name
;uri
;workspace
;workspace.name
;project_templates
"
/>
</Params>
<OutputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Length="255" />
<Column Name="color" Label="Color" DataType="DT_WSTR" Length="50" />
<Column Name="created_at" Label="CreatedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="created_by.gid" Label="CreatedById" DataType="DT_WSTR" Length="50" />
<Column Name="created_by.name" Label="CreatedByName" DataType="DT_WSTR" Length="255" />
<Column Name="custom_field_settings" Label="CustomFieldSettings" DataType="DT_NTEXT" />
<Column Name="current_status_update.gid" Label="CurrentStatusUpdateId" DataType="DT_WSTR" Length="50" />
<Column Name="current_status_update.title" Label="CurrentStatusUpdateTitle" DataType="DT_WSTR" Length="100" />
<Column Name="current_status_update.resource_subtype" Label="CurrentStatusUpdateResourceSubtype" DataType="DT_WSTR" Length="100" />
<Column Name="due_on" Label="DueOn" DataType="DT_WSTR" Length="50" />
<Column Name="custom_fields" Label="CustomFields" DataType="DT_WSTR" Length="4000" />
<Column Name="members" Label="Members" DataType="DT_WSTR" Length="500" />
<Column Name="owner.gid" Label="OwnerId" DataType="DT_WSTR" Length="50" />
<Column Name="owner.name" Label="OwnerName" DataType="DT_WSTR" Length="255" />
<Column Name="start_on" Label="StartOn" DataType="DT_WSTR" Length="50" />
<Column Name="workspace.gid" Label="WorkspaceId" DataType="DT_WSTR" Length="50" />
<Column Name="workspace.name" Label="WorkspaceName" DataType="DT_WSTR" Length="255" />
<Column Name="permalink_url" Label="PermalinkUrl" DataType="DT_WSTR" Length="500" />
<Column Name="public" Label="Public" DataType="DT_BOOL" />
<Column Name="default_access_level" Label="DefaultAccessLevel" DataType="DT_WSTR" Length="50" />
<Column Name="privacy_setting" Label="PrivacySetting" DataType="DT_WSTR" Length="50" />
<Column Name="project_templates" Label="ProjectTemplates" DataType="DT_WSTR" Length="500" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_User">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="name;
;email
;photo
;workspaces"
/>
</Params>
<OutputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Length="255" />
<Column Name="email" Label="Email" DataType="DT_WSTR" Length="100" />
<Column Name="photo.image_1024x1024" Label="PhotoImage1024X1024" DataType="DT_WSTR" Length="50" />
<Column Name="photo.image_128x128" Label="PhotoImage128X128" DataType="DT_WSTR" Length="50" />
<Column Name="photo.image_21x21" Label="PhotoImage21X21" DataType="DT_WSTR" Length="50" />
<Column Name="photo.image_27x27" Label="PhotoImage27X27" DataType="DT_WSTR" Length="50" />
<Column Name="photo.image_36x36" Label="PhotoImage36X36" DataType="DT_WSTR" Length="50" />
<Column Name="photo.image_60x60" Label="PhotoImage60X60" DataType="DT_WSTR" Length="50" />
<Column Name="workspaces" Label="Workspaces" DataType="DT_WSTR" Length="500" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_UserTaskList">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="owner
;owner.name
;name
;workspace
;workspace.name
"
/>
</Params>
<OutputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Length="255" />
<Column Name="owner.gid" Label="OwnerId" DataType="DT_WSTR" Length="50" />
<Column Name="owner.name" Label="OwnerName" DataType="DT_WSTR" Length="255" />
<Column Name="workspace.gid" Label="WorkspaceId" DataType="DT_WSTR" Length="50" />
<Column Name="workspace.name" Label="WorkspaceName" DataType="DT_WSTR" Length="255" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_Goal">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="due_on
;html_notes
;is_workspace_level
;liked
;name
;notes
;start_on
;status
;current_status_update
;current_status_update.resource_subtype
;current_status_update.title
;followers
;likes
;metric
;metric.currency_code
;metric.current_display_value
;metric.current_number_value
;metric.initial_number_value
;metric.precision
;metric.progress_source
;metric.resource_subtype
;metric.target_number_value
;metric.unit
;metric.can_manage
;metric.is_custom_weight
;num_likes
;owner
;owner.name
;team
;team.name
;time_period
;time_period.display_name
;time_period.end_on
;time_period.period
;time_period.start_on
;workspace
;workspace.name"
/>
</Params>
<OutputColumns>
<Column Name="name" Label="Name" DataType="DT_WSTR" Length="255" />
<Column Name="due_on" Label="DueOn" DataType="DT_WSTR" Length="50" />
<Column Name="html_notes" Label="HtmlNotes" DataType="DT_NTEXT" />
<Column Name="is_workspace_level" Label="IsWorkspaceLevel" DataType="DT_BOOL" />
<Column Name="liked" Label="Liked" DataType="DT_BOOL" />
<Column Name="notes" Label="Notes" DataType="DT_WSTR" Length="2000" />
<Column Name="start_on" Label="StartOn" DataType="DT_WSTR" Length="50" />
<Column Name="status" Label="Status" DataType="DT_WSTR" Length="50" />
<Column Name="current_status_update.gid" Label="CurrentStatusUpdateId" DataType="DT_WSTR" Length="50" />
<Column Name="current_status_update.resource_subtype" Label="CurrentStatusUpdateResourceSubtype" DataType="DT_WSTR" Length="100" />
<Column Name="current_status_update.title" Label="CurrentStatusUpdateTitle" DataType="DT_WSTR" Length="100" />
<Column Name="followers" Label="Followers" DataType="DT_WSTR" Length="500" />
<Column Name="likes" Label="Likes" DataType="DT_WSTR" Length="1000" />
<Column Name="metric.gid" Label="MetricId" DataType="DT_WSTR" Length="50" />
<Column Name="metric.currency_code" Label="MetricCurrencyCode" DataType="DT_WSTR" Length="50" />
<Column Name="metric.current_display_value" Label="MetricCurrentDisplayValue" DataType="DT_WSTR" Length="50" />
<Column Name="metric.current_number_value" Label="MetricCurrentNumberValue" DataType="DT_R8" />
<Column Name="metric.initial_number_value" Label="MetricInitialNumberValue" DataType="DT_R8" />
<Column Name="metric.precision" Label="MetricPrecision" DataType="DT_I4" />
<Column Name="metric.progress_source" Label="MetricProgressSource" DataType="DT_WSTR" Length="50" />
<Column Name="metric.resource_subtype" Label="MetricResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="metric.target_number_value" Label="MetricTargetNumberValue" DataType="DT_R8" />
<Column Name="metric.unit" Label="MetricUnit" DataType="DT_WSTR" Length="50" />
<Column Name="metric.can_manage" Label="MetricCanManage" DataType="DT_BOOL" />
<Column Name="num_likes" Label="NumLikes" DataType="DT_I4" />
<Column Name="owner.gid" Label="OwnerId" DataType="DT_WSTR" Length="50" />
<Column Name="owner.name" Label="OwnerName" DataType="DT_WSTR" Length="255" />
<Column Name="team.gid" Label="TeamId" DataType="DT_WSTR" Length="50" />
<Column Name="team.name" Label="TeamName" DataType="DT_WSTR" Length="255" />
<Column Name="time_period.gid" Label="TimePeriodId" DataType="DT_WSTR" Length="50" />
<Column Name="time_period.display_name" Label="TimePeriodDisplayName" DataType="DT_WSTR" Length="255" />
<Column Name="time_period.end_on" Label="TimePeriodEndOn" DataType="DT_WSTR" Length="50" />
<Column Name="time_period.period" Label="TimePeriodPeriod" DataType="DT_WSTR" Length="50" />
<Column Name="time_period.start_on" Label="TimePeriodStartOn" DataType="DT_WSTR" Length="50" />
<Column Name="workspace.gid" Label="WorkspaceId" DataType="DT_WSTR" Length="50" />
<Column Name="workspace.name" Label="WorkspaceName" DataType="DT_WSTR" Length="255" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_Membership">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="name
;resource_subtype
;member
;member.name
;parent
;parent.name
;parent.owner
;parent.owner.name
;access_level
;portfolio.name
;user.name
"
/>
</Params>
<OutputColumns>
<Column Name="resource_subtype" Label="ResourceSubtype" DataType="DT_WSTR" Length="100" />
<Column Name="member.gid" Label="MemberId" DataType="DT_WSTR" Length="50" />
<Column Name="member.name" Label="MemberName" DataType="DT_WSTR" Length="255" />
<Column Name="parent.gid" Label="ParentId" DataType="DT_WSTR" Length="50" />
<Column Name="parent.name" Label="ParentName" DataType="DT_WSTR" Length="255" />
<Column Name="parent_owner.gid" Label="ParentOwnerId" DataType="DT_WSTR" Length="50" />
<Column Name="parent_owner.name" Label="ParentOwnerName" DataType="DT_WSTR" Length="255" />
<Column Name="access_level" Label="AccessLevel" DataType="DT_WSTR" Length="50" />
<Column Name="portfolio.gid" Label="PortfolioId" DataType="DT_WSTR" Length="50" />
<Column Name="portfolio.name" Label="PortfolioName" DataType="DT_WSTR" Length="255" />
<Column Name="user.gid" Label="UserId" DataType="DT_WSTR" Length="50" />
<Column Name="user.name" Label="UserName" DataType="DT_WSTR" Length="255" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_TeamMembership">
<OutputColumns>
<Column Name="is_admin" Label="IsAdmin" DataType="DT_BOOL" />
<Column Name="is_guest" Label="IsGuest" DataType="DT_BOOL" />
<Column Name="is_limited_access" Label="IsLimitedAccess" DataType="DT_BOOL" />
<Column Name="team.gid" Label="TeamId" DataType="DT_WSTR" Length="50" />
<Column Name="team.name" Label="TeamName" DataType="DT_WSTR" Length="255" />
<Column Name="user.gid" Label="UserId" DataType="DT_WSTR" Length="50" />
<Column Name="user.name" Label="UserName" DataType="DT_WSTR" Length="255" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_TimeTrackingEntry">
<Params>
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="name
;created_by.name
;duration_minutes
;entered_on
;created_at
;task.name"
/>
</Params>
<OutputColumns>
<Column Name="created_by.gid" Label="CreatedById" DataType="DT_WSTR" Length="50" />
<Column Name="created_by.name" Label="CreatedByName" DataType="DT_WSTR" Length="255" />
<Column Name="duration_minutes" Label="DurationMinutes" DataType="DT_I4" />
<Column Name="entered_on" Label="EnteredOn" DataType="DT_WSTR" Length="50" />
<Column Name="created_at" Label="CreatedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="task.gid" Label="TaskId" DataType="DT_WSTR" Length="50" />
<Column Name="task.name" Label="TaskName" DataType="DT_WSTR" Length="255" />
</OutputColumns>
</EndPoint>
</Template>
<EndPoints>
<EndPoint Name="get_workspaces" Template="T_Workspace" Label="Get Workspaces" Desc="" Url="/workspaces" Filter="$.data[*]">
</EndPoint>
<EndPoint Name="get_workspace" Template="T_Workspace" Label="Get Workspace (Single)" Desc="" Url="/workspaces/[$WorkspaceId$]" Filter="$.data">
<Params>
<Param Name="WorkspaceId" Template="T_WorkspaceIdParam" Required="True" ReadAs="Id" IsKey="True"/>
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_projects" Template="T_Project" Label="Get Projects" Desc="" Url="/projects" Filter="$.data[*]">
<Params>
<Param Name="WorkspaceId" Template="T_WorkspaceIdParam" Type="Query"/>
<Param Name="TeamId" Template="T_TeamIdParam" Type="Query" />
</Params>
</EndPoint>
<EndPoint Name="get_project" Template="T_Project" Label="Get Project (Single)" Desc="" Url="/projects/[$ProjectId$]" Filter="$.data">
<Params>
<Param Name="ProjectId" Template="T_ProjectIdParam" Required="True" ReadAs="Id" IsKey="True"/>
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_tasks" Template="T_Task" Label="Get Tasks" Desc=""
Url="<<[$QueryBy$]|~|Eq|~|user_task_list|~|user_task_lists/[$UserTaskListId$]/|~|,FUN_IF>><<[$QueryBy$]|~|Eq|~|tag|~|tags/[$TagId$]/|~|,FUN_IF>>tasks<<[$QueryBy$]|~|Eq|~|project|~|?project=[$ProjectId$]|~|,FUN_IF>>"
Filter="$.data[*]"
>
<Params>
<Param Name="QueryBy" Required="True" Options="project;tag;section;user_task_list;assignee_and_workspace" Value="project"/>
<Param Name="ProjectId" Template="T_ProjectIdParam" Desc="The project to filter tasks on."/>
<Param Name="WorkspaceId" Template="T_WorkspaceIdParam" Type="Query" VisibleIf="QueryBy==assignee_and_workspace" RequiredIf="QueryBy==assignee_and_workspace" ValueTemplate="<<[$QueryBy$]|~|Eq|~|assignee_and_workspace|~|{$value$}|~|,FUN_IF>>" Desc="The workspace to filter tasks on. Note: If you specify workspace, you must also specify the assignee to filter on."/>
<Param Name="AssigneeId" Template="T_UserIdParam" Type="Query" Label="Assignee Id" VisibleIf="QueryBy==assignee_and_workspace" RequiredIf="QueryBy==assignee_and_workspace" ValueTemplate="<<[$QueryBy$]|~|Eq|~|assignee_and_workspace|~|{$value$}|~|,FUN_IF>>" Desc="The assignee to filter tasks on. If searching for unassigned tasks, assignee.any = null can be specified. Note: If you specify assignee, you must also specify the workspace to filter on."/>
<Param Name="SectionId" Template="T_SectionIdParam" Type="Query" VisibleIf="QueryBy==section" RequiredIf="QueryBy==section" ValueTemplate="<<[$QueryBy$]|~|Eq|~|section|~|{$value$}|~|,FUN_IF>>" Desc="The section to filter tasks on."/>
<Param Name="TagId" Template="T_TagIdParam" Type="Placeholder" VisibleIf="QueryBy==tag" RequiredIf="QueryBy==tag" ValueTemplateXX="<<[$QueryBy$]|~|Eq|~|tag|~|/tags/{$value$}|~|,FUN_IF>>"/>
<Param Name="UserTaskListId" Type="Placeholder" VisibleIf="QueryBy==user_task_list" RequiredIf="QueryBy==user_task_list" ValueTemplate="<<[$QueryBy$]|~|Eq|~|user_task_list|~|/user_task_lists/{$value$}|~|,FUN_IF>>"/>
<Param Name="CompletedSince" Label="Completed Since" Type="Query" Key="completed_since" Template="T_DateTimeParam" Desc="Only return tasks that are either incomplete or that have been completed since this time." />
<Param Name="ModifiedSince" Label="Modified Since" Type="Query" Key="modified_since" Template="T_DateTimeParam" Desc="Only return tasks that have been modified since the given time. Note: A task is considered “modified” if any of its properties
change, or associations between it and other objects are modified (e.g. a task being added to a project). A task is not considered modified just because another object it is associated with (e.g. a subtask) is modified. Actions that count as modifying the task
include assigning, renaming, completing, and adding stories."/>
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_subtasks" Template="T_SubTask" Label="Get Sub Tasks" Desc="Only enter TaskId if QueryBy=task else you may get error."
Url="<<[$QueryBy$]|~|Eq|~|user_task_list|~|user_task_lists/[$UserTaskListId$]/|~|,FUN_IF>><<[$QueryBy$]|~|Eq|~|tag|~|tags/[$TagId$]/|~|,FUN_IF>>tasks<<[$QueryBy$]|~|Eq|~|project|~|?project=[$ProjectId$]|~|[$TaskId$],FUN_IF>>"
Filter="$..subtasks[?(@name)]">
<Params>
<Param Name="QueryBy" Required="True" Options="project;task;tag;section;user_task_list;assignee_and_workspace" Value="project"/>
<Param Name="TaskId" Label="Parent Task Id" VisibleIf="QueryBy==task" RequiredIf="QueryBy==task" ReadAs="ParentId" IsKey="True" Desc="The parent task id for which you would like to fetch all sub tasks." ValueTemplate="/{$value$}"/>
<Param Name="ProjectId" Template="T_ProjectIdParam" Desc="The project to filter tasks on."/>
<Param Name="WorkspaceId" Template="T_WorkspaceIdParam" Type="Query" VisibleIf="QueryBy==assignee_and_workspace" RequiredIf="QueryBy==assignee_and_workspace" ValueTemplate="<<[$QueryBy$]|~|Eq|~|assignee_and_workspace|~|{$value$}|~|,FUN_IF>>" Desc="The workspace to filter tasks on. Note: If you specify workspace, you must also specify the assignee to filter on."/>
<Param Name="AssigneeId" Template="T_UserIdParam" Type="Query" Label="Assignee Id" VisibleIf="QueryBy==assignee_and_workspace" RequiredIf="QueryBy==assignee_and_workspace" ValueTemplate="<<[$QueryBy$]|~|Eq|~|assignee_and_workspace|~|{$value$}|~|,FUN_IF>>" Desc="The assignee to filter tasks on. If searching for unassigned tasks, assignee.any = null can be specified. Note: If you specify assignee, you must also specify the workspace to filter on."/>
<Param Name="SectionId" Template="T_SectionIdParam" Type="Query" VisibleIf="QueryBy==section" RequiredIf="QueryBy==section" ValueTemplate="<<[$QueryBy$]|~|Eq|~|section|~|{$value$}|~|,FUN_IF>>" Desc="The section to filter tasks on."/>
<Param Name="TagId" Template="T_TagIdParam" Type="Placeholder" VisibleIf="QueryBy==tag" RequiredIf="QueryBy==tag" ValueTemplateXX="<<[$QueryBy$]|~|Eq|~|tag|~|/tags/{$value$}|~|,FUN_IF>>"/>
<Param Name="UserTaskListId" Type="Placeholder" VisibleIf="QueryBy==user_task_list" RequiredIf="QueryBy==user_task_list" ValueTemplate="<<[$QueryBy$]|~|Eq|~|user_task_list|~|/user_task_lists/{$value$}|~|,FUN_IF>>"/>
<Param Name="CompletedSince" Label="Completed Since" Type="Query" Key="completed_since" Template="T_DateTimeParam" Desc="Only return tasks that are either incomplete or that have been completed since this time." />
<Param Name="ModifiedSince" Label="Modified Since" Type="Query" Key="modified_since" Template="T_DateTimeParam" Desc="Only return tasks that have been modified since the given time. Note: A task is considered “modified” if any of its properties
change, or associations between it and other objects are modified (e.g. a task being added to a project). A task is not considered modified just because another object it is associated with (e.g. a
subtask) is modified. Actions that count as modifying the task include assigning, renaming, completing, and adding stories."/>
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_workspace_tasks" Template="T_Task" Label="Get Workspace Tasks" Desc="Get tasks for all projects in a specified workspace (or default workspace)."
Url="/projects"
Filter="$.data[*]">
<Params>
<Param Name="Fields" Template="T_FieldsParam" Target="child_project_tasks"/>
<Param Name="WorkspaceId" Template="T_WorkspaceIdParam" Type="Query" Desc="The workspace to filter tasks on. Note: If you specify workspace."/>
<Param Name="CompletedSince" Label="Completed Since" Type="Query" Key="completed_since" Template="T_DateTimeParam" Desc="Only return tasks that are either incomplete or that have been completed since this time." />
<Param Name="ModifiedSince" Label="Modified Since" Type="Query" Key="modified_since" Template="T_DateTimeParam" Desc="Only return tasks that have been modified since the given time. Note: A task is considered “modified” if any of its properties
change, or associations between it and other objects are modified (e.g. a task being added to a project). A task is not considered modified just because another object it is associated with (e.g. a subtask) is modified. Actions that count as modifying the task
include assigning, renaming, completing, and adding stories."/>
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
<EndPoint Name="child_project_tasks" Url="/projects/[$parent.gid$]/tasks" Filter="$.data[*]">
<Params>
<Param Name="EnableArrayFlattening" Value="True" Type="Property" />
<Param Name="Fields" Template="T_FieldsParam"/>
<Param Name="CompletedSince" Type="Query" Key="completed_since" />
<Param Name="ModifiedSince" Type="Query" Key="modified_since" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Type="Property" />
</Params>
</EndPoint>
<OutputColumns>
<Column Name="p1_gid" Label="ProjectId" DataType="DT_WSTR" Length="30"/>
<Column Name="p1_name" Label="ProjectName" DataType="DT_WSTR" Length="255" />
</OutputColumns>
</EndPoint>
<EndPoint Name="search_tasks" Template="T_Task" Label="Search Tasks (Advanced Filter)" Desc="Search tasks with in a specified workspace (or default workspace) using advanced server side filters."
Url="/workspaces/[$WorkspaceId$]/tasks/search"
Filter="$.data[*]">
<Params>
<Param Name="Fields" Template="T_FieldsParam" />
<Param Name="WorkspaceId" Template="T_WorkspaceIdParam" Type="Default" Desc="The workspace to filter tasks on. Note: If you specify workspace."/>
<Param Name="Text" Type="Query" Key="text" Desc="Performs full-text search on both task name and description."/>
<Param Name="ProjectsNot" Label="Projects (NOT)" Template="T_ProjectIdParam" Type="Query" Key="projects.not" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of project IDs."/>
<Param Name="ProjectsAll" Label="Projects (ALL)" Template="T_ProjectIdParam" Type="Query" Key="projects.all" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of project IDs."/>
<Param Name="ProjectsAny" Label="Projects (ANY)" Template="T_ProjectIdParam" Type="Query" Key="projects.any" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of project IDs."/>
<Param Name="SectionsNot" Label="Sections (NOT)" Template="T_SectionIdParam" Type="Query" Key="sections.not" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of section IDs."/>
<Param Name="SectionsAll" Label="Sections (ALL)" Template="T_SectionIdParam" Type="Query" Key="sections.all" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of section IDs."/>
<Param Name="SectionsAny" Label="Sections (ANY)" Template="T_SectionIdParam" Type="Query" Key="sections.any" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of section IDs."/>
<Param Name="TagNot" Label="Tags (NOT)" Template="T_TagIdParam" Key="tags.not" Type="Query" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of tag IDs."/>
<Param Name="TagAll" Label="Tags (ALL)" Template="T_TagIdParam" Key="tags.all" Type="Query" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of tag IDs."/>
<Param Name="TagAny" Label="Tags (ANY)" Template="T_TagIdParam" Key="tags.any" Type="Query" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of tag IDs."/>
<Param Name="AssignedByNot" Label="Assigned By (NOT)" Template="T_UserIdParam" Type="Query" Key="assigned_by.not" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of user IDs."/>
<Param Name="AssignedByAll" Label="Assigned By (ALL)" Template="T_UserIdParam" Type="Query" Key="assigned_by.all" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of user IDs."/>
<Param Name="AssignedByAny" Label="Assigned By (ANY)" Template="T_UserIdParam" Type="Query" Key="assigned_by.any" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of user IDs."/>
<Param Name="PortfoliosAny" Label="Portfolios (ANY)" Template="T_PortfolioIdParam" Type="Query" Key="portfolios.any" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of portfolio IDs."/>
<Param Name="TeamsAny" Label="Teams (ANY)" Template="T_TeamIdParam" Type="Query" Key="teams.any" MultiSelect="True" MultiSelectSeparator="," Desc="Comma-separated list of team IDs."/>
<Param Name="DueOn" Label="Due On" Template="T_DateParam" Type="Query" Key="due_on" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="DueOnBefore" Label="Due On Before" Template="T_DateParam" Type="Query" Key="due_on.before" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="DueOnAfter" Label="Due On After" Template="T_DateParam" Type="Query" Key="due_on.after" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="DueOnNull" Label="Due On (Null)" Type="Query" Key="due_on" Options=";null" Desc="Search for DueOn [null] value."/>
<Param Name="StartOn" Label="Start On" Template="T_DateParam" Type="Query" Key="start_on" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="StartOnBefore" Label="Start On Before" Template="T_DateParam" Type="Query" Key="start_on.before" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="StartOnAfter" Label="Start On After" Template="T_DateParam" Type="Query" Key="start_on.after" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="StartOnNull" Label="Start On (Null)" Type="Query" Key="start_on" Options=";null" Desc="Search for StartOn [null] value."/>
<Param Name="CreatedOn" Label="Created On" Template="T_DateParam" Type="Query" Key="created_on" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="CreatedOnBefore" Label="Created On Before" Template="T_DateParam" Type="Query" Key="created_on.before" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="CreatedOnAfter" Label="Created On After" Template="T_DateParam" Type="Query" Key="created_on.after" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="CreatedOnNull" Label="Created On (Null)" Type="Query" Key="created_on" Options=";null" Desc="Search for CreatedOn [null] value."/>
<Param Name="ModifiedOn" Label="Modified On" Template="T_DateParam" Type="Query" Key="modified_on" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="ModifiedOnBefore" Label="Modified On Before" Template="T_DateParam" Type="Query" Key="modified_on.before" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="ModifiedOnAfter" Label="Modified On After" Template="T_DateParam" Type="Query" Key="modified_on.after" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="ModifiedOnNull" Label="Modified On (Null)" Type="Query" Key="modified_on" Options=";null" Desc="Search for ModifiedOn [null] value."/>
<Param Name="CompletedOn" Label="Completed On" Template="T_DateParam" Type="Query" Key="completed_on" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="CompletedOnBefore" Label="Completed On Before" Template="T_DateParam" Type="Query" Key="completed_on.before" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="CompletedOnAfter" Label="Completed On After" Template="T_DateParam" Type="Query" Key="completed_on.after" Desc="ISO 8601 date string (e.g. 2025-12-31)."/>
<Param Name="CompletedOnNull" Label="Completed On (Null)" Type="Query" Key="completed_on" Options=";null" Desc="Search for CompletedOn [null] value."/>
<Param Name="DueAt" Label="Due At" Template="T_DateTimeParam" Type="Query" Key="due_at" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="DueAtBefore" Label="Due At Before" Template="T_DateTimeParam" Type="Query" Key="due_at.before" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="DueAtAfter" Label="Due At After" Template="T_DateTimeParam" Type="Query" Key="due_at.after" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="StartAt" Label="Start At" Template="T_DateTimeParam" Type="Query" Key="start_at" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="StartAtBefore" Label="Start At Before" Template="T_DateTimeParam" Type="Query" Key="start_at.before" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="StartAtAfter" Label="Start At After" Template="T_DateTimeParam" Type="Query" Key="start_at.after" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="CreatedAt" Label="Created At" Template="T_DateTimeParam" Type="Query" Key="created_at" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="CreatedAtBefore" Label="Created At Before" Template="T_DateTimeParam" Type="Query" Key="created_at.before" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="CreatedAtAfter" Label="Created At After" Template="T_DateTimeParam" Type="Query" Key="created_at.after" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="ModifiedAt" Label="Modified At" Template="T_DateTimeParam" Type="Query" Key="modified_at" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="ModifiedAtBefore" Label="Modified At Before" Template="T_DateTimeParam" Type="Query" Key="modified_at.before" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="ModifiedAtAfter" Label="Modified At After" Template="T_DateTimeParam" Type="Query" Key="modified_at.after" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="CompletedAt" Label="Completed At" Template="T_DateTimeParam" Type="Query" Key="completed_at" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="CompletedAtBefore" Label="Completed At Before" Template="T_DateTimeParam" Type="Query" Key="completed_at.before" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="CompletedAtAfter" Label="Completed At After" Template="T_DateTimeParam" Type="Query" Key="completed_at.after" Desc="ISO 8601 date string (e.g. 2025-12-31T23:59:59)."/>
<Param Name="IsBlocked" Label="Is Blocked" Type="Query" Key="is_blocked" Options=";true;false" Desc=""/>
<Param Name="IsBlocking" Label="Is Blocking" Type="Query" Key="is_blocking" Options=";true;false" Desc=""/>
<Param Name="IsSubtask" Label="Is Subtask" Type="Query" Key="is_subtask" Options=";true;false" Desc=""/>
<Param Name="HasAttachment" Label="Has Attachment" Type="Query" Key="has_attachment" Options=";true;false" Desc=""/>
<Param Name="Completed" Label="Completed" Type="Query" Key="completed" Options=";true;false" Desc=""/>
<Param Name="SortBy" Label="Sort By" Type="Query" Key="sort_by" Options=";due_date;created_at;completed_at;modified_at;likes" Desc=""/>
<Param Name="SortAscending" Label="Sort Ascending" Type="Query" Key="sort_ascending" Options=";true;false" Desc=""/>
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_task" Template="T_Task" Label="Get Task (Single)" Desc="" Url="/tasks/[$TaskId$]" Filter="$.data">
<Params>
<Param Name="TaskId" Required="True" ReadAs="Id" IsKey="True"/>
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_workspace_teams" Template="T_Team" Label="Get Workspace Teams" Desc="Returns records for all teams in the workspace visible to the authorized user." Url="/workspaces/[$WorkspaceId$]/teams" Filter="$.data[*]">
<Params>
<Param Name="WorkspaceId" Template="T_WorkspaceIdParam" Required="True" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_project_sections" Template="T_Section" Label="Get Project Sections" Desc="" Url="/projects/[$ProjectId$]/sections" Filter="$.data[*]">
<Params>
<Param Name="ProjectId" Template="T_ProjectIdParam" Required="True" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_project_section" Template="T_Section" Label="Get Project Section" Desc="" Url="/projects/[$ProjectId$]/sections/[$SectionId$]" Filter="$.data">
<Params>
<Param Name="ProjectId" Template="T_ProjectIdParam" Required="True" />
<Param Name="SectionId" Template="T_SectionIdParam" Required="True" ReadAs="Id" IsKey="True" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_users" Template="T_User" Label="Get Users" Desc="" Url="/users" Filter="$.data[*]">
<Params>
<Param Name="WorkspaceId" Type="Query" Template="T_WorkspaceIdParam" Required="True" />
</Params>
</EndPoint>
<EndPoint Name="get_user" Template="T_User" Label="Get User (Single)" Desc="" Url="/users/[$UserId$]" Filter="$.data">
<Params>
<Param Name="UserId" Template="T_UserIdParam" Required="True" ReadAs="Id" IsKey="True"/>
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_allocations" Template="T_Allocation" Label="Get Allocations" Desc="" Url="/allocations" Filter="$.data[*]">
<Params>
<Param Name="WorkspaceId" Template="T_WorkspaceIdParam" Type="Query" />
<Param Name="ProjectId" Template="T_ProjectIdParam" Type="Query" Key="parent" />
<Param Name="AssigneeId" Template="T_UserIdParam" Type="Query" Key="assignee" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_attachments" Template="T_Attachment"
Label="Get Attachments (For Project refer to Key-Resources Upload only)"
Desc="There are three possible parent values for this request: project, project_brief, and task. For a project, an attachment refers to a file uploaded to the [Key resources] section in the project Overview. For a project brief, an attachment refers to inline files in the project brief itself. For a task, an attachment refers to a file directly associated to that task. Note that within the Asana app, inline images in the task description do not appear in the index of image thumbnails nor as stories in the task. However, requests made to GET /attachments for a task will return all of the images in the task, including inline images."
Url="/attachments" Filter="$.data[*]">
<Params>
<Param Name="ParentId" Type="Query" Label="Parent Id (e.g. Id of Project, Task or ProjectBrief)" Key="parent" Required="True" Desc="Globally unique identifier for object to fetch statuses from. Must be a GID for a project, project_brief, or task."/>
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="download_attachment" Template="."
Label="Download Attachment"
Url="/attachments/[$AttachmentId$]"
Filter="$.data"
Desc="Download a specific attachment by Id."
>
<Params>
<Param Name="AttachmentId" IsKey="True" Label="Attachment ID" Required="True" Type="Placeholder" Desc="The attachment Id for the attachment to get." />
<Param Name="FileOverwriteMode" Type="Property" Value="AlwaysOverwrite" Required="True" />
<Param Name="TargetFilePath" Key="ResponseDataFile" Type="Property" Required="True" Editor="FileSave" Desc="Specify a disk file path to save file as" />
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="name
;resource_subtype
;connected_to_app
;created_at
;download_url
;host
;parent
;parent.name
;parent.resource_subtype
;permanent_url
;size
;view_url"
/>
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
<EndPoint Name="child_download_attachment" Url="[$parent.download_url$]" OutputHeaders="StatusCode,Content-Length,Content-Type">
<Params>
<Param Name="TargetFilePath" Key="ResponseDataFile" Type="Property" />
<Param Name="FileOverwriteMode" Type="Property" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Type="Property" Value="True" />
<Param Name="HttpConnection" Type="Property" Desc="Do not pass Authorization header. Only use Signed URL generated in the previous step."/>
<Param Name="SaveContentAsBinary" Type="Property" Value="True"/>
<Param Name="EnableRawOutputModeSingleRow" Type="Property" Value="True" />
<Param Name="RawOutputDataRowTemplate" Type="Property" Value='{"Status":"Done"}' />
</Params>
</EndPoint>
<OutputColumns>
<Column Name="p1_gid" Label="Id" DataType="DT_WSTR" Length="50" />
<Column Name="ResponseHeaders_StatusCode" Label="StatusCode" DataType="DT_I4" />
<Column__ Name="ResponseHeaders_Content-Type" Label="ContentType" DataType="DT_STR" Length="100"/>
<Column Name="p1_name" Label="Name" DataType="DT_WSTR" Length="255" />
<Column Name="p1_name" Label="Path" DataType="DT_WSTR" ValueTemplate="[$TargetFilePath$]" />
<Column Name="p1_resource_subtype" Label="ResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="p1_connected_to_app" Label="ConnectedToApp" DataType="DT_BOOL" />
<Column Name="p1_created_at" Label="CreatedAt" DataType="DT_DBTIMESTAMP" />
<Column Name="p1_download_url" Label="DownloadUrl" DataType="DT_WSTR" Length="500" />
<Column Name="p1_host" Label="Host" DataType="DT_WSTR" Length="50" />
<Column Name="p1_parent.gid" Label="ParentId" DataType="DT_WSTR" Length="50" />
<Column Name="p1_parent.name" Label="ParentName" DataType="DT_WSTR" Length="255" />
<Column Name="p1_parent.resource_subtype" Label="ParentResourceSubtype" DataType="DT_WSTR" Length="50" />
<Column Name="p1_permanent_url" Label="PermanentUrl" DataType="DT_WSTR" Length="500" />
<Column Name="p1_size" Label="Size" DataType="DT_I4" />
<Column Name="p1_view_url" Label="ViewUrl" DataType="DT_WSTR" Length="500" />
</OutputColumns>
</EndPoint>
<EndPoint Name="download_attachments" Template="T_Attachment"
Label="Download Multiple Attachments"
Url="/attachments"
Filter="$.data[*]"
OutputHeaders="StatusCode,Content-Length,Content-Type"
Desc="Download Multiple Attachments for a specified parent.There are three possible parent values for this request: project, project_brief, and task. For a project, an attachment refers to a file uploaded to the [Key resources] section in the project Overview. For a project brief, an attachment refers to inline files in the project brief itself. For a task, an attachment refers to a file directly associated to that task. Note that within the Asana app, inline images in the task description do not appear in the index of image thumbnails nor as stories in the task. However, requests made to GET /attachments for a task will return all of the images in the task, including inline images."
>
<Params>
<Param Name="ParentId" Type="Query" Label="Parent Id (e.g. Id of Project, Task or ProjectBrief)" Key="parent" Required="True" Desc="Globally unique identifier for object to fetch statuses from. Must be a GID for a project, project_brief, or task."/>
<Param Name="OverwriteFile" Value="True" Required="True" Options=";True;False" />
<Param Name="SaveFolder" Value="c:\temp" Desc="Specify a disk folder path to save file(s) to" Required="True" Editor="FolderOpen" />
<Param Name="Fields" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="name
;resource_subtype
;connected_to_app
;created_at
;download_url
;host
;parent
;parent.name
;parent.resource_subtype
;permanent_url
;size
;view_url"
/>
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
<OutputColumns>
<Column Name="ResponseHeaders_StatusCode" Label="StatusCode" DataType="DT_I4" Order="-10"/>
<Column Name="download_url" Label="SavedFilePath" DataType="DT_WSTR" Length="300" ValueTemplate="[$SaveFolder$]\[$parent.gid$]_[$parent.name$]" Order="-9"/>
<Column Name="download_url" Label="SavedBytes" DataType="DT_I8"
ValueTemplate="<<[$SaveFolder$]\[$parent.gid$]_[$parent.name$]|~|{$value$}|~|GET|~||~||~|false|~|false|~|[$OverwriteFile$]|~|false|~|true,FUN_HTTP_WRITE_BINARY>>" Order="-8"/>
</OutputColumns>
</EndPoint>
<EndPoint Name="get_portfolios" Template="T_Portfolio" Label="Get Portfolios" Desc="" Url="/portfolios" Filter="$.data[*]">
<Params>
<Param Name="WorkspaceId" Template="T_WorkspaceIdParam" Type="Query"/>
<Param Name="OwnerId" Label="Owner Id" Template="T_UserIdParam" Required="True" Type="Query" Key="owner" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_goals" Template="T_Goal" Label="Get Goals" Desc="" Url="/goals" Filter="$.data[*]">
<Params>
<Param Name="Workspace" Template="T_WorkspaceIdParam" Type="Query"/>
<Param Name="Project" Template="T_ProjectIdParam" Type="Query"/>
<Param Name="Portfolio" Template="T_PortfolioIdParam" Type="Query"/>
<Param Name="Team" Template="T_TeamIdParam" Type="Query"/>
<Param Name="IsWorkspaceLevel" Label="Is Workspace Level" Type="Query" Key="is_workspace_level" Options=";true;false"/>
<Param Name="TimePeriods" Label="Time Periods (e.g. Id1,Id2)" Type="Query" Key="time_periods" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_workspace_custom_fields" Template="T_CustomField" Label="Get Workspace Custom Fields" Desc="" Url="/workspaces/[$WorkspaceId$]/custom_fields" Filter="$.data[*]">
<Params>
<Param Name="WorkspaceId" Template="T_WorkspaceIdParam" Required="True" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_project_custom_fields" Template="T_ProjectCustomField" Label="Get Project Custom Fields" Desc="" Url="/projects/[$ProjectId$]/custom_field_settings" Filter="$.data[*].custom_field" IncludeParentColumns="True">
<Params>
<Param Name="ProjectId" Template="T_ProjectIdParam" Required="True" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_portfolio_custom_fields" Template="T_PortfolioCustomField" Label="Get Portfolio Custom Fields" Desc="" Url="/portfolios/[$PortfolioId$]/custom_field_settings" Filter="$.data[*]">
<Params>
<Param Name="PortfolioId" Template="T_PortfolioIdParam" Required="True" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_user_task_lists" Template="T_UserTaskList" Label="Get User Task Lists" Desc="" Url="/users/[$UserId$]/user_task_list" Filter="$.data[*]">
<Params>
<Param Name="UserId" Template="T_UserIdParam" Required="True" />
<Param Name="WorkspaceId" Type="Query" Template="T_WorkspaceIdParam" Required="True" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_memberships" Template="T_Membership" Label="Get Memberships" Desc="" Url="/memberships" Filter="$.data[*]">
<Params>
<Param Name="ProjectId" Template="T_ProjectIdParam" Type="Query" Key="parent" />
<Param Name="PortfolioId" Type="Query" Key="parent" />
<Param Name="GoalId" Type="Query" Key="parent" />
<Param Name="MemberId" Label="Member or Team Id (Use with Project OR Portfolio OR Goal)" Template="T_UserIdParam" Type="Query" Key="member" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
<EndPoint Name="get_tags" Template="T_Tag" Label="Get Tags" Desc="" Url="/tags" Filter="$.data[*]">
<Params>
<Param Name="WorkspaceId" Type="Query" Template="T_WorkspaceIdParam" Required="True" />
</Params>
</EndPoint>
<EndPoint Name="get_time_tracking_entries" Template="T_TimeTrackingEntry" Label="Get Time Tracking Entries" Desc="" Url="/tasks/[$TaskId$]/time_tracking_entries" Filter="$.data[*]">
<Params>
<Param Name="TaskId" Template="T_TaskIdParam" Required="True" />
<Param Name="ContinueOn404Error" Key="ContineOn404Error" Label="Continue On 404 Error (When record not found)" Type="Property" Value="False" />
</Params>
</EndPoint>
</EndPoints>
<Tables>
<Table Name="Workspaces" SelectEndPoint="get_workspaces" LookupEndPoint="get_workspace" />
<Table Name="WorkspaceCustomFields" SelectEndPoint="get_workspace_custom_fields" />
<Table Name="WorkspaceTeams" SelectEndPoint="get_workspace_teams" />
<Table Name="WorkspaceTasks" SelectEndPoint="get_workspace_tasks" LookupEndPoint="get_task" />
<Table Name="Projects" SelectEndPoint="get_projects" LookupEndPoint="get_project" />
<Table Name="ProjectCustomFields" SelectEndPoint="get_project_custom_fields" />
<Table Name="ProjectSections" SelectEndPoint="get_project_sections" LookupEndPoint="get_project_section" />
<Table Name="Tasks" SelectEndPoint="get_tasks" LookupEndPoint="get_task" />
<Table Name="SubTasks" SelectEndPoint="get_subtasks" LookupEndPoint="get_task" />
<Table Name="Users" SelectEndPoint="get_users" LookupEndPoint="get_user" />
<Table Name="Allocations" SelectEndPoint="get_allocations" />
<Table Name="Portfolios" SelectEndPoint="get_portfolios" />
<Table Name="Goals" SelectEndPoint="get_goals" LookupEndPointXX="get_goal" />
<Table Name="Memberships" SelectEndPoint="get_memberships" LookupEndPointXX="get_membership" />
<Table Name="TimeTrackingEntries" SelectEndPoint="get_time_tracking_entries" />
<Table Name="Tags" SelectEndPoint="get_tags" />
</Tables>
<Examples>
<Example Name="Read Workspaces" Desc="Read all workspaces" Code="SELECT * FROM Workspaces" Default="True" />
<Example Name="Read Projects" Desc="Read all projects" Code="SELECT * FROM Projects" />
<Example Name="Read Tasks (default project)" Desc="Read all tasks (default project)" Code="SELECT * FROM Tasks" />
<Example Name="Read Tasks for a specific project" Desc="Read all tasks for a specified project" >
<Code>
<![CDATA[SELECT * FROM Tasks WITH (ProjectId='1200652735638082')]]>
</Code>
</Example>
<Example Name="Read Sub Tasks - First Level (default project)" Desc="Read all first level sub tasks for default project. If you sub tasks for 3rd, 4th level deep then this wont capture." >
<Code>
<![CDATA[SELECT * FROM SubTasks]]>
</Code>
</Example>
<Example Name="Read Sub Tasks - First Level for specified project" Desc="Read all first level sub tasks for a specified project id. If you sub tasks for 3rd, 4th level deep then this wont capture." >
<Code>
<![CDATA[SELECT * FROM SubTasks WITH (ProjectId='1200652735638082')]]>
</Code>
</Example>
<Example Name="Read Sub Tasks for a specified parent task" >
<Code>
<![CDATA[SELECT * FROM SubTasks WITH(QueryBy='task', TaskId='1207150838176996')]]>
</Code>
</Example>
<Example Name="Read Workspace Tasks (All Projects)" >
<Code>
<![CDATA[SELECT * FROM WorkspaceTasks]]>
</Code>
</Example>
<Example Name="Search Tasks (Advanced Filters - Just like Asana Search UI)" >
<Code>
<![CDATA[
--//search text in task title or description
SELECT * FROM search_tasks WITH(Text='Hotfix')
--//search text in all tasks from any projects listed below
SELECT * FROM search_tasks WITH(Text='Hotfix', ProjectsAny='1200652735638082,1206028542305053')
--//list all tasks from any projects listed below
SELECT * FROM search_tasks WITH(Text='Hotfix', ProjectsAny='1200652735638082,1206028542305053')
--//list all tasks due on specified date (same way you can use CreatedOn, CompletedOn ...)
SELECT * FROM search_tasks WITH(DueOn='2024-12-21')
--//list all tasks with due date after specified date (same way you can use CreatedOnAfter, CompletedOnAfter ...)
SELECT * FROM search_tasks WITH(DueOnAfter='2024-12-21')
SELECT * FROM search_tasks WITH(DueOnAfter='yearstart+1d')
--//list all tasks with due date after specified date (same way you can use CreatedOnBefore, CompletedOnBefore ...)
SELECT * FROM search_tasks WITH(DueOnBefore='2024-12-21')
SELECT * FROM search_tasks WITH(DueOnBefore='monthstart-5d')
--//list all tasks with due date after specified datetime (same way you can use CreatedAtBefore, CompletedAtBefore ...)
SELECT * FROM search_tasks WITH(DueAtBefore='2024-12-21T23:59:59')
SELECT * FROM search_tasks WITH(DueAtBefore='now-10h')
--//list all tasks with attachment
SELECT * FROM search_tasks WITH(HasAttachment='true')
]]>
</Code>
</Example>
<Example Name="Download Attachment to Local Disk" Desc="Download Attachment to Local Disk File." >
<Code>
<![CDATA[
SELECT * FROM download_attachment
WITH (
AttachmentId='1208216218258030'
, TargetFilePath='c:\temp\1208216218258030_AWS-refund-request.png'
, FileOverwriteMode=0 --0=AlwaysOverwrite, 1=FailIfExists, 2=SkipIfExists
)
]]>
</Code>
</Example>
<Example Name="Download Multiple Attachments to Local Disk" Desc="Download Multiple Attachments for a specified Parent (e.g. Task, Project, ProjectBrief) to Local Disk Folder. Saved file name syntax is {AttachmentId}_{FileName}." >
<Code>
<![CDATA[
SELECT * FROM download_attachments
WITH (
ParentId='1206673375982078' --Id of Task , Project or ProjectBrief
, SaveFolder='c:\temp'
, OverwriteFile=1
)
]]>
</Code>
</Example>
<Example Name="Read Portfolios for a specified Owner" Desc="Read Portfolios for a specified Owner (Default Workspace)." >
<Code>
<![CDATA[
SELECT * FROM Portfolios WITH(OwnerId='1200442904128317')
]]>
</Code>
</Example>
<Example Name="Read Portfolios for a specified Owner and Workspace" Desc="Read Portfolios for a specified Owner Id and Workspace id." >
<Code>
<![CDATA[
SELECT * FROM Portfolios WITH(OwnerId='1200442904128317', WorkspaceId='1200442900140748')
]]>
</Code>
</Example>
<Example Name="Read Project Goals" Desc="Read Goals for a specified Project Id." >
<Code>
<![CDATA[
SELECT * FROM Goals WITH(Project='1206673375982078')
]]>
</Code>
</Example>
<Example Name="Read Workspace Goals" Desc="Read Goals for a specified Workspace Id." >
<Code>
<![CDATA[
SELECT * FROM Goals WITH(Workspace='1200442900140748')
]]>
</Code>
</Example>
<Example Name="Read Team Goals" Desc="Read Goals for a specified Team Id." >
<Code>
<![CDATA[
SELECT * FROM Goals WITH(Team='1200442900140748')
]]>
</Code>
</Example>
<Example Name="Read Memberships for a project" Desc="Read Memberships for a specific project." >
<Code>
<![CDATA[
SELECT * FROM Memberships WITH(ProjectId=1206673375982078)
]]>
</Code>
</Example>
<Example Name="Read Memberships for a project" Desc="Read Memberships for a specific project." >
<Code>
<![CDATA[
SELECT * FROM Memberships WITH(PortfolioId=1206673375982077)
]]>
</Code>
</Example>
<Example Name="Read Time Entries for a Task" Desc="Read Time Entries for a specific task." >
<Code>
<![CDATA[
SELECT * FROM TimeTrackingEntries WITH(TaskId=1207150837043133)
]]>
</Code>
</Example>
</Examples>
</ApiConfig>
