tag:support.getcheddar.com,2009-06-01:/discussions/problems/9454-customer-by-countryCheddar: Discussion 2017-10-04T20:29:40Ztag:support.getcheddar.com,2009-06-01:Comment/435742982017-09-27T10:23:50Z2017-09-27T10:23:52Zcustomer by country<div><p>how can I display my customer list by country ?</p></div>Tom RICHERtag:support.getcheddar.com,2009-06-01:Comment/435742982017-09-27T14:13:07Z2017-09-27T14:13:07Zcustomer by country<div><p>Hi Tom,</p>
<p>You can display your customer search in XML or JSON (see the buttons at the bottom of the <a href="https://www.getcheddar.com/admin/customers/search/subscriptionStatus/activeOnly/orderBy/id/orderByDirection/asc/perPage/100/page/1">customer search page</a>) to get full customer details, including the country code of the billing address, for each customer record returned by the search. To find the country for each customer record in the JSON or XML files, just search for the <code>ccCountry</code> param.</p>
<p>The JSON and XML files only display the current page of your search results. If your customer search is multiple pages, make sure to get the XML or JSON for each page of your search. Let me know if I can answer any other questions, Tom.</p>
<p>Meghan</p></div>Meghan Turnertag:support.getcheddar.com,2009-06-01:Comment/435742982017-10-03T13:08:48Z2017-10-03T13:08:48Zcustomer by country<div><p>Hello Meghan,</p>
<p>Thanks. I've tried your solution but I've been unable to find any client based in the UK (even though we have a few client operating there). I've tried by searching "UK" as ccCountry but couldn't find one...<br>
I've done it differently and have been able to find the data I needed.</p>
<p>Thanks for your help !</p></div>Tom RICHERtag:support.getcheddar.com,2009-06-01:Comment/435742982017-10-03T16:29:04Z2017-10-03T16:29:04Zcustomer by country<div><p>Hi Tom,</p>
<p>Try using the <a href="http://docs.getcheddar.com/#get-all-customers">get all customers API call instead</a> and then searching the results for the country code "GB" rather than "UK" (GB is the ISO Alpha-2 country code for the United Kingdom). Let me know if that works!</p>
<p>Meghan</p></div>Meghan Turnertag:support.getcheddar.com,2009-06-01:Comment/435742982017-10-04T16:42:28Z2017-10-04T16:42:28Zcustomer by country<div><p>Hi Meghan,</p>
<p>It is working with "GB" ! Thanks for the tips.</p>
<p>Thanks a lot for your help and your reactivity :) !</p></div>Tom RICHERtag:support.getcheddar.com,2009-06-01:Comment/435742982017-10-04T20:29:39Z2017-10-04T20:29:39Zcustomer by country<div><p>Happy to help, Tom! I'll go ahead and close this discussion, but if you have any other questions, feel free to re-open it by commenting.</p>
<p>Meghan</p></div>Meghan Turner