{"id":3689,"date":"2023-08-31T06:08:03","date_gmt":"2023-08-31T05:08:03","guid":{"rendered":"https:\/\/help.expertsender.com\/?post_type=es&#038;p=3689"},"modified":"2024-04-25T07:57:06","modified_gmt":"2024-04-25T06:57:06","slug":"get-rejected-subscribers","status":"publish","type":"es","link":"https:\/\/help.expertsender.com\/pl\/emp\/api\/methods\/imports\/get-rejected-subscribers\/","title":{"rendered":"Get rejected subscribers"},"content":{"rendered":"\n<p>ImportToListRejected collection allows retrieving a list of subscribers that were rejected during an import for various reasons. Executing a GET request on this collection will return the data in CSV format. This is the same information that can be retrieved manually through Reports-&gt;Imports page in ExpertSender Panel application.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h.ig5bbrivjizb_l\"><a href=\"https:\/\/sites.google.com\/expertsender.com\/api-documentation-v2\/methods\/imports\/get-rejected-subscribers?authuser=0#h.ig5bbrivjizb\"><\/a><a href=\"https:\/\/sites.google.com\/expertsender.com\/api-documentation-v2\/methods\/imports\/get-rejected-subscribers?authuser=0#h.ig5bbrivjizb\"><\/a><strong>Request data format<\/strong><\/h3>\n\n\n\n<p>Request URL parameters:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Element\/attribute<\/th><th>Type<\/th><th>Notes<\/th><\/tr><\/thead><tbody><tr><td>apiKey<\/td><td>string<\/td><td>Your API key, required for authentication. Required.<\/td><\/tr><tr><td>id<\/td><td>integer<\/td><td>ID of import to list task. ID can be obtained while\u00a0<a href=\"https:\/\/help.expertsender.com\/emp\/scheduled-tasks\/\" data-type=\"es\" data-id=\"6773\">scheduling the task<\/a>.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Example URL:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#A6ACCD;--cbp-line-number-width:8.4375px;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"https:\/\/api.esv2.com\/v2\/Api\/ImportToListRejected?apiKey=YOUR_API_KEY_HERE&amp;id=123\" style=\"color:#A6ACCD;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg  style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-palenight\" style=\"background-color: #292D3E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #A6ACCD\">https:\/\/api.esv2.com\/v2\/Api\/ImportToListRejected?apiKey=YOUR_API_KEY_HERE&amp;id=123<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h.jhehm8g100n8_l\"><strong>Response<\/strong><\/h3>\n\n\n\n<p>The response from this method is always data in CSV format, rather than XML, because the amount of data returned can be substantial.<\/p>\n\n\n\n<p>CSV response minimizes overheads and allows for seamless integration with third party code\/systems.<\/p>\n\n\n\n<p>Response content type is &#8220;text\/csv&#8221;. Returned data contains a header with column names in the first row.<\/p>\n\n\n\n<p>CSV output is formatted using following settings:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Field separator: comma (,)<\/li>\n\n\n\n<li>Quoting character: (&#8220;)<\/li>\n\n\n\n<li>Escape character: (&#8220;)<\/li>\n\n\n\n<li>Encoding: UTF-8<\/li>\n<\/ul>\n\n\n\n<p>CSV response columns:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Type<\/th><th>Notes<\/th><\/tr><\/thead><tbody><tr><td>Value<\/td><td>string<\/td><td>Value (e.g. email address, phone number) that was rejected.<\/td><\/tr><tr><td>Problem<\/td><td>string<\/td><td>Reason why email was rejected. See below for all possible reasons.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Problem types (one of those will be in Problem column in CSV):<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>Conflicting Custom Subscriber ID<\/td><td>Custom Subscriber ID conflicted with existing subscribers.<\/td><\/tr><tr><td>Conflicting Email<\/td><td>email address conflicted with existing subscribers.<\/td><\/tr><tr><td>Conflicting Phone<\/td><td>phone number conflicted with existing subscribers.<\/td><\/tr><tr><td>Country\/Region blacklisted<\/td><td>value was rejected because its dialing prefix was present on a local blacklist.<\/td><\/tr><tr><td>Domain blacklisted<\/td><td>value was rejected because its domain is present on blacklist.<\/td><\/tr><tr><td>Domain rejected<\/td><td>value was rejected because its domain is present on global blacklist.<\/td><\/tr><tr><td>Duplicated Custom Subscriber ID<\/td><td>Custom Subscriber ID was duplicated in the import.<\/td><\/tr><tr><td>Duplicated Email<\/td><td>email was duplicated in the import.<\/td><\/tr><tr><td>Duplicated Phone<\/td><td>phone number was duplicated in the import.<\/td><\/tr><tr><td>Email blacklisted<\/td><td>email was rejected because it was present on a local blacklist.<\/td><\/tr><tr><td>Email rejected<\/td><td>value was rejected using internal rule. It usually means that subscriber either does not exist or issued spam complaints.<\/td><\/tr><tr><td>Empty Custom Subscriber ID<\/td><td>Custom Subscriber ID was empty<\/td><\/tr><tr><td>Empty email<\/td><td>email address was empty<\/td><\/tr><tr><td>Empty phone number<\/td><td>phone number was empty<\/td><\/tr><tr><td>Entries skipped because of selected import type<\/td><td>value was skipped because it did not fit the import criteria.<\/td><\/tr><tr><td>Invalid<\/td><td>string is not valid (wrong formatting etc).<\/td><\/tr><tr><td>Invalid Custom Subscriber ID<\/td><td>string is not a valid Custom Subscriber ID<\/td><\/tr><tr><td>Invalid email address<\/td><td>string is not a valid email address<\/td><\/tr><tr><td>Invalid phone number<\/td><td>string is not a valid phone number<\/td><\/tr><tr><td>Opted out<\/td><td>subscriber previously unsubscribed from the list (only during imports with AllowImportingUnsubscribed option set to false).<\/td><\/tr><tr><td>Parsing error<\/td><td>line of imported file is corrupted and could not be parsed.<\/td><\/tr><tr><td>Phone blacklisted<\/td><td>phone was rejected because it was present on a local blacklist<\/td><\/tr><tr><td>Phone rejected<\/td><td>phone was rejected because it was present on a global blacklist<\/td><\/tr><tr><td>Skipped due to no value of a required custom field<\/td><td>self-explanatory.<\/td><\/tr><tr><td>Skipped Email<\/td><td>value was skipped because it was not found on the list (in ReplaceOnly and UpdateOnly mode) or because it it already existed on a list (in AddOnly mode).<\/td><\/tr><tr><td>Skipped Phone<\/td><td>value was skipped because it was not found on the list (in ReplaceOnly and UpdateOnly mode) or because it it already existed on a list (in AddOnly mode)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h.atjrqrhv4rbr_l\"><strong>Examples<\/strong><\/h3>\n\n\n\n<p>Request:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#A6ACCD;--cbp-line-number-width:8.4375px;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"GET http:\/\/api.esv2.com\/v2\/Api\/ImportToListRejected?apiKey=test_api_key1&amp;id=287 HTTP\/1.1\nAccept-Encoding: gzip,deflate\nHost: api.esv2.com\nConnection: Keep-Alive\nUser-Agent: Apache-HttpClient\/4.1.1 (java 1.5)\" style=\"color:#A6ACCD;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg  style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-palenight\" style=\"background-color: #292D3E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #A6ACCD\">GET http:\/\/api.esv2.com\/v2\/Api\/ImportToListRejected?apiKey=test_api_key1&amp;id=287 HTTP\/1.1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">Accept-Encoding: gzip,deflate<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">Host: api.esv2.com<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">Connection: Keep-Alive<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">User-Agent: Apache-HttpClient\/4.1.1 (java 1.5)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>OK response:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#A6ACCD;--cbp-line-number-width:16.859375px;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"HTTP\/1.1 200 OK\nCache-Control: private\nContent-Type: text\/csv; charset=utf-8\nServer: Microsoft-IIS\/7.5\nX-AspNetMvc-Version: 5.1\nX-AspNet-Version: 4.0.30319\nSet-Cookie: TEMP_DATA=27aa335a-4ef6-49c0-af32-d143691fa14b; path=\/\nX-Powered-By: ASP.NET\nDate: Tue, 24 Jun 2014 10:47:38 GMT\nContent-Length: 31336\nValue,Problem\ninvalid1.@domain.com,Invalid email address\n123invalid678,Invalid phone number\nblacklisted@domain.com,Email blacklisted\nusername@blacklisted.com,Domain blacklisted\n48506089829,Skipped Phone\n...\" style=\"color:#A6ACCD;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg  style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-palenight\" style=\"background-color: #292D3E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #A6ACCD\">HTTP\/1.1 200 OK<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">Cache-Control: private<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">Content-Type: text\/csv; charset=utf-8<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">Server: Microsoft-IIS\/7.5<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">X-AspNetMvc-Version: 5.1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">X-AspNet-Version: 4.0.30319<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">Set-Cookie: TEMP_DATA=27aa335a-4ef6-49c0-af32-d143691fa14b; path=\/<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">X-Powered-By: ASP.NET<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">Date: Tue, 24 Jun 2014 10:47:38 GMT<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">Content-Length: 31336<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">Value,Problem<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">invalid1.@domain.com,Invalid email address<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">123invalid678,Invalid phone number<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">blacklisted@domain.com,Email blacklisted<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">username@blacklisted.com,Domain blacklisted<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">48506089829,Skipped Phone<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #A6ACCD\">...<\/span><\/span><\/code><\/pre><\/div>\n","protected":false},"author":5,"featured_media":0,"parent":3682,"menu_order":287,"template":"","format":"standard","emp-category":[],"class_list":["post-3689","es","type-es","status-publish","format-standard","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3689","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es"}],"about":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/types\/es"}],"author":[{"embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/users\/5"}],"version-history":[{"count":4,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3689\/revisions"}],"predecessor-version":[{"id":10444,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3689\/revisions\/10444"}],"up":[{"embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3682"}],"wp:attachment":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/media?parent=3689"}],"wp:term":[{"taxonomy":"emp-category","embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/emp-category?post=3689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}