Amazon Selling Partner (SP-API) Connector - Source Code
<ApiConfig Name="Amazon Selling Partner (SP-API)"
Desc="Amazon Selling Partner Connector (SP-API) can be used to integrated SP-API that helps Amazon sellers to programmatically exchange data on listings, orders, payments, reports, and more."
Version="1"
Slug="amazon-selling-partner-connector"
Id="c7682787-9fad-4d72-990a-bd85e8ad17f0"
EngineVersion="16"
Logo="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJYAAACWCAIAAACzY+a1AAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAWJAAAFiQBmxXGFAAAIINJREFUeF7tXQl8U1XWj4AOo36jfq4zjOOM44KI34wjIrgMgo7igiu4gSwqKrLq6AiigmyyyipLC20pBbpvlK2U7vtCSxe677RNkzRp3pr38l7ynfvua0jTFpJ0S4ac3/+XX5rcd+9953/Puefce/OqIGiDB24ND4VuDw+Fbg8PhW4PD4VuDw+Fbg8PhW4PD4VuDw+Fbg8PhW6P/zYKKZanDUaGE1he7Ar4HL6FMjZXuTXcm0KS4TBnmDaAUq1tblXXNTZVVNVWVNdZo7KmrrahqblV06rR4fL4Qndn1F0pBPIAeorV6IgWVVuTUg0A8qJiThwNDt2wacuHH876ZO5nFnz88dx58+b/vH5jcFjEydi4hiYlcCnRqW1rJy0VWjfhLnBXCoE8guHqGprCI6Lnz1/4xLjxQ4YOUTgiv7vxf6a8/vrqteti4+JbVBqoENXZpSHXhztRCFaCXV9js3Kf94GZs2b/618vPPbYmDvuuFOmxUG59tpr/3LvvWOfeOK119/45tulYJ1gkQajyb3M0W0oBM22E3R6ZvaadesXLV4yfvyTMg99JNdff/3rb7717bLvIo8dhyHCi2Z3IdINKIRww2g2nyso8vHz/3zefFnlklxzzTXyu16ITSUvvfLq1u07M7JzSQbZvU1nXBAuTSFoEPhTtbVn5Zz7+ptvZR33EXNdxbraj+d+Gp+YrKcY12fRdSnEuoM481Rs3A3Dr8eaHTp0KH7TfzKko4mRIx/KzMnV6kkXZ9GlKbzYogoJi8AKHTLEsYCzryQ3v0BH0K6cO7oohRB2An+Q4cmKHFQpKauEYMqmh64DV6QQhjyk3v4BR377W9l/Dq4sXvJVYUmZy7LoihSKZvOJ02dGP/IIqG8AJj97JDI6RqenXHNSdDkKGU4oKCxZ8uW/QXHDhg3DGhxEwXPw/AWLIM1gedGmt64Al6MQYoe169Zj9fVT8uCcBBwJFMxmm966AlyIQuymMrPzpr3zLqisly50xIgRo0c/8tBDo+S/JXFuTOCrdv26B4aXC/pS16IQdPTp5/Ow4pyQm2+5Zdy48VNee/2TuZ8u/+HHTVu2rt+wad4XC6ZOe+efEybcffef5HJOyfQZH54+cxZCZZtuDzpciEI9xTY0tbw4+SVZZ3aLxbZmzp6Tlp6lamuH2tpJxgIYHPmFxSt+WoWLOScPjhy513s/TNXWfXYFuAqFeCHt0JFA8H6yzuyTYddeC6+TX3r5THxik1Kl1VO4NqDNAvgT7LutnUxJz8RXOSfr1m/wUNgjwEE1K9WzZs+5+eabZYXZIb8ZPhxev/r31+eLL6i1eqikp2UUIBLiSbDI1PQsfK0T8+IPK35ywaDUVSiE0d2kVN92++2ytuyW195482RsHGi2J/KsAcU0OgI86h//eLd8vSPy3fIfPBT2AMndVVTXyapyRA74HgTu7YwyoBXwqDAvjnNqu3Hpd997KOweeCKMO5soq8oRSUpNNzqSruFp8uVXXpWvd0SWLf+edb1lNpegEGwILCkwxOFF7cVLviooLHHIMkgptJnx4Uy5Ckfk22XfeZKKHgGqaWxudTSjSEpNczTdhsIQ1IA9/WHECLkWuwWSlnPni1ztlJSrUAiaxXlhemZ2YEhYwNHAjZt/ef/96TNnzX5lyhRZhZ0FMgSNTu8QfwBM4bqfN4wc+ZBckd0y7Z13E5JToZ+ONtqvcBUKAaAXiEshewOnerFFVVPXWFJWcaGssuhCOQQg584X5xUU5eafzz2HkFdQCCWdUCWmcP2GTQ+Nelhmxm55e9o7Z9FpDA+FlwXMVeBUAUAnTHIIRpPBAsHMSTAYzfZkEV2BKfwZKOy8fGqPTJ32TnxSiofCwQEoHSgHwMiA9xs2bhnluBW+9fbUM/GJHgr7EaBZCzBhFkDUo9bqIXVp1egampQrf1r9wIMPyszYLdNnzMzMOeehsB8BygUnCWxhaPUUBnxeWFJ6/FRsaHik134fSEX+OWGCQyt5WJYt/8EFj1+4N4VgXtLEiWZNsAwIdhJT0vZ5Hfj+hxULFy958+23X53y2oQJz/5zwrOPjx07+pFHHho16q/33Xf77XcMHz7ciTXSZZ7VmT4B0AamABFNO8UAZwFHAtdv3AR5HtjWex988OZbbz8xbvw99/z5hhtvlBXfd+KhsFcAI8NBKeQbx0+e9j14aPvOXYuXfDlx0nOygvtfPBQ6CWx2MMkVlZSdPH0GJjMntoX7RDwUOgwcWLbpiPKqmsTktGXfLZd1OUjiodAx4MC9WalOTc965933ZC0O3sl8EA+FjgFCzZr6i2vW/SzrzwXEQ6EDMJrMEG1CSnDX738v688FxEOhvRDN5rSMrJmz58ia6wtxIgvsKh4K7QIvmlMzsj79TD5N6pzq7bzK0co9FF4BOP4sLCn9+JO5WGW9jFwefHDkjJmzvvr6Gz//gMDg0KDQ8LCIKEBIWMSs2R+NcHzL10PhldGialuwYBHWl0P8WdvTqIdHL1i4eMsv23z9/GPjErLz8mFwwOTKiWiXCt4ADZu3bH344dHyBXaLh8LLAeV/7eTxU7GjHkZ7QM7xd99990+b9u4v23aUVdYIZkQVIz3iybohoNPp/UIPhZcD6Ppii+rvj/5d1pbj8sADD65Zsw7s2IYzG3go7BeA0kH1kdExsqocEXwg/5UpUxKSU1s1OqgNrwn0BA+F/QJIA8H1WS/B2CnY3059592omBPgh8Eb29TcFR4K+wXgRSGRl/XkuGzbsVPVhh5uaFNtt/BQ2PcA1TcpVU6cA8by2efz0jNzIJu0qbYnYAo3bNwMgatchd3iobB7gBfNySuYPecjWU8OSnBohNaRBxlgCleuWnPvvX+Vq7BbPAcvugfkaglJKdcNc/Jn2fFJKfabIAAohJhn9kcfy9c7Iv9ZuoxwpYNPGC5B4em4eFlJDsrbb0/LyjnnkGXg31R8MH2GXIUjAnGT5zR3NwAbOnk6TlaSgwLuN/fceYcohKgVOHBu399zmrt79IbCzVu3lVfVQkBrU2dPwF606ELZ+CefkqtwRN557/2k1HQPhbYwmsynz5yVleSg7Ph1d1VNvf0UQmtKtXbX7r333X+/XIUjMum5548EBnso7ASkC4oNi4iSleSgfLv0u8KSUvsDfSjZotKMf+ophTNbWIr/ufF3X3/zLdRjzxrCgGGQKQRdgFn4+QfISnJQnv/XCxlZuQbBrogUhgsYEFCOr3VuJ/KVV6fgZTzXgUvMhadinXSkIJBUQExrU2e3ABMsq6j+9NPP5SudkjGPj409m2DnYt7AwL3DGZCIqGP2PH5ZKsCmpGXIl/VCnn7mmWal2v4JuL/hIhSeAdU459lmzZ6TnJp+RUNE53Eysx977DH5st5JYHBoc6vGzlXZ/sbgU9ib1B7LL9t2NLeqewpqwFzA6SUmp370MTrP0ScPyBw//snzxRcYzkOhBKAQ5jNZNw4Kflri5Jde9vHzh3kOEhQAcIYB74HXqtqGmBOnnFuO6Vawt1iz7ufyqho7p+F+xeBTCIrOyj3ntIqH//a38Hrdtddt2LQ5Oze/6ALk+vV1DU2QL0IKDzX/umffnXfehQs756u7Cjblw0eDXOH5+YNPIZgLKH3X7j1YO06ItW9844231v68YfeefWAlU157Xf60r4/x46Gw/McV+YUl0H+bOxpgDD6FOFZMzejVMwoHRX5avaawpIw2XPUUAmDGAgc4cuRIWTduIisRhaUeChEgOm9Va2OOn8Kq6asZ6/IyXHoQJgg+QOWQYNe9dv2GssrqQU8tXIJCAMXwNXWNY8aOxTrqb8EcrF677vsfV1r+tEdgeOER9v4H0xOSUx06MNBPcBkKWWNbOxkRfex3N90ECrJfp46KxcQXLfnyXEFRZk7egkWLrT+/jFhioqXfLYdEs1WjG/RYBuAqFGJodPpVa9Ziz9bnLFqT9PHcT4G8dukJJ3EJSbfe8r/yFz2L5Yn98xcuyiso1FOsK/AHcCEKsUcqraha/sOPWFn2WIadYqnqD3/4w4KFi7Lz8nUk+mdaEEk1Nrdu27HrWjtmxNtuu+3Lr/6dX1gM/HmWuXsEeNTSiuqVq9bIautTufXW22B8KNVt1i2CMSnV2pmz59x00xUeJvTDipVqLZjuIE9+NnA5CgGgI7DFjVt+kTXXR/L008+EhkeCAXVtDj6srKmb9NzzclErsZjvjl27W1Qam2tdAS5KIUxRrRptakbWxIl981iZ4LDwqpp6VVt7TzmAnmJKyipmdfy0GCIXazceGhGl0Tr87FOC5gjGSLCi3mCSwZkt7+FzghUIprcO2RUpBICyYJYCIiFwOBUbt3AhChqdkLmffhZz8lRGVm5zK9rhu0wOBy0CyiprINOQL5bkxRcnx5w4DcGnwd5zchwQg6jizQTLkto6uj6VqTzJVMXCK1sYxJRFM5WnAHRdMqkqI0gdFO4NkY5SyOkN0D8TYRB7P3yuCBxuwOSTnZt/7PhJH1//VavXzpw1+4knxl3XXfTx1FPPTJ780rwvFmzZui3gSGDUseNAHqRuoH17EnCg0Ggyl5RWBIeGB4WEBYWEB4WGxycmQ7YD3bAp3A0YHtkWQ5OaGro2gy1JMJyL5lJ3GE/MEiImCJGThfAJYoBCCHlYiHhOiJhkPD6dT1zL5QQylckkgf7DjXNwkEKSpJT1dH0J1VpLkHqCNQ7A6WZskaBcnZ6+UF51Jj7xSGCw936f7Tt/3bZ957YdGLt27/UKBN1HRqekZdY1NgH9vIh+JQqX21R4GeBUAS60AOi3qwYY0ISOUjUw1Wlcxi9C6AjTXoV5m8K8XWHepTD/2oE9CvPujvfw+Q4E4JWuyyBIwjmrcIRCcDXtLcYzq6FV48npdF0qqdMQFC19OxBBGqgSiAEVAzEAUK4N8Oe0tMdrc22/g6Lp6rPGU9PNXhIxwBNQ2C32dYb0IZeyhGxrRFOjTbV2wCErBJ5IPtVLHk3eCj72XboxDw2fAaHQVcERFEM154lH30Sa2TfEvG+Y2es3Eq43e91k9rpZAry50ex1nXnfNbYU7hvCJ35BaQaCQuQuSHU1l7IJ+Qdoe//1Jp9xfOI3dFMewaJp/KrkEiik6do4IXCM6K8QQm83nniJT17EJy005GxiLgQzZZEIpSFswV4+cZ541MKcxKVM4eeUpgHFqLaVXxkOhzMEzZBtzYbzkchjSD7d5DNcDJnOJ29kqk8ThFpvgPjKJQ6VDCBYsl1DtdRRLTWUspZS1ZNtF0nNRVKrJPQaQq+V0EbqVPAh1drIn11qOiB5MpnCoVzmatDqgFghAlibkWxXG86HiUG3yZPzLoVpv0KImMYn7mAvRJG6JhS4XlVconAU8j8EOeED4ESQN6O0Af5EOaIAfzKlYWLwJMnrYgqHsef3k+0q59TlBIUAyFh5gmxnyo4LMbNQP/DsuBMBHAWX7s2WJVBNRTAGO3o/4PHFIAJuFqXzIkFoQAl0bSalLAd1ybMMY2SqYoTwN1FEiincq6Ab8giKdE5LzlEoAcYdZ6brEoyx35p8/oIoRANKCsa2KUzeELW+z5ZEQRIC3kPuHxpl/72TJeQecINocBNkWxPdVMleiOZj5wghCg7ChcZcNJShGCuwhb5i4N8sVmjyuZNshwzNGS8K6AWFGAYTqangMraa/Ed2uAXANegNdHE3Snr4lK/p+mxSqyIJPUGh//IpEflfw6V0L8AfSRGEntS20nWZXOpS00Ep85MmGhjQXPp2lPhDeVY0ZG0z+Ut+C7QEYz3mZbJdi5LsTtXai15TiAD3QDNV8ULIDfIUbQuIs4eKwQ9z6T/SjZlSDvtfZ4sMT9ee5dKXCaHjUaCHbrnj9vcogDBDrjemEBysMXYFIg8AX/mONORtQqszzs41fUKhBMiNVLWGnG2o0zixtSRAuLte4DH+bDo4SQybwaX9yFREkJoagpUWpdxrsoTxBxYDsx1vJvQqpjzEkLFaiJpjOjTBdOBuxB++X3Tv1yAT3K/gsveREJpK90jqmoWIRdJEKH3r/wLVfF5aIXFyWPcdhWiqM5DaZqYm13jiXXQPEN3sHdaJSLBR8K7g/f2uF4NeEaKWGOPXGfJ9IKkidI16I4rcXJJRKeXF4SVnIvWtdEMaW3yYS9kuxCwVA180HbwL3SAMXDkggFu+Br3fqhDCR7Nlp5GfRI4H/ZiSqYwSj76E9YC86Ik50tqITYsOoO8oRJCGJ8NSF4sMuQeFsJdRR9Fws/IqcG8WLhHHCtPhW4Xo6Xz8Zi47nC2KYqoTqNYSiAf0BiNm1IrUAXG/aCx27BDhDQeaItVVdF0KWxJjyAnmk3YKMZ+JQX+DGQ7dAtyIzBzGMMQlZFn+Ci7Dl6lNJ0g9ugVUM+o/n/i1yWcY1oB4eAJbEtDLW+tbCjE4uHNCr2SqEvmkzWLQs/KsLg9Py61KgA+lG0bLPdsVEAIIUZP4pJWGcyFsWQpTm0s3FlDNJaT2IkHAhA81A6M495ISL0QtDBopDrRfC6BKxBOmCtcjp3RoE4YmwdeR6hq6qYipzWEqsg2FJ/nULcaYtyA0Q72FrmLmbO9oiEye31Djqa8N50PJdiXkx6iVjqZJvVYMmowu3IsKG098SWobLN86h/6gUAKkHDB+CQ1bHChELTQdehTdZKfR2h0s1rkNKQtUZox63Bg7w5DnxZaeYuqL6ZZ6SllHtdZD1I6gVaI5BtgldGg6QVPUlQDMQVSMLtGS7WpS24LqUTdSrXVUSy3d0sBUp7MFB7n01cZTb4mHOzjb0dXaOgO+gtjE734hfDaXuYdSnkfj2Io8NG5Ikq5PM/mOQ3UiE3zAUHAEFbOUcQr9RiGGNNjJ9lZD/k4hbKrJZ6QUrdkN0BeoRrphZKmgRy+FeEQhhP2VT1rIJ803ZK1hiwOY8kim8gQYDanTke3tlwUE/Rq6MZ8pj2bKo9hCHy5jBZ/4GX96qhj8G9GvYwDBKzR6xQFnBdOB+8WjEw2ZG0hVBRq7yCt0VgVa0tLwSQvM++9ANe9S8ElbCF1DNyUdRD9TaAHFkvo2tuSoMXoSRGjoHrpowREMMXvd0LEPcLvZ+06z911m7z+Zvf9q9r5Peu0J+Nu7pfJ3mb1uM3v9TqrnN904eXsgcSwe/pPh3HZSp5acue3ZHBmsQLapxEPXoqt2wXzxAlOTIM+RvcNAUSjN5JD9kO06urGQT/rSBEO++xnFPsBVXSF5syvD5ioMm/ovAygMlYBLQFn5JLYwACwbJjnpNnswKfCo+jamLAZdCxPEIQVTkSBNyc5HMRYMFIUYcIcQiVA0pa6nG0rYojDj8bdQXIe3tkEvNspyIXSsN+1UmPaiHSUuxwfSJ0pZDdOEdAzlsmsrYILaZkPeNkT8XgVbFI4od2prqSsGlkIMGHryKrCKbshlS5O4zIPG4zNgbCK7xKbpInRKRoO6BNGyFzA3lo9fwRbH0TVpKEiGCNnO3RgYu0Q7fbHQUBjHlpxBLrcv7A9jMCi0gDGi3MuIAle6Lok9f5RP9haiPxcDx6LtNCASZyPY9dkot5+AnSQ0Ck0DUPT0kHBsnvHsVi7Lnyk7RrUWo2QRbb8Acw7RIA1cXko07WHdbgwqhRbAIIXbk9Y+qIsZbJEfl7haiFokBr1vChhn8hsBs46sWUynBTYEOApLPVAthpfC5HuLKeBpaFqMWGiMW27I30c1ZRE0gbSPFxlsOj/YcA0KrQF0StZJUATVnM8WHTCkLReOTTUdmmTyecJ0YJR5/5/M+283ew1zLD/pCrgcKvG+CSo0+fyfyXeseOhZIfI1PvkrtsSfaslHO3wo63dw3WDA4XoUWoNiUcJOAoBPllRVMRWRhtxNfPJi47EJQvhoFNaC6VjSuMsDygCkwqKvQgweAfEkf3amIWcjXXOGaikhCUJqi0aNdjm377JwbQph7KPIGy+GgSkwEBRAgowOobS1UJoWSt1MqQBKtL9aeIgtOsIWHe0Bh5mSELo2AwqjS+BCTQvZpiS1rVAhOhMLtF1qC2zOdc3OBi5OoQ2wivFSGVrblE7oACCm58h2JcT3lwGhV4FzltZCBQIgr47iVVaXdpWXx2BTiPiwUqXNtzKwTVjDpgAA2MXr3ZcHTr17qgTD0oo1bMpgXP7bAcLgUYhiFpHQayDBItsaUZqlV6NPgEuLUlAGCdSyBMNIr/gN2vjuVMx+oAqBSKgE0J32kZXDq6W5jkZZiJmhJ9aLL9K1uOSgsjgoFMINSwcvNUrmQrQhd4chewu8MiXhlKqF1IK7w1vY6DQKpbpIXyyhG4s7UEQ3laNibUqpmE3Nl4dUoaYJ14O2YW0LGAhCT7XWoFYaOzVKKWth1oSZ2JpFSt1ENxRQLZU9rosOCAaDQoaHeMSQs148fP2l9E56Axk9l7IYH4qFvIJuqhAPWkWbHQmcyUdhjJlItVzoILtLE90BKqSay4Ro6ejYdgVbHkeQuk6GxRipugQh8gO01WVpDl5/RR0znniDKYvoaA78Nsmn+ZnXKcSQTwhCfamSAceAUyitFrL5+8xew4EbIfwf/NkPucR5AD5ulnBUwZ99Hx1alCmsRKtu+xRC9PN8/Bwu6Qs+broQ8YjJF2V1QtBDdP05+/0Y5OZ0/QVEiZRdcIlLqNaKTguVQGF9khA9B3Us9EkuaR6f+Bm8CuGPot2VXxXi0ecgT0X5BvK3JJ/hb96oEMO+IIjB/PXvQFMoEVMqRPwdVGk8+R44SZQhaMF/gm9soVSNpKYJZYHoh4wWCocacrZQynJSp0Zl1I1MTZZ45D4wES75B6q13K71Yhg66moubRNwz8fOMu+7TjysoOuljVlLGUxhFKKQj/8JZS9tUse0KrY4XAh9HG0SRUyXwiKIvIDCQ1clhRyYQiFyj96/Z/N3EoQOrRRDpIBhFadYUTiMLfBCB8OlkiiWIbRgQ2bvG8UjCqYqtRMNPQC1W5chhD9oOjiJKQ8RQyfACDAURhOU1fRmRSGXvBktZkq9Qu2S7YaCUORRff9B16WhfX+GvmopNCEK/YHCOwzZ6xCF6ICCdaTXUdKawvw9pK5VGvtoKiVIkik+YPJ71OSlYEsT7KAQAlEDEIZ2G8I/IrUNXPIS8M/GM19SzQWXjLgThRvRWJEvZ/VGM11bgBbfDzzAnt+L4hqWuVopxI408lEwAiH8KaYqnVLXS7Zokhi6NKt1QyE2UHilaLbQ2+T7N5gUmfKkK1PIGElNlTH+Z4mbVVADUx5uOjTRdBBGwElkbR3FOlNokvuDfvIiMBWpMALMB0YzZcEQuF69VgjqI7VNhrzdJp/fI790SMGfeY+pjJeOvbRZR5idKCzYS+qU0v4OBC80zJfG2A9QmBM2iq7NRI7OuokugKqY8mgxaLR45BmmLEhaymkSI+abdyi47KMoEZSpsqEQRgw0h9ZpybZ6LuuA+Rfo8JPox5RoNe6qpRAALLZrDFk/iQGPol+9SumEePgmLnUp1Vra8aMLGyvcC2ELGCLZ1kDXp3GpX5t8b4ERwKWvJ9VVVwxnwHtzmfuhvBC9mFKVSKYs8qnrUFgbMZWuPi3ZdycK+YSVZDvEWU2kroVqSDdkrhYD70UnLc58bhWRXrUUYkASrWkwnNtljPwHOnuxC2bHW8Wj/4J8EWJU0KlMYQBQqDDvf9Dk+7TJb6LJd4LZ5zH0yS4FJCGUslLSJoBDeiTaOqAhKEImhuZITaVwYhlcwqXtlqZeI2EwsSWHxaNjwJca8n1kO8YURn8kdeYeqblnTb4TTT5jzPtuQCH0qS+AVFynh0I0waAD/DoVWuOoz+OytkJ4CcMf0nbwq/hpLB1WCOnzY8aY543HJxuPv2A88Sofv4AtDqVUdQTFANNUaxWXtl4MmS+GLZIR/IXx5LdMWZTUipEtOmg6/Lh0vHo11ZgG+TtVn0hXRwrRcyGLN55eKefmFgp3Qwo4yngCmntRwgt87PtsYTDZppK8LsBDoQy0Ng0cEAxDai8y5Qmi/y3mnWArq0l1DcrEZQqHchmr6PoMquUC1VRENRWjHFEP2pTsjxUpZRmXNFcMvlkIuQdDDLrGGDORKT6I6ufMfPz30gavQjwyRgh/VwibJoRNFaI+Mfk+bt4K42MaXRMreVfhkiM98x+oVmpOQksJ+FXUVSgm99xDYSdIZ/gJwhj1jJTyTwGtoTjeMhee94ZcEMqAEpEeYfLDCQYAHTVWUw3ZTHW8Fc7StSlo8YU2kJo6IXwOMuWgF4Vjc4XI6ULkDAkfCpFvmvxHmfyu4zLXogqtKORStqCf6UjNoRbROOtoUerw1U0h3i5AOwYdYMEWBYgzhajnINng4+ZSLaWdKLTOC7tCskWLui8pHZiG9KPgV5PfI2LADWzeHqopi2pIldGYRtfF8fGrUZhz/BOS0EH9lyjslBd2xVVNIdouILVqUqch27WkHqOd1Law5WdQXLNHwRYGEu1KK0d6JQp7AlALln3qA2TZsZ9QTQXI1qUFFwTwsYKZLU1BR0MPPkvXxUP+QDWkeCi8AuTVmQCFEDqGS/4S0gOE5EXymeB9Q8Wwe6jWelAfWFLvKIRJi4WgVwwYZ96u4HL9IBe0qQEYZWrSxCCIeG/j0v6DtqIaUj0UXgFADNVcaowZg9JBfJIMQzr+azz9FtVcIiXO0jL3xXLxADqJy+Ztk1J7nCTYB9aItrQyV6AFBD8FU5vbDSWoM4V87GwU1AQo0AGahiQh7E34k4//CXljm/KXIFGYesC8CqbYD6+yzSaUwOmp1jq6sdyQsRmCTy59HZe6ypC9m6lMplT10gKNXBJ0CiwyNTnSMzMc2BqUAB6bplS1cDndVEbq9civ2pTBnVFWM1WZTG0OakKvpRuLmdpzlApM9grNUcpapjKNbiiC3Mbmq4HE4IQzMMDBJkhNLamuItXV6LWtQUrGwVCsFCc9j0c63AAO0CH+MKQFVQZyR5szE1ZAoVDHUQz0J7wHC+bQnol1sW4AhiidybgqD150AIUVYgd61nJvFWTP5VDGUsz6/eWBS9pZuL8wqBR60BfwUOj28FDo9vBQ6PbwUOj28FDo9vBQ6PbwUOj28FDo9vBQ6PbwUOj28FDo9vBQ6PbwUOj28FDo9vBQ6OagDf8PwsicwCMI92AAAAAASUVORK5CYII="
>
<ServiceUrls>
<ServiceUrl Name="LIVE: North America - US, Canada, Mexico, and Brazil marketplaces (AWS us-east-1)"
Url="https://sellingpartnerapi-na.amazon.com"
Desc="Use this to connect North America (Canada, US, Mexico, and Brazil marketplaces (AWS us-east-1)"/>
<ServiceUrl Name="LIVE: Europe, Asia, Africa - India, South Africa, Saudi Arabia, Egypt, Turkey and U.A.E marketplaces (AWS eu-west-1)"
Url="https://sellingpartnerapi-eu.amazon.com"
Desc="Use this to connect Spain, UK, France, Belgium, Netherlands, Germany, Italy, Sweden, South Africa, Poland, Saudi Arabia, Egypt, Turkey, United Arab Emirates, and India marketplaces (AWS eu-west-1)"/>
<ServiceUrl Name="LIVE: Far East - Singapore, Australia, and Japan marketplaces (AWS us-west-2)"
Url="https://sellingpartnerapi-fe.amazon.com"
Desc="Use this to connect Singapore, Australia, and Japan marketplaces (AWS us-west-2)"/>
<ServiceUrl Name="SANDBOX: North America - US, Canada, Mexico, and Brazil marketplaces (AWS us-east-1)"
Url="https://sandbox.sellingpartnerapi-na.amazon.com"
Desc="Use this to connect North America (Canada, US, Mexico, and Brazil marketplaces (AWS us-east-1). Refer to this link to find sample parameters. Example requests https://github.com/amzn/selling-partner-api-models/blob/main/models/. Open API model file and search for x-amzn-api-sandbox to find sample parameters which you must send to invoke correct sandbox request." HelpLink="https://github.com/amzn/selling-partner-api-models/blob/main/models/"/>
<ServiceUrl Name="SANDBOX: Europe, Asia, Africa - India, South Africa, Saudi Arabia, Egypt, Turkey and U.A.E marketplaces (AWS eu-west-1)"
Url="https://sandbox.sellingpartnerapi-eu.amazon.com"
Desc="Use this to connect Spain, UK, France, Belgium, Netherlands, Germany, Italy, Sweden, South Africa, Poland, Saudi Arabia, Egypt, Turkey, United Arab Emirates, and India marketplaces (AWS eu-west-1). Refer to this link to find sample parameters. Example requests https://github.com/amzn/selling-partner-api-models/blob/main/models/. Open API model file and search for x-amzn-api-sandbox to find sample parameters which you must send to invoke correct sandbox request." HelpLink="https://github.com/amzn/selling-partner-api-models/blob/main/models/"/>
<ServiceUrl Name="SANDBOX: Far East - Singapore, Australia, and Japan marketplaces (AWS us-west-2)"
Url="https://sandbox.sellingpartnerapi-fe.amazon.com"
Desc="Use this to connect Singapore, Australia, and Japan marketplaces (AWS us-west-2). Refer to this link to find sample parameters. Example requests https://github.com/amzn/selling-partner-api-models/blob/main/models/. Open API model file and search for x-amzn-api-sandbox to find sample parameters which you must send to invoke correct sandbox request." HelpLink="https://github.com/amzn/selling-partner-api-models/blob/main/models/"/>
<ServiceUrl Url="https://([\w\d\-.])+\.amazonaws.(com|in|cn|jp)--regex" Hidden="True"/>
<ServiceUrl Url="https://([\w\d\-.])+\.cloudfront.net--regex" Hidden="True"/>
</ServiceUrls>
<Auths>
<Auth Name="OAuthSelf" Label="OAuth (Self Authorize - Private App)" Type="OAuth"
ConnStr="ScopeSeparator={space};UseCustomApp=True;CustomAuthHeader=x-amz-access-token;AccessToken=fake" TestEndPoint="get_marketplaceparticipations">
<Params>
<Param Name="ClientId" />
<Param Name="ClientSecret" Secret="True" />
<Param Name="TokenUrl" Value="https://api.amazon.com/auth/o2/token"/>
<Param Name="TokenUIMode" Value="OnlyRefreshToken" Hidden="True"/>
<Param Name="AuthUrl" Label="AuthUrl (Do not Use for Private App - Self Authorization)"
Hidden="True"
Value="https://sellercentral.amazon.com/apps/authorize/consent?application_id=[YOUR-APPLICATION-ID]&version=beta" />
<Param Name="OrdersApiVersion" Value="v0" Hidden="True"/>
<Param Name="SellerApiVersion" Value="v1" Hidden="True"/>
<Param Name="ShippingApiVersion" Value="v1" Hidden="True"/>
<Param Name="ServicesApiVersion" Value="v1" Hidden="True"/>
<Param Name="FbaApiVersion" Value="v1" Hidden="True"/>
<Param Name="SalesApiVersion" Value="v1" Hidden="True"/>
<Param Name="ReportsApiVersion" Value="2021-06-30" Hidden="True"/>
<Param Name="ProductsFeesApiVersion" Value="v0" Hidden="True"/>
<Param Name="ProductPricingApiVersion" Value="v0" Hidden="True"/>
<Param Name="CatalogItemsApiVersion" Value="2022-04-01" Hidden="True"/>
<Param Name="VendorOrdersApiVersion" Value="v1" Hidden="True"/>
<Param Name="RetryMode" Hidden="True" Value="RetryWhenStatusCodeMatch" />
<Param Name="RetryStatusCodeList" Hidden="True" Value="429" HelpLink="https://developer-docs.amazon.com/sp-api/docs/usage-plans-and-rate-limits-in-the-sp-api"/>
<Param Name="RetryCountMax" Value="5" Hidden="True" />
<Param Name="RetryMultiplyWaitTime" Value="True" Hidden="True" />
</Params>
<Notes>
<![CDATA[To call Amazon SP-API you need to register as Developer and create an App to obtain Client ID / Client Secret. After that authorize to get a Refresh Token. Perform the following steps (Detailed steps found in the each link described below)
<ol>
<li>Go to <a target="_blank" href="https://developer-docs.amazon.com/sp-api/docs/register-as-a-private-developer">Register as a Private App developer</a>. You can wait for day or two to get approval. Check status <a href="https://developer-docs.amazon.com/sp-api/docs/check-the-status-of-your-request-to-register-as-a-developer" target="_blank">this way</a>
<li>Once your Developer account is approved. Login to your account and <a href="https://developer-docs.amazon.com/sp-api/docs/registering-your-application" target="_blank">create a new app</a> and obtain Client ID and Client Secret.
<li>In the very last step can <a href="https://developer-docs.amazon.com/sp-api/docs/self-authorization" target="_blank">click here</a> to learn how to obtain Refresh Token (Self-Authorize).
<li>Copy Client ID, Client Secret and Refresh Token and paste on the Connector UI. Refresh Token field is found under the Grid on the Connector UI and Client ID and Client Secret found in the Grid.
<li>For Video Tutorial <a href="https://community.zappysys.com/t/how-to-call-amazon-sp-api-selling-partner-in-ssis-odbc-apps-e-g-powerbi/213" target="_blank">check this blog post</a>
</ol>
]]>
</Notes>
</Auth>
</Auths>
<Template>
<Param Name="T_Date"
Options="2023-12-31;2023-12-31T00:00:00;now;now-24h;today;yesterday;yearstart-10y;monthstart;monthend;yearstart;yearend;weekstart;weekend;yearstart-1y;yearend-1y;monthstart-1d;monthend+1d;monthend+1d-1y"
ValueTemplate="<<{$value$}|~|yyyy-MM-ddTHH:mm:ss.fffZ|~||~|true,FUN_TO_DATETIME>>"
/>
<Param Name="T_MarketplaceId" Type="Query" Options="United States of America=ATVPDKIKX0DER;Brazil=A2Q3Y263D00KWC;Canada=A2EUQ1WTGCTBG2;Mexico=A1AM78C64UM0Y8;Spain=A1RKKUPIHCS9HS;United Kingdom=A1F83G8C2ARO7P;France=A13V1IB3VIYZZH;Belgium=AMEN7PMS3EDWL;Netherlands=A1805IZSGTT6HS;Germany=A1PA6795UKMFR9;Italy=APJ6JRA9NG5V4;Sweden=A2NODRKZP88ZB9;South Africa=AE08WJ6YKNBMC;Poland=A1C3SOZRARQ6R3;Egypt=ARBP9OOSHTCHU;Turkey=A33AVAJ2PDY3EV;Saudi Arabia=A17E79C6D8DWNP;United Arab Emirates (U.A.E.)=A2VIGQ35RCS4UG;India=A21TJRUUN4KGV;Singapore=A19VAU5U5O7RUS;Australia=A39IBJ37TRP1C6;Japan=A1VC38T7YXB528;"/>
<Param Name="T_MarketplaceIdList" Type="Query" Options="United States of America=ATVPDKIKX0DER;Brazil=A2Q3Y263D00KWC;Canada=A2EUQ1WTGCTBG2;Mexico=A1AM78C64UM0Y8;Spain=A1RKKUPIHCS9HS;United Kingdom=A1F83G8C2ARO7P;France=A13V1IB3VIYZZH;Belgium=AMEN7PMS3EDWL;Netherlands=A1805IZSGTT6HS;Germany=A1PA6795UKMFR9;Italy=APJ6JRA9NG5V4;Sweden=A2NODRKZP88ZB9;South Africa=AE08WJ6YKNBMC;Poland=A1C3SOZRARQ6R3;Egypt=ARBP9OOSHTCHU;Turkey=A33AVAJ2PDY3EV;Saudi Arabia=A17E79C6D8DWNP;United Arab Emirates (U.A.E.)=A2VIGQ35RCS4UG;India=A21TJRUUN4KGV;Singapore=A19VAU5U5O7RUS;Australia=A39IBJ37TRP1C6;Japan=A1VC38T7YXB528;" MultiSelect="True" MultiSelectAllOnBlank="True" MultiSelectSeparator="," Key="marketplaceIds"/>
<Param Name="T_MarketplaceIdPostList" Type="Placeholder" Template="T_MarketplaceIdList" MultiSelectTemplate=""{@value}"" ValueTemplate="[ {$value$} ]" />
<Param Name="T_ReportType" Options="GET_VENDOR_SALES_REPORT;GET_VENDOR_NET_PURE_PRODUCT_MARGIN_REPORT"
HelpLink="https://developer-docs.amazon.com/sp-api/docs/report-type-values"/>
<EndPoint Name="T_Pagination">
<Params>
<Param Name="NextUrlAttributeOrExpr" Type="Property" Value="$.payload.NextToken" />
<Param Name="NextUrlSuffix" Type="Property" Value="NextToken=<%nextlink_encoded%>" />
</Params>
</EndPoint>
<EndPoint Name="T_PaginationCatalog">
<Params>
<Param Name="PageSize" Key="pageSize" Type="Query" Value="20" Hidden="True" />
<Param Name="NextUrlAttributeOrExpr" Type="Property" Value="$.pagination.nextToken" />
<Param Name="NextUrlSuffix" Type="Property" Value="pageToken=<%nextlink_encoded%>" />
</Params>
</EndPoint>
<EndPoint Name="T_PaginationVendor">
<Params>
<Param Name="PageSize" Key="limit" Type="Query" Value="100" Hidden="True" />
<Param Name="NextUrlAttributeOrExpr" Type="Property" Value="$.payload.pagination.nextToken" />
<Param Name="NextUrlSuffix" Type="Property" Value="nextToken=<%nextlink_encoded%>" />
</Params>
</EndPoint>
<EndPoint Name="T_OrdersParams" Url="/orders/[$OrdersApiVersion$]/orders"
Method="GET"
IncludeParentColumns="True"
Filter="$.payload.Orders[*]"
HelpLink="https://developer-docs.amazon.com/sp-api/docs/orders-api-v0-reference#get-ordersv0orders"
>
<Params>
<Param Name="CreatedAfter" Type="Query" Template="T_Date" Value="1900-01-01T00:00:00" Desc="A UTC date used for selecting orders created after (or at) a specified time. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02). If LastUpdatedAfter is not specified. Specifying both CreatedAfter and LastUpdatedAfter returns an error. You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="CreatedBefore" Type="Query" Template="T_Date" Desc="A UTC date used for selecting orders created before (or at) a specified time. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02) You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="LastUpdatedAfter" Type="Query" Template="T_Date" Desc="A UTC date used for selecting orders that were last updated after (or at) a specified time. An update is defined as any change in order status, including the creation of a new order. Includes updates made by Amazon and by the seller. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02). If CreatedAfter is not specified.Specifying both CreatedAfter and LastUpdatedAfter returns an error.If LastUpdatedAfter is specified, then BuyerEmail and SellerOrderId cannot be specified. You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="LastUpdatedBefore" Type="Query" Template="T_Date" Desc="A UTC date used for selecting orders that were last updated before (or at) a specified time. An update is defined as any change in order status, including the creation of a new order. Includes updates made by Amazon and by the seller. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02) You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="OrderStatuses" Type="Query" MultiSelect="True" Options="Pending;Unshipped;PartiallyShipped;PendingAvailability;Shipped;Canceled;Canceled;Unfulfillable" Desc="A list of OrderStatus values. Used to select orders with a current status that matches one of the status values that you specify." />
<Param Name="MarketplaceIds" Template="T_MarketplaceIdList" Required="True" Key="MarketplaceIds"/>
<Param Name="FulfillmentChannels" Type="Query" MultiSelect="True" MultiSelectSeparator="," Options="Fulfilled by Amazon=AFN;Fulfilled by the seller=MFN" Desc="A list that indicates how an order was fulfilled." />
<Param Name="PaymentMethods" Type="Query" MultiSelect="True" MultiSelectSeparator="," Options="Cash on delivery=COD;Convenience store payment=CVS;Any payment method other than COD or CVS=Other" Desc="A list of PaymentMethod values. Used to select orders paid for with the payment methods that you specify." />
<Param Name="BuyerEmail" Type="Query" Desc="The e-mail address of a buyer. Used to select only the orders that contain the specified e-mail address. If BuyerEmail is specified, then FulfillmentChannel, OrderStatus, PaymentMethod, LastUpdatedAfter, LastUpdatedBefore, and SellerOrderId cannot be specified." />
<Param Name="SellerOrderId" Type="Query" Desc="An order identifier that is specified by the seller. Not an Amazon order identifier. Used to select only the orders that match a seller-specified order identifier. If SellerOrderId is specified, then FulfillmentChannel, OrderStatus, PaymentMethod, LastUpdatedAfter, LastUpdatedBefore, and BuyerEmail cannot be specified." />
<Param Name="MaxResultsPerPage" Type="Query" Hidden="True" Desc="A number that indicates the maximum number of orders that can be returned per page. Value must be 1 - 100. Default 100."/>
<Param Name="EasyShipShipmentStatuses" Type="Query" MultiSelect="True" MultiSelectSeparator="," Desc="A list of EasyShipShipmentStatus values. Used to select Easy Ship orders with statuses that match the specified values. If EasyShipShipmentStatus is specified, only Amazon Easy Ship orders are returned.
Possible values:
- PendingSchedule (The package is awaiting the schedule for pick-up.)
- PendingPickUp (Amazon has not yet picked up the package from the seller.)
- PendingDropOff (The seller will deliver the package to the carrier.)
- LabelCanceled (The seller canceled the pickup.)
- PickedUp (Amazon has picked up the package from the seller.)
- DroppedOff (The package is delivered to the carrier by the seller.)
- AtOriginFC (The packaged is at the origin fulfillment center.)
- AtDestinationFC (The package is at the destination fulfillment center.)
- Delivered (The package has been delivered.)
- RejectedByBuyer (The package has been rejected by the buyer.)
- Undeliverable (The package cannot be delivered.)
- ReturningToSeller (The package was not delivered and is being returned to the seller.)
- ReturnedToSeller (The package was not delivered and was returned to the seller.)
- Lost (The package is lost.)
- OutForDelivery (The package is out for delivery.)
- Damaged (The package was damaged by the carrier.)"
Options="PendingSchedule;PendingPickUp;PendingDropOff;LabelCanceled;PickedUp;DroppedOff;AtOriginFC;AtDestinationFC;Delivered;RejectedByBuyer;Undeliverable;ReturningToSeller;ReturnedToSeller ;Lost;OutForDelivery;Damaged"
/>
<Param Name="ElectronicInvoiceStatuses" Type="Query" MultiSelect="True" MultiSelectSeparator="," Desc="A list of ElectronicInvoiceStatus values. Used to select orders with electronic invoice statuses that match the specified values.
Possible values:
- NotRequired (Electronic invoice submission is not required for this order.)
- NotFound (The electronic invoice was not submitted for this order.)
- Processing (The electronic invoice is being processed for this order.)
- Errored (The last submitted electronic invoice was rejected for this order.)
- Accepted (The last submitted electronic invoice was submitted and accepted.)"
Options="NotRequired;NotFound;Processing;Errored;Accepted"
/>
<Param Name="AmazonOrderIds" Type="Query" Desc="Comma separated list of AmazonOrderId values. An AmazonOrderId is an Amazon-defined order identifier, in 3-7-7 format. Max count : 50" />
<Param Name="ActualFulfillmentSupplySourceId" Type="Query" Desc="Denotes the recommended sourceId where the order should be fulfilled from." />
<Param Name="IsISPU" Type="Query" Desc="When true, this order is marked to be picked up from a store rather than delivered." />
<Param Name="StoreChainStoreId" Type="Query" Desc="The store chain store identifier. Linked to a specific store in a store chain."/>
</Params>
</EndPoint>
<EndPoint Name="T_Order">
<OutputColumns>
<Column Name="AmazonOrderId" DataType="DT_WSTR" Length="500" />
<Column Name="PurchaseDate" DataType="DT_DBTIMESTAMP" />
<Column Name="LastUpdateDate" DataType="DT_DBTIMESTAMP" />
<Column Name="OrderStatus" DataType="DT_WSTR" Length="100" />
<Column Name="FulfillmentChannel" DataType="DT_WSTR" Length="50" />
<Column Name="SalesChannel" DataType="DT_WSTR" Length="100" />
<Column Name="ShipServiceLevel" DataType="DT_WSTR" Length="500" />
<Column Name="OrderTotal.CurrencyCode" Label="CurrencyCode" DataType="DT_WSTR" Length="50" />
<Column Name="OrderTotal.Amount" Label="Amount" DataType="DT_WSTR" Length="50" />
<Column Name="NumberOfItemsShipped" DataType="DT_I4" />
<Column Name="NumberOfItemsUnshipped" DataType="DT_I4" />
<Column Name="PaymentMethod" DataType="DT_WSTR" Length="50" />
<Column Name="PaymentMethodDetails" DataType="DT_WSTR" Length="500" />
<Column Name="IsReplacementOrder" DataType="DT_BOOL" />
<Column Name="MarketplaceId" DataType="DT_WSTR" Length="500" />
<Column Name="ShipmentServiceLevelCategory" DataType="DT_WSTR" Length="100" />
<Column Name="OrderType" DataType="DT_WSTR" Length="500" />
<Column Name="EarliestShipDate" DataType="DT_DBTIMESTAMP" />
<Column Name="LatestShipDate" DataType="DT_DBTIMESTAMP" />
<Column Name="EarliestDeliveryDate" DataType="DT_DBTIMESTAMP" />
<Column Name="LatestDeliveryDate" DataType="DT_DBTIMESTAMP" />
<Column Name="IsBusinessOrder" DataType="DT_BOOL" />
<Column Name="IsPrime" DataType="DT_BOOL" />
<Column Name="IsGlobalExpressEnabled" DataType="DT_BOOL" />
<Column Name="IsPremiumOrder" DataType="DT_BOOL" />
<Column Name="IsSoldByAB" DataType="DT_BOOL" />
<Column Name="IsIBA" DataType="DT_BOOL" />
<Column Name="DefaultShipFromLocationAddress.Name" Label="DefaultShipFromName" DataType="DT_WSTR" Length="500" />
<Column Name="DefaultShipFromLocationAddress.AddressLine1" Label="DefaultShipAddressLine1" DataType="DT_WSTR" Length="500" />
<Column Name="DefaultShipFromLocationAddress.City" Label="DefaultShipFromCity" DataType="DT_WSTR" Length="100" />
<Column Name="DefaultShipFromLocationAddress.StateOrRegion" Label="DefaultShipFromStateOrRegion" DataType="DT_WSTR" Length="50" />
<Column Name="DefaultShipFromLocationAddress.PostalCode" Label="DefaultShipFromPostalCode" DataType="DT_WSTR" Length="100" />
<Column Name="DefaultShipFromLocationAddress.CountryCode" Label="DefaultShipFromCountryCode" DataType="DT_WSTR" Length="50" />
<Column Name="DefaultShipFromLocationAddress.Phone" Label="DefaultShipFromPhone" DataType="DT_WSTR" Length="500" />
<Column Name="DefaultShipFromLocationAddress.AddressType" Label="DefaultShipFromAddressType" DataType="DT_WSTR" Length="100" />
<Column Name="FulfillmentInstruction.FulfillmentSupplySourceId" Label="FulfillmentSupplySourceId" DataType="DT_WSTR" Length="500" />
<Column Name="IsISPU" DataType="DT_BOOL" />
<Column Name="IsAccessPointOrder" DataType="DT_BOOL" />
<Column Name="AutomatedShippingSettings.HasAutomatedShippingSettings" Label="HasAutomatedShippingSettings" DataType="DT_BOOL" />
<Column Name="EasyShipShipmentStatus" DataType="DT_WSTR" Length="500" />
<Column Name="ElectronicInvoiceStatus" DataType="DT_WSTR" Length="500" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_OrderItem">
<OutputColumns>
<Column Name="P_payload_AmazonOrderId" Label="AmazonOrderId" DataType="DT_WSTR" Length="50" />
<Column Name="OrderItemId" Label="OrderItemId" DataType="DT_WSTR" Length="50" />
<Column Name="Title" Label="Title" DataType="DT_WSTR" Length="300" />
<Column Name="ASIN" Label="ASIN" DataType="DT_WSTR" Length="50" />
<Column Name="SellerSKU" Label="SellerSKU" DataType="DT_WSTR" Length="50" />
<Column Name="QuantityOrdered" Label="QuantityOrdered" DataType="DT_I8" />
<Column Name="QuantityShipped" Label="QuantityShipped" DataType="DT_I8" />
<Column Name="TaxCollection.Model" Label="Model" DataType="DT_WSTR" Length="100" />
<Column Name="ProductInfo.NumberOfItems" Label="NumberOfItems" DataType="DT_WSTR" Length="4" />
<Column Name="ItemPrice.CurrencyCode" Label="PriceCurrencyCode" DataType="DT_WSTR" Length="10" />
<Column Name="ItemPrice.Amount" Label="PriceAmount" DataType="DT_WSTR" Length="20" />
<Column Name="ItemTax.CurrencyCode" Label="TaxCurrencyCode" DataType="DT_WSTR" Length="10" />
<Column Name="ItemTax.Amount" Label="TaxAmount" DataType="DT_WSTR" Length="20" />
<Column Name="TaxCollection.ResponsibleParty" Label="ResponsibleParty" DataType="DT_WSTR" Length="84" />
<Column Name="BuyerRequestedCancel.IsBuyerRequestedCancel" Label="IsBuyerRequestedCancel" DataType="DT_WSTR" Length="20" />
<Column Name="BuyerRequestedCancel.BuyerCancelReason" Label="BuyerCancelReason" DataType="DT_WSTR" Length="80" />
<Column Name="IsGift" Label="IsGift" DataType="DT_WSTR" Length="20" />
<Column Name="ConditionSubtypeId" Label="ConditionSubtypeId" DataType="DT_WSTR" Length="40" />
<Column Name="IsTransparency" Label="IsTransparency" DataType="DT_BOOL" />
<Column Name="PromotionDiscount.CurrencyCode" Label="PromotionDiscountCurrencyCode" DataType="DT_WSTR" Length="10" />
<Column Name="PromotionDiscount.Amount" Label="PromotionDiscountAmount" DataType="DT_WSTR" Length="20" />
<Column Name="PromotionDiscountTax.CurrencyCode" Label="PromotionDiscountTaxCurrencyCode" DataType="DT_WSTR" Length="10" />
<Column Name="PromotionDiscountTax.Amount" Label="PromotionDiscountTaxAmount" DataType="DT_WSTR" Length="20" />
<Column Name="ConditionId" Label="ConditionId" DataType="DT_WSTR" Length="20" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_VendorPurchaseOrder">
<OutputColumns>
<Column Name="P_payload.orders_purchaseOrderNumber" Label="PurchaseOrderNumber" DataType="DT_WSTR" Length="50" />
<Column Name="P_payload.orders_purchaseOrderState" Label="PurchaseOrderState" DataType="DT_WSTR" Length="50" />
<Column Name="purchaseOrderDate" Label="PurchaseOrderDate" DataType="DT_DBTIMESTAMP" />
<Column Name="purchaseOrderChangedDate" Label="PurchaseOrderChangedDate" DataType="DT_DBTIMESTAMP" />
<Column Name="purchaseOrderStateChangedDate" Label="PurchaseOrderStateChangedDate" DataType="DT_DBTIMESTAMP" />
<Column Name="purchaseOrderType" Label="PurchaseOrderType" DataType="DT_WSTR" Length="50" />
<Column Name="paymentMethod" Label="PaymentMethod" DataType="DT_WSTR" Length="50" />
<Column Name="buyingParty.partyId" Label="BuyingPartyPartyId" DataType="DT_WSTR" Length="50" />
<Column Name="sellingParty.partyId" Label="SellingPartyPartyId" DataType="DT_WSTR" Length="50" />
<Column Name="shipToParty.partyId" Label="ShipToPartyPartyId" DataType="DT_WSTR" Length="50" />
<Column Name="billToParty.partyId" Label="BillToPartyPartyId" DataType="DT_WSTR" Length="50" />
<Column Name="shipWindow" Label="ShipWindow" DataType="DT_WSTR" Length="200" />
<Column Name="items" Label="Items" DataType="DT_NTEXT" />
<Column Name="importDetails.importContainers" Label="ImportContainers" DataType="DT_WSTR" Length="100" />
<Column Name="importDetails.internationalCommercialTerms" Label="InternationalCommercialTerms" DataType="DT_WSTR" Length="500" />
<Column Name="importDetails.methodOfPayment" Label="MethodOfPayment" DataType="DT_WSTR" Length="100" />
<Column Name="importDetails.portOfDelivery" Label="PortOfDelivery" DataType="DT_WSTR" Length="50" />
<Column Name="importDetails.shippingInstructions" Label="ShippingInstructions" DataType="DT_WSTR" Length="2000" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_VendorPurchaseOrderItem">
<OutputColumns>
<Column Name="P_payload.orders_purchaseOrderNumber" Label="PurchaseOrderNumber" DataType="DT_WSTR" Length="50" />
<Column Name="P_payload.orders_purchaseOrderState" Label="PurchaseOrderState" DataType="DT_WSTR" Length="50" />
<Column Name="P_payload.orders_orderDetails_purchaseOrderDate" Label="PurchaseOrderDate" DataType="DT_DBTIMESTAMP" />
<Column Name="P_payload.orders_orderDetails_purchaseOrderChangedDate" Label="PurchaseOrderChangedDate" DataType="DT_DBTIMESTAMP" />
<Column Name="P_payload.orders_orderDetails_purchaseOrderStateChangedDate" Label="PurchaseOrderStateChangedDate" DataType="DT_DBTIMESTAMP" />
<Column Name="P_payload.orders_orderDetails_purchaseOrderType" Label="PurchaseOrderType" DataType="DT_WSTR" Length="50" />
<Column Name="P_payload.orders_orderDetails_importDetails_importContainers" Label="ImportContainers" DataType="DT_WSTR" Length="100" />
<Column Name="P_payload.orders_orderDetails_importDetails_internationalCommercialTerms" Label="InternationalCommercialTerms" DataType="DT_WSTR" Length="100" />
<Column Name="P_payload.orders_orderDetails_importDetails_methodOfPayment" Label="MethodOfPayment" DataType="DT_WSTR" Length="50" />
<Column Name="P_payload.orders_orderDetails_importDetails_portOfDelivery" Label="PortOfDelivery" DataType="DT_WSTR" Length="50" />
<Column Name="P_payload.orders_orderDetails_importDetails_shippingInstructions" Label="ShippingInstructions" DataType="DT_WSTR" Length="2000" />
<Column Name="P_payload.orders_orderDetails_paymentMethod" Label="PaymentMethod" DataType="DT_WSTR" Length="50" />
<Column Name="P_payload.orders_orderDetails_buyingParty_partyId" Label="BuyingPartyPartyId" DataType="DT_WSTR" Length="50" />
<Column Name="P_payload.orders_orderDetails_sellingParty_partyId" Label="SellingPartyPartyId" DataType="DT_WSTR" Length="50" />
<Column Name="P_payload.orders_orderDetails_shipToParty_partyId" Label="ShipToPartyPartyId" DataType="DT_WSTR" Length="50" />
<Column Name="P_payload.orders_orderDetails_billToParty_partyId" Label="BillToPartyPartyId" DataType="DT_WSTR" Length="50" />
<Column Name="P_payload.orders_orderDetails_shipWindow" Label="ShipWindow" DataType="DT_WSTR" Length="200" />
<Column Name="itemSequenceNumber" Label="ItemSequenceNumber" DataType="DT_WSTR" Length="6" />
<Column Name="amazonProductIdentifier" Label="AmazonProductIdentifier" DataType="DT_WSTR" Length="50" />
<Column Name="vendorProductIdentifier" Label="VendorProductIdentifier" DataType="DT_WSTR" Length="50" />
<Column Name="orderedQuantity.amount" Label="OrderedQuantityAmount" DataType="DT_I8" />
<Column Name="orderedQuantity.unitOfMeasure" Label="OrderedQuantityUnitOfMeasure" DataType="DT_WSTR" Length="50" />
<Column Name="orderedQuantity.unitSize" Label="OrderedQuantityUnitSize" DataType="DT_I8" />
<Column Name="isBackOrderAllowed" Label="IsBackOrderAllowed" DataType="DT_BOOL" />
<Column Name="netCost.amount" Label="NetCostAmount" DataType="DT_WSTR" Length="40" />
<Column Name="netCost.currencyCode" Label="NetCostCurrencyCode" DataType="DT_WSTR" Length="12" />
<Column Name="listPrice.amount" Label="ListPriceAmount" DataType="DT_WSTR" Length="40" />
<Column Name="listPrice.currencyCode" Label="ListPriceCurrencyCode" DataType="DT_WSTR" Length="12" />
</OutputColumns>
</EndPoint>
<EndPoint Name="T_Report" Group="Reports" Url="/reports/[$ReportsApiVersion$]/reports"
Method="POST"
Desc="Returns data from the specified report type. You can check following link for various available reports (list updated frequently), you can access report based on API Key role / permission, participation (e.g. Vendor/Seller), seller market place etc http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html. Depending on which Report you choose, it can take upto 30 minutes to generate report. Also some reports have strict limits on how many times you can access per hour (e.g. 2 times per 30 minutes). Check documentation for call limits."
AllowParamBindForLayoutMap="True" ContentType="application/json" JsonRowFormat="Multicontent"
Body="{$rows$}"
NoOutputColumns="True" MetaScanRows = "3000" CachedTtl="600"
HelpLink="https://developer-docs.amazon.com/sp-api/docs/report-type-values"
>
<LayoutMap>
<![CDATA[<?xml version="1.0" encoding="utf-8"?>
<settings>
<dataset id="root" readfrominput="True" />
<map name="reportType" src="ReportType" />
<map name="dataStartTime" src="StartDate" />
<map name="dataEndTime" src="EndDate" />
<map name="marketplaceIds" src="MarketplaceIds" fragment="True"/>
<map name="reportOptions" src="ReportOptions" fragment="True"/>
</settings>
]]>
</LayoutMap>
<Params>
<Param Name="StartDate" Template="T_Date" Type="Placeholder" Label="		StartDate" Desc="Report Start date if applicable - Must be UTC date in ISO format e.g. (2020-01-31T00:00:00Z). You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="EndDate" Template="T_Date" Type="Placeholder" Label="	EndDate" Desc="Report End date if applicable - Must be UTC date in ISO format e.g. (2020-01-31T00:00:00Z). You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="MarketplaceIds" Template="T_MarketplaceIdPostList" Required="True" Type="Placeholder" />
<Param Name="ReportOptions" OptionsEndPoint="get_report_options" OptionsEndPointValueColumn="OptionNameValue" OptionsEndPointParameters="Filter=$.data[?(@id=='[$ReportType$]')].opt[*].v[*]"
MultiSelect="True" MultiSelectSeparator="," ValueTemplate="{ {$value$} }" />
<Param Name="DateParseHandling" Type="Property" Value="DateTime" Hidden="False"/>
<Param Name="FileCompressionType" Type="Property" Hidden="False"/>
</Params>
</EndPoint>
<EndPoint Name="T_ReportData" TreatBodyAsDirectValue="True" Filter="$.data[*].opt[*].v[*]" IncludeParentColumns="True" >
<Body>
<![CDATA[
{
data:[
{ format:'JSON',cat:'Analytics Reports',id:'GET_BRAND_ANALYTICS_MARKET_BASKET_REPORT',name:'Market Basket Analysis Report', fil:[{v:"$.dataByAsin"}], opt:[{k:"reportPeriod", v: ["DAY","WEEK","MONTH","QUARTER"]}] },
{ format:'JSON',cat:'Analytics Reports',id:'GET_BRAND_ANALYTICS_SEARCH_TERMS_REPORT',name:'Amazon Search Terms Report', fil:[{v:"$.dataByDepartmentAndSearchTerm"}], opt:[{k:"reportPeriod", v: ["DAY","WEEK","MONTH","QUARTER"]}] },
{ format:'JSON',cat:'Analytics Reports',id:'GET_BRAND_ANALYTICS_REPEAT_PURCHASE_REPORT',name:'Repeat Purchase', fil:[{v:"$.dataByAsin"}], opt:[{k:"reportPeriod", v: ["WEEK","MONTH","QUARTER"]}] },
{ format:'JSON',cat:'Analytics Reports',id:'GET_VENDOR_REAL_TIME_INVENTORY_REPORT',name:'Rapid Retail Analytics Inventory Report', fil:[{v:"$.reportData"}], opt:[] },
{ format:'JSON',cat:'Analytics Reports',id:'GET_VENDOR_REAL_TIME_TRAFFIC_REPORT',name:'Rapid Retail Analytics Traffic Report', fil:[{v:"$.reportData"}], opt:[] },
{ format:'JSON',cat:'Analytics Reports',id:'GET_VENDOR_REAL_TIME_SALES_REPORT',name:'Rapid Retail Analytics Sales Report', fil:[{v:"$.reportData"}], opt:[] },
{ format:'JSON',cat:'Analytics Reports',id:'GET_VENDOR_SALES_REPORT',name:'Vendor Sales Report', fil:[{v:"$.salesByAsin"},{v:"$.salesAggregate"}], opt:[{k:"reportPeriod", v: ["DAY","WEEK","MONTH","QUARTER"]},{k:"distributorView", v: ["MANUFACTURING","SOURCING"]}, {k:"sellingProgram", v: ["RETAIL","BUSINESS","FRESH"]}] },
{ format:'JSON',cat:'Analytics Reports',id:'GET_VENDOR_NET_PURE_PRODUCT_MARGIN_REPORT',name:'Net Pure Product Margin Report', fil:[{v:"$.netPureProductMarginAggregate"},{v:"$.netPureProductMarginByAsin"}], opt:[{k:"reportPeriod", v: ["DAY","WEEK","MONTH","QUARTER"]}] },
{ format:'JSON',cat:'Analytics Reports',id:'GET_VENDOR_TRAFFIC_REPORT',name:'Vendor Traffic Report', fil:[{v:"$.netPureProductMarginByAsin"},{v:"trafficByAsin"}], opt:[{k:"reportPeriod", v: ["DAY","WEEK","MONTH","QUARTER"]}] },
{ format:'JSON',cat:'Analytics Reports',id:'GET_VENDOR_FORECASTING_REPORT',name:'Vendor Forecasting Report', fil:[{v:"$.forecastByAsin"}], opt:[{k:"sellingProgram", v: ["RETAIL","FRESH"]}] },
{ format:'JSON',cat:'Analytics Reports',id:'GET_VENDOR_INVENTORY_REPORT',name:'Vendor Inventory Report', fil:[{v:"$.inventoryAggregate"},{v:"$.inventoryByAsin"}], opt:[{k:"reportPeriod", v: ["DAY","WEEK","MONTH","QUARTER"]},{k:"distributorView", v: ["MANUFACTURING","SOURCING"]}, {k:"sellingProgram", v: ["RETAIL","FRESH"]}] },
{ format:'JSON',cat:'Analytics Reports',id:'GET_SALES_AND_TRAFFIC_REPORT',name:'Sales and Traffic Business Report', fil:[{v:"$.salesAndTrafficByDate"},{v:"$.salesAndTrafficByAsin"}], opt:[{k:"dateGranularity", v: ["DAY","WEEK","MONTH"]},{k:"asinGranularity", v: ["PARENT","CHILD","SKU"]}] },
{ format:'TSV',cat:'Inventory Reports',id:'GET_FLAT_FILE_OPEN_LISTINGS_DATA',name:'Inventory Report (Open Listing)', fil:[], opt:[{k:"custom", v: ["true"]}] },
{ format:'TSV',cat:'Inventory Reports',id:'GET_MERCHANT_LISTINGS_ALL_DATA',name:'All Listings Report', fil:[], opt:[{k:"custom", v: ["true"]}] },
{ format:'TSV',cat:'Inventory Reports',id:'GET_MERCHANT_LISTINGS_DATA',name:'Active Listings Report', fil:[], opt:[] },
{ format:'TSV',cat:'Inventory Reports',id:'GET_MERCHANT_LISTINGS_INACTIVE_DATA',name:'Inactive Listings Report', fil:[], opt:[] },
{ format:'TSV',cat:'Inventory Reports',id:'GET_MERCHANT_LISTINGS_DATA_BACK_COMPAT',name:'Open Listings Report', fil:[], opt:[{k:"custom", v: ["true"]}] },
{ format:'TSV',cat:'Inventory Reports',id:'GET_MERCHANT_LISTINGS_DATA_LITE',name:'Open Listings Report Lite', fil:[], opt:[] },
{ format:'TSV',cat:'Inventory Reports',id:'GET_MERCHANT_LISTINGS_DATA_LITER',name:'Open Listings Report Liter', fil:[], opt:[] },
{ format:'TSV',cat:'Inventory Reports',id:'GET_MERCHANT_CANCELLED_LISTINGS_DATA',name:'Canceled Listings Report', fil:[], opt:[{k:"custom", v: ["true"]}] },
{ format:'TSV',cat:'Inventory Reports',id:'GET_MERCHANTS_LISTINGS_FYP_REPORT',name:'Suppressed Listings Report', fil:[], opt:[] },
{ format:'TSV',cat:'Inventory Reports',id:'GET_PAN_EU_OFFER_STATUS',name:'Pan-European Eligibility: FBA ASINs', fil:[], opt:[] },
{ format:'TSV',cat:'Inventory Reports',id:'GET_MFN_PANEU_OFFER_STATUS',name:'Pan-European Eligibility: Self-fulfilled ASINs', fil:[], opt:[] },
{ format:'TSV',cat:'Inventory Reports',id:'GET_REFERRAL_FEE_PREVIEW_REPORT',name:'Referral Fee Preview Report', fil:[], opt:[] },
{ format:'TSV',cat:'Order Reports',id:'GET_FLAT_FILE_ACTIONABLE_ORDER_DATA_SHIPPING',name:'Unshipped Orders Report', fil:[], opt:[{k:"ShowSalesChannel", v: ["true"]}] },
{ format:'XML',cat:'Order Reports',id:'GET_ORDER_REPORT_DATA_INVOICING',name:'Scheduled XML Order Report (Invoicing) - For EU Market', fil:[], opt:[] },
{ format:'XML',cat:'Order Reports',id:'GET_ORDER_REPORT_DATA_TAX',name:'Scheduled XML Order Report (Tax) - For NA Market', fil:[], opt:[] },
{ format:'XML',cat:'Order Reports',id:'GET_ORDER_REPORT_DATA_SHIPPING',name:'Scheduled XML Order Report (Shipping)', fil:[], opt:[] },
{ format:'TSV',cat:'Order Reports',id:'GET_FLAT_FILE_ORDER_REPORT_DATA_INVOICING',name:'Requested or Scheduled Flat File Order Report (Invoicing) - For EU Market', fil:[], opt:[{k:"ShowSalesChannel", v: ["true"]}] },
{ format:'TSV',cat:'Order Reports',id:'GET_FLAT_FILE_ORDER_REPORT_DATA_SHIPPING',name:'Requested or Scheduled Flat File Order Report (Shipping)', fil:[], opt:[{k:"ShowSalesChannel", v: ["true"]}] },
{ format:'TSV',cat:'Order Reports',id:'GET_FLAT_FILE_ORDER_REPORT_DATA_TAX',name:'Requested or Scheduled Flat File Order Report (Tax) - For NA Market', fil:[], opt:[{k:"ShowSalesChannel", v: ["true"]}] },
{ format:'TSV',cat:'Order Reports',id:'GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL',name:'Flat File Orders By Last Update Report', fil:[], opt:[] },
{ format:'TSV',cat:'Order Reports',id:'GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL',name:'Flat File Orders By Order Date Report', fil:[], opt:[] },
{ format:'TSV',cat:'Order Reports',id:'GET_FLAT_FILE_ARCHIVED_ORDERS_DATA_BY_ORDER_DATE',name:'Flat File Archived Orders Report', fil:[], opt:[] },
{ format:'XML',cat:'Order Reports',id:'GET_XML_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL',name:'XML Orders By Last Update Report', fil:[], opt:[] },
{ format:'XML',cat:'Order Reports',id:'GET_XML_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL',name:'XML Orders By Order Date Report', fil:[], opt:[] },
{ format:'TSV',cat:'Order Reports',id:'GET_FLAT_FILE_PENDING_ORDERS_DATA',name:'Flat File Pending Orders Report', fil:[], opt:[] },
{ format:'XML',cat:'Order Reports',id:'GET_PENDING_ORDERS_DATA',name:'XML Pending Orders Report', fil:[], opt:[] },
{ format:'TSV',cat:'Order Reports',id:'GET_CONVERGED_FLAT_FILE_PENDING_ORDERS_DATA',name:'Converged Flat File Pending Orders Report', fil:[], opt:[] },
{ format:'XML',cat:'Returns Reports',id:'GET_XML_RETURNS_DATA_BY_RETURN_DATE',name:'XML Returns Report by Return Date', fil:[], opt:[] },
{ format:'TSV',cat:'Returns Reports',id:'GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE',name:'Flat File Returns Report by Return Date', fil:[], opt:[] },
{ format:'XML',cat:'Returns Reports',id:'GET_XML_MFN_PRIME_RETURNS_REPORT',name:'XML Prime Returns Report by Return Date', fil:[], opt:[] },
{ format:'TSV',cat:'Returns Reports',id:'GET_CSV_MFN_PRIME_RETURNS_REPORT',name:'CSV Prime Returns Report by Return Date', fil:[], opt:[] },
{ format:'XML',cat:'Returns Reports',id:'GET_XML_MFN_SKU_RETURN_ATTRIBUTES_REPORT',name:'XML Return Attributes Report by Return Date', fil:[], opt:[] },
{ format:'TSV',cat:'Returns Reports',id:'GET_FLAT_FILE_MFN_SKU_RETURN_ATTRIBUTES_REPORT',name:'Flat File Return Attributes Report by Return Date', fil:[], opt:[] },
{ format:'TSV',cat:'Performance Reports',id:'GET_SELLER_FEEDBACK_DATA',name:'Flat File Feedback Report', fil:[], opt:[] },
{ format:'XML',cat:'Performance Reports',id:'GET_V1_SELLER_PERFORMANCE_REPORT',name:'XML Customer Metrics Report', fil:[], opt:[] },
{ format:'TSV',cat:'Performance Reports',id:'GET_V2_SELLER_PERFORMANCE_REPORT',name:'Seller Performance Report', fil:[], opt:[] },
{ format:'JSON',cat:'Performance Reports',id:'GET_PROMOTION_PERFORMANCE_REPORT',name:'Promotions Performance Report', fil:[{v:"$.promotions"}], opt:[{k:"promotionStartDateFrom", v: ["2022-01-01T00:00:00Z","today","yesterday","today-1d","monthstart-1d","monthstart-1m+1d","yearstart-1d+1y"]},{k:"promotionStartDateTo", v: ["2022-01-01T00:00:00Z","today","yesterday","today-1d","monthstart-1d","monthstart-1m+1d","yearstart-1d+1y"]}] },
{ format:'JSON',cat:'Performance Reports',id:'GET_COUPON_PERFORMANCE_REPORT',name:'Coupons Performance Report', fil:[{v:"$.coupons"}], opt:[{k:"campaignStartDateFrom", v: ["2022-01-01T00:00:00Z","today","yesterday","today-1d","monthstart-1d","monthstart-1m+1d","yearstart-1d+1y"]},{k:"campaignStartDateTo", v: ["2022-01-01T00:00:00Z","today","yesterday","today-1d","monthstart-1d","monthstart-1m+1d","yearstart-1d+1y"]}] },
{ format:'SCHEDULED-TSV',cat:'Settlement Reports',id:'GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE',name:'Flat File Settlement Report', fil:[], opt:[] },
{ format:'SCHEDULED-XML',cat:'Settlement Reports',id:'GET_V2_SETTLEMENT_REPORT_DATA_XML',name:'XML Settlement Report', fil:[], opt:[] },
{ format:'SCHEDULED-TSV',cat:'Settlement Reports',id:'GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2',name:'Flat File V2 Settlement Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_AMAZON_FULFILLED_SHIPMENTS_DATA_GENERAL',name:'FBA Amazon Fulfilled Shipments Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_AMAZON_FULFILLED_SHIPMENTS_DATA_INVOICING',name:'FBA Amazon Fulfilled Shipments Report (Invoicing)', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_AMAZON_FULFILLED_SHIPMENTS_DATA_TAX',name:'FBA Amazon Fulfilled Shipments Report (Tax)', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL',name:'Flat File All Orders Report by Last Update', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL',name:'Flat File All Orders Report by Order Date', fil:[], opt:[] },
{ format:'XML',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_XML_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL',name:'XML All Orders Report by Last Update', fil:[], opt:[] },
{ format:'XML',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_XML_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL',name:'XML All Orders Report by Order Date', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_SALES_DATA',name:'FBA Customer Shipment Sales Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_PROMOTION_DATA',name:'FBA Promotions Report - For NA Market Only', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_FULFILLMENT_CUSTOMER_TAXES_DATA',name:'FBA Customer Taxes', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_REMOTE_FULFILLMENT_ELIGIBILITY',name:'Remote Fulfillment Eligibility', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_AFN_INVENTORY_DATA',name:'FBA Amazon Fulfilled Inventory Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_AFN_INVENTORY_DATA_BY_COUNTRY',name:'FBA Multi-Country Inventory Report - For EU Market Only', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_LEDGER_SUMMARY_VIEW_DATA',name:'Inventory Ledger Report - Summary View', fil:[], opt:[{k:"aggregateByLocation", v: ["COUNTRY","FC"]},{k:"aggregatedByTimePeriod", v: ["MONTHLY","WEEKLY","DAILY"]},{k:"eventType", v:["","Adjustments","CustomerReturns","Receipts","Shipments","VendorReturns","WhseTransfers"]},{k:"FNSKU", v: ["some_value"]},{k:"MSKU", v: ["some_value"]},{k:"ASIN", v: ["some_value"]}] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_LEDGER_DETAIL_VIEW_DATA',name:'Inventory Ledger Report - Detailed View', fil:[], opt:[{k:"eventType", v:["","Adjustments","CustomerReturns","Receipts","Shipments","VendorReturns","WhseTransfers"]},{k:"FNSKU", v: ["some_value"]},{k:"MSKU", v: ["some_value"]},{k:"ASIN", v: ["some_value"]}] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_RESERVED_INVENTORY_DATA',name:'FBA Reserved Inventory Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_MYI_UNSUPPRESSED_INVENTORY_DATA',name:'FBA Manage Inventory', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_MYI_ALL_INVENTORY_DATA',name:'FBA Manage Inventory - Archived', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_RESTOCK_INVENTORY_RECOMMENDATIONS_REPORT',name:'Restock Inventory Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_FULFILLMENT_INBOUND_NONCOMPLIANCE_DATA',name:'FBA Inbound Performance Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_STRANDED_INVENTORY_UI_DATA',name:'FBA Stranded Inventory Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_STRANDED_INVENTORY_LOADER_DATA',name:'FBA Bulk Fix Stranded Inventory Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_STORAGE_FEE_CHARGES_DATA',name:'FBA Storage Fees Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_INVENTORY_PLANNING_DATA',name:'FBA Manage Inventory Health Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_OVERAGE_FEE_CHARGES_DATA',name:'FBA Inventory Storage Overage Fees Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_ESTIMATED_FBA_FEES_TXT_DATA',name:'FBA Fee Preview Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_REIMBURSEMENTS_DATA',name:'FBA Reimbursements Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_FULFILLMENT_LONGTERM_STORAGE_FEE_CHARGES_DATA',name:'FBA Long Term Storage Fee Charges Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_FULFILLMENT_CUSTOMER_RETURNS_DATA',name:'FBA Returns Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_REPLACEMENT_DATA',name:'FBA Replacements Report - For NA, IN Markets only', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_RECOMMENDED_REMOVAL_DATA',name:'FBA Recommended Removal Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA',name:'FBA Removal Order Detail Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL_DATA',name:'FBA Removal Shipment Detail Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_SNS_FORECAST_DATA',name:'Subscribe and Save Forecast Report', fil:[], opt:[] },
{ format:'TSV',cat:'Fulfillment by Amazon (FBA) Reports',id:'GET_FBA_SNS_PERFORMANCE_DATA',name:'Subscribe and Save Performance Report', fil:[], opt:[] },
{ format:'CSV',cat:'Tax Reports',id:'GST_MTR_STOCK_TRANSFER_REPORT',name:'GST Merchant Stock Transfer Report - For IN Market Only', fil:[], opt:[] },
{ format:'CSV',cat:'Tax Reports',id:'GST_MTR_B2B',name:'GST Merchant Tax Report - Business to Business - For IN Market Only', fil:[], opt:[] },
{ format:'CSV',cat:'Tax Reports',id:'GST_MTR_B2C',name:'GST Merchant Tax Report - Business to Customer - For IN Market Only', fil:[], opt:[] },
{ format:'TSV',cat:'Tax Reports',id:'GET_FLAT_FILE_SALES_TAX_DATA',name:'Sales Tax Report', fil:[], opt:[] },
{ format:'CSV',cat:'Tax Reports',id:'SC_VAT_TAX_REPORT',name:'Amazon VAT Calculation Report - For Germany, Spain, Italy, France, Netherlands, Sweden, Poland, Belgium, and UK marketplaces', fil:[], opt:[] },
{ format:'TSV',cat:'Tax Reports',id:'GET_VAT_TRANSACTION_DATA',name:'Amazon VAT Transactions Report- For Germany, Spain, Italy, France, and UK marketplaces', fil:[], opt:[] },
{ format:'TSV',cat:'Tax Reports',id:'GET_GST_MTR_B2B_CUSTOM',name:'On Demand GST Merchant Tax Report B2B', fil:[], opt:[] },
{ format:'TSV',cat:'Tax Reports',id:'GET_GST_MTR_B2C_CUSTOM',name:'On Demand GST Merchant Tax Report B2C', fil:[], opt:[] },
{ format:'CSV',cat:'Tax Reports',id:'GET_GST_STR_ADHOC',name:'On Demand Stock Transfer Report', fil:[], opt:[] },
{ format:'TSV',cat:'Invoice Data Reports',id:'GET_FLAT_FILE_VAT_INVOICE_DATA_REPORT',name:'Flat File VAT Invoice Data Report (VIDR) - For Spain, UK, France, Netherlands, Germany, Italy, Sweden, Poland', fil:[], opt:[{k:"ReportOption=pendingInvoices", v:["true"]},{k:"ReportOption=All", v:["true"]}] },
{ format:'XML',cat:'Invoice Data Reports',id:'GET_XML_VAT_INVOICE_DATA_REPORT',name:'XML VAT Invoice Data Report (VIDR) - For Spain, UK, France, Netherlands, Germany, Italy, Sweden, Poland', fil:[], opt:[{k:"ReportOption=pendingInvoices", v:["true"]},{k:"ReportOption=All", v:["true"]}] },
{ format:'XML',cat:'Browse Tree Reports',id:'GET_XML_BROWSE_TREE_DATA',name:'Browse Tree Report', fil:[], opt:[] },
{ format:'TSV',cat:'Easy Ship Reports',id:'GET_EASYSHIP_DOCUMENTS',name:'EasyShip Report', fil:[], opt:[] },
{ format:'PDF',cat:'Easy Ship Reports',id:'GET_EASYSHIP_PICKEDUP',name:'EasyShip Picked Up Report', fil:[], opt:[] },
{ format:'TSV',cat:'Easy Ship Reports',id:'GET_EASYSHIP_WAITING_FOR_PICKUP',name:'EasyShip Waiting for Pick Up Report', fil:[], opt:[] },
{ format:'XLSX',cat:'Amazon Business Reports',id:'FEE_DISCOUNTS_REPORT',name:'Referral Fee Discounts Report', fil:[], opt:[] },
{ format:'CSV',cat:'B2B product opportunities reports',id:'GET_B2B_PRODUCT_OPPORTUNITIES_RECOMMENDED_FOR_YOU',name:'B2B Product Opportunities - Recommended for You Report - For US,Spain,UK,France,Germany,Italy,India,Japan', fil:[], opt:[{k:"categories", v:["some_category1;some_category2;some_category3","Luggage;Wireless;Groceries"]},{k:"subCategories", v:["some_sub_category1;some_sub_category2;some_sub_category3","9100 Backpacks;1500 Navigation Electronics"]},{k:"depersonalized", v:["true"]},{k:"filterMode", v:["include","exclude"]}] },
{ format:'CSV',cat:'B2B product opportunities reports',id:'GET_B2B_PRODUCT_OPPORTUNITIES_NOT_YET_ON_AMAZON',name:'B2B Product Opportunities - Not yet on Amazon - For US,Spain,UK,France,Germany,Italy,India,Japan', fil:[], opt:[{k:"categories", v:["some_category1;some_category2;some_category3","Luggage;Wireless;Groceries"]},{k:"depersonalized", v:["true"]},{k:"filterMode", v:["include","exclude"]}] },
{ format:'TSV',cat:'Regulatory Compliance Reports',id:'END_USER_DATA_REPORT',name:'End User Data Report - For DE, FR, IT, ES, NL, PL, SE and BE (EU-8) markets', fil:[], opt:[{k:"reportPeriod", v: ["DAY","WEEK","MONTH"]}] },
{ format:'TSV',cat:'Regulatory Compliance Reports',id:'FBA_BULK_INVOICE',name:'FBA Bulk Invoice', fil:[], opt:[{k:"orderIds", v:["orderid_1,orderid_2,orderid_3"]},{k:"transactionTypes", v:["SHIPMENT","REFUND","CANCEL","EINVOICE_CANCEL","FC_TRANSFER","FC_TRANSFER_CANCEL","FC_REMOVAL","FC_REMOVAL_CANCEL","MCF_SHIPMENT","MCF_CANCEL","MCF_REFUND"]},{k:"invoiceTypes", v:["CUSTOMER_COPY","SELLER_COPY","TRANSPORTER_COPY"]}] },
{ format:'JSON',cat:'Regulatory Compliance Reports',id:'MARKETPLACE_ASIN_PAGE_VIEW_METRICS',name:'Marketplace ASIN Page View Metrics - For DE, FR, IT, ES, NL, PL, SE, BE (EU-8) and UK markets', fil:[{v:"$.marketplaceAsinPageViewMetrics"}], opt:[{k:"productType", v:["some_product_type","AUTO_BATTERY","LUGGAGE","..."]}] },
{ format:'CSV',cat:'Regulatory Compliance Reports',id:'GET_EPR_MONTHLY_REPORTS',name:'EPR Monthly Report', fil:[], opt:[] },
{ format:'CSV',cat:'Regulatory Compliance Reports',id:'GET_EPR_QUARTERLY_REPORTS',name:'EPR Quarterly Report', fil:[], opt:[] },
{ format:'CSV',cat:'Regulatory Compliance Reports',id:'GET_EPR_ANNUAL_REPORTS',name:'EPR Annual Report', fil:[], opt:[] },
]
}
]]>
</Body>
<Params>
<Param Name="Filter" Options="All Options=$.data[*].opt[*].v[*];All Reports=$.data[*].opt[0].v[0];Options For One Report=$.data[?(@id=='GET_MERCHANT_LISTINGS_ALL_DATA')].opt[*].v[*]"/>
</Params>
</EndPoint>
</Template>
<EndPoints>
<EndPoint Name="download_report" Group="Reports" Label="Download Report File to Local Disk"
Template="T_Report"
>
<Params>
<Param Name="ReportType" Required="True" OptionsEndPoint="get_report_types"
OptionsEndPointLabelColumn="Category,Name"
OptionsEndPointValueColumn="Id"
OptionsEndPointParameters="Filter=$.data[*]"
/>
<Param Name="FileOverwriteMode"
Label="File Overwrite Mode"
Type="Property"
Value="AlwaysOverwrite"
Required="True"
/>
<Param Label="Target File Path"
Name="TargetFilePath"
Key="ResponseDataFile"
Desc="Specify a disk file path to save file to"
Required="True"
Type="Property"
Value="c:\temp\amazon_report.txt"
Editor="FileSave"
/>
</Params>
<EndPoint Name="child_get_report_status"
TreatBodyAsDirectValue="False"
Desc="Set TreatBodyAsDirectValue=True if you wish to invoke this endpoint for Sandbox sample report"
Body="{status:'DONE',reportDocumentId:'0356cf79-b8b0-4226-b4b9-0ee058ea5760'}"
Url="/reports/[$ReportsApiVersion$]/reports/[$parent.reportId$]"
Method="GET" Filter="" NoOutputColumns="True">
<Params>
<Param Name="EnableStatusCheck" Type="Property" Value="true" />
<Param Name="StatusCheckIterationWaitSeconds" Type="Property" Value="5" />
<Param Name="StatusCheckMaxWaitSeconds" Type="Property" Value="2400" />
<Param Name="StatusCheckForFailedValue" Type="Property" Value="True" />
<Param Name="StatusContinueValue" Type="Property" Value="IN_PROGRESS|IN_QUEUE" />
<Param Name="StatusFailedValue" Type="Property" Value="CANCELLED|FATAL" />
<Param Name="StatusSuccessValue" Type="Property" Value="DONE|DONE_NO_DATA" />
</Params>
<EndPoint Name="child_get_report_url" Method="GET" Desc="When previous URL has DONE status then get reportDocumentId attribute which you pass to this endpoint."
Url="/reports/[$ReportsApiVersion$]/documents/[$parent.reportDocumentId$]" CachedTtl="10" SkipEndPointIf="[$parent.processingStatus$]=DONE_NO_DATA">
<Params>
<Param Name="EnableStatusCheck" Type="Property" Value="false" />
</Params>
<EndPoint Name="child_download_url" Method="GET" Url="[$parent.url$]" CachedTtl="10" OutputHeaders="StatusCode,Content-Length,Content-Type">
<Params>
<Param Name="HttpConnection" Type="Property" Desc="Do not pass Authorization header. Only use Signed URL generated in the previous step."/>
<Param Name="EnableStatusCheck" Type="Property" Value="false" />
<Param Name="SaveContentAsBinary"
Required="True"
Type="Property"
Hidden="True"
Value="True"
/>
<Param Name="DateParseHandling" Type="Property" />
<Param Name="FileCompressionType" Type="Property"/>
<Param Name="FileOverwriteMode" Type="Property" />
<Param Name="TargetFilePath" Key="ResponseDataFile"/>
<Param Name="EnableRawOutputModeSingleRow" Type="Property" Value="True" />
<Param Name="RawOutputDataRowTemplate" Type="Property" Value='{"Report": "[$ReportType$]", "Status":"Done", "TargetFilePath":"[$TargetFilePath,FUN_JSONENC$]"}' />
</Params>
</EndPoint>
</EndPoint>
</EndPoint>
<OutputColumns>
<Column Name="Report" DataType="DT_WSTR" />
<Column Name="Status" DataType="DT_WSTR" />
<Column Name="TargetFilePath" DataType="DT_WSTR" />
<Column Name="ResponseHeaders_StatusCode" Label="StatusCode" DataType="DT_I4" />
<Column Name="ResponseHeaders_Content-Type" Label="ContentType" DataType="DT_WSTR" />
<Column Name="ResponseHeaders_Content-Length" Label="ContentLength" DataType="DT_I4" />
</OutputColumns>
</EndPoint>
<EndPoint Name="get_report_tsv" Group="Reports" Label="Get Report Data - Tab Separated File (TSV)"
Template="T_Report"
>
<Params>
<Param Name="ReportType" Required="True" OptionsEndPoint="get_report_types"
OptionsEndPointLabelColumn="Category,Name"
OptionsEndPointValueColumn="Id"
OptionsEndPointParameters="Filter=$.data[?(@format=='TSV')]"
/>
</Params>
<EndPoint Name="child_get_report_status"
TreatBodyAsDirectValue="False"
Desc="Set TreatBodyAsDirectValue=True if you wish to invoke this endpoint for Sandbox sample report"
Body="{status:'DONE',reportDocumentId:'0356cf79-b8b0-4226-b4b9-0ee058ea5760'}"
Url="/reports/[$ReportsApiVersion$]/reports/[$parent.reportId$]"
Method="GET" Filter="" NoOutputColumns="True">
<Params>
<Param Name="EnableStatusCheck" Type="Property" Value="true" />
<Param Name="StatusCheckIterationWaitSeconds" Type="Property" Value="5" />
<Param Name="StatusCheckMaxWaitSeconds" Type="Property" Value="2400" />
<Param Name="StatusCheckForFailedValue" Type="Property" Value="True" />
<Param Name="StatusContinueValue" Type="Property" Value="IN_PROGRESS|IN_QUEUE" />
<Param Name="StatusFailedValue" Type="Property" Value="CANCELLED|FATAL" />
<Param Name="StatusSuccessValue" Type="Property" Value="DONE|DONE_NO_DATA" />
</Params>
<EndPoint Name="child_get_report_url" Method="GET" Desc="When previous URL has DONE status then get reportDocumentId attribute which you pass to this endpoint."
Url="/reports/[$ReportsApiVersion$]/documents/[$parent.reportDocumentId$]" CachedTtl="10" SkipEndPointIf="[$parent.processingStatus$]=DONE_NO_DATA">
<Params>
<Param Name="EnableStatusCheck" Type="Property" Value="false" />
</Params>
<EndPoint Name="child_download_url" Method="GET" ResponseFormat="Csv" Url="[$parent.url$]" CachedTtl="10">
<Params>
<Param Name="HttpConnection" Type="Property" Desc="Do not pass Authorization header. Only use Signed URL generated in the previous step."/>
<Param Name="EnableStatusCheck" Type="Property" Value="false" />
<Param Name="ColumnDelimiter" Type="Property" Value="{TAB}" />
<Param Name="ResponseCharset" Type="Property" Value="Windows-1252" />
<Param Name="DateParseHandling" Type="Property" />
<Param Name="FileCompressionType" Type="Property"/>
</Params>
</EndPoint>
</EndPoint>
</EndPoint>
</EndPoint>
<EndPoint Name="get_report_csv" Group="Reports" Label="Get Report Data - Comma Separated File (CSV)"
Template="T_Report"
>
<Params>
<Param Name="ReportType" Required="True" OptionsEndPoint="get_report_types"
OptionsEndPointLabelColumn="Category,Name"
OptionsEndPointValueColumn="Id"
OptionsEndPointParameters="Filter=$.data[?(@format=='CSV')]"
/>
</Params>
<EndPoint Name="child_get_report_status"
TreatBodyAsDirectValue="False"
Desc="Set TreatBodyAsDirectValue=True if you wish to invoke this endpoint for Sandbox sample report"
Body="{status:'DONE',reportDocumentId:'0356cf79-b8b0-4226-b4b9-0ee058ea5760'}"
Url="/reports/[$ReportsApiVersion$]/reports/[$parent.reportId$]"
Method="GET" Filter="" NoOutputColumns="True">
<Params>
<Param Name="EnableStatusCheck" Type="Property" Value="true" />
<Param Name="StatusCheckIterationWaitSeconds" Type="Property" Value="5" />
<Param Name="StatusCheckMaxWaitSeconds" Type="Property" Value="2400" />
<Param Name="StatusCheckForFailedValue" Type="Property" Value="True" />
<Param Name="StatusContinueValue" Type="Property" Value="IN_PROGRESS|IN_QUEUE" />
<Param Name="StatusFailedValue" Type="Property" Value="CANCELLED|FATAL" />
<Param Name="StatusSuccessValue" Type="Property" Value="DONE|DONE_NO_DATA" />
</Params>
<EndPoint Name="child_get_report_url" Method="GET" Desc="When previous URL has DONE status then get reportDocumentId attribute which you pass to this endpoint."
Url="/reports/[$ReportsApiVersion$]/documents/[$parent.reportDocumentId$]" CachedTtl="10" SkipEndPointIf="[$parent.processingStatus$]=DONE_NO_DATA">
<Params>
<Param Name="EnableStatusCheck" Type="Property" Value="false" />
</Params>
<EndPoint Name="child_download_url" Method="GET" ResponseFormat="Csv" Url="[$parent.url$]" CachedTtl="10">
<Params>
<Param Name="HttpConnection" Type="Property" Desc="Do not pass Authorization header. Only use Signed URL generated in the previous step."/>
<Param Name="EnableStatusCheck" Type="Property" Value="false" />
<Param Name="ColumnDelimiter" Type="Property" Value="," />
<Param Name="ResponseCharset" Type="Property" Value="Windows-1252" />
<Param Name="DateParseHandling" Type="Property" />
<Param Name="FileCompressionType" Type="Property"/>
</Params>
</EndPoint>
</EndPoint>
</EndPoint>
</EndPoint>
<EndPoint Name="get_report_xml" Group="Reports" Label="Get Report Data - XML File"
Template="T_Report"
>
<Params>
<Param Name="ReportType" Required="True"
OptionsEndPoint="get_report_types" OptionsEndPointLabelColumn="Category,Name" OptionsEndPointValueColumn="Id"
OptionsEndPointParameters="Filter=$.data[?(@format=='XML')]"
/>
<Param Name="Filter" Required="True"
Label="Filter for XML File"
Value="$.Result.Node[*]"
Target="child_download_url"
Options="Example1=$.Result.Node[*];Example2=$.SomeNode.SomeArray[?(@SomeProperty='ABCD')];"
/>
</Params>
<EndPoint Name="child_get_report_status"
TreatBodyAsDirectValue="False"
Desc="Set TreatBodyAsDirectValue=True if you wish to invoke this endpoint for Sandbox sample report"
Body="{status:'DONE',reportDocumentId:'0356cf79-b8b0-4226-b4b9-0ee058ea5760'}"
Url="/reports/[$ReportsApiVersion$]/reports/[$parent.reportId$]"
Method="GET" Filter="" NoOutputColumns="True">
<Params>
<Param Name="EnableStatusCheck" Type="Property" Value="true" />
<Param Name="StatusCheckIterationWaitSeconds" Type="Property" Value="5" />
<Param Name="StatusCheckMaxWaitSeconds" Type="Property" Value="2400" />
<Param Name="StatusCheckForFailedValue" Type="Property" Value="True" />
<Param Name="StatusContinueValue" Type="Property" Value="IN_PROGRESS|IN_QUEUE" />
<Param Name="StatusFailedValue" Type="Property" Value="CANCELLED|FATAL" />
<Param Name="StatusSuccessValue" Type="Property" Value="DONE|DONE_NO_DATA" />
</Params>
<EndPoint Name="child_get_report_url" Method="GET" Desc="When previous URL has DONE status then get reportDocumentId attribute which you pass to this endpoint."
Url="/reports/[$ReportsApiVersion$]/documents/[$parent.reportDocumentId$]" CachedTtl="10" SkipEndPointIf="[$parent.processingStatus$]=DONE_NO_DATA">
<Params>
<Param Name="EnableStatusCheck" Type="Property" Value="false" />
</Params>
<EndPoint Name="child_download_url" Method="GET" ResponseFormat="Xml" Url="[$parent.url$]" CachedTtl="10" Filter="$.AmazonEnvelope.Message[*]">
<Params>
<Param Name="Filter" Type="Property" />
<Param Name="HttpConnection" Type="Property" Desc="Do not pass Authorization header. Only use Signed URL generated in the previous step."/>
<Param Name="EnableStatusCheck" Type="Property" Value="false" />
<Param Name="ElementsToTreatAsArray" Type="Property" Value="Message" />
<Param Name="DateParseHandling" Type="Property" />
<Param Name="FileCompressionType" Type="Property"/>
</Params>
</EndPoint>
</EndPoint>
</EndPoint>
</EndPoint>
<EndPoint Name="get_report_json" Group="Reports" Label="Get Report Data - JSON File"
Template="T_Report"
>
<Params>
<Param Name="ReportType" Required="True"
OptionsEndPoint="get_report_types" OptionsEndPointLabelColumn="Category,Name" OptionsEndPointValueColumn="Id"
OptionsEndPointParameters="Filter=$.data[?(@format=='JSON')]"
/>
<Param Name="Filter" Required="True"
Label="Filter for JSON File"
Target="child_download_url"
OptionsEndPoint="get_report_filters" OptionsEndPointValueColumn="FilterValue" OptionsEndPointParameters="Filter=$.data[?(@id=='[$ReportType$]')].fil[*].v[*]"
/>
</Params>
<EndPoint Name="child_get_report_status"
TreatBodyAsDirectValue="False"
Desc="Set TreatBodyAsDirectValue=True if you wish to invoke this endpoint for Sandbox sample report"
Body="{status:'DONE',reportDocumentId:'0356cf79-b8b0-4226-b4b9-0ee058ea5760'}"
Url="/reports/[$ReportsApiVersion$]/reports/[$parent.reportId$]"
Method="GET" Filter="" NoOutputColumns="True">
<Params>
<Param Name="EnableStatusCheck" Type="Property" Value="true" />
<Param Name="StatusCheckIterationWaitSeconds" Type="Property" Value="5" />
<Param Name="StatusCheckMaxWaitSeconds" Type="Property" Value="2400" />
<Param Name="StatusCheckForFailedValue" Type="Property" Value="True" />
<Param Name="StatusContinueValue" Type="Property" Value="IN_PROGRESS|IN_QUEUE" />
<Param Name="StatusFailedValue" Type="Property" Value="CANCELLED|FATAL" />
<Param Name="StatusSuccessValue" Type="Property" Value="DONE|DONE_NO_DATA" />
</Params>
<EndPoint Name="child_get_report_url" Method="GET" Desc="When previous URL has DONE status then get reportDocumentId attribute which you pass to this endpoint."
Url="/reports/[$ReportsApiVersion$]/documents/[$parent.reportDocumentId$]" CachedTtl="10" SkipEndPointIf="[$parent.processingStatus$]=DONE_NO_DATA">
<Params>
<Param Name="EnableStatusCheck" Type="Property" Value="false" />
</Params>
<EndPoint Name="child_download_url" Method="GET" ResponseFormat="Json" Url="[$parent.url$]" CachedTtl="10" >
<Params>
<Param Name="Filter" Type="Property" />
<Param Name="HttpConnection" Type="Property" Desc="Do not pass Authorization header. Only use Signed URL generated in the previous step."/>
<Param Name="EnableStatusCheck" Type="Property" Value="false" />
<Param Name="DateParseHandling" Type="Property" />
<Param Name="FileCompressionType" Type="Property"/>
</Params>
</EndPoint>
</EndPoint>
</EndPoint>
</EndPoint>
<EndPoint Name="get_report_options" Label="Get Report Options" Template="T_ReportData" >
<OutputColumns>
<Column Name="P_data_id" Label="Id"/>
<Column Name="P_data_name" Label="ReportName"/>
<Column Name="P_data_cat" Label="ReportCategory"/>
<Column Name="P_data_type" Label="FileFormat"/>
<Column Name="P_data_options_k" Label="OptionName"/>
<Column Name="v" Label="OptionValue"/>
<Column Name="v" Label="OptionNameValue" ValueTemplate=" "[$parent.P_data_options_k$]" : "{$value$}" "/>
</OutputColumns>
</EndPoint>
<EndPoint Name="get_report_filters" Label="Get Report Filters" Template="T_ReportData" Filter="$.data[*].fil[*].v[*]" >
<OutputColumns>
<Column Name="P_data_id" Label="Id"/>
<Column Name="P_data_name" Label="ReportName"/>
<Column Name="P_data_cat" Label="ReportCategory"/>
<Column Name="P_data_type" Label="FileFormat"/>
<Column Name="P_data_fil_k" Label="FilterName"/>
<Column Name="v" Label="FilterValue"/>
</OutputColumns>
</EndPoint>
<EndPoint Name="get_inventory_summaries" Group="Catalog" Label="Get FBA Inventory Summaries (Fulfilled By Amazon)"
Template="T_PaginationCatalog" Url="/fba/inventory/[$FbaApiVersion$]/summaries" IncludeParentColumns="True"
Filter="$.payload.inventorySummaries[*]"
HelpLink="https://developer-docs.amazon.com/sp-api/docs/fbainventory-api-v1-reference#get-fbainventoryv1summaries"
Desc="Returns a list of inventory summaries. The summaries returned depend on the presence or absence of the startDateTime, sellerSkus and sellerSku parameters."
>
<Params>
<Param Name="MarketplaceIds" Template="T_MarketplaceId" Key="marketplaceIds" Required="True" />
<Param Name="Details" Key="details" Label="Include details" Type="Query" Required="True" Value="true" Options=";true;false" Desc="true to return inventory summaries with additional summarized inventory details and quantities. Otherwise, returns inventory summaries only (default value false)." />
<Param Name="GranularityType" Key="granularityType" Value="Marketplace" Required="True" Hidden="True" Options=";Marketplace" Label="Granularity Type" Type="Query" Desc="The granularity type for the inventory aggregation level." />
<Param Name="GranularityId" Key="granularityId" Label="Granularity Id" Required="True" Template="T_MarketplaceId" Type="Query" Desc="The granularity ID for the inventory aggregation level (e.g. MarketPlaceId if granularityType is MarketPlace ID)." />
<Param Name="StartDateTime" Template="T_Date" Key="startDateTime" Label="Start Date" Type="Query" Desc="A start date and time in ISO8601 format. If specified, all inventory summaries that have changed since then are returned. You must specify a date and time that is no earlier than 18 months prior to the date and time when you call the API. Note: Changes in inboundWorkingQuantity, inboundShippedQuantity and inboundReceivingQuantity are not detected. You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="SellerSku" Key="sellerSku" Label="SellerSku (Single)" Type="Query" Desc="A single seller SKU used for querying the specified seller SKU inventory summaries." />
<Param Name="SellerSkus" Key="sellerSkus" Label="SellerSkus (Multiple)" Type="Query" Desc="A list of seller SKUs for which to return inventory summaries. You may specify up to 50 SKUs." />
</Params>
<OutputColumns>
<Column Name="asin" DataType="DT_WSTR" Label="Asin" Length="500" />
<Column Name="fnSku" DataType="DT_WSTR" Label="FnSku" Length="50" />
<Column Name="productName" DataType="DT_WSTR" Label="ProductName" Length="500" />
<Column Name="totalQuantity" DataType="DT_I4" Label="TotalQuantity" />
<Column Name="sellerSku" DataType="DT_WSTR" Label="SellerSku" Length="100" />
<Column Name="condition" DataType="DT_WSTR" Label="Condition" Length="50" />
<Column Name="lastUpdatedTime" DataType="DT_DBTIMESTAMP" Label="LastUpdatedTime" />
<Column Name="inventoryDetails.fulfillableQuantity" DataType="DT_I4" Label="InventoryDetailsFulfillableQuantity" />
<Column Name="inventoryDetails.inboundWorkingQuantity" DataType="DT_I4" Label="InventoryDetailsInboundWorkingQuantity" />
<Column Name="inventoryDetails.inboundShippedQuantity" DataType="DT_I4" Label="InventoryDetailsInboundShippedQuantity" />
<Column Name="inventoryDetails.inboundReceivingQuantity" DataType="DT_I4" Label="InventoryDetailsInboundReceivingQuantity" />
<Column Name="inventoryDetails.reservedQuantity.totalReservedQuantity" DataType="DT_I4" Label="InventoryDetailsReservedQuantityTotalReservedQuantity" />
<Column Name="inventoryDetails.reservedQuantity.pendingCustomerOrderQuantity" DataType="DT_I4" Label="InventoryDetailsReservedQuantityPendingCustomerOrderQuantity" />
<Column Name="inventoryDetails.reservedQuantity.pendingTransshipmentQuantity" DataType="DT_I4" Label="InventoryDetailsReservedQuantityPendingTransshipmentQuantity" />
<Column Name="inventoryDetails.reservedQuantity.fcProcessingQuantity" DataType="DT_I4" Label="InventoryDetailsReservedQuantityFcProcessingQuantity" />
<Column Name="inventoryDetails.researchingQuantity.totalResearchingQuantity" DataType="DT_I4" Label="InventoryDetailsResearchingQuantityTotalResearchingQuantity" />
<Column Name="inventoryDetails.researchingQuantity.researchingQuantityBreakdown" DataType="DT_WSTR" Label="InventoryDetailsResearchingQuantityResearchingQuantityBreakdown" Length="1000" />
<Column Name="inventoryDetails.unfulfillableQuantity.totalUnfulfillableQuantity" DataType="DT_I4" Label="InventoryDetailsUnfulfillableQuantityTotalUnfulfillableQuantity" />
<Column Name="inventoryDetails.unfulfillableQuantity.customerDamagedQuantity" DataType="DT_I4" Label="InventoryDetailsUnfulfillableQuantityCustomerDamagedQuantity" />
<Column Name="inventoryDetails.unfulfillableQuantity.warehouseDamagedQuantity" DataType="DT_I4" Label="InventoryDetailsUnfulfillableQuantityWarehouseDamagedQuantity" />
<Column Name="inventoryDetails.unfulfillableQuantity.distributorDamagedQuantity" DataType="DT_I4" Label="InventoryDetailsUnfulfillableQuantityDistributorDamagedQuantity" />
<Column Name="inventoryDetails.unfulfillableQuantity.carrierDamagedQuantity" DataType="DT_I4" Label="InventoryDetailsUnfulfillableQuantityCarrierDamagedQuantity" />
<Column Name="inventoryDetails.unfulfillableQuantity.defectiveQuantity" DataType="DT_I4" Label="InventoryDetailsUnfulfillableQuantityDefectiveQuantity" />
<Column Name="inventoryDetails.unfulfillableQuantity.expiredQuantity" DataType="DT_I4" Label="InventoryDetailsUnfulfillableQuantityExpiredQuantity" />
</OutputColumns>
</EndPoint>
<EndPoint Name="search_catalog_items" Group="Catalog" Label="Search Catalog Items"
Template="T_PaginationCatalog" Url="/catalog/[$CatalogItemsApiVersion$]/items" IncludeParentColumns="True"
Filter="$.items[*].summaries[*]"
HelpLink="https://developer-docs.amazon.com/sp-api/docs/catalog-items-api-v2022-04-01-reference#get-catalog2022-04-01items"
Desc="Search for and return a list of Amazon catalog items and associated information either by identifier or by keywords."
>
<Params>
<Param Name="MarketplaceIds" Template="T_MarketplaceIdList" Required="True" />
<Param Name="Identifiers" Label="Identifiers (comma-delimited list)" Type="Query" Key="identifiers" Desc="A comma-delimited list of product identifiers to search the Amazon catalog for. Note: Cannot be used with keywords." />
<Param Name="IdentifiersType" Type="Query" Key="identifiersType" Desc="Type of product identifiers to search the Amazon catalog for. Note: Required when identifiers are provided."
Options="ASIN (Amazon Standard Identification Number)=ASIN;
EAN (European Article Number)=EAN;
GTIN (Global Trade Item Number)=GTIN;
ISBN (International Standard Book Number)=ISBN;
JAN (Japanese Article Number)=JAN;
MINSAN (Minsan Code)=MINSAN;
SKU (Stock Keeping Unit - must be used with sellerId)=SKU;
UPC (Universal Product Code)=UPC"
/>
<Param Name="IncludedData"
Filter="$.items[*]"
Label="IncludedData" Type="Query" Key="includedData" Desc="A comma-delimited list of data sets to include in the response. Default: summaries."
MultiSelect="True" MultiSelectSeparator=","
Options="
attributes;
classifications;
dimensions;
identifiers;
images;
productTypes;
relationships;
salesRanks;
summaries;"
/>
<Param Name="Filter"
Value="$.items[*].summaries[*]"
Options="$.items[*];
$.items[*].summaries[*];
$.items[*].images[*].images[*];
$.items[*].attributes[*];
$.items[*].classifications[*].classifications[*];
$.items[*].identifiers[*].identifiers[*];
$.items[*].productTypes[*];
$.items[*].salesRanks[*];
$.items[*].relationships[*].relationships[*];
$.items[*].dimensions[*];
$.refinements[*].brands[*];
$.refinements[*].classifications[*];"
/>
<Param Name="Locale" Type="Query" Key="locale" Desc="Locale for retrieving localized summaries. Defaults to the primary locale of the marketplace." />
<Param Name="SellerId" Type="Query" Key="sellerId" Desc="A selling partner identifier, such as a seller account or vendor code. Note: Required when identifiersType is SKU." />
<Param Name="Keywords" Label="Keywords (comma-delimited list)" Type="Query" Key="keywords" Desc="A comma-delimited list of words to search the Amazon catalog for. Note: Cannot be used with identifiers." />
<Param Name="BrandNames" Label="BrandNames (comma-delimited list)" Type="Query" Key="brandNames" Desc="A comma-delimited list of brand names to limit the search for keywords-based queries. Note: Cannot be used with identifiers" />
<Param Name="ClassificationIds" Label="Classification Ids (comma-delimited list)" Type="Query" Key="classificationIds" Desc="A comma-delimited list of classification identifiers to limit the search for keywords-based queries. Note: Cannot be used with identifiers." />
<Param Name="KeywordsLocale" Type="Query" Key="keywordsLocale" Desc="The language of the keywords provided for keywords-based queries. Defaults to the primary locale of the marketplace. Note: Cannot be used with identifiers." />
</Params>
</EndPoint>
<EndPoint Name="get_report_types" Label="Get Report Types" Template="T_ReportData" Filter="$.data[*]" >
<Params>
<Param Name="Filter" Options="All Reports=$.data[*];Tab-delimited / Flat File Reports=$.data[?(@format=='TSV')];Comma-delimited Reports=$.data[?(@format=='CSV')];XML Reports=$.data[?(@format=='XML')];PDF Reports=$.data[?(@format=='PDF')];Excel (XLSX) Reports=$.data[?(@format=='XLSX')]"/>
</Params>
<OutputColumns>
<Column Name="id" Label="Id"/>
<Column Name="name" Label="Name"/>
<Column Name="cat" Label="Category"/>
<Column Name="format" Label="Format"/>
<Column Name="opt" Label="Options"/>
</OutputColumns>
</EndPoint>
<EndPoint Name="get_marketplaceparticipations" Group="Sellers" Label="Get Market Place Participations" Url="/sellers/[$SellerApiVersion$]/marketplaceParticipations"
Method="GET"
IncludeParentColumns="True"
Filter="$.payload[*]">
<Params></Params>
<OutputColumns>
<Column Name="marketplace.id" Label="Id" DataType="DT_WSTR" Length="56" />
<Column Name="marketplace.countryCode" Label="CountryCode" DataType="DT_WSTR" Length="8" />
<Column Name="marketplace.name" Label="Name" DataType="DT_WSTR" Length="52" />
<Column Name="marketplace.defaultCurrencyCode" Label="DefaultCurrencyCode" DataType="DT_WSTR" Length="12" />
<Column Name="marketplace.defaultLanguageCode" Label="DefaultLanguageCode" DataType="DT_WSTR" Length="20" />
<Column Name="marketplace.domainName" Label="DomainName" DataType="DT_WSTR" Length="68" />
<Column Name="participation.isParticipating" Label="IsParticipating" DataType="DT_BOOL" />
<Column Name="participation.hasSuspendedListings" Label="HasSuspendedListings" DataType="DT_BOOL" />
</OutputColumns>
</EndPoint>
<EndPoint Name="get_vendor_purchaseorders" Group="Vendors"
Template="T_PaginationVendor,T_VendorPurchaseOrder" Label="Get Vendor PurchaseOrders" Url="/vendor/orders/[$VendorOrdersApiVersion$]/purchaseOrders"
Method="GET"
IncludeParentColumns="True"
Filter="$.payload.orders[*].orderDetails"
Desc="Returns a list of purchase orders created or changed during the time frame that you specify. You define the time frame using the createdAfter, createdBefore, changedAfter and changedBefore parameters. The date range to search must not be more than 7 days. You can choose to get only the purchase order numbers by setting includeDetails to false. You can then use the getPurchaseOrder operation to receive details for a specific purchase order."
HelpLink="https://developer-docs.amazon.com/sp-api/docs/vendor-orders-api-v1-reference#get-vendorordersv1purchaseorders"
>
<Params>
<Param Name="CreatedAfter" Key="createdAfter" Type="Query" Template="T_Date" Value="1900-01-01T00:00:00" Desc="Purchase orders that became available after this time will be included in the result. Must be in ISO 8601 date/time format. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02). If LastUpdatedAfter is not specified. Specifying both CreatedAfter and LastUpdatedAfter returns an error. You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="CreatedBefore" Key="createdBefore" Type="Query" Template="T_Date" Desc="Purchase orders that became available before this time will be included in the result. Must be in ISO 8601 date/time format. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02) You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="ChangedAfter" Key="changedAfter" Type="Query" Template="T_Date" Desc="Purchase orders that changed after this timestamp will be included in the result. Must be in ISO 8601 date/time format. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02). If CreatedAfter is not specified.Specifying both CreatedAfter and LastUpdatedAfter returns an error.If LastUpdatedAfter is specified, then BuyerEmail and SellerOrderId cannot be specified. You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="ChangedBefore" Key="changedBefore" Type="Query" Template="T_Date" Desc="Purchase orders that changed before this timestamp will be included in the result. Must be in ISO 8601 date/time format. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02) You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="IncludeDetails" Key="includeDetails" Type="Query" Options=";true;false" Desc="When true, returns purchase orders with complete details. Otherwise, only purchase order numbers are returned. Default value is true." />
<Param Name="SortOrder" Key="sortOrder" Type="Query" Options=";ASC;DESC" Desc="Sort in ascending or descending order by purchase order creation date." />
<Param Name="PoItemState" Key="poItemState" Type="Query" Options=";ACCEPTED;PARTIALLY_ACCEPTED;REJECTED;UNCONFIRMED" Desc="Current state of the purchase order item. If this value is Cancelled, this API will return purchase orders which have one or more items cancelled by Amazon with updated item quantity as zero." />
<Param Name="IsPOChanged" Key="isPOChanged" Type="Query" Options=";true;false" Desc="When true, returns purchase orders which were modified after the order was placed. Vendors are required to pull the changed purchase order and fulfill the updated purchase order and not the original one. Default value is false." />
<Param Name="PurchaseOrderState" Key="purchaseOrderState" Type="Query" Options=";New;Acknowledged;Closed" Desc="Filters purchase orders based on the purchase order state." />
<Param Name="OrderingVendorCode" Key="orderingVendorCode" Type="Query" Desc="Filters purchase orders based on the specified ordering vendor code. This value should be same as 'sellingParty.partyId' in the purchase order. If not included in the filter, all purchase orders for all of the vendor codes that exist in the vendor group used to authorize the API client application are returned." />
</Params>
</EndPoint>
<EndPoint Name="get_vendor_purchaseorder_items" Group="Vendors"
Template="T_PaginationVendor,T_VendorPurchaseOrderItem" Label="Get Vendor PurchaseOrder Items" Url="/vendor/orders/[$VendorOrdersApiVersion$]/purchaseOrders"
Method="GET"
IncludeParentColumns="True"
Filter="$.payload.orders[*].orderDetails.items[*]"
Desc="Returns a list of purchase order items created or changed during the time frame that you specify. You define the time frame using the createdAfter, createdBefore, changedAfter and changedBefore parameters. The date range to search must not be more than 7 days. You can choose to get only the purchase order numbers by setting includeDetails to false. You can then use the getPurchaseOrder operation to receive details for a specific purchase order."
HelpLink="https://developer-docs.amazon.com/sp-api/docs/vendor-orders-api-v1-reference#get-vendorordersv1purchaseorders"
>
<Params>
<Param Name="CreatedAfter" Key="createdAfter" Type="Query" Template="T_Date" Value="1900-01-01T00:00:00" Desc="Purchase orders that became available after this time will be included in the result. Must be in ISO 8601 date/time format. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02). If LastUpdatedAfter is not specified. Specifying both CreatedAfter and LastUpdatedAfter returns an error. You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="CreatedBefore" Key="createdBefore" Type="Query" Template="T_Date" Desc="Purchase orders that became available before this time will be included in the result. Must be in ISO 8601 date/time format. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02) You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="ChangedAfter" Key="changedAfter" Type="Query" Template="T_Date" Desc="Purchase orders that changed after this timestamp will be included in the result. Must be in ISO 8601 date/time format. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02). If CreatedAfter is not specified.Specifying both CreatedAfter and LastUpdatedAfter returns an error.If LastUpdatedAfter is specified, then BuyerEmail and SellerOrderId cannot be specified. You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="ChangedBefore" Key="changedBefore" Type="Query" Template="T_Date" Desc="Purchase orders that changed before this timestamp will be included in the result. Must be in ISO 8601 date/time format. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02) You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)" />
<Param Name="IncludeDetails" Key="includeDetails" Type="Query" Options=";true;false" Desc="When true, returns purchase orders with complete details. Otherwise, only purchase order numbers are returned. Default value is true." />
<Param Name="SortOrder" Key="sortOrder" Type="Query" Options=";ASC;DESC" Desc="Sort in ascending or descending order by purchase order creation date." />
<Param Name="PoItemState" Key="poItemState" Type="Query" Options=";ACCEPTED;PARTIALLY_ACCEPTED;REJECTED;UNCONFIRMED" Desc="Current state of the purchase order item. If this value is Cancelled, this API will return purchase orders which have one or more items cancelled by Amazon with updated item quantity as zero." />
<Param Name="IsPOChanged" Key="isPOChanged" Type="Query" Options=";true;false" Desc="When true, returns purchase orders which were modified after the order was placed. Vendors are required to pull the changed purchase order and fulfill the updated purchase order and not the original one. Default value is false." />
<Param Name="PurchaseOrderState" Key="purchaseOrderState" Type="Query" Options=";New;Acknowledged;Closed" Desc="Filters purchase orders based on the purchase order state." />
<Param Name="OrderingVendorCode" Key="orderingVendorCode" Type="Query" Desc="Filters purchase orders based on the specified ordering vendor code. This value should be same as 'sellingParty.partyId' in the purchase order. If not included in the filter, all purchase orders for all of the vendor codes that exist in the vendor group used to authorize the API client application are returned." />
</Params>
</EndPoint>
<EndPoint Name="get_orders" Group="Orders" Template="T_Pagination,T_Order,T_OrdersParams" Label="Get Orders"
IncludeParentColumns="True"
Desc="Returns orders created or updated during the time frame indicated by the specified parameters. You can also apply a range of filtering criteria to narrow the list of orders returned. If NextToken is present, that will be used to retrieve the orders instead of other criteria."
>
</EndPoint>
<EndPoint Name="get_order" Group="Orders" Template="T_Order" Label="Get Order (Single)" Url="/orders/[$OrdersApiVersion$]/orders/[$AmazonOrderId$]"
Method="GET"
Filter="$.payload"
Desc="Returns the order information for a specified OrderId"
HelpLink="https://developer-docs.amazon.com/sp-api/docs/orders-api-v0-reference#get-ordersv0ordersorderid"
>
<Params>
<Param Name="AmazonOrderId" IsKey="True" Desc="Filters purchase orders based on the specified orderid." />
</Params>
</EndPoint>
<EndPoint Name="get_order_items" Group="Orders" Template="T_Pagination,T_OrderItem" Label="Get Order Items (For Single Order)" Url="/orders/[$OrdersApiVersion$]/orders/[$AmazonOrderId$]/orderItems"
Method="GET"
Filter="$.payload.OrderItems[*]"
Desc="Returns the order items information for a specified OrderId"
HelpLink="https://developer-docs.amazon.com/sp-api/docs/orders-api-v0-reference#get-ordersv0ordersorderidorderitems"
>
<Params>
<Param Name="AmazonOrderId" IsKey="True" Desc="Filters purchase orders based on the specified orderid." />
</Params>
</EndPoint>
<EndPoint Name="get_order_items_all" Group="Orders" Template="T_Pagination,T_OrderItem,T_OrdersParams" Label="Get Orders Items (For All Orders **Slow**)"
IncludeParentColumns="True"
Desc="Returns the order items information for a specified order search criterial (All orders by Create/Update date, status etc)"
>
<EndPoint Name="get_order_items" Group="Orders" Template="T_Pagination" Label="Get Order Items" Url="/orders/[$OrdersApiVersion$]/orders/[$parent.AmazonOrderId$]/orderItems"
Method="GET"
IncludeParentColumns="True"
Filter="$.payload.OrderItems[*]"
>
</EndPoint>
</EndPoint>
</EndPoints>
<Tables>
<Table Name="Orders" SelectEndPoint="get_orders" LookupEndPoint="get_order" />
<Table Name="OrderItems" SelectEndPoint="get_order_items_all" />
<Table Name="ReportTypes" SelectEndPoint="get_report_types" />
<Table Name="MarketPlaceParticipations" SelectEndPoint="get_marketplaceparticipations" />
</Tables>
<Examples>
<Example Name="Read Orders" Desc="Read orders with search criteria such as CreatedAfter, CreatedBefore, MarketPlaceIds, OrderStatuses, PaymentType and many more"
Default="True" >
<Code>
<![CDATA[SELECT * FROM Orders
--WHERE AmazonOrderId='902-1845936-5435065'
WITH(
CreatedAfter='1900-01-01T00:00:00'
-- , CreatedBefore='1900-01-01T00:00:00'
-- , LastUpdatedAfter='1900-01-01T00:00:00'
-- , LastUpdatedBefore='1900-01-01T00:00:00'
-- , OrderStatuses='Pending~Unshipped~PartiallyShipped~PendingAvailability~Shipped~Canceled~Unfulfillable'
-- , MarketplaceIds='ATVPDKIKX0DER~A2Q3Y263D00KWC~A2EUQ1WTGCTBG2'
-- , FulfillmentChannels='AFN~MFN'
-- , PaymentMethods='COD~CVS~Other'
-- , AmazonOrderIds='1111111,222222,333333'
)
--CONNECTION(
-- ServiceUrl='https://sellingpartnerapi-na.amazon.com'
--)]]>
</Code>
</Example>
<Example Name="Read Single Order" Desc="Read single order by orderid" >
<Code>
<![CDATA[SELECT * FROM Orders
Where AmazonOrderId='902-1845936-5435065'
--CONNECTION(
-- ServiceUrl='https://sellingpartnerapi-na.amazon.com'
--)]]>
</Code>
</Example>
<Example Name="Read Order Items (For Single Order)" Desc="Read order items for a specified orderid" >
<Code>
<![CDATA[SELECT * FROM get_order_items
WITH(
AmazonOrderId ='902-1845936-5435065'
)
--CONNECTION(
-- ServiceUrl='https://sellingpartnerapi-na.amazon.com'
--)]]>
</Code>
</Example>
<Example Name="Read Order Items (For All Orders - Slow)" Desc="Read order items with search criteria on orders such as CreatedAfter, CreatedBefore, MarketPlaceIds, OrderStatuses, PaymentType and many more. This is slow way of pulling all items for all orders without reading one by one order."
Default="True" >
<Code>
<![CDATA[SELECT * FROM OrderItems
WITH(
CreatedAfter='1900-01-01T00:00:00'
-- , CreatedBefore='1900-01-01T00:00:00'
-- , LastUpdatedAfter='1900-01-01T00:00:00'
-- , LastUpdatedBefore='1900-01-01T00:00:00'
-- , OrderStatuses='Pending~Unshipped~PartiallyShipped~PendingAvailability~Shipped~Canceled~Unfulfillable'
-- , MarketplaceIds='ATVPDKIKX0DER~A2Q3Y263D00KWC~A2EUQ1WTGCTBG2'
-- , FulfillmentChannels='AFN~MFN'
-- , PaymentMethods='COD~CVS~Other'
-- , AmazonOrderIds='1111111,222222,333333'
)
--CONNECTION(
-- ServiceUrl='https://sellingpartnerapi-na.amazon.com'
--)]]>
</Code>
</Example>
<Example Name="Sandbox - Read Orders (Fake data for testing)" Desc="Read orders which has fake values (sandbox data)" >
<Code>
<![CDATA[SELECT *
FROM Orders
--DONOT try WHERE AmazonOrderId='TEST_CASE_200' (WHERE clause) for sandbox endpoint, it will return empty row. If you try in Live API then should work.
WITH(
CreatedAfter='TEST_CASE_200'
--CreatedAfter='TEST_CASE_200_NEXT_TOKEN'
, MarketplaceIds='ATVPDKIKX0DER'
)
CONNECTION(
ServiceUrl='https://sandbox.sellingpartnerapi-na.amazon.com'
)]]>
</Code>
</Example>
<Example Name="Sandbox - Read Single Order (Fake data for testing)" Desc="Read single order with orderid which has fake values (sandbox data)" >
<Code>
<![CDATA[SELECT *
FROM get_order
--DONOT try WHERE AmazonOrderId='TEST_CASE_200' (WHERE clause) for sandbox endpoint, it will return empty row. If you try in Live API then should work.
WITH(
AmazonOrderId='TEST_CASE_200'
-- AmazonOrderId='TEST_CASE_IBA_200'
)
CONNECTION(
ServiceUrl='https://sandbox.sellingpartnerapi-na.amazon.com'
)]]>
</Code>
</Example>
<Example Name="Sandbox - Read Order Items (Fake data for testing)" Desc="Read order items with orderid which has fake values (sandbox data)" >
<Code>
<![CDATA[SELECT *
FROM get_order_items
--DONOT try WHERE AmazonOrderId='TEST_CASE_200' (WHERE clause) for sandbox endpoint, it will return empty row. If you try in Live API then should work.
WITH(
AmazonOrderId='TEST_CASE_200'
-- AmazonOrderId='TEST_CASE_IBA_200'
)
CONNECTION(
ServiceUrl='https://sandbox.sellingpartnerapi-na.amazon.com'
)]]>
</Code>
</Example>
<Example Name="Generic Request - Read Any API Endpoint" Desc="Read any API endpoint using generic request endpoint" >
<Code>
<![CDATA[SELECT *
FROM generic_request
WITH(
URL='/orders/v0/orders/TEST_CASE_200/orderItems'
, Filter='$.payload.OrderItems[*]'
, IncludeParentColumns=1
-- , RequestMethod='GET'
-- , Body=''
-- , IsMultiPart=0
-- , RequestContentTypeCode"='Default'
-- , ResponseFormat='Default' --Json, Csv, Xml
-- , Headers='Accept: */* || Cache-Control: no-cache'
-- , PagingMode"=''
-- , PagingByUrlAttributeName=''
-- , PagingIncrementBy='1'
-- , NextUrlAttributeOrExpr=''
-- , NextUrlWaitInMs='0'
-- , ColumnDelimiter=','
-- , HasColumnHeaderRow='True'
-- , ElementsToTreatAsArray=''
)
CONNECTION(
ServiceUrl='https://sandbox.sellingpartnerapi-na.amazon.com'
)]]>
</Code>
</Example>
<Example Name="Get Report Types" Desc="Lists report types which you can use for download_report / get_report_tsv / get_report_csv or get_report_xml endpoints" >
<Code>
<![CDATA[SELECT * FROM ReportTypes)]]>
</Code>
</Example>
<Example Name="Download Report to Local Disk" Desc="This example shows how to run a report and download data to local disk file. You can save any file format report by calling this endpoint." >
<Code>
<![CDATA[
SELECT * FROM download_report
WITH(
ReportType='GET_XML_BROWSE_TREE_DATA'
, TargetFilePath='c:\temp\GET_XML_BROWSE_TREE_DATA.gz'
, MarketplaceIds='ATVPDKIKX0DER'
--, FileOverwriteMode='FailIfExists' (Default is 'AlwaysOverwrite')
--, StartDate='2012-12-31'
--, EndDate='today-1d'
)
]]>
</Code>
</Example>
<Example Name="Generate Report" Desc="This example shows how to get data from a specified report" >
<Code>
<![CDATA[SELECT *
FROM get_report_tsv
WITH(
ReportType='GET_MERCHANT_LISTINGS_ALL_DATA'
, MarketplaceIds='ATVPDKIKX0DER'
)]]>
</Code>
</Example>
<!--
<Example Name="Sandbox - Generate Report" Desc="Amazon Sandbox API still broken so no good example with DONE status. You can mock response with DONE status by tools like Fiddler
or change TreatBodyAsDirectValue="True" in Endpoint child_get_report_status found under get_report_tsv / get_report_csv etc (Do not forget to change back to TreatBodyAsDirectValue="False".
(Auto responder Tab-> Add response file with
data {processingStatus:"DONE",reportDocumentId:"0356cf79-b8b0-4226-b4b9-0ee058ea5760"}
for URL https://sandbox.sellingpartnerapi-na.amazon.com/reports/2021-06-30/reports/ID323)
Which responds to https://sandbox.sellingpartnerapi-na.amazon.com/reports/2021-06-30/documents/0356cf79-b8b0-4226-b4b9-0ee058ea5760
and then https://d34o8swod1owfl.cloudfront.net/Report_47700__GET_MERCHANT_LISTINGS_ALL_DATA_.txt
."
>
<Code>
<![CDATA[
/*must mock response for https://sandbox.sellingpartnerapi-na.amazon.com/reports/2021-06-30/reports/ID323 as described above (Mock OR set TreatBodyAsDirectValue="True" )*/
SELECT *
FROM get_report_tsv
WITH(
ReportType='GET_MERCHANT_LISTINGS_ALL_DATA'
, StartDate='2024-03-10T20:11:24.000'
, MarketplaceIds='A1PA6795UKMFR9~ATVPDKIKX0DER'
)
CONNECTION(
ServiceUrl='https://sandbox.sellingpartnerapi-na.amazon.com'
)
]]>
</Code>
</Example>
-->
</Examples>
</ApiConfig>
