{"id":17779,"date":"2023-05-02T16:27:25","date_gmt":"2023-05-02T14:27:25","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/getting-the-exact-address-of-companies-with-the-following-data-company-city-state-what-is-my-best-option\/"},"modified":"2023-05-02T16:27:25","modified_gmt":"2023-05-02T14:27:25","slug":"getting-the-exact-address-of-companies-with-the-following-data-company-city-state-what-is-my-best-option","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/getting-the-exact-address-of-companies-with-the-following-data-company-city-state-what-is-my-best-option\/","title":{"rendered":"Getting The Exact Address Of Companies With The Following Data: Company, City, State; What Is My Best Option?"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Hi all, <\/p>\n<p>I&#8217;m currently trying to merge 3 lists of together over 30.000 rows with companies, to make sure I can delete the duplicates I want to merge the companies sin one list with one similar cell for all, the exact address or coordinates.<\/p>\n<p>I&#8217;ve tried using bing maps API, but after checking it doesn&#8217;t show up correctly. What I can do is go into google maps an manually put in the company, state &amp; city and then copy the address but doing this for 30.000 rows will take me years.<\/p>\n<p>What would my best option be to do this? I&#8217;m advanced with Zapier &amp; Power Automate.<\/p>\n<p>Many thanks!<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/Florent-Lesage\"> \/u\/Florent-Lesage <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/135mhst\/getting_the_exact_address_of_companies_with_the\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/135mhst\/getting_the_exact_address_of_companies_with_the\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-17779 jlk' href='javascript:void(0)' data-task='like' data-post_id='17779' data-nonce='65e0e39b87' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-17779 lc'>0<\/span><\/a><\/div><\/div> <div class='status-17779 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Hi all, I&#8217;m currently trying to merge 3 lists of together over 30.000 rows with companies, to&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-17779","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/17779","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=17779"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/17779\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=17779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=17779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=17779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}