Asana Connector - Source Code
<ApiConfig Name="Asana" Version="1"
Slug="asana-connector"
Id="871E4C4B-378F-4C3F-A999-12B603CFA164"
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 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" Type="Http" ConnStr="CredentialType=Token;" HelpLink="https://developers.asana.com/docs/personal-access-token" TestEndPoint="get_workspaces">
<Params>
<Param Name="Password" Label="Enter Token (Personal Access Token - PAT)" Secret="True" />
<Param Name="WorkspaceId" Template="T_WorkspaceIdParam" Label="Default Workspace (** Select after Token is entered **)" />
<Param Name="ProjectId" Template="T_ProjectIdParam" Key="project" Label="Default Project (** Select after Token is entered **)" />
<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 PAT (Personal Access Token). .
<ol>
<li>Follow <a href="https://app.asana.com/0/my-apps">this link</a> and click to Create new token.</li>
<li>Once token generated copy it enter in Token field on this UI. Treat Token like a Password, keep it secure.</li>
</ol>
]]>
</Notes>
</Auth>
<Auth Name="OAuth" Type="OAuth" 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" Template="T_WorkspaceIdParam" Label="Default Workspace (** Select after Token is generated **)" />
<Param Name="ProjectId" 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 OAuth App.
<ol>
<li>Follow <a href="https://app.asana.com/0/my-apps">this link</a> and click to Create new app under My Apps.</li>
<li>Give your app a name e.g. My Integration. Check one of the options | Check I Agree | Click Create app</li>
<li>Copy Client Id and Secret. Keep it secure, we will use it later on API Connection UI.</li>
<li>Click on the OAuth section (Under Configure) on your left. Under the Redirect URLs Click [Add redirect URL] button. Enter URL like this <b>https://zappysys.com/oauth</b>. Do not use any random URL otherwise it may not work.</li>
<li>Click on the <b>Manage distribution</b> section (Under Test & distribute) on your left. Here you can add specific workspaces you like to access using this App. If you like to access any workspace then choose [Any workspace] option</li>
<li>Click [Save changes] button. Might be located all the way bottom right on your screen.</li>
<li>Now go back to connection UI and enter ClientId, Client Secret and Redirect URL (match exactly).</li>
<li>Click <b>Generate Token</b> and follow the login prompts. If everything goes well you will see Refresh Token generated.</li>
<li>Choose <b>Default Workspace</b> and <b>Default Project</b>.</li>
<li>Click Test connection to confirm. Now you are ready to use this connection.</li>
</ol>
]]>
</Notes>
</Auth>
</Auths>
<Template>
<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>>"
/>
<EndPoint>
<Param Name="NextUrlAttributeOrExpr" Type="Property" Value="$.next_page.uri" />
<Param Name="Limit" Key="limit" Type="Query" Desc="Results per page. The number of objects to return per page. The value must be between 1 and 100." />
<OutputColumns>
<Column Name="gid" Label="Id" DataType="DT_WSTR" Length="50" />
<Column__ Name="resource_type" Label="ResourceType" DataType="DT_WSTR" Length="100" />
</OutputColumns>
</EndPoint>
<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">
<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>
<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" Type="Query" Key="opt_fields" MultiSelect="True" MultiSelectSeparator="," MultiSelectAllOnBlank="True"
Options="actual_time_minutes
;approval_status
;assignee
;assignee.name
;assignee_section
;assignee_section.name
;assignee_status
;completed
;completed_at
;completed_by
;completed_by.name
;created_at
;created_by
;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"
/>
</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="dependencies" Label="Dependencies" DataType="DT_WSTR" Length="500" />
<Column Name="dependents" Label="Dependents" DataType="DT_WSTR" Length="500" />
<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_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_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_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[*]">
</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" 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[*]">
</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="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="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="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>
